我正在尝试设置后缀和多夫科特,后者将虚拟用户存储在 MySQL 数据库中,接下来是指导(但在这里我重述了所有内容,因为指南中有一些“错误”,我根据评论进行了修复。)序言:我已经从Ubuntu 存储库安装了Postfix
、Dovecot
和。postfix-mysql
dovecot-mysql
让我们从 Postfix 配置开始:
smtpd_banner = $myhostname ESMTP $mail_name (Ubuntu)
biff = no
readme_directory = no
myhostname = localhost
alias_maps = hash:/etc/aliases
alias_database = hash:/etc/aliases
mydestination = localhost
relayhost =
mynetworks = 127.0.0.0/8 [::ffff:127.0.0.0]/104 [::1]/128
mailbox_size_limit = 0
recipient_delimiter = +
inet_interfaces = all
relay_domains = *
virtual_alias_maps = proxy:mysql:/etc/postfix/virtual_alias_maps.cf
virtual_mailbox_domains = proxy:mysql:/etc/postfix/virtual_mailbox_domains.cf
virtual_mailbox_maps = proxy:mysql:/etc/postfix/virtual_mailbox_maps.cf
virtual_mailbox_base = /home/vmail
virtual_mailbox_limit = 512000000
virtual_minimum_uid = 5000
virtual_transport = virtual
virtual_uid_maps = static:5000
virtual_gid_maps = static:5000
local_transport = virtual
local_recipient_maps = $virtual_mailbox_maps
transport_maps = hash:/etc/postfix/transport
smtpd_sasl_auth_enable = yes
smtpd_sasl_type = dovecot
smtpd_sasl_path = /var/run/dovecot/auth-client
smtpd_recipient_restrictions = permit_mynetworks, permit_sasl_authenticated, reject_unauth_destination
smtpd_relay_restrictions = permit_mynetworks, permit_sasl_authenticated, reject_unauth_destination
smtpd_sasl_security_options = noanonymous
smtpd_sasl_tls_security_options = $smtpd_sasl_security_options
smtpd_tls_auth_only = yes
smtpd_tls_cert_file = /etc/ssl/private/server.crt
smtpd_tls_key_file = /etc/ssl/private/server.key
smtpd_sasl_local_domain = $myhostname
broken_sasl_auth_clients = yes
smtpd_tls_loglevel = 1
然后我创建了用户vmail
来存储电子邮件:
groupadd -g 5000 vmail
useradd -u 5000 -g vmail -s /usr/bin/nologin -d /home/vmail -m vmail
MySQL 数据库和用户用于存储有关域和虚拟用户的信息:
CREATE DATABASE postfix_db;
USE postfix_db;
CREATE USER postfix_user@localhost IDENTIFIED BY 'password';
GRANT ALL ON postfix_db.* TO postfix_user@localhost;
FLUSH PRIVILEGES;
然后我创建了与域、转发和用户相关的表:
CREATE TABLE `domains` (
`domain` varchar(50) NOT NULL default "",
PRIMARY KEY (`domain`),
UNIQUE KEY `domain` (`domain`)
);
CREATE TABLE `forwardings` (
`source` varchar(80) NOT NULL default "",
`destination` text NOT NULL,
PRIMARY KEY (`source`)
);
CREATE TABLE `users` (
`email` varchar(80) NOT NULL default "",
`password` varchar(20) NOT NULL default "",
`quota` varchar(20) NOT NULL default '20971520',
`domain` varchar(255) NOT NULL default "",
UNIQUE KEY `email` (`email`)
);
我在表中添加了我的域名(已正确设置 A 和 MX 记录):
INSERT INTO `domains` VALUES ('virtualdomain.tld');
以及与该域名相关的帐户:
INSERT INTO `users` VALUES ('[email protected]', ENCRYPT('password'), '20971520', 'virtualdomain.tld');
然后我创建了一个自签名证书:
cd /etc/ssl/private/
openssl genpkey -algorithm RSA -pkeyopt rsa_keygen_bits:2048 -out server.key
chmod 400 server.key
openssl req -new -key server.key -out server.csr
openssl x509 -req -days 365 -in server.csr -signkey server.key -out server.crt
chmod 444 server.crt
然后是我在 Postfix 配置中引用的文件:
/etc/postfix/virtual_alias_maps.cf
user = postfix_user
password = hunter2
hosts = localhost
dbname = postfix_db
table = domains
select_field = domain
where_field = domain
/etc/postfix/virtual_mailbox_domains.cf
user = postfix_user
password = hunter2
hosts = localhost
dbname = postfix_db
table = forwardings
select_field = destination
where_field = source
/etc/postfix/virtual_mailbox_maps.cf
user = postfix_user
password = hunter2
hosts = localhost
dbname = postfix_db
table = users
select_field = concat(domain,'/',email,'/')
where_field = email
进而
touch /etc/postfix/transport
postmap /etc/postfix/transport
现在我删除了默认的 Dovecot 配置文件,并将其替换为:
protocols = imap
auth_mechanisms = plain
passdb {
driver = sql
args = /etc/dovecot/dovecot-sql.conf
}
userdb {
driver = sql
args = /etc/dovecot/dovecot-sql.conf
}
service auth {
unix_listener auth-client {
group = postfix
mode = 0660
user = postfix
}
user = root
}
mail_home = /home/vmail/%d/%u
mail_location = maildir:~
ssl_cert = </etc/ssl/private/server.crt
ssl_key = </etc/ssl/private/server.key
我创建了该/etc/dovecot/dovecot-sql.conf
文件:
driver = mysql
connect = host=localhost dbname=postfix_db user=postfix_user password=hunter2
# The new name for MD5 is MD5-CRYPT so you might need to change this depending on version
default_pass_scheme = MD5-CRYPT
# Get the mailbox
user_query = SELECT '/home/vmail/%d/%u' as home, 'maildir:/home/vmail/%d/%u' as mail, 5000 AS uid, 5000 AS gid, concat('dirsize:storage=', quota) AS quota FROM users WHERE email = '%u'
# Get the password
password_query = SELECT email as user, password, '/home/vmail/%d/%u' as userdb_home, 'maildir:/home/vmail/%d/%u' as userdb_mail, 5000 as userdb_uid, 5000 as userdb_gid FROM users WHERE email = '%u'
# If using client certificates for authentication, comment the above and uncomment the following
#password_query = SELECT null AS password, ‘%u’ AS user
...最后重新启动 dovecot 和 postfix:
service postfix dovecot restart
问题是,当我尝试发送电子邮件至时[email protected]
,我在日志中看到以下内容:
NOQUEUE: reject: RCPT from blablabla.com[xxx.xxx.xxx.xxx]: 451 4.3.0 <[email protected]>: Temporary lookup failure; from=<[email protected]> to=<[email protected]> proto=ESMTP helo=<blablabla.com>
邮件被退回并显示错误
550 5.1.1 "Recipient address rejected: User unknown in virtual alias table"
答案1
看起来,你的virtual_alias_maps
和virtual_mailbox_domains
被交换了。尝试重命名它们
mv /etc/postfix/virtual_alias_maps.cf /tmp/virtual_mailbox_domains.tmp
mv /etc/postfix/virtual_mailbox_domains.cf /etc/postfix/virtual_alias_maps.cf
mv /tmp/virtual_mailbox_domains.tmp /etc/postfix/virtual_mailbox_domains.cf
别忘了跑步postfix reload
。
答案2
我确信 Dovecot 是创建 auth 文件的人,因为 postfix 与 dovecot 对话,并且 dovecot 进行身份验证,因此在您的“dovecot.conf”中添加:
path = /var/run/dovecot/auth-client
进入客户端块如下:
service auth {
unix_listener auth-client {
path = /var/run/dovecot/auth-client
group = postfix
mode = 0660
user = postfix
}
或者
service auth {
unix_listener /var/run/dovecot/auth-client {
group = postfix
mode = 0660
user = postfix
}
重启 dovecot
检查 /var/run/dovecot/auth-client 是否已创建
输入ls -l /var/run/dovecot/auth-client
以确认。
然后重试。