Re: Postfix + SASL + MySQL...What did I miss?
It works very well now. I can send and receive mails with
Mozilla-Thunderbird(MUA) on Windows XP.
I have add these configs:
# cat /usr/local/lib/sasl2/smtpd.conf
pwcheck_method: saslauthd
mech_list: plain login
# cat /usr/local/etc/imapd.conf
sasl_auxprop_plugin: sql
sasl_sql_engine: mysql
sasl_sql_hostnames: localhost
sasl_sql_user: mail
sasl_sql_passwd: *****
sasl_sql_database: mail
sasl_sql_statement: select PASSWORD from user where USERNAME = '%u'
sasl_sql_verbose: true
# cat /etc/pam.d/smtp
auth required pam_mysql.so user=mail passwd=***** host=localhost
db=mail table=user usercolumn=USERNAME passwdcolumn=PASSWORD crypt=0
sqllog=0
account sufficient pam_mysql.so user=mail passwd=***** host=localhost
db=mail table=user usercolumn=USERNAME passwdcolumn=PASSWORD crypt=0
sqllog=0
By the way, there is no accounst/passwords in /usr/local/etc/sasldb2,
but MySQL does.
And I add a new account, it can send and receive mails with
Mozilla-ThunderBird on Windows XP.
So HAYYP now,,I have been fighting with it for almost two months!!
Many thanks for the helps!!
討論串 (同標題文章)
FreeBSD 近期熱門文章
PTT數位生活區 即時熱門文章
