Postfix + SASL + MySQL...What did I miss?

看板FreeBSD作者virileman.時間21年前 (2004/07/29 00:01)推噓0(0推 0噓 0→)

留言0則, 0人參與討論串1/4 (看更多)

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: cyrus-imapd-2.2.6 cyrus-sasl-2.1.19 cyrus-sasl-saslauthd-2.1.19 postfix-2.1.4,1 (build with MySQL) I follow these instructions to set up smtpd.conf http://lists.freebsd.org/mailman/htdig/freebsd-questions/2004-April/042847.html http://lists.freebsd.org/pipermail/freebsd-questions/2004-March/039296.html 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[70.68.235.3] 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[70.68.235.3]: SASL PLAIN authentication failed Jul 27 21:09:05 me postfix/smtpd[771]: warning: S01060050fc412395.vf.shawcable.net[70.68.235.3]: SASL LOGIN authentication failed Jul 27 21:09:11 me postfix/smtpd[771]: lost connection after AUTH from S01060050fc412395.vf.shawcable.net[70.68.235.3] Jul 27 21:09:11 me postfix/smtpd[771]: disconnect from S01060050fc412395.vf.shawcable.net[70.68.235.3] mysql> use mail; mysql> select * from user; +----+----------+----------+---------+---------------+------------------------+-------- | ID | USERNAME | PASSWORD | FORWARD | DOMAIN | MAIL | FILTER +----+----------+----------+---------+---------------+------------------------+-------- | 1 | test | zzzzzz | test | me.uos.idv.tw | test@me.uos.idv.tw | OK | 2 | cyrus | zzzzzz | cyrus | me.uos.idv.tw | cyrus@me.uos.idv.tw | OK | 3 | kkk | zzzzzz | kkk | me.uos.idv.tw | kkk@mail.me.uos.idv.tw | 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='%u@%r' as well.