Hi, everyone

Originally, I used /usr/local/etc/sasldb2 to store accounts/passwords(plain text) data,
and used Mozilla Thunderbird as my MUA. I can pass the SASL authentication(both smtp and imap) successfully.

After that, I wanted to use MySQL to store accounts/passwords(plain text),
but I got fail of SASL authentication.

I am using FreeBSD 5.2 release, and have complete installed these softwares from port:
postfix-2.1.4,1 (build with MySQL)

I follow these instructions to set up smtpd.conf

I have been searched and read many documents on mail-listing and google, but I still don't
know what I miss @@, and /var/log/maillog doesn't provide enough information to me to solve
the problem. I am sure that I have enter correct accounts/passwords.

Please note that it works well with /usr/local/etc/sasldb2, but not MySQL >"<
It seems to me that it doesn't talk to MySQL at all, because I tried
to use incorrect sql_user/sql_passwd in smtpd.conf, it gived me the same log in /var/log/maillog

Please give me some hints to fix this problem, I have tried it for several weeks, kind of tired,
but I don't want to give up. Thank you in advance.

These are some logs, and configurations: (the accounts and password are real, you can test it if you want)

# cat /var/log/maillog
Jul 27 21:09:01 me postfix/smtpd[771]: connect from S01060050fc412395.vf.shawcable.net[]
Jul 27 21:09:04 me postfix/smtpd[771]: warning: SASL authentication failure: Password verification failed
Jul 27 21:09:04 me postfix/smtpd[771]: warning: S01060050fc412395.vf.shawcable.net[]: SASL PLAIN authentication failed
Jul 27 21:09:05 me postfix/smtpd[771]: warning: S01060050fc412395.vf.shawcable.net[]: SASL LOGIN authentication failed
Jul 27 21:09:11 me postfix/smtpd[771]: lost connection after AUTH from S01060050fc412395.vf.shawcable.net[]
Jul 27 21:09:11 me postfix/smtpd[771]: disconnect from S01060050fc412395.vf.shawcable.net[]

mysql> use mail;
mysql> select * from user;
| 1 | test | zzzzzz | test | me.uos.idv.tw | [EMAIL PROTECTED] | OK
| 2 | cyrus | zzzzzz | cyrus | me.uos.idv.tw | [EMAIL PROTECTED] | OK
| 3 | kkk | zzzzzz | kkk | me.uos.idv.tw | [EMAIL PROTECTED] | OK
3 rows in set (0.02 sec)

I have these parameters in main.cf: broken_sasl_auth_clients = yes smtpd_sasl_auth_enable = yes smtpd_sasl_local_domain = smtpd_sender_restrictions = permit_mynetworks, permit_sasl_authenticated, reject_non_fqdn_sender smtpd_recipient_restrictions = permit_mynetworks, permit_sasl_authenticated, permit_auth_destination, permit_mx_backup, check_relay_domains, reject_unknown_recipient_domain, reject_non_fqdn_recipient, reject_unauth_destination, reject smtpd_client_restrictions = permit_mynetworks permit_sasl_authenticated reject_unauth_pipelining reject_unknown_client

# cat /usr/local/lib/sasl2/smtpd.conf pwcheck_method: auxprop auxprop_plugin: sql mech_list: plain login sql_engine: mysql sql_hostnames: localhost sql_user: mail sql_passwd: secret sql_database: mail sql_select: select PASSWORD from user where USERNAME='%u' sql_verbose: true

I have tried to change auxprop_plugin: mysql and USERNAME='[EMAIL PROTECTED]' as well.

Dont just search. Find. Check out the new MSN Search! http://search.msn.click-url.com/go/onm00200636ave/direct/01/

[EMAIL PROTECTED] mailing list
To unsubscribe, send any mail to "[EMAIL PROTECTED]"

Reply via email to