virtual_alias_domains with mysql: 'User unknown in virtual alias table'

7 msg	Postfix 2.2.5 on latest Solaris 9 x86
5 msg	Postfix Relay, and Pop-before-smtp
12 msg	Newb Question
13 msg	Best defense against this?
1 msg	undelivered mail problem - SOLVED
4 msg	Legal local-part

virtual_alias_domains with mysql: 'User unknown...
\ Benjamin Jackson (22 Sep 2007)
. \ (Wietse Venema) (23 Sep 2007)
. \ Justin McAleer (24 Sep 2007)

6 msg	Submission port (587): howto to use differente ...
5 msg	When does smtpd_reject_unlisted_recipient kick in?
4 msg	Postfix 'falling back' on sasldb? I don't want ...
3 msg	Nested access maps (I think ;))
3 msg	Suppression of encoding bad header function in ...
4 msg	RE: Catchall ??
3 msg	problem with .forward files + forwarding loops
5 msg	Postfix Strange Behaviours
7 msg	Content filter question, based upon auth'ed or not
28 msg	Mail stuck in active queue for loooong time
11 msg	How to stop a user from changing the 'From:' he...
10 msg	[Semi-OT] blocked port 465, anywhere?
7 msg	chroot problems on Nexenta (OpenSolaris)

Subject:	virtual_alias_domains with mysql: 'User unknown in virtual alias table'
Group:	Postfix-users
From:	Benjamin Jackson
Date:	22 Sep 2007

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=<
cb03bffe0709221253w70c2e55bgfc96c113f5a70c64>
Sep 22 19:53:33 dumbo postfix/qmgr[15686]: E3EBCFC0E4: from=<
bhjackson>, 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=<
ben>, orig_to=<ben>, 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_admin@localhost on mail
29 Query SELECT transport FROM transport WHERE
domain='*'
29 Query SELECT transport FROM transport WHERE
domain='*'
30 Connect mail_admin@localhost on mail
30 Query SELECT domain FROM aliases WHERE
original_id > 0
31 Connect mail_admin@localhost 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_admin@localhost on mail
32 Query SELECT destination FROM forwardings
WHERE source='ben'
32 Query SELECT destination FROM forwardings
WHERE source='ben'
32 Query SELECT destination FROM forwardings
WHERE source='ben'
33 Connect mail_admin@localhost on mail
33 Query SELECT email FROM users WHERE email='
ben'

Anyone have any idea what's going on?

Thanks in advance,

Ben