postfix +mysql实现邮件监控

代码

  添加数据表mail_watch
CREATE TABLE `mail_watch` (
  `sender` varchar(100)  NOT NULL,
  `bcc` varchar(100)  NOT NULL,
  PRIMARY KEY  (`sender`)
)

main.cf

sender_bcc_maps = mysql:/etc/postfix/mail_watch.cf
recipient_bcc_maps = mysql:/etc/postfix/mail_watch.cf

mysql_watch.cf

user = postfix
password = xxxxx
dbname = postfix
table = mail_watch
select_field = bcc
where_field = sender
hosts = localhost