From owner-freebsd-questions@FreeBSD.ORG Wed Apr 7 16:51:32 2004 Return-Path: Delivered-To: freebsd-questions@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id DD9CF16A4CE for ; Wed, 7 Apr 2004 16:51:32 -0700 (PDT) Received: from relay01.roc.ny.frontiernet.net (relay01.roc.ny.frontiernet.net [66.133.131.34]) by mx1.FreeBSD.org (Postfix) with ESMTP id 1047643D1F for ; Wed, 7 Apr 2004 16:51:32 -0700 (PDT) (envelope-from drew@mykitchentable.net) Received: (qmail 26549 invoked from network); 7 Apr 2004 23:50:18 -0000 Received: from 67-51-124-168.dsl1.elk.ca.frontiernet.net (HELO blacklamb.mykitchentable.net) ([67.51.124.168]) (envelope-sender )SMTP for ; 7 Apr 2004 23:50:18 -0000 Received: from mykitchentable.net (unknown [165.107.42.233]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) by blacklamb.mykitchentable.net (Postfix) with ESMTP id 9BD843BF394; Wed, 7 Apr 2004 16:50:16 -0700 (PDT) Message-ID: <407493BB.7050206@mykitchentable.net> Date: Wed, 07 Apr 2004 16:50:19 -0700 From: Drew Tomlinson User-Agent: Mozilla Thunderbird 0.5 (Windows/20040207) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Brent Wiese References: <20040407193232.BHDM6191.fed1rmmtao09.cox.net@SAMBA> In-Reply-To: <20040407193232.BHDM6191.fed1rmmtao09.cox.net@SAMBA> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit cc: freebsd-questions@freebsd.org Subject: Re: Postfix - Sasl - mysql X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.1 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Wed, 07 Apr 2004 23:51:33 -0000 On 4/7/2004 12:32 PM Brent Wiese wrote: >>Brent Wiese wrote: >> >> >>>I (tried) following the instructions at: >>>http://high5.net/howto/ >>> >>>I have postfix virtual users working in MySQL. I have >>> >>> >>courier imap/pop3 >> >> >>>working w/ virtual users. I wanted to add SMTP auth. >>> >>>I added the cyrus-sasl2 port (also chose support for it in >>> >>> >>postfix port) >> >> >>>"WITH_MYSQL". >>> >>>No go. >>> >>>I added the following lines to >>> >>> >>/usr/local/lib/sasl2/smtpd.conf (found this >> >> >>>in another faq/tutorial, so it may be incorrect) >>> >>>sasl_pwcheck_method: auxprop >>>sasl_auxprop_plugin: sql >>> >>> >> sql_engine: mysql >> mech_list: login plain crammd6 digestmd5 >> >> >>>sql_user: postfix-user >>>sql_passwd: thepassword >>>sql_database: postfix >>>sql_statement: SELECT password FROM mailbox WHERE username = '%u' >>>sql_verbose: yes >>> >>> >>> >>That works for me.. >> >> > >No go. Still getting "no user in db" in /var/log/maillog. > >I get: >postfix/smtpd[23761]: sql_select option missing >postfix/smtpd[23761]: auxpropfunc error no mechanism available >In /var/log/messages > >I turned on logging in mysql and it didn't log any queries. > >Any other suggestions? > > Have you verified that "smtpd_sasl_local_domain =" and not "smtpd_sasl_local_domain =$myhostname" as shown in the how-to? Although I wasn't using MySQL, I still got the "no user in db" and "no secret in database" messages you were getting. It stumped me for weeks until I stumbled across the Postfix bug tidbit on the web. I'd be real curious to know if that solves your problems. Cheers, Drew