On Sat, Aug 08, 2015 at 11:13:46PM +0200, Palica wrote:
> I have figured it out!
>
> This is the changed query:
>
> query = SELECT alias FROM (SELECT alias, 0 as priority FROM alias WHERE
> address='%s' AND active='1' UNION SELECT username as destination, 1 as
> priority FROM mailbox WHERE usern
I have figured it out!
This is the changed query:
query = SELECT alias FROM (SELECT alias, 0 as priority FROM alias WHERE
address='%s' AND active='1' UNION SELECT username as destination, 1 as
priority FROM mailbox WHERE username='%s' AND active='1') ORDER BY
priority LIMIT 1;
Thanks Palic
Hi list,
I have a postfix server with virtualdomains delivery only. I use sqlite
as db backend to lookup virtual aliases, domains and mailboxes.
relay_domains = sqlite:/etc/postfix/sqlite_relay_domain_maps.cf
relay_recipient_maps =
sqlite:/etc/postfix/sqlite_relay_recipient_maps.cf
virtual_a