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: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?52B93988.2050205>