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@xxxxxxxxxx>
To: "Patrick Ben Koetter" <p@xxxxxxxxxxxxxxxx>;
<cyrus-sasl@xxxxxxxxxxxxxxxxxxxx>
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@xxxxxxxxxxxxxxxx>
To: <cyrus-sasl@xxxxxxxxxxxxxxxxxxxx>
Sent: Saturday, August 25, 2007 8:36 PM
Subject: Re: SASL stoped working
* mysql.jorge@xxxxxxxxxx <mysql.jorge@xxxxxxxxxx>:
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@rick
--
The Book of Postfix
<http://www.postfix-book.com>
saslfinger (debugging SMTP AUTH):
<http://postfix.state-of-mind.de/patrick.koetter/saslfinger/>
