Postfix - Sasl - mysql

[Brent Wiese]

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