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

weifeng270

root@kernel:/etc/postfix/mysql# telnet mail.erabay.cn 25
Trying 58.246.26.66...
Connected to mail.erabay.cn.
Escape character is '^]'.
220 erabay.com ESMTP Postfix (Ubuntu)
ehlo kkk
250-erabay.com
250-PIPELINING
250-SIZE 10240000
250-VRFY
250-ETRN
250-STARTTLS
250-AUTH PLAIN LOGIN
250-AUTH=PLAIN LOGIN
250-ENHANCEDSTATUSCODES
250-8BITMIME
250 DSN
auth plain
334
AGtrawBra2s=
535 5.7.0 Error: authentication failed: authentication failure





"mysql_virtual_mailbox_maps.cf" 8L, 173C written              
root@kernel:/etc/postfix/mysql# postconf -n
alias_database = hash:/etc/aliases
alias_maps = hash:/etc/aliases
append_dot_mydomain = no
biff = no
broken_sasl_auth_clients = yes
config_directory = /etc/postfix
home_mailbox = Maildir/
inet_interfaces = all
inet_protocols = ipv4
mailbox_size_limit = 0
mydestination = mail.erabay.com, kernel, localhost
myhostname = erabay.com
mynetworks = 127.0.0.0/8
myorigin = /etc/mailname
recipient_delimiter = +
relayhost =
smtp_tls_session_cache_database = btree{queue_directory}/smtp_scache
smtpd_banner = $myhostname ESMTP $mail_name (Ubuntu)
smtpd_recipient_restrictions = permit_sasl_authenticated,permit_mynetworks,reject_unauth_destination
smtpd_sasl_auth_enable = yes
smtpd_sasl_security_options = noanonymous
smtpd_tls_cert_file = /etc/ssl/certs/ssl-cert-snakeoil.pem
smtpd_tls_key_file = /etc/ssl/private/ssl-cert-snakeoil.key
smtpd_tls_session_cache_database = btree{queue_directory}/smtpd_scache
smtpd_use_tls = yes
virtual_gid_maps = static:5000
virtual_mailbox_base = /home/vmail
virtual_mailbox_domains = mysql:/etc/postfix/mysql/mysql_virtual_domains_maps.cf
virtual_mailbox_maps = mysql:/etc/postfix/mysql/mysql_virtual_mailbox_maps.cf
virtual_uid_maps = static:5000
root@kernel:/etc/postfix/mysql#






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'



root@kernel:/etc/postfix/mysql# postmap -q "kkk@erabay.cn" mysql:/etc/postfix/mysql/mysql_virtual_mailbox_maps.cf
/home/vmail/
root@kernel:/etc/postfix/mysql# postmap -q "mail.erabay.cn" mysql:/etc/postfix/mysql/mysql_virtual_domains_maps.cf
erabay.cn

root@kernel:~# perl -MMIME::Base64 -e 'print encode_base64("\0kernel\0kernel";'
AGtlcm5lbABrZXJuZWw=
root@kernel:~# perl -MMIME::Base64 -e 'print encode_base64("\0kkk\0kkk";'
AGtrawBra2s=      this is right
root@kernel:~# perl -MMIME::Base64 -e 'print encode_base64("\0kkk@erabay.cn\0kkk";'
AGtray5jbgBra2s=
root@kernel:~# perl -MMIME::Base64 -e 'print encode_base64("\0kernel@erabay.cn\0kkk";'
AGtlcm5lbC5jbgBra2s=

root@kernel:/etc/postfix/mysql# telnet mail.erabay.cn 25
Trying 58.246.26.66...
Connected to mail.erabay.cn.
Escape character is '^]'.
220 erabay.com ESMTP Postfix (Ubuntu)
ehlo kkk
250-erabay.com
250-PIPELINING
250-SIZE 10240000
250-VRFY
250-ETRN
250-STARTTLS
250-AUTH PLAIN LOGIN
250-AUTH=PLAIN LOGIN
250-ENHANCEDSTATUSCODES
250-8BITMIME
250 DSN
auth plain
334
AGtrawBra2s=
535 5.7.0 Error: authentication failed: authentication failure

[ 本帖最后由 weifeng270 于 2008-1-23 17:45 编辑 ]

weifeng270

就是这个地方出错了。
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

就是这个出错了。
kernel postfix/smtpd[4351]: sql plugin doing query SELECT password FROM mailbox WHERE username='kkk.cn@erabay.com'

sosogh

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

建议查看一下mysql中数据表建立是否正常，域相关设置是否正常。

reymundo

首先要看你的Postfix是什么版本，如果低于2.2，你可以选用旧的查询格式编写，否则就要按这种格式编写query。还有一点要注意：文档中建议别用"localhost"作为mysql的host值，因为这样会读Unix的socket，建议用TCP格式，如本机就用127.0.0.1。

其次要看看你的username字段究竟存的是什么字符串，如果是username@domain.com完整格式地址的话，query中只要用%s就可以了，%s只是替换掉不可预见的多余字符，能保证还原从报头中获取到的邮件地址；而%u则替换掉邮件地址中"@domain.com"部分，剩下的当然是username了；%d则替换掉邮件地址中"username@"部分，余下domain.com部分。以上是比较常用的，其他格式请看看postfix关于mysql table部分的文档。参考后调整一下你的SQL语句就应该没问题了。

mdnght

mail.log 出现这样的问题是什么原因？


Feb  2 20:51:18 debian postfix/proxymap[5567]: fatal: open /etc/Postfix/mysql_virtual_sender_maps.cf: Permission denied
Feb  2 20:51:19 debian postfix/cleanup[3155]: warning: premature end-of-input on private/proxymap socket while reading input attribute name
Feb  2 20:51:19 debian postfix/cleanup[3155]: warning: private/proxymap socket: service dict_proxy_open: Success
Feb  2 20:51:19 debian postfix/master[3144]: warning: process /usr/lib/postfix/proxymap pid 5567 exit status 1
Feb  2 20:51:19 debian postfix/master[3144]: warning: /usr/lib/postfix/proxymap: bad command startup -- throttling

weifeng270

谢谢。我再去试一下。
在提交一个完整的。

weifeng270

没有权限。你再加点权限。

weifeng270

这个主题到这里结束。

我发现了新的问题。

总结就是vim /var/log/messages
vim /var/log/maillog