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

2015-10-06 Thread Voytek
On Tue, September 29, 2015 10:46 am, Viktor Dukhovni wrote: > I don't think this meets the OP's needs. He seems to want only some > of the addresses in the target domain aliased. For that, those and only > those addresses should be listed in the virtual alias table (whether file > based or SQL):

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 (SELECT username FROM mail

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 user

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 rem

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 u...@aname.com