dovecot - Jun 2010 - Postfix, MySQL, Dovecot LDA and alias domains

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

On 2010-06-22 7:06 AM, Darek M wrote:
> 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).
The MTA is what does recipient validation...

postconf -n output would be helpful...