Page 1 of 1
Manage domain and delivery through MySql?
Posted: 23 Oct 2016 13:19
by telvenes
Hi,
I have multiple mailservers and webservers.
Is it possible to manage domain and delivery through MySql?
Re: Manage domain and delivery through MySql?
Posted: 23 Oct 2016 20:05
by telvenes
domain transport
Re: Manage domain and delivery through MySql?
Posted: 26 Oct 2016 11:40
by telvenes
no one knows?
Re: Manage domain and delivery through MySql?
Posted: 26 Oct 2016 11:41
by telvenes
should be a database that is shared for all mailscanners
Re: Manage domain and delivery through MySql?
Posted: 27 Oct 2016 06:24
by 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?
Re: Manage domain and delivery through MySql?
Posted: 16 Nov 2016 22:07
by 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?
Re: Manage domain and delivery through MySql?
Posted: 20 Nov 2016 17:57
by 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"