dovecot+mysql-优快云博客

本文详细介绍了如何使用Dovecot与MySQL结合配置邮件服务器的过程。包括安装Dovecot及插件、配置文件编辑、MySQL数据库连接设置、邮件位置指定等步骤。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

##############dovecot+mysql############
1.
yum install dovecotdovecot-mysql.x86_64 -y
####dovecot dovecot-mysql 软件的安装，dovecot-mysql dovecot 软件的插件，让此软件可以识别mysql

2.配置文件
（1）vim /etc/dovecot/dovecot.conf
    24 protocols = imap pop3 lmtp ###支持收件协议
    48 login_trusted_networks =0.0.0.0/0##信任网络
    49 disable_plaintext_auth = no ###开启明文认证
（2）vim /etc/dovecot/conf.d/10-auth.conf
     123 include auth-sql.conf.ext ##开启mysql的认证方式
（3）##生成dovecot读取mysql的配置
   cp/usr/share/doc/dovecot-2.2.10/example-config/dovecot-sql.conf.ext/etc/dovecot/dovecot-sql.conf.ext ###复制配置文件模版

   vim/etc/dovecot/dovecot-sql.conf.ext
     32 driver = mysql ###数据库类型
     71 connect = host=localhostdbname=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'
    125 user_query = SELECT maildir, 666AS uid, 666 AS gid FROM emailuser WHERE username = '%u' ###查询邮件内容
（4） vim /etc/dovecot/conf.d/10-mail.conf
30 mail_location=maildir:/home/vmail/%d/%n ##指定邮件位置
168 first_valid_uid = 666              ###邮件文件查询用户身份
175 first_valid_gid = 666
（5）systemctl restart dovecot
3.测试
（1）telnet 172.25.254.144 110

（2）雷鸟

172 yum install dovecot -y
173 yum install dovecot-mysql -y
174 vim /etc/dovecot/dovecot.conf
     24 protocols = imap pop3 lmtp
     48 login_trusted_networks=0.0.0.0/0
     49 disable_plaintext_auth = no
175 vim /etc/dovecot/conf.d/10-auth.conf
    123 include auth-sql.conf.ext
176  cp /usr/share/doc/dovecot-2.2.10/example-config/dovecot-sql.conf.ext/etc/dovecot/dovecot-sql.conf.ext
177 vim /etc/dovecot/dovecot-sql.conf.ext
     32 driver = mysql ###数据库类型
     71 connect = host=localhostdbname=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'
    125 user_query = SELECT maildir, 666AS uid, 666 AS gid FROM emailuser WHERE username = '%u' ###查询邮件内容
178 vim /etc/dovecot/conf.d/10-mail.conf
      30 mail_location=maildir:/home/vmail/%d/%n ##指定邮件位置
     168 first_valid_uid = 666               ###邮件文件查询用户身份
     175 first_valid_gid = 666
179 systemctl restart dovecot

########空壳邮件########
重置一台主机，配置网络。修改主机名称。

server:
    1 hostnamectl set-hostname nullmail.example.com
    2 hostname
    3 logout
    4 vim /etc/postfix/main.cf
75 myhostname = nullmail.example.com
83 mydomain = example.com
99 myorigin = westos.com
112 inet_interfaces = all
163 mydestination =
316 relayhost = 172.25.254.144

    5 systemctl restart postfix.service
测试：
    6 mail root
    7 mailq
    8 mail

desktop: 176 mail

配置DNS：

[root@westos-mail ~]# vim/etc/named.conf

[root@westos-mail ~]# vim/etc/named.rfc1912.zones

[root@westos-mail ~]# cd /var/named/
[root@westos-mail named]# ls
data named.ca named.loopback slaves
dynamic named.empty qq.com.zone westos.com.zone
example.com.zone named.localhost sb.com.zone
[root@westos-mail named]# vim example.com.zone