From owner-freebsd-questions@FreeBSD.ORG  Wed Apr  7 12:33:54 2004
Return-Path: <owner-freebsd-questions@FreeBSD.ORG>
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 8481716A4CE
	for <freebsd-questions@freebsd.org>;
	Wed,  7 Apr 2004 12:33:54 -0700 (PDT)
Received: from fed1rmmtao09.cox.net (fed1rmmtao09.cox.net [68.230.241.30])
	by mx1.FreeBSD.org (Postfix) with ESMTP id 3AAC843D1D
	for <freebsd-questions@freebsd.org>;
	Wed,  7 Apr 2004 12:33:54 -0700 (PDT)
	(envelope-from brently@bjwcs.com)
Received: from SAMBA ([68.231.19.60]) by fed1rmmtao09.cox.net
          (InterMail vM.6.01.03.01 201-2131-111-101-20040311) with ESMTP
          id <20040407193232.BHDM6191.fed1rmmtao09.cox.net@SAMBA>
          for <freebsd-questions@freebsd.org>;
          Wed, 7 Apr 2004 15:32:32 -0400
From: "Brent Wiese" <brently@bjwcs.com>
To: <freebsd-questions@freebsd.org>
Date: Wed, 7 Apr 2004 12:32:21 -0700
MIME-Version: 1.0
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: 7bit
X-Mailer: Microsoft Office Outlook, Build 11.0.5510
Thread-Index: AcQcbBqCIgvdQvomSJWJxxaeiW4DCwAZYRdQ
In-Reply-To: <4073A341.2040006@elvandar.org>
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
Message-Id: <20040407193232.BHDM6191.fed1rmmtao09.cox.net@SAMBA>
Subject: RE: Postfix - Sasl - mysql
X-BeenThere: freebsd-questions@freebsd.org
X-Mailman-Version: 2.1.1
Precedence: list
List-Id: User questions <freebsd-questions.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/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: Wed, 07 Apr 2004 19:33:54 -0000

> 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?