Manage domain and delivery through MySql?

[telvenes]

Hi,

I have multiple mailservers and webservers.

Is it possible to manage domain and delivery through MySql?

[telvenes]

domain transport

[telvenes]

no one knows?

[telvenes]

should be a database that is shared for all mailscanners

[pdwalker]

I believe that it is a feature of postfix, but I've never used it before and I don't know how it works. I think someone in the forums has done this before, so using google search should turn up a result.

EFA doesn't support it directly, so you wouldn't be able to use EFA to directly manage your domains in the mysql database.

How technical are your skills?

[telvenes]

I have come up with 2 ways to do this

1:
https://workaround.org/ispmail/wheezy/c ... e-database

2:
Make a script that converts the transport table into /etc/postfix/transport

I am thinking 1 will work best and 2 mabey be the smartes if efa update comes and change the config? what you think?

[webguyz]

Would stay with option 2 to ensure future compatibility.

Create cron script to check your Mysql for new domains once an hour or whatever and then if new ones exist create a script to read the domain entries in from mysl and create textfile /etc/postfix/transport and then execute "postmap /etc/postfix/transport"