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