Skip site navigation (1)Skip section navigation (2)
Date:      Tue, 24 Dec 2013 07:36:40 +0000
From:      Matthew Seaman <matthew@FreeBSD.org>
To:        freebsd-questions@freebsd.org
Subject:   Re: How to Stop IMAP & LMTPUNIX from logging SQL engine 'mysql' not supported
Message-ID:  <52B93988.2050205@FreeBSD.org>
In-Reply-To: <4618c0cd6e7730f4d5265037c280e45c@dweimer.net>
References:  <4618c0cd6e7730f4d5265037c280e45c@dweimer.net>

Next in thread | Previous in thread | Raw E-Mail | Index | Archive | Help
This is an OpenPGP/MIME signed message (RFC 4880 and 3156)
--nAK626QlAXCqO2R4na4p2rNuBafSAWft9
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

On 20/12/2013 20:38, dweimer wrote:
> I have a server setup that runs sendmail along with Cyrus IMAP, and
> SASLAUTH, its working fine, in fact I am sending this message through
> the server.  However ever since I set up the server, and throughout
> several upgrades I have consistently been receiving the following
> messages in /var/log/messages.
>=20
> Dec 20 14:17:28 webmail imaps[47553]: SQL engine 'mysql' not supported
> Dec 20 14:17:28 webmail imaps[47553]: auxpropfunc error no mechanism
> available
> Dec 20 14:17:51 webmail lmtpunix[47578]: SQL engine 'mysql' not support=
ed
> Dec 20 14:17:51 webmail lmtpunix[47578]: auxpropfunc error no mechanism=

> available
>=20
> I have the server setup to use saslauthd, which is set to use sasldb as=

> the back end, I can't find anywhere where its set to try mysql as the
> back end.  which would be causing these error messages, as I don't have=

> mysql Installed, and never intend to.
>=20
> # From /usr/local/etc/imapd.conf
> sasl_pwcheck_method: saslauthd
>=20
> # From /etc/rc.conf
> cyrus_imapd_enable=3D"YES"
> saslauthd_enable=3D"YES"
> saslauthd_flgas=3D"-a sasldb"
> sendmail_enable=3D"YES"
>=20
> # From /var/db/ports Options files.
> mail_cyrus-imapd24/options:OPTIONS_FILE_UNSET+=3DMYSQL
> security_cyrus-sasl2/options:OPTIONS_FILE_UNSET+=3DMYSQL
>=20
> Anyone have any ideas what settings I am missing so that it stops tryin=
g
> to authenticate against the non existent mysql back end?
>=20

It's been a while since I had much to do with Cyrus IMAP, but I remember
this effect.

Check out /usr/local/lib/sasl2/Cyrus.conf -- IIRC, I had to truss the
imapd process to find that file: it didn't seem to be documented
anywhere.  In particular look at the settings for 'pwcheck_method' and
'auxprop_plugin'

	Cheers,

	Matthew

--=20
Dr Matthew J Seaman MA, D.Phil.
PGP: http://www.infracaninophile.co.uk/pgpkey



--nAK626QlAXCqO2R4na4p2rNuBafSAWft9
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: OpenPGP digital signature
Content-Disposition: attachment; filename="signature.asc"

-----BEGIN PGP SIGNATURE-----
Version: GnuPG/MacGPG2 v2.0.20 (Darwin)
Comment: Using GnuPG with Thunderbird - http://www.enigmail.net/

iQJ8BAEBCgBmBQJSuTmRXxSAAAAAAC4AKGlzc3Vlci1mcHJAbm90YXRpb25zLm9w
ZW5wZ3AuZmlmdGhob3JzZW1hbi5uZXQ2NTNBNjhCOTEzQTRFNkNGM0UxRTEzMjZC
QjIzQUY1MThFMUE0MDEzAAoJELsjr1GOGkAT9q8P/jPFpsTLkwY6Nnhk3ukx13kl
bJaDiQwPOmopbjnvnURD1VyxirSn2a7YJJssbqGSsi2jJ+HjXu/7qLdqD6yipX3p
TX8mik9tLIXgXhYCRRy8Q2wgxMhclLuPoOw7mvVVsRwApMYeZD2+9z32SiXFl9NG
rzIoxortHYO+jbuP7r5zcaQ5usQnWG3hDQuTkF0tDXG7zhm/s+qwgRxwy402qi/T
pwSmNJI0EpMIlte3oQhwmW5U7bLrrrdba8lAuwbN3BadtoPPFzDyAmWVT9u8stHl
EXnQYvP59dyqnmBfAFyCLL9mysc/tCRGJdOKCndFM3gFEnuF8wqFjXWVTgAo1A3j
oaolkLL9oY61hM8xe6VGpeKKfEI94VAe9JkVDe03zpuQM6Zl2s/MWchH88+30Luw
NOWmd6UJLBCDWrlT1qji2Pa+/eMeCmbUgxCZ4FWcj+cvCWpuSmhZwzZcKvmHxUBO
usHPL85hRqIohCRNN4XAIx/l9lT5jKUbMeu1e40g6H3xU3yGycEO39U7rx/vdIrH
ySwjuUTkY8ur814Ke0MhPejI7unmZ8IQKRGQqYGuyzFqdikX3GwLMvwnhAyx+1qY
9iTvFGQ4308MsUVBeNgA1ZAR/IGSZKyfhi1z+nDtKBvtnVsISNuyY4FToSJqgUJQ
O91xI5fsWRl1v50QHt6G
=Ee81
-----END PGP SIGNATURE-----

--nAK626QlAXCqO2R4na4p2rNuBafSAWft9--



Want to link to this message? Use this URL: <http://docs.FreeBSD.org/cgi/mid.cgi?52B93988.2050205>