postfix sasl mysql 认证出错 帮忙提个建议

weifeng270

这是加了邮件后缀认证的通过的方法 。
root@erabay:/etc/postfix/mysql# perl -MMIME::Base64 -e 'print encode_base64("\0kkk\@\kkk.com\0kkk");'
AGtra0Bra2suY29tAGtraw==

my email accont kkk@kkk.com

root@erabay:/etc/postfix/mysql# vim /etc/postfix/sasl/smtpd.conf
pwcheck_method:auxprop
auxprop_plugin:sql
#sql_select: SELECT password FROM mailbox WHERE username='%u@%d' and active='1'
#sql_select: SELECT password FROM mailbox WHERE username='%u@%r' and domain='%r'and active='1'
sql_select: SELECT password FROM mailbox WHERE username='%u@%r' and domain='%r'and active='1'
#sql_select: SELECT password FROM mailbox WHERE username='%u'
#sql_select: SELECT password FROM admin WHERE username='%u@' and domain='%r'and active='1'

#mech_list: plain login

#sql_select: SELECT password FROM admin WHERE username = '%u@%r' and active='1'

#sql_select: SELECT password FROM admin WHERE username = '%u' and active='1'
#sql_select: SELECT password FROM admin WHERE username = '%u' and active='1'
sql_engine:mysql
sql_hostnames:127.0.0.1
sql_user:postfix
sql_passwd:kernel
sql_database:postfix
log_level: 7
#log_level: 5


这个是smtpd.conf 设置




root@erabay:/etc/postfix/mysql# telnet localhost 25
Trying 127.0.0.1...
Connected to localhost.
Escape character is '^]'.
220 mail.erabay.com ESMTP Postfix (Ubuntu)
ehlo kkk
250-mail.erabay.com
250-PIPELINING
250-SIZE 10240000
250-VRFY
250-ETRN
250-AUTH DIGEST-MD5 NTLM LOGIN CRAM-MD5 PLAIN
250-AUTH=DIGEST-MD5 NTLM LOGIN CRAM-MD5 PLAIN
250-ENHANCEDSTATUSCODES
250-8BITMIME
250 DSN
auth plain
334
AGtra0Bra2suY29tAGtraw==
235 2.0.0 Authentication successful
^]
telnet> quit