Skip to content

Postfix

Réécrire les adresses de destination depuis MySQL

Une base de données avec ce genre d'infos :

MariaDB [mail]> select * from match_mail;
+----------------------------------+--------------------+
| mail_random                      | mail               |
+----------------------------------+--------------------+
| djDjejddjdjd@random.archinard.fr | johan@archinard.fr |
+----------------------------------+--------------------+

Côté Postfix : 

dnf install postfix-mysql

postconf -e 'recipient_canonical_maps = mysql:/etc/postfix/mysql-recipient.cf'

vim /etc/postfix/mysql-recipient.cf
user = bob
password = toto
dbname = mail
hosts = 127.0.0.1
query = SELECT mail FROM match_mail where mail_random='%s'

Dans les logs :

Apr 06 16:25:57 franky postfix/smtp[140]: 55326C014D8FE: to=<johan@archinard.fr>, orig_to=<djDjejddjdjd@random.archinard.fr>, relay=mail.slashroot.fr[37.187.123.137]:25, delay=0.56, delays=0.17/0.14/0.15/0.11, dsn=2.0.0, status=sent (250 2.0.0 Ok: queued as 9331353DC4)