Postfix + SASL + MySQL = PROBLEM

[Mathieu Arnold]

+-Le 29/10/2005 20:17 +0400, k K a dit :
| Hello.
| I need help.
| 
| I want to use mysql database to manage smtp authentication.
| I'm installing cyrus-sasl-2.1.21 with mysql support (from source code).
| Here is my smtpd.conf
| 
| pwcheck_method: auxprop
| auxprop_plugin: sql
| sql_engine: mysql
| sql_hostnames: localhost
| sql_user: mailuser
| sql_password: 123456
| sql_database: maildb
| sql_select: SELECT passwd FROM users WHERE userid='%u'
| sql_verbose: yes
| 
| I'm running postfix.
| And when I'm sending mail, in /var/log/maillog I can see:
| 
| postfix/smtpd[14871]: warning: SASL authentication failure: no secret in
| database
| postfix/smtpd[14871]: warning: unknown[192.168.0.51]: SASL CRAM-MD5
| authentication failed
| postfix/smtpd[14871]: warning: SASL authentication failure: Password
| verification failed
| postfix/smtpd[14871]: warning: unknown[192.168.0.51]: SASL PLAIN
| authentication failed
| postfix/smtpd[14871]: warning: unknown[192.168.0.51]: SASL LOGIN
| authentication failed
| 
| What's wrong?

Well, it does not seems that postfix is looking at your file, maybe you
could try to see what's postfix smtpd is doing exactly (adding -v to the
smtpd line in your master.cf or setting debug_* appropriately).

-- 
Mathieu Arnold