dovecot+mysql（数据库对邮件服务器的管理）

1.下载

yum insatll dovecot dovecot-mysql -y

—— dovecot-mysql为 dovecot的插件，让dovecot可以识别mysql

2.配置

[root@westos-mail ~]# vim /etc/dovecot/dovecot.conf ##编辑dovecot主配置文件
24 protocols = imap pop3 lmtp ##支持的收件协议
48 login_trusted_networks = 0.0.0.0/0 ##信任的网络
49 disable_plaintext_auth = no ##开启明文认证

[root@westos-mail ~]# vim /etc/dovecot/conf.d/10-auth.conf ##认证配置文件
123 !include auth-sql.conf.ext ##开启mysql的认证方式

——————生成dovecot读取mysql的配置——————

[root@westos-mail ~]# cp /usr/share/doc/dovecot-2.2.10/example-config/dovecot-sql.conf.ext /etc/dovecot/dovecot-sql.conf.ext
[root@westos-mail ~]# vim /etc/dovecot/dovecot-sql.conf.ext ##dovecot与数据库配置文件
32 driver = mysql ##数据库类型
71 connect = host=localhost dbname=email user=postuser password=postuser ##查询时用到的库、表、用户及密码
78 default_pass_scheme = PLAIN ##默认认证时明文认证
107 password_query = \ ##查询密码匹配
108 SELECT username, domain, password \ ##查询名称,域名,密码
109 FROM emailuser WHERE username = ‘%u’ AND domain = ‘%d’ ##从emailuser表的字段查询
125 user_query = SELECT maildir, 666 AS uid, 666 AS gid FROM emailuser WHERE username = ‘%u’ ##从emailuser表maildir字段查询邮件地址，username字段查询用户来认证

# %u = entire user@domain ##完整名称即lee@lee.com
# %n = user part of user@domain ##名称部分即lee
# %d = domain part of user@domain ##域名部分即lee.com

[root@westos-mail ~]# vim /etc/dovecot/conf.d/10-mail.conf ##邮件配置
30 mail_location = maildir:/home/vmail/%d/%n ##指定邮件位置
168 first_valid_uid = 666 ##邮件文件查询用户身份uid
175 first_valid_gid = 666 ##gid

[root@westos-mail ~]# systemctl restart dovecot.service ##重启dovecot

3.测试

[root@qq-mail ~]# telnet 172.25.254.133 110
Trying 172.25.254.133…
Connected to 172.25.254.133.
Escape character is ‘^]’.
+OK [XCLIENT] Dovecot ready.
user lee@lee.com ##用户名
+OK
pass lee ##密码
+OK Logged in.
quit
+OK Logging out.
Connection closed by foreign host.

可以在雷鸟上登陆测试