mysql_table format change

6 msg	unknown mail tansport error
1 msg	[Fwd: Re: user unknown]
2 msg	OT? Offloading components to another server
2 msg	ldap lookups, mail loops back to myself vs. unk...

mysql_table format change
\ Todd Merritt (28 Aug 2007)
. \ (Wietse Venema) (29 Aug 2007)

26 msg	Reject mail to unknown recipients using LDAP lo...
1 msg	Courier + PgSQL problem
7 msg	virtual users canonicalization and check_policy...
6 msg	smtpd_hard_error_limit
4 msg	Virtual domain aliases
4 msg	multiple deliveries and truncated email.
1 msg	another x-original-to question...
3 msg	Problems with QUEUE
7 msg	user unknown
3 msg	send the queue
1 msg	setting up post fix as a mailer for my web site...
6 msg	Some customers receiving duplicate e-mails afte...
2 msg	cannot find your hostname
2 msg	Postfix 2.3 DSN support problem
4 msg	envelope sender rewriting from body header

Subject:	mysql_table format change
Group:	Postfix-users
From:	Todd Merritt
Date:	28 Aug 2007

I have several alias domains configured in a mysql table using
proxymap. I'm trying to convert them to use the newer query parameter
format. The lookups work after switching, but I get relay access denied
messages for mail sent to valid addresses in those domains from external
mail servers. Any ideas what I could be overlooking ?

user = postfix
password = password
dbname = email
table = virtdoms
select_field = destemail
where_field = srcemail
additional_conditions = AND domain = 'XYZ.arizona.edu'
hosts = db

The above works, switching it to:

user = postfix
password = password
dbname = email
hosts = db
query = SELECT destemail FROM virtdoms WHERE domain = '%d' AND srcemail
= '%s'

works for domains that are allowed to relay, but returns a 550 relay
denied for non-relay domains. I'm able to run postmap -q for the
address that fails and it returns the expected value.

Thanks,
Todd