mirroring one domain.tld to domain.tld.au

2015-09-28 Thread Voytek
I have Postfix/Dovecot/postfixadmin/MySQL with several virtual mailbox domains one of the domains is like aname.com.au, the user also now has aname.com, and, would like to 'mirror' most of the addresses to be u...@aname.com, THOUGH, some are to remain as us...@aname.com.au so, both

Re: mirroring one domain.tld to domain.tld.au

2015-09-28 Thread Peter
On 09/29/2015 03:41 AM, Voytek wrote: > I have Postfix/Dovecot/postfixadmin/MySQL with several virtual mailbox > domains > > one of the domains is like aname.com.au, the user also now has aname.com, > and, would like to 'mirror' most of the addresses to be u...@aname.com, > THOUGH, some are to

Re: mirroring one domain.tld to domain.tld.au

2015-09-28 Thread Viktor Dukhovni
On Tue, Sep 29, 2015 at 12:29:29PM +1300, Peter wrote: > query = (SELECT goto FROM alias WHERE address='%s' AND active) > UNION (SELECT goto FROM (SELECT '%u@' || target_domain goto > FROM alias_domain WHERE alias_domain = '%d' AND active) AS a > WHERE (goto IN (SELECT

Re: mirroring one domain.tld to domain.tld.au

2015-09-28 Thread Benny Pedersen
On September 29, 2015 1:30:09 AM Peter wrote: query = (SELECT goto FROM alias WHERE address='%s' AND active) UNION (SELECT goto FROM (SELECT '%u@' || target_domain goto FROM alias_domain WHERE alias_domain = '%d' AND active) AS a WHERE (goto IN