From owner-freebsd-questions@FreeBSD.ORG  Tue Dec 24 01:08:39 2013
Return-Path: <owner-freebsd-questions@FreeBSD.ORG>
Delivered-To: freebsd-questions@freebsd.org
Received: from mx1.freebsd.org (mx1.freebsd.org [8.8.178.115])
 (using TLSv1 with cipher ADH-AES256-SHA (256/256 bits))
 (No client certificate requested)
 by hub.freebsd.org (Postfix) with ESMTPS id 87230573
 for <freebsd-questions@freebsd.org>; Tue, 24 Dec 2013 01:08:39 +0000 (UTC)
Received: from neonpark.inter-sonic.com (neonpark.inter-sonic.com
 [212.247.8.98])
 (using TLSv1 with cipher ADH-CAMELLIA256-SHA (256/256 bits))
 (No client certificate requested)
 by mx1.freebsd.org (Postfix) with ESMTPS id 4A71B1F22
 for <freebsd-questions@freebsd.org>; Tue, 24 Dec 2013 01:08:39 +0000 (UTC)
X-Virus-Scanned: amavisd-new at BSDLabs AB
Message-ID: <52B8DD09.2090605@intersonic.se>
Date: Tue, 24 Dec 2013 02:02:01 +0100
From: Per olof Ljungmark <peo@intersonic.se>
Organization: Intersonic AB
User-Agent: Mozilla/5.0 (X11; FreeBSD amd64;
 rv:24.0) Gecko/20100101 Thunderbird/24.1.0
MIME-Version: 1.0
To: dweimer@dweimer.net, 
 FreeBSD Questions <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>
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
X-BeenThere: freebsd-questions@freebsd.org
X-Mailman-Version: 2.1.17
Precedence: list
List-Id: User questions <freebsd-questions.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/options/freebsd-questions>, 
 <mailto:freebsd-questions-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-questions/>
List-Post: <mailto:freebsd-questions@freebsd.org>
List-Help: <mailto:freebsd-questions-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-questions>, 
 <mailto:freebsd-questions-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Tue, 24 Dec 2013 01:08:39 -0000

On 2013-12-20 21: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?
> 

Perhaps cyrus-sasl2 is compiled with sql support? Did you install
packages or "make install" from ports?