I tried your SQL, but it still doesn't work...
The SQL part works fine now, it finds the right row, but I'm unsure what I
need to select to have exim understand it.
I ran exim -bt foobar@???, one of the secundairy domains, and this is
what happened:
mysql_aliases director: mysql query=SELECT user FROM tblAliases WHERE (alias
= 'foobar' OR 'foobar' like alias) AND domain='cerala.com' LIMIT 1
mysql_aliases director generated cerala@???
errors_to=NULL transport=NULL
uid=unset gid=unset home=NULL
mysql_aliases director succeeded for foobar
However, after this it starts over on top of the Directors again, it queries
MySQL for cerala@???, and finds mysql_aliases generates
cipri@??? after which it again restarts with the Directors. And then
this happens:
mysql_aliases director: mysql query=SELECT user FROM tblAliases WHERE (alias
= 'cipri' OR 'cipri' like alias) AND domain='cipri.com' LIMIT 1
mysql_aliases director generated cipri@???
errors_to=NULL transport=NULL
uid=unset gid=unset home=NULL
mysql_aliases director succeeded for cipri
system_aliases director: lsearch key=cipri
file="/etc/aliases"
system_aliases director declined for cipri:
userforward director: file = .forward
set uid=0 gid=0 euid=2000 egid=4000
successful stat of /home/cipri/.
/home/cipri/.forward not found
restored uid=0 gid=0 euid=8 egid=8
queued for local_delivery transport: local_part=cipri domain=cipri.com
errors_to=NULL
domain_data=NULL local_part_data=NULL
localuser director succeeded for cipri
cipri@???
<-- cipri@???
<-- cerala@???
<-- foobar@???
deliver to cipri in domain cipri.com
director = localuser, transport = local_delivery
So in the end, it made three queries, while the first (foobar@???)
should have already told Exim to deliver the mail to user cerala, but no
luck here yet :(
Cipri
