[求助]postfix虚拟域没有成功

nothing9

main.cf 主要部分

virtual_alias_domains =
virtual_alias_maps = mysql:/etc/postfix/mysql-virtual_forwardings.cf mysql:/etc/postfix/mysql-virtual_email2email.cf
virtual_mailbox_domains = mysql:/etc/postfix/mysql-virtual_domains.cf
virtual_mailbox_maps = mysql:/etc/postfix/mysql-virtual_mailboxes.cf
virtual_mailbox_base = /home/vmail
virtual_uid_maps = static:5000
virtual_gid_maps = static:5000
smtpd_sasl_auth_enable = yes
broken_sasl_auth_clients = yes
smtpd_recipient_restrictions = permit_mynetworks, permit_sasl_authenticated, reject_unauth_destination

执行 echo "hello" | mail user@example.com 和 尝试 telnet localhost 25 登陆后的日志

邮件日志如下 mail.log

Jun  5 16:41:21 debian authdaemond.mysql: modules="authmysql", daemons=5
Jun  5 16:41:21 debian authdaemond.mysql: modules="authmysql", daemons=5
Jun  5 16:41:35 debian postfix/pickup[4423]: F160A3B80: uid=0 from=<root>
Jun  5 16:41:35 debian postfix/cleanup[4533]: warning: F160A3B80: virtual_alias_maps map lookup problem for user@example.com
Jun  5 16:41:35 debian postfix/pickup[4423]: warning: maildrop/E58053B38: Error writing message file
Jun  5 16:42:04 debian postfix/pickup[4423]: 99D823B86: uid=0 from=<root>
Jun  5 16:42:04 debian postfix/cleanup[4533]: warning: connect to mysql server 127.0.0.1: Host 'localhost.localdomain' is not allowed to connect to this MySQL server
Jun  5 16:42:04 debian postfix/cleanup[4533]: warning: 99D823B86: virtual_alias_maps map lookup problem for user@example.com
Jun  5 16:42:04 debian postfix/pickup[4423]: warning: maildrop/E58053B38: Error writing message file
Jun  5 16:42:04 debian postfix/pickup[4423]: 9D4373B86: uid=0 from=<root>
Jun  5 16:42:04 debian postfix/cleanup[4533]: warning: 9D4373B86: virtual_alias_maps map lookup problem for user@example.com
Jun  5 16:42:04 debian postfix/pickup[4423]: warning: maildrop/989513B80: Error writing message file
Jun  5 16:42:35 debian postfix/pickup[4423]: 9E2B73B85: uid=0 from=<root>
Jun  5 16:42:35 debian postfix/cleanup[4571]: warning: connect to mysql server 127.0.0.1: Host 'localhost.localdomain' is not allowed to connect to this MySQL server
Jun  5 16:42:35 debian postfix/cleanup[4571]: warning: 9E2B73B85: virtual_alias_maps map lookup problem for user@example.com
Jun  5 16:42:35 debian postfix/pickup[4423]: warning: maildrop/E58053B38: Error writing message file
Jun  5 16:42:35 debian postfix/pickup[4423]: 9FC373B85: uid=0 from=<root>
Jun  5 16:42:35 debian postfix/cleanup[4533]: warning: 9FC373B85: virtual_alias_maps map lookup problem for user@example.com
Jun  5 16:42:35 debian postfix/pickup[4423]: warning: maildrop/989513B80: Error writing message file
Jun  5 16:43:05 debian courierpop3login: Connection, ip=[::ffff:127.0.0.1]
Jun  5 16:43:16 debian courierpop3login: LOGIN FAILED, ip=[::ffff:127.0.0.1]
Jun  5 16:43:35 debian postfix/pickup[4423]: 9E55D3B85: uid=0 from=<root>
Jun  5 16:43:35 debian postfix/cleanup[4571]: warning: 9E55D3B85: virtual_alias_maps map lookup problem for user@example.com
Jun  5 16:43:35 debian postfix/pickup[4423]: warning: maildrop/E58053B38: Error writing message file
Jun  5 16:43:35 debian postfix/pickup[4423]: 9F2A73B85: uid=0 from=<root>
Jun  5 16:43:35 debian postfix/cleanup[4533]: warning: connect to mysql server 127.0.0.1: Host 'localhost.localdomain' is not allowed to connect to this MySQL server
Jun  5 16:43:35 debian postfix/cleanup[4533]: warning: 9F2A73B85: virtual_alias_maps map lookup problem for user@example.com
Jun  5 16:43:35 debian postfix/pickup[4423]: warning: maildrop/989513B80: Error writing message file
Jun  5 16:43:37 debian courierpop3login: LOGIN FAILED, ip=[::ffff:127.0.0.1]
Jun  5 16:43:39 debian courierpop3login: LOGOUT, ip=[::ffff:127.0.0.1]
Jun  5 16:43:47 debian postfix/smtpd[4583]: connect from localhost.localdomain[127.0.0.1]
Jun  5 16:44:10 debian postfix/smtpd[4583]: warning: localhost.localdomain[127.0.0.1]: SASL login authentication failed
Jun  5 16:44:12 debian postfix/smtpd[4583]: disconnect from localhost.localdomain[127.0.0.1]
Jun  5 16:44:35 debian postfix/pickup[4423]: 685923B88: uid=0 from=<root>
Jun  5 16:44:35 debian postfix/cleanup[4571]: warning: connect to mysql server 127.0.0.1: Host 'localhost.localdomain' is not allowed to connect to this MySQL server
Jun  5 16:44:35 debian postfix/cleanup[4571]: warning: 685923B88: virtual_alias_maps map lookup problem for user@example.com
Jun  5 16:44:35 debian postfix/pickup[4423]: warning: maildrop/E58053B38: Error writing message file
Jun  5 16:44:35 debian postfix/pickup[4423]: 697AC3B88: uid=0 from=<root>
Jun  5 16:44:35 debian postfix/cleanup[4533]: warning: 697AC3B88: virtual_alias_maps map lookup problem for user@example.com
Jun  5 16:44:35 debian postfix/pickup[4423]: warning: maildrop/989513B80: Error writing message file
Jun  5 16:45:35 debian postfix/pickup[4423]: 683713B88: uid=0 from=<root>
Jun  5 16:45:35 debian postfix/cleanup[4533]: warning: connect to mysql server 127.0.0.1: Host 'localhost.localdomain' is not allowed to connect to this MySQL server
Jun  5 16:45:35 debian postfix/cleanup[4533]: warning: 683713B88: virtual_alias_maps map lookup problem for user@example.com
Jun  5 16:45:35 debian postfix/pickup[4423]: warning: maildrop/E58053B38: Error writing message file
Jun  5 16:45:35 debian postfix/pickup[4423]: 694C03B88: uid=0 from=<root>
Jun  5 16:45:35 debian postfix/cleanup[4571]: warning: 694C03B88: virtual_alias_maps map lookup problem for user@example.com
Jun  5 16:45:35 debian postfix/pickup[4423]: warning: maildrop/989513B80: Error writing message file
Jun  5 16:45:45 debian postfix/smtpd[4583]: connect from localhost.localdomain[127.0.0.1]
Jun  5 16:46:19 debian postfix/smtpd[4583]: warning: localhost.localdomain[127.0.0.1]: SASL login authentication failed
Jun  5 16:46:24 debian postfix/smtpd[4583]: disconnect from localhost.localdomain[127.0.0.1]
Jun  5 16:46:35 debian postfix/pickup[4423]: B04C73B88: uid=0 from=<root>
Jun  5 16:46:35 debian postfix/cleanup[4533]: warning: B04C73B88: virtual_alias_maps map lookup problem for user@example.com
Jun  5 16:46:35 debian postfix/pickup[4423]: warning: maildrop/E58053B38: Error writing message file
Jun  5 16:46:35 debian postfix/pickup[4423]: B131C3B88: uid=0 from=<root>
Jun  5 16:46:35 debian postfix/cleanup[4571]: warning: connect to mysql server 127.0.0.1: Host 'localhost.localdomain' is not allowed to connect to this MySQL server
Jun  5 16:46:35 debian postfix/cleanup[4571]: warning: B131C3B88: virtual_alias_maps map lookup problem for user@example.com
Jun  5 16:46:35 debian postfix/pickup[4423]: warning: maildrop/989513B80: Error writing message file
Jun  5 16:46:53 debian postfix/pickup[4423]: 91DB83B8C: uid=0 from=<root>
Jun  5 16:46:53 debian postfix/cleanup[4571]: warning: 91DB83B8C: virtual_alias_maps map lookup problem for user@example.com
Jun  5 16:46:53 debian postfix/pickup[4423]: warning: maildrop/E58053B38: Error writing message file
Jun  5 16:46:53 debian postfix/pickup[4423]: 92A583B8C: uid=0 from=<root>
Jun  5 16:46:53 debian postfix/cleanup[4533]: warning: connect to mysql server 127.0.0.1: Host 'localhost.localdomain' is not allowed to connect to this MySQL server
Jun  5 16:46:53 debian postfix/cleanup[4533]: warning: 92A583B8C: virtual_alias_maps map lookup problem for user@example.com
Jun  5 16:46:53 debian postfix/pickup[4423]: warning: maildrop/989513B80: Error writing message file
Jun  5 16:46:53 debian postfix/pickup[4423]: 93C203B8C: uid=0 from=<root>
Jun  5 16:46:53 debian postfix/cleanup[4571]: warning: 93C203B8C: virtual_alias_maps map lookup problem for admin@example.com
Jun  5 16:46:53 debian postfix/pickup[4423]: warning: maildrop/909E33B88: Error writing message file
Jun  5 16:47:35 debian postfix/pickup[4423]: 616C73B8B: uid=0 from=<root>
Jun  5 16:47:35 debian postfix/cleanup[4533]: warning: 616C73B8B: virtual_alias_maps map lookup problem for user@example.com
Jun  5 16:47:35 debian postfix/pickup[4423]: warning: maildrop/E58053B38: Error writing message file
Jun  5 16:47:35 debian postfix/pickup[4423]: 622833B8B: uid=0 from=<root>
Jun  5 16:47:35 debian postfix/cleanup[4571]: warning: 622833B8B: virtual_alias_maps map lookup problem for user@example.com
Jun  5 16:47:35 debian postfix/pickup[4423]: warning: maildrop/989513B80: Error writing message file
Jun  5 16:47:35 debian postfix/pickup[4423]: 62D133B8B: uid=0 from=<root>
Jun  5 16:47:35 debian postfix/cleanup[4571]: warning: 62D133B8B: virtual_alias_maps map lookup problem for admin@example.com
Jun  5 16:47:35 debian postfix/pickup[4423]: warning: maildrop/909E33B88: Error writing message file
Jun  5 16:48:35 debian postfix/pickup[4423]: AB96F3B8B: uid=0 from=<root>
Jun  5 16:48:35 debian postfix/cleanup[4571]: warning: connect to mysql server 127.0.0.1: Host 'localhost.localdomain' is not allowed to connect to this MySQL server
Jun  5 16:48:35 debian postfix/cleanup[4571]: warning: AB96F3B8B: virtual_alias_maps map lookup problem for user@example.com
Jun  5 16:48:35 debian postfix/pickup[4423]: warning: maildrop/E58053B38: Error writing message file
Jun  5 16:48:35 debian postfix/pickup[4423]: ACBC33B8B: uid=0 from=<root>
Jun  5 16:48:35 debian postfix/cleanup[4533]: warning: connect to mysql server 127.0.0.1: Host 'localhost.localdomain' is not allowed to connect to this MySQL server
Jun  5 16:48:35 debian postfix/cleanup[4533]: warning: ACBC33B8B: virtual_alias_maps map lookup problem for user@example.com
Jun  5 16:48:35 debian postfix/pickup[4423]: warning: maildrop/989513B80: Error writing message file
Jun  5 16:48:35 debian postfix/pickup[4423]: ADD8A3B8B: uid=0 from=<root>
Jun  5 16:48:35 debian postfix/cleanup[4533]: warning: ADD8A3B8B: virtual_alias_maps map lookup problem for admin@example.com
Jun  5 16:48:35 debian postfix/pickup[4423]: warning: maildrop/909E33B88: Error writing message file

请问：这是哪里没有配置好？请指点，谢了先～～～

nothing9

附上现在配置的完整的相关文件
main.cf

# See /usr/share/postfix/main.cf.dist for a commented, more complete version

smtpd_banner = $myhostname ESMTP $mail_name (Debian/GNU)
biff = no

# appending .domain is the MUA's job.
append_dot_mydomain = no

# Uncomment the next line to generate "delayed mail" warnings
#delay_warning_time = 4h

myhostname = debian.example.com
alias_maps = hash:/etc/aliases
alias_database = hash:/etc/aliases
myorigin = /etc/mailname
mydestination = debian.example.com, localhost.example.com, localhost
relayhost =
mynetworks = 127.0.0.0/8
mailbox_command = procmail -a "$EXTENSION"
mailbox_size_limit = 0
recipient_delimiter = +
inet_interfaces = all
virtual_alias_domains =
virtual_alias_maps = mysql:/etc/postfix/mysql-virtual_forwardings.cf mysql:/etc/postfix/mysql-virtual_email2email.cf
virtual_mailbox_domains = mysql:/etc/postfix/mysql-virtual_domains.cf
virtual_mailbox_maps = mysql:/etc/postfix/mysql-virtual_mailboxes.cf
virtual_mailbox_base = /home/vmail
virtual_uid_maps = static:5000
virtual_gid_maps = static:5000
smtpd_sasl_auth_enable = yes
broken_sasl_auth_clients = yes
smtpd_recipient_restrictions = permit_mynetworks,permit_sasl_authenticated,reject_unauth_destination
smtpd_use_tls = yes
smtpd_tls_cert_file = /etc/postfix/smtpd.cert
smtpd_tls_key_file = /etc/postfix/smtpd.key

nothing9

mysql-virtual_domains.cf

user = provider_admin
password = mypass
dbname = provider
table = domains
select_field = 'virtual'
where_field = domain
hosts = 127.0.0.1

mysql-virtual_email2email.cf

user = provider_admin
password = mypass
dbname = provider
table = users
select_field = email
where_field = email
hosts = 127.0.0.1

mysql-virtual_forwardings.cf

user = provider_admin
password = mypass
dbname = provider
table = forwardings
select_field = destination
where_field = source
hosts = 127.0.0.1

mysql-virtual_mailboxes.cf

user = provider_admin
password = mypass
dbname = provider
table = users
select_field = CONCAT(SUBSTRING_INDEX(email,'@',-1),'/',SUBSTRING_INDEX(email,'@',1),'/')
where_field = email
hosts = 127.0.0.1

顺便请问：那一句 CONCAT 中是用 单引号，还是主键盘上数字1旁边的那个键？