How to Stop IMAP & LMTPUNIX from logging SQL engine 'mysql' not supported

[Matthew Seaman]

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.
> 
> 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 supported
> Dec 20 14:17:51 webmail lmtpunix[47578]: auxpropfunc error no mechanism
> available
> 
> 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.
> 
> # From /usr/local/etc/imapd.conf
> sasl_pwcheck_method: saslauthd
> 
> # From /etc/rc.conf
> cyrus_imapd_enable="YES"
> saslauthd_enable="YES"
> saslauthd_flgas="-a sasldb"
> sendmail_enable="YES"
> 
> # From /var/db/ports Options files.
> mail_cyrus-imapd24/options:OPTIONS_FILE_UNSET+=MYSQL
> security_cyrus-sasl2/options:OPTIONS_FILE_UNSET+=MYSQL
> 
> Anyone have any ideas what settings I am missing so that it stops trying
> to authenticate against the non existent mysql back end?
> 

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

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


-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 1036 bytes
Desc: OpenPGP digital signature
URL: <http://lists.freebsd.org/pipermail/freebsd-questions/attachments/20131224/b036d6e1/attachment.sig>