From owner-freebsd-questions@FreeBSD.ORG Tue Dec 24 07:37:01 2013 Return-Path: Delivered-To: freebsd-questions@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:1900:2254:206a::19:1]) (using TLSv1 with cipher ADH-AES256-SHA (256/256 bits)) (No client certificate requested) by hub.freebsd.org (Postfix) with ESMTPS id BBFDA8A0 for ; Tue, 24 Dec 2013 07:37:01 +0000 (UTC) Received: from smtp.infracaninophile.co.uk (smtp6.infracaninophile.co.uk [IPv6:2001:8b0:151:1:3cd3:cd67:fafa:3d78]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (No client certificate requested) by mx1.freebsd.org (Postfix) with ESMTPS id 6190116B4 for ; Tue, 24 Dec 2013 07:37:01 +0000 (UTC) Received: from seedling.black-earth.co.uk (seedling.black-earth.co.uk [81.2.117.99]) (authenticated bits=0) by smtp.infracaninophile.co.uk (8.14.7/8.14.7) with ESMTP id rBO7anrb012215 (version=TLSv1/SSLv3 cipher=DHE-RSA-CAMELLIA256-SHA bits=256 verify=NO) for ; Tue, 24 Dec 2013 07:36:55 GMT (envelope-from matthew@FreeBSD.org) DKIM-Filter: OpenDKIM Filter v2.8.3 smtp.infracaninophile.co.uk rBO7anrb012215 Authentication-Results: smtp.infracaninophile.co.uk/rBO7anrb012215; dkim=none reason="no signature"; dkim-adsp=none Message-ID: <52B93988.2050205@FreeBSD.org> Date: Tue, 24 Dec 2013 07:36:40 +0000 From: Matthew Seaman User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.6; rv:24.0) Gecko/20100101 Thunderbird/24.2.0 MIME-Version: 1.0 To: freebsd-questions@freebsd.org Subject: Re: How to Stop IMAP & LMTPUNIX from logging SQL engine 'mysql' not supported References: <4618c0cd6e7730f4d5265037c280e45c@dweimer.net> In-Reply-To: <4618c0cd6e7730f4d5265037c280e45c@dweimer.net> X-Enigmail-Version: 1.6 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="nAK626QlAXCqO2R4na4p2rNuBafSAWft9" X-Virus-Scanned: clamav-milter 0.98 at lucid-nonsense.infracaninophile.co.uk X-Virus-Status: Clean X-Spam-Status: No, score=-2.8 required=5.0 tests=ALL_TRUSTED,AWL,BAYES_00 autolearn=ham version=3.3.2 X-Spam-Checker-Version: SpamAssassin 3.3.2 (2011-06-06) on lucid-nonsense.infracaninophile.co.uk X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.17 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Tue, 24 Dec 2013 07:37:01 -0000 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--