postfix 整合mysql

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

CREATE DATABASE postfix;
USE postfix;

CREATE TABLE users (
    id INT AUTO_INCREMENT PRIMARY KEY,
    username VARCHAR(255) NOT NULL,
    password VARCHAR(255) NOT NULL,
    domain VARCHAR(255) NOT NULL
);

# MySQL 配置
relayhost = 
smtpd_sasl_type = dovecot
smtpd_sasl_path = private/auth
smtpd_sasl_auth_enable = yes
smtpd_recipient_restrictions =
    permit_mynetworks,
    permit_sasl_authenticated,
    reject_unauth_destination

# MySQL 连接配置
mysql_host = localhost
mysql_user = postfix
mysql_password = postfix_password
mysql_database = postfix

user = postfix
password = postfix_password
hosts = localhost
dbname = postfix
query = SELECT username FROM users WHERE username='%u' AND domain='%d'

user = postfix
password = postfix_password
hosts = localhost
dbname = postfix
query = SELECT 1 FROM users WHERE username='%u' AND domain='%d'

virtual_gid_maps = static:5000
virtual_uid_maps = static:5000
virtual_mailbox_domains = mysql:/etc/postfix/mysql_virtual_domains.cf
virtual_mailbox_maps = mysql:/etc/postfix/mysql_virtual_mailboxes.cf
virtual_alias_maps = mysql:/etc/postfix/mysql_virtual_aliases.cf
recipient_delimiter = +

user = postfix
password = postfix_password
hosts = localhost
dbname = postfix
query = SELECT domain FROM users GROUP BY domain

user = postfix
password = postfix_password
hosts = localhost
dbname = postfix
query = SELECT 1 FROM users WHERE username='%u' AND domain='%d'

user = postfix
password = postfix_password
hosts = localhost
dbname = postfix
query = SELECT destination FROM aliases WHERE source='%s' AND active = 1

sudo systemctl restart postfix
sudo systemctl restart mysql