postfix+mysql

1.配置mysql

實驗之前，制作要使用數據庫和表

  添加數據庫用戶，并給其授權

 * vim /etc/postfix/mailuser.cf     ##查詢用戶名

   1 host = localhost   ##數據庫主機

  2 user = postuser    ##登錄數據庫用戶

  3 password = 123     ##登錄密碼

  4 dbname = email    ##postfix查詢庫的名稱

  5 table = emailuser  ##postfix查詢表的名稱

  6 select_field = username   ##postfix查詢的字段

  7 where_field = username    ##給postfix查詢的條件

  * vim /etc/postfix/maildomain.cf    ##域名查詢

  1 host = localhost

  2 user = postuser

  3 password = 123

  4 dbname = email

  5 table = emailuser

  6 select_field = domain

  7 where_field = domain

   vim /etc/postfix/mailbox.cf   

   1 host = localhost

  2 user = postuser

  3 password = 123

  4 dbname = email

  5 table = emailuser

  6 select_field = maildir

  7 where_field = username

 測試

  2.配置postfix

  groupadd -g 666 vmail   ##添加用戶組并指定gid為666

   useradd -s /sbin/nologin -u 666 vmail -g 666  ##添加用戶，并指定uid和gid為666

 * postconf -e "virtual_mailbox_base = /home/vmail"   ##設定虛擬用戶郵件目錄

   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"  ##指定MySQL查找主機

   postconf -e "virtual_mailbox_domains = mysql:/etc/postfix/maildomain.cf"  ##指定MySQL查找域名

   postconf -e "virtual_mailbox_maps = mysql:/etc/postfix/mailbox.cf"  ##指定MySQL查找郵箱

  *systemctl restart postfix   ##重啟postfix服務

  測試

  發送給linux@linux.com的郵件在/home/vmail/linux/new/里找到