SASL stoped working

Sat Aug 25 16:55:17 EDT 2007

Ok i have it working using sasldb2.
But, the auxprop with sql mysql plugin still not working, this may be a bug, 
from the package? or sasl?

Jorge

----- Original Message ----- 
From: "Jorge Bastos" <mysql.jorge at decimal.pt>
To: "Patrick Ben Koetter" <p at state-of-mind.de>; 
<cyrus-sasl at lists.andrew.cmu.edu>
Sent: Saturday, August 25, 2007 9:23 PM
Subject: Re: SASL stoped working

> 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/>
>>
>
> 