☰

收件人地址被拒绝：虚拟别名表中的用户未知

tag-icon • tag-icon email postfix postgresql
收件人地址被拒绝：虚拟别名表中的用户未知

我正在使用 Postfix 和 Dovecot 设置邮件服务器。发送邮件非常顺利，但接收邮件却不行。当我使用我的 GMail 帐户向自己发送电子邮件时，出现此错误： Recipient address rejected: User unknown in virtual alias table

我的用户存储在 PostgreSQL 表中。

这是我的main.cf：

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


# Debian specific:  Specifying a file name will cause the first
# line of that file to be used as the name.  The Debian default
# is /etc/mailname.
#myorigin = /etc/mailname

smtpd_banner = $myhostname ESMTP $mail_name (Ubuntu)
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

readme_directory = no

# TLS parameters
smtpd_tls_cert_file = /etc/letsencrypt/live/mydomain.com/fullchain.pem
smtpd_tls_key_file = /etc/letsencrypt/live/mydomain.com/privkey.pem
smtpd_use_tls = yes
smtpd_tls_session_cache_database = btree:${data_directory}/smtpd_scache
smtp_tls_session_cache_database = btree:${data_directory}/smtp_scache
smtpd_tls_mandatory_protocols=!SSLv2,!SSLv3
smtp_tls_mandatory_protocols=!SSLv2,!SSLv3
smtpd_tls_protocols=!SSLv2,!SSLv3
smtp_tls_protocols=!SSLv2,!SSLv3
smtpd_tls_exclude_ciphers = aNULL, eNULL, EXPORT, DES, RC4, MD5, PSK, aECDH, EDH-DSS-DES-CBC3-SHA, EDH-RSA-DES-CDC3-SHA, KRB5-DE5, CBC3-SHA

# See /usr/share/doc/postfix/TLS_README.gz in the postfix-doc package for
# information on enabling SSL in the smtp client.

smtpd_relay_restrictions = permit_mynetworks permit_sasl_authenticated defer_unauth_destination
myhostname = mydomain.com
virtual_alias_maps = pgsql:/etc/postfix/pgsql-virtual-aliases.cf
virtual_mailbox_maps = pgsql:/etc/postfix/pgsql-virtual-mailbox.cf
alias_maps = pgsql:/etc/postfix/pgsql-virtual-aliases.cf
#alias_database = pgsql:/etc/postfix/pgsql-virtual-aliases.cf
#local_recipient_maps = pgsql:/etc/postfix/pgsql-virtual-mailbox.cf
local_recipient_maps = 
myorigin = mydomain.com
mydestination = mydomain.com, localhost
relayhost = 
mynetworks = 127.0.0.0/8 [::ffff:127.0.0.0]/104 [::1]/128
#mailbox_command = procmail -a "$EXTENSION"
mailbox_command = 
mailbox_size_limit = 0
recipient_delimiter = +
inet_interfaces = all
inet_protocols = all

home_mailbox = Maildir/
smtpd_sasl_type = dovecot
smtpd_sasl_path = private/auth
smtpd_sasl_auth_enable = yes
smtpd_tls_auth_only = no
smtp_use_tls = yes
smtp_tls_note_starttls_offer = yes
smtpd_tls_loglevel = 1
smtpd_tls_received_header = yes
#smtpd_tls_session_cache_timeout = 3600s
smtpd_sasl_local_domain = mydomain.com
smtpd_sasl_security_options = noanonymous
broken_sasl_auth_clients = yes
smtpd_recipient_restrictions = permit_sasl_authenticated,permit_mynetworks,reject_unauth_destination
smtpd_client_restrictions = permit_sasl_authenticated,permit_mynetworks,reject_unknown_client_hostname
smtp_tls_security_level = may
smtpd_tls_security_level = may

pgsql-虚拟-别名.cf：

hosts = localhost
user = postfix
password = my_password
dbname = my_db

query = SELECT email FROM users WHERE email = '%s'

pgsql-虚拟邮箱.cf：

hosts = localhost
user = postfix
password = my_password
dbname = my_db

query = SELECT concat(email,'/') as email FROM users WHERE username='%u'

答案1

如果您已正确设置虚拟别名映射，只需从 main.cf 配置中删除此行：

myorigin = mydomain.com

建议来自这里：https://www.virtualmin.com/node/7746 我花了大量时间试图弄清楚为什么找不到虚拟用户。

相关内容