root@kernel:/etc/postfix/mysql# vim /etc/postfix/sasl/smtpd.conf
pwcheck_method: auxprop
auxprop_plugin: sql
mech_list: plain login
sql_engine: mysql
sql_hostnames: 127.0.0.1
sql_user: postfix
sql_passwd: postfix
sql_database: postfix
#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 admin WHERE username='%u@' and domain='%r'and active='1'
#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'
log_level: 7
Jan 23 16:28:53 kernel postfix/smtpd[4351]: sql plugin Parse the username kkk.cn
Jan 23 16:28:53 kernel postfix/smtpd[4351]: sql plugin try and connect to a host
Jan 23 16:28:53 kernel postfix/smtpd[4351]: sql plugin trying to open db 'postfix' on host '127.0.0.1'
Jan 23 16:28:53 kernel postfix/smtpd[4351]: sql plugin Parse the username kkk.cn
Jan 23 16:28:53 kernel postfix/smtpd[4351]: sql plugin try and connect to a host
Jan 23 16:28:53 kernel postfix/smtpd[4351]: sql plugin trying to open db 'postfix' on host '127.0.0.1'
Jan 23 16:28:53 kernel postfix/smtpd[4351]: begin transaction
Jan 23 16:28:53 kernel postfix/smtpd[4351]: sql plugin create statement from userPassword kkk.cn erabay.com
Jan 23 16:28:53 kernel postfix/smtpd[4351]: sql plugin doing query SELECT password FROM mailbox WHERE username='kkk.cn@erabay.com' and domain='erabay.com'and active='1';
Jan 23 16:28:53 kernel postfix/smtpd[4351]: sql plugin: no result found
Jan 23 16:28:53 kernel postfix/smtpd[4351]: sql plugin create statement from cmusaslsecretPLAIN kkk.cn erabay.com
Jan 23 16:28:53 kernel postfix/smtpd[4351]: sql plugin doing query SELECT password FROM mailbox WHERE username='kkk.cn@erabay.com' and domain='erabay.com'and active='1';
Jan 23 16:28:53 kernel postfix/smtpd[4351]: sql plugin: no result found
Jan 23 16:28:53 kernel postfix/smtpd[4351]: commit transaction
Jan 23 16:28:53 kernel postfix/smtpd[4351]: sql plugin Parse the username kkk.cn
Jan 23 16:28:53 kernel postfix/smtpd[4351]: sql plugin try and connect to a host
Jan 23 16:28:53 kernel postfix/smtpd[4351]: sql plugin trying to open db 'postfix' on host '127.0.0.1'
[ 本帖最后由 weifeng270 于 2008-1-23 17:45 编辑 ]作者: weifeng270 时间: 2008-01-23 21:52
就是这个地方出错了。
Jan 23 16:28:53 kernel postfix/smtpd[4351]: sql plugin create statement from userPassword kkk.cn erabay.com
Jan 23 16:28:53 kernel postfix/smtpd[4351]: sql plugin doing query SELECT password FROM mailbox WHERE username='kkk.cn@erabay.com' and domain='erabay.com'and active='1';
Jan 23 16:28:53 kernel postfix/smtpd[4351]: sql plugin: no result found
Jan 23 16:28:53 kernel postfix/smtpd[4351]: sql plugin create statement from cmusaslsecretPLAIN kkk.cn erabay.com
Jan 23 16:28:53 kernel postfix/smtpd[4351]: sql plugin doing query SELECT password FROM mailbox WHERE username='kkk.cn@erabay.com' and domain='erabay.com'and active='1';
Jan 23 16:28:53 kernel postfix/smtpd[4351]: sql plugin: no result found
Jan 23 16:28:53 kernel postfix/smtpd[4351]: commit transaction
Jan 23 16:28:53 kernel postfix/smtpd[4351]: sql plugin Parse the username kkk.cn
Jan 23 16:28:53 kernel postfix/smtpd[4351]: sql plugin try and connect to a host
Jan 23 16:28:53 kernel postfix/smtpd[4351]: sql plugin trying to open db 'postfix' on host '127.0.0.1'作者: weifeng270 时间: 2008-01-23 21:54
就是这个出错了。
kernel postfix/smtpd[4351]: sql plugin doing query SELECT password FROM mailbox WHERE username='kkk.cn@erabay.com'作者: sosogh 时间: 2008-01-29 18:58
Jan 23 16:28:53 kernel postfix/smtpd[4351]: sql plugin doing query SELECT password FROM mailbox WHERE username='kkk.cn@erabay.com' and domain='erabay.com'and active='1';
Jan 23 16:28:53 kernel postfix/smtpd[4351]: sql plugin: no result found
no result found哦作者: marion 时间: 2008-01-31 18:51
建议查看一下mysql中数据表建立是否正常,域相关设置是否正常。作者: reymundo 时间: 2008-02-02 03:47
首先要看你的Postfix是什么版本,如果低于2.2,你可以选用旧的查询格式编写,否则就要按这种格式编写query。还有一点要注意:文档中建议别用"localhost"作为mysql的host值,因为这样会读Unix的socket,建议用TCP格式,如本机就用127.0.0.1。
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