[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Authenticated SMTP using CYRUS SASL and MD5 crypted password on MySQL



Hello,

I'm configuring SMTP authenticated service in Postifix. I have installed
CYRUS SASL libraries 2.1.22 and rebuilded Postfix with CYRUS SASL
support:

# find /usr -name 'libsasl*.*'
/usr/local/lib/sasl2/libsasldb.so.2.0.22
/usr/local/lib/sasl2/libsasldb.so.2
/usr/local/lib/sasl2/libsasldb.so
/usr/local/lib/sasl2/libsasldb.la
/usr/local/lib/libsasl2.so.2.0.22
/usr/local/lib/libsasl2.so.2
/usr/local/lib/libsasl2.so
/usr/local/lib/libsasl2.la

Note that I'm using Postfix+MySQL and that password are stored in
mailbox table in MD5 format.

I've configured SMTP for CYRUS SASL:

# smtpd.conf
pwcheck_method: auxprop
auxprop_plugin: sql
mech_list: plain login

sql_engine: mysql
sql_hostnames: 127.0.0.1
sql_user: postfix
sql_passwd: ****
sql_database: postfix
sql_format: crypt
sql_select: select password from mailbox where name='%u' or
username='%u'
sql_verbose: yes

But I still cant authenticate for authenticated SMTP:

 # telnet 127.0.0.1 25
Trying 127.0.0.1...
Connected to 127.0.0.1.
Escape character is '^]'.
220 av7.sttspa.it
ehlo sttspa.it
250-av7.sttspa.it
250-PIPELINING
250-SIZE 35840000
250-VRFY
250-ETRN
250-AUTH LOGIN PLAIN
250-ENHANCEDSTATUSCODES
250-8BITMIME
250 DSN
AUTH PLAIN AGRlYnVnAGRlYnVn
535 5.7.8 Error: authentication failed: authentication failure

I'm sure that I'm wrong in something, but I can't understand what:

Jun 10 11:00:26 av7 postfix/smtpd[26270]: warning: SASL authentication
failure: Password veri fication failed
Jun 10 11:00:26 av7 postfix/smtpd[26270]: warning: localhost[127.0.0.1]:
SASL PLAIN authentic ation failed: authentication failure

Any hint is apprecciated.

Tnx,

rocsca