postfix配置mysql

sudo apt-get update
sudo apt-get install postfix mysql-server

CREATE DATABASE postfix;
CREATE USER 'postfixuser'@'localhost' IDENTIFIED BY 'your_password';
GRANT ALL PRIVILEGES ON postfix.* TO 'postfixuser'@'localhost';
FLUSH PRIVILEGES;

USE postfix;
CREATE TABLE `virtual` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `domain` varchar(255) NOT NULL,
  `username` varchar(255) NOT NULL,
  `password` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
);

# MySQL 配置
relay_domains = mysql:/etc/postfix/mysql-relay_domains.cf
virtual_alias_domains = mysql:/etc/postfix/mysql-virtual_alias_domains.cf
virtual_mailbox_domains = mysql:/etc/postfix/mysql-virtual_mailbox_domains.cf
virtual_mailbox_maps = mysql:/etc/postfix/mysql-virtual_mailmailboxes.cf

# 其他配置项...

user = postfixuser
password = your_password
hosts = localhost
dbname = postfix
query = SELECT domain FROM relay_domains WHERE domain='%s'

sudo systemctl restart postfix