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

最新推荐文章于 2021-04-29 06:18:07 发布

wing glass

最新推荐文章于 2021-04-29 06:18:07 发布

阅读量170

点赞数

文章标签： auxprop mysql

本文链接：https://blog.csdn.net/weixin_32352621/article/details/113317189

版权

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

(2012-01-01 03:24:48)

标签：

认证

mysql

杂谈

postfix sasl mysql 认证出错帮忙提个建议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 FRO

吸奶器文档中建议别用"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语句就应该没问题了。:-)mail.log 出现这样的问题是什么原因？

Feb2 20:51:18 debian postfix/proxymap: fatal: open

/etc/Postfix/mysql_virtual_sender_maps.cf: Permission denied

Feb2 20:51:19 debian postfix/cleanup: warning: premature

end-of-input on private/proxymap socket while reading input

attribute name

Feb2 20:51:19 debian postfix/cleanup: warning: private/proxymap

socket: service dict_proxy_open: Success

Feb2 20:51:19 debian postfix/master: warning: process

/usr/lib/postfix/proxymap pid 5567 exit status 1

Feb2 20:51:19 debian postfix/master: warning:

/usr/lib/postfix/proxymap: bad command startup -- throttling回复 #6