dovecot+mysql

1.yum install php httpd php-mysql.x86_64 mariadb-server.x86_64 -y

2.systemctl start mariadb

3.mysql_secure_installation ##安全初始化数据库

4.tar jxf /mnt/phpMyAdmin-3.4.0-all-languages.tar.bz2 -C /var/www/html/

5.cd /var/www/html/

6.ls

phpMyAdmin-3.4.0-all-language

7.mv phpMyAdmin-3.4.0-all-languages/ mysqladmin

8.cd mysqladmin/

9.cp -p config.sample.inc.php config.inc.php 

10.vim config.inc.php 

$cfg['blowfish_secret'] = 'mysql'; /* YOU MUST FILL IN THIS FOR COOKIE AUTH! */

11.systemctl start httpd

打开浏览器 172.25.254.157/mysqladmin ,用root用户登陆，创建email库 

[root@westos-mail mysqladmin]# mysql -uroot -predhat

MariaDB [mysql]> create user postuser@localhost identified by 'postuser';

Query OK, 0 rows affected (0.00 sec)

MariaDB [mysql]> grant select,update,insert on email.* to postuser@localhost;

Query OK, 0 rows affected (0.00 sec)

MariaDB [mysql]> show grants for postuser@localhost;

1.下载安装

yum install dovecot dovecot-mysql -y   ##dovecot-mysql  dovecot软件的插件，让此软件可以识别mysql

2.配置文件

vim /etc/dovecot/dovecot.conf
 24 protocols = imap pop3 lmtp    ##支持收件协议
 48 login_trusted_networks =0.0.0.0/0  ##信任网络
 49 disable_plaintext_auth = no   ##开启明文认证

vim /etc/dovecot/conf.d/10-auth.conf
123 !include auth-sql.conf.ext  ##开启mysql的认证方式

##生成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=localhost dbname=emailuser=postuser password=postuaer   ##查询时用到的库，用户
 78 default_pass_scheme = PLAIN  ##默认认证方式为明文
107 password_query = \          ##查询密码匹配
108   SELECT username, domain, password \
109   FROM emailuser WHERE username ='%n' AND domain = '%d'  ##查询邮件内容
125 user_query = SELECT maildir, 666 AS uid, 666 AS gid FROM emailuser WHEREus    erid = '%u'


 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


systemctl restart dovecot

 

 

测试

[root@qq-mail ~]telnet 172.25.254.157 110 
Trying172.25.254.157… 
Connectedto 172.25.254.157. 
Escapecharacter is ‘^]’. 
+OK[XCLIENT] Dovecot ready. 
user haha.haha.com 
+OK 
pass haha
+OKLogged in. 
quit 

过程截图如下：