[Vmail-discuss] domain aliasing with local delivery

[Paul Warren]

> 
> I just updated to vmail 0.5 (basically, updating sql-tables and
> exim.conf) and tried domain aliasing. If the recipient in the new
> domain is just forwarded, it works fine, but if mails should be local
> delivered, they are lost. I tracked it down to this query: select path
> from domain left join domain_alias on domain_alias.domain_name =
> domain.domain_name where domain.domain_name = '$domain' or
> domain_alias.alias = '$domain'

My apologies.  This is a known issue which I have fixed locally, but
have not released.  If you put "limit 1" on the end of the queries then
this problem is alleviated.

So the file query ends up as:

file = ${lookup mysql{select path from domain left join domain_alias on
domain_alias.domain_name = domain.domain_name where domain.domain_name =
'$domain' or domain_alias.alias = '$domain' limit
1}{$value}fail}/${lookup mysql{select mbox_name from popbox left join
domain_alias on popbox.domain_name = domain_alias.domain_name where
(popbox.domain_name = '$domain' or domain_alias.alias = '$domain') and
local_part = '$local_part' limit 1}{$value}fail}

I'll do a release shortly.

Paul