[Vmail-discuss] domain aliasing with local delivery

Paul Warren pdw@xxxxxxxxxxxxx
Fri, 26 Oct 2001 21:32:46 +0100

On Fri, Oct 26, 2001 at 10:05:54PM +0200, Jakob Hirsch wrote:
> ----- Original Message ----- From: "Paul Warren" <pdw@ex-parrot.com>
> > 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.
> Ok, thanks, that does it for me.
> But it's only a workaround, that only works if the real domain is
> listed in the domain-table before the alias domain.

The alias domain should not be listed in the domain-table at all - only
in the alias table.

The problem (AIUI) was that a query for e.g. mydomain.com was producing:

path    mbox_name   domain.domain_name  alias.alias
foo     bar         mydomain.com        myalias.com
foo     bar         mydomain.com
foo     bar         mydomain.com        myotheralias.com

The contents of path and mbox_name are always there, and always correct,
they just sometimes appear more than once.  The limit 1 means that only
one will be returned.  Have I missed something?

> Maybe this can't be handled in a single sql-statement...

I think the above is OK, but it's not exactly pretty.  I should have
also mentioned that the user query needs a limit 1:

user = ${lookup mysql{select unix_user 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

but I suspect you've already got that...