[WBEL-users] Postfix sasl mylsq : SASL PLAIN authentication failed

[Christian Huegel]

Hello everybody,


i´m trying to set up postfix with sasl AUTH against an mysql-database 
and when i connect from evolution i get the following message in mail.log :
	SASL PLAIN authentication failed


Here are the configs i´m using:
/usr/lib/sasl2/smtpd.conf:

  log_level: 3
pwcheck_method: auxprop
auxprop_plugin: sql
mech_list: PLAIN LOGIN CRAM-MD5 DIGEST-MD5
sql_engine: mysql
sql_hostnames: localhost
sql_user: vmailuser
sql_passwd: *****
sql_database: mail
sql_select: select clear from postfix_users where email='%u@%r'
sql_usessl: no

/etc/postfix/main.cf:

-----snip--------
smtpd_sasl_auth_enable = yes
smtpd_sasl_security_options = noanonymous
smtpd_sasl_local_domain = $myhostname
broken_sasl_auth_clients = yes
smtpd_recipient_restrictions = permit_sasl_authenticated,
reject_unauth_destination
alias_maps = mysql:/etc/postfix/mysql-aliases.cf
relocated_maps = mysql:/etc/postfix/mysql-relocated.cf
smtpd_helo_required = yes
disable_vrfy_command = yes
smtpd_data_restrictions = reject_unauth_pipelining
smtpd_etrn_restrictions = reject

# SSL Part

smtpd_use_tls = yes
smtp_use_tls = yes
smtpd_tls_auth_only = no
smtp_tls_note_starttls_offer = yes
smtpd_tls_key_file = /etc/postfix/ssl/smtpd.key
smtpd_tls_cert_file = /etc/postfix/ssl/smtpd.crt
smtpd_tls_CAfile = /etc/postfix/ssl/cacert.pem
smtpd_tls_loglevel = 1
smtpd_tls_received_header = yes
smtpd_tls_session_cache_timeout = 3600s
tls_random_source = dev:/dev/urandom
-------snap------------

telnet localhost 25

ehlo localhost
250-mail.postfix.de
250-PIPELINING
250-SIZE 10240000
250-ETRN
250-STARTTLS
250-AUTH PLAIN LOGIN DIGEST-MD5 CRAM-MD5
250-AUTH=PLAIN LOGIN DIGEST-MD5 CRAM-MD5
250 8BITMIME

The imapd-ssl authentication with the same username and passwort works 
fine with mysql.



Am i missing something?

Thanks, i guess i goo to sleep now: trying about 5 hours to get this 
working and i´m kind of frustated.

Best regards

Christian