SASL stoped working

[Jorge Bastos]

Nothing.

I have in smtpd.conf:

pwcheck_method: auxprop
auxprop_plugin: sql
mech_list: plain login cram-md5 digest-md5
sql_engine: mysql
sql_hostnames: 127.0.0.1
sql_user: user
sql_passwd: pwd
sql_database: postfix
sql_select: select password from smtp_auth_users where username='%u' and 
status='true'

the postfix debug info show's me:

Aug 25 21:17:17 lira postfix/smtpd[32305]: SASL authentication debug: could 
not find auxprop plugin, was searching for 'sql'
Aug 25 21:17:17 lira last message repeated 3 times
Aug 25 21:17:17 lira postfix/smtpd[32305]: warning: unknown[84.91.34.156]: 
SASL LOGIN authentication failed: authentication failure
Aug 25 21:17:17 lira postfix/smtpd[32305]: > unknown[84.91.34.156]: 535 
5.7.0 Error: authentication failed: authentication failure


if i change smtpd.conf to:

pwcheck_method: auxprop
auxprop_plugin: sasldb
mech_list: plain login cram-md5 digest-md5

and do the folowing:

lira:/etc/postfix/sasl# saslpasswd2 user
Password:
Again (for verification):
lira:/etc/postfix/sasl# testsaslauthd -u user -p 123
0: OK "Success."

Now to make sure that postfix/saslauthd is reading /etc/sasldb2 i changed 
the permitions of it with
chmod 0 /etc/sasldb2

and postfix show's me:
Aug 25 21:21:47 lira postfix/smtpd[32607]: > unknown[84.91.34.156]: 
250-STARTTLS
Aug 25 21:21:47 lira postfix/smtpd[32607]: > unknown[84.91.34.156]: 250-AUTH 
CRAM-MD5 DIGEST-MD5 LOGIN PLAIN
Aug 25 21:21:47 lira postfix/smtpd[32607]: match_list_match: unknown: no 
match
Aug 25 21:21:47 lira postfix/smtpd[32607]: match_list_match: 84.91.34.156: 
no match
Aug 25 21:21:47 lira postfix/smtpd[32607]: > unknown[84.91.34.156]: 
250-AUTH=CRAM-MD5 DIGEST-MD5 LOGIN PLAIN
Aug 25 21:21:47 lira postfix/smtpd[32607]: > unknown[84.91.34.156]: 
250-ENHANCEDSTATUSCODES
Aug 25 21:21:47 lira postfix/smtpd[32607]: > unknown[84.91.34.156]: 
250-8BITMIME
Aug 25 21:21:47 lira postfix/smtpd[32607]: > unknown[84.91.34.156]: 250 DSN
Aug 25 21:21:47 lira postfix/smtpd[32607]: watchdog_pat: 0x808a4e8
Aug 25 21:21:47 lira postfix/smtpd[32607]: < unknown[84.91.34.156]: AUTH 
LOGIN
Aug 25 21:21:47 lira postfix/smtpd[32607]: xsasl_cyrus_server_first: 
sasl_method LOGIN
Aug 25 21:21:47 lira postfix/smtpd[32607]: xsasl_cyrus_server_auth_response: 
uncoded server challenge: Username:
Aug 25 21:21:47 lira postfix/smtpd[32607]: > unknown[84.91.34.156]: 334 
VXNlcm5hbWU6
Aug 25 21:21:47 lira postfix/smtpd[32607]: < unknown[84.91.34.156]: dXNlcg==
Aug 25 21:21:47 lira postfix/smtpd[32607]: xsasl_cyrus_server_next: decoded 
response: user
Aug 25 21:21:47 lira postfix/smtpd[32607]: xsasl_cyrus_server_auth_response: 
uncoded server challenge: Password:
Aug 25 21:21:47 lira postfix/smtpd[32607]: > unknown[84.91.34.156]: 334 
UGFzc3dvcmQ6
Aug 25 21:21:47 lira postfix/smtpd[32607]: < unknown[84.91.34.156]: MTIz
Aug 25 21:21:47 lira postfix/smtpd[32607]: xsasl_cyrus_server_next: decoded 
response: 123
Aug 25 21:21:47 lira postfix/smtpd[32607]: warning: SASL authentication 
problem: unable to open Berkeley db /etc/sasldb2: Permission denied
Aug 25 21:21:47 lira postfix/smtpd[32607]: warning: SASL authentication 
problem: unable to open Berkeley db /etc/sasldb2: Permission denied
Aug 25 21:21:47 lira postfix/smtpd[32607]: warning: unknown[84.91.34.156]: 
SASL LOGIN authentication failed: authentication failure
Aug 25 21:21:47 lira postfix/smtpd[32607]: > unknown[84.91.34.156]: 535 
5.7.0 Error: authentication failed: authentication failure
Aug 25 21:21:47 lira postfix/smtpd[32607]: watchdog_pat: 0x808a4e8
Aug 25 21:21:47 lira postfix/smtpd[32607]: smtp_get: EOF


Ok, so i changed the permisions back to:
chmod 644 /etc/sasldb2

And tryed to use auth again and postfix show's me:

Aug 25 21:22:38 lira postfix/smtpd[32607]: > unknown[84.91.34.156]: 250-AUTH 
CRAM-MD5 DIGEST-MD5 LOGIN PLAIN
Aug 25 21:22:38 lira postfix/smtpd[32607]: match_list_match: unknown: no 
match
Aug 25 21:22:38 lira postfix/smtpd[32607]: match_list_match: 84.91.34.156: 
no match
Aug 25 21:22:38 lira postfix/smtpd[32607]: > unknown[84.91.34.156]: 
250-AUTH=CRAM-MD5 DIGEST-MD5 LOGIN PLAIN
Aug 25 21:22:38 lira postfix/smtpd[32607]: > unknown[84.91.34.156]: 
250-ENHANCEDSTATUSCODES
Aug 25 21:22:38 lira postfix/smtpd[32607]: > unknown[84.91.34.156]: 
250-8BITMIME
Aug 25 21:22:38 lira postfix/smtpd[32607]: > unknown[84.91.34.156]: 250 DSN
Aug 25 21:22:38 lira postfix/smtpd[32607]: watchdog_pat: 0x808a4e8
Aug 25 21:22:38 lira postfix/smtpd[32607]: < unknown[84.91.34.156]: AUTH 
LOGIN
Aug 25 21:22:38 lira postfix/smtpd[32607]: xsasl_cyrus_server_first: 
sasl_method LOGIN
Aug 25 21:22:38 lira postfix/smtpd[32607]: xsasl_cyrus_server_auth_response: 
uncoded server challenge: Username:
Aug 25 21:22:38 lira postfix/smtpd[32607]: > unknown[84.91.34.156]: 334 
VXNlcm5hbWU6
Aug 25 21:22:38 lira postfix/smtpd[32607]: < unknown[84.91.34.156]: dXNlcg==
Aug 25 21:22:38 lira postfix/smtpd[32607]: xsasl_cyrus_server_next: decoded 
response: user
Aug 25 21:22:38 lira postfix/smtpd[32607]: xsasl_cyrus_server_auth_response: 
uncoded server challenge: Password:
Aug 25 21:22:38 lira postfix/smtpd[32607]: > unknown[84.91.34.156]: 334 
UGFzc3dvcmQ6
Aug 25 21:22:38 lira postfix/smtpd[32607]: < unknown[84.91.34.156]: MTIz
Aug 25 21:22:38 lira postfix/smtpd[32607]: xsasl_cyrus_server_next: decoded 
response: 123
Aug 25 21:22:38 lira postfix/smtpd[32607]: warning: unknown[84.91.34.156]: 
SASL LOGIN authentication failed: authentication failure
Aug 25 21:22:38 lira postfix/smtpd[32607]: > unknown[84.91.34.156]: 535 
5.7.0 Error: authentication failed: authentication failure
Aug 25 21:22:38 lira postfix/smtpd[32607]: watchdog_pat: 0x808a4e8
Aug 25 21:22:38 lira postfix/smtpd[32607]: smtp_get: EOF


Is this my problem, or some problem with the latest packages?


Jorge





----- Original Message ----- 
From: "Patrick Ben Koetter" <p at state-of-mind.de>
To: <cyrus-sasl at lists.andrew.cmu.edu>
Sent: Saturday, August 25, 2007 8:36 PM
Subject: Re: SASL stoped working


>* mysql.jorge at decimal.pt <mysql.jorge at decimal.pt>:
>> Hi,
>> I updated to the last SID packages and now sasl stoped working.
>> I updated sasl and postfix.
>> I have auxprop plugin with sql, i was checking the mysql log and it
>> doesn't connect to mysql even.
>> Does anyone know is there was some configuration changes?
>
> Move /etc/postfix/sasl/smtpd.conf to /etc/sasl2/smtpd.conf.
>
> p at rick
>
> -- 
> The Book of Postfix
> <http://www.postfix-book.com>
> saslfinger (debugging SMTP AUTH):
> <http://postfix.state-of-mind.de/patrick.koetter/saslfinger/>
>