Re: 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:	Re: virtual_alias_domains with mysql: 'User unknown in virtual alias table'
Group:	Postfix-users
From:	Justin McAleer
Date:	24 Sep 2007

Benjamin Jackson wrote:
> 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 <http://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 <http://127.0.0.1>
>

Unless your aliases table is empty or has no entries with original_id >
0, that query will always return something, so any and every domain will
be considered a virtual alias domain. You should add the domain value
into the where clause, unless you want that behavior for some reason.

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