postfix邮件服务+mariadb数据库

postfix+mariadb

前期准备

1.
yum install postfix.x86_64 httpd.x86_64 php.x86_64 php-mysql.x86_64 mariadb-server.x86_64 -y
配置mariadb phpmyadmin
初始化mysql_secure_installation
创建所需的库 表 字段
插入数据
创建邮件管理用户

2.postfix用文件查找数据库数据
1.vim /etc/postfix/mailuser.cf ##用户名称查询
hosts = localhost ##数据库所在主机
user = postuser ##登陆数据库的用户
password = postuser ##登陆数据库的密码
dbname = email ##postfix要查询的库名
table = EmailUser ##postfix要查询的表名
select_field = Username ##postfix要查询的字段
where_field = Username ##postfix查询条件

vim /etc/postfix/maildomain.cf ##用户域名查询
hosts = localhost
user = postuser
password = postuser
dbname = email
table = EmailUser
select_field = Domain
where_field = Domain

vim /etc/postfix/mailbox.cf ##用户邮箱位置查询
hosts = localhost
user = postuser
password = postuser
dbname = email
table = EmailUser
select_field = Maildir
where_field = Username

postmap -q “[e-mail]” mysql:/etc/postfix/mailbox.cf ##执行查询命令测试是否实现查询功能

配置

groupadd -g 666 mailbox
useradd -s /sbin/nologin -u 666 mailbox -g 666

postconf -e “virtual_mailbox_base = /home/mailbox” ##设定虚拟用户的邮件目录
postconf -e “virtual_uid_maps = static:666” ##虚拟用户建立文件的uid
postconf -e “virtual_gid_maps = static:666” ##虚拟用户监理文件的gid
postconf -e “virtual_alias_maps = mysql:/etc/postfix/mailuser.cf”
postconf -e “virtual_mailbox_domains = mysql:/etc/postfix/maildomain.cf”
postconf -e “virtual_mailbox_maps = mysql:/etc/postfix/mailbox.cf”

systemctl restart postfix