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"