Postfix + SASL + MySQL = PROBLEM
k K
_k78 at rambler.ru
Sat Oct 29 12:17:47 EDT 2005
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?
More information about the Cyrus-sasl
mailing list