OSEC

Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com
virtual_alias_domains with mysql: "User unknown in virtual alias table"

From: Benjamin Jackson (bhjacksongmail.com)
Date: Sat Sep 22 2007 - 15:38:37 CDT

Hey all,
Trying to move from hash-based virtual_alias_domains to mysql tables. Lemme
see if I got this right:

1. Changed main.cf to add:

virtual_alias_domains
= proxy:mysql:/etc/postfix/mysql-virtual_alias_domains.cf

2. Added /etc/postfix/mysql-virtual_alias_domains.cf:

user = myusername
password = mypassword
dbname = mydbname
query = SELECT domain FROM aliases WHERE original_id > 0
hosts = 127.0.0.1

The where clause in the query is a catch-all which I added after trying
without it and getting an error.

3. Restart postfix.

When I send mail from gmail to one of my forwards after doing this, I get
this in my log:

---------------

Sep 22 19:53:32 dumbo postfix/smtpd[15702]: connect from
wa-out-1112.google.com[209.85.146.181]
Sep 22 19:53:32 dumbo postfix/smtpd[15702]: E3EBCFC0E4: client=
wa-out-1112.google.com[209.85.146.181]
Sep 22 19:53:33 dumbo postfix/cleanup[15817]: E3EBCFC0E4: message-id=<
cb03bffe0709221253w70c2e55bgfc96c113f5a70c64mail.gmail.com>
Sep 22 19:53:33 dumbo postfix/qmgr[15686]: E3EBCFC0E4: from=<
bhjacksongmail.com>, size=1996, nrcpt=1 (queue active)
Sep 22 19:53:33 dumbo postfix/trivial-rewrite[15812]: warning: do not list
domain incomumdesign.com in BOTH virtual_alias_domains and
virtual_mailbox_domains
Sep 22 19:53:33 dumbo postfix/error[15819]: E3EBCFC0E4: to=<
benincomumdesign.com>, orig_to=<benin-comum.com>, relay=none, delay=1,
status=bounced (User unknown in virtual alias table)

---------------

That warning ("warning: do not list domain incomumdesign.com in BOTH
virtual_alias_domains and virtual_mailbox_domains ") makes no sense to me,
as incomumdesign.com (the original) is not in the table pointed to in
the virtual_alias_domains config.

The mysql log looks like the user is being found:

                     29 Connect mail_adminlocalhost on mail
                     29 Query SELECT transport FROM transport WHERE
domain='*'
                     29 Query SELECT transport FROM transport WHERE
domain='*'
                     30 Connect mail_adminlocalhost on mail
                     30 Query SELECT domain FROM aliases WHERE
original_id > 0
                     31 Connect mail_adminlocalhost on mail
                     31 Query SELECT 'domain' FROM domains WHERE
domain='gmail.com'
                     30 Query SELECT domain FROM aliases WHERE
original_id > 0
                     31 Query SELECT 'domain' FROM domains WHERE
domain='in-comum.com'
                     32 Connect mail_adminlocalhost on mail
                     32 Query SELECT destination FROM forwardings
WHERE source='benin-comum.com'
                     32 Query SELECT destination FROM forwardings
WHERE source='benin-comum.com'
                     32 Query SELECT destination FROM forwardings
WHERE source='benincomumdesign.com'
                     33 Connect mail_adminlocalhost on mail
                     33 Query SELECT email FROM users WHERE email='
benincomumdesign.com'

Anyone have any idea what's going on?

Thanks in advance,

Ben