[Dovecot] Postfix, MySQL, Dovecot LDA and alias domains

[Darek M]

Hi there,

I have a postfix/postfixadmin/mysql/dovecot install that was using
'virtual' for the LDA.  I tried the 'dovecot' LDA to enable Sieve but
ran into trouble with aliases.  With domain "some-domain.com" being an
alias to "somedomain.com", mail sent to *@somedomain.com would be
delivered to the Maildir fine, but the 'dovecot' LDA tossed "unknown
user" for anything sent to *@some-domain.com (the alias to the other
domain).

My dovecot.sql:

driver = mysql
connect = host=/var/lib/mysql/mysql.sock dbname=postfix user=dovecot
password=dovecot
user_query = SELECT concat('/home/vmail/', maildir) as home,
concat('maildir:/home/vmail/', maildir) as mail, 5000 AS uid, 5000 AS
gid, concat('maildir:storage=', quota) AS quota FROM mailbox WHERE
username = '%u' AND active = '1'
password_query = SELECT username as user, password,
concat('/home/vmail/', maildir) as userdb_home,
concat('maildir:/home/vmail/', maildir) as userdb_mail, 5000 as
userdb_uid, 5000 as userdb_gid FROM mailbox WHERE username = '%u' AND
active = '1'

The problem is fairly simple: Dovecot isn't being told anything about
the 'alias_domain' table that pairs alias domains with actual ones.

So the question is: do I add a second "user_query" in dovecot.sql, or
is there an "alias_query" directive, or similar?  And does anyone have
a query that would point an alias domain to the real maildir?

- Darek