Hi ,

I use virtual_alias_maps with a mysql server to manage aliases and catch-all accounts. For the past few years this approach worked like a charm, but after upgrading to 2.10 I get two different behaviours.

When mailing from a domain to a domain both hosted on this server, the virtual_alias_maps behave correctly. When mailing from a domain on a different server to one hosted on my server the alias lookup fails (the message gets through when the actual user exists).

MySQL log when the email is received from any external mailserver:

130305 21:48:54 283 Query SELECT `destination` FROM `virtual_aliases` WHERE source='hazelhof.nl' LIMIT 1 284 Query SELECT 1 FROM `virtual_domains` WHERE name='hazelhof.nl' LIMIT 1 297 Query SELECT `destination` FROM `virtual_aliases` WHERE source='[email protected]' LIMIT 1 297 Query SELECT `destination` FROM `virtual_aliases` WHERE source='@domain.nl' LIMIT 1 282 Query SELECT '/var/mail/hazelhof.nl/alias' AS `home`, 5000 AS `uid`, 5000 AS `gid`, CONCAT('*:bytes=', quota_kb) AS `quota_rule` FROM `virtual_users` WHERE `email` = '[email protected]' LIMIT 1

which results in a reject, Mail.log: Mar 5 21:55:30 black-mail postfix/smtpd[19444]: NOQUEUE: reject: RCPT from domain.nl[2a00:d10:101::26:0]: 554 5.7.1 <[email protected]>: Recipient address rejected: Unknown user; from=<[email protected]> to=<[email protected]> proto=ESMTP helo=<domain.nl>

MySQL log when mailing from an internal domain
130305 21:48:23 283 Query SELECT `destination` FROM `virtual_aliases` WHERE source='hazelhof.nl' LIMIT 1 284 Query SELECT 1 FROM `virtual_domains` WHERE name='hazelhof.nl' LIMIT 1
                  307 Connect   provider@localhost on provider
307 Query SELECT `destination` FROM `virtual_aliases` WHERE source='[email protected]' LIMIT 1 307 Query SELECT `destination` FROM `virtual_aliases` WHERE source='@hazelhof.nl' LIMIT 1
                  308 Connect   provider@localhost on provider
308 Query SELECT `email` FROM `virtual_users` WHERE email='[email protected]' LIMIT 1 307 Query SELECT `destination` FROM `virtual_aliases` WHERE source='[email protected]' LIMIT 1 307 Query SELECT `destination` FROM `virtual_aliases` WHERE source='@hazelhof.nl' LIMIT 1 283 Query SELECT `destination` FROM `virtual_aliases` WHERE source='hazelhof.nl' LIMIT 1 284 Query SELECT 1 FROM `virtual_domains` WHERE name='hazelhof.nl' LIMIT 1 290 Query SELECT `destination` FROM `virtual_aliases` WHERE source='[email protected]' LIMIT 1 290 Query SELECT `destination` FROM `virtual_aliases` WHERE source='@hazelhof.nl' LIMIT 1 290 Query SELECT `destination` FROM `virtual_aliases` WHERE source='[email protected]' LIMIT 1 290 Query SELECT `destination` FROM `virtual_aliases` WHERE source='postmaster' LIMIT 1 290 Query SELECT `destination` FROM `virtual_aliases` WHERE source='@black-mail.nl' LIMIT 1 283 Query SELECT `destination` FROM `virtual_aliases` WHERE source='black-mail.nl' LIMIT 1 284 Query SELECT 1 FROM `virtual_domains` WHERE name='black-mail.nl' LIMIT 1 309 Connect provider_spamass@localhost on provider_spamassassin
                  309 Query     set autocommit=1
309 Query SELECT preference, value FROM userpref WHERE username = '[email protected]' OR username = '$GLOBAL' OR username = CONCAT('%','black-mail.nl') ORDER BY username ASC

Which results in a correct relay to the postmaster account.

It appears to me that there are two different lookups being done, have I missed something in the 2.10 changelog?
user = provider
password = xxxxx
hosts = 127.0.0.1
dbname = xxxxx
query = SELECT `destination` FROM `virtual_aliases` WHERE source='%s' LIMIT 1;

# | ID      |   domain_id    | source        | destination
# | int(11) | int(11)        | varchar(100)  | varchar(1000)
# | 1       | 1              | @hazelhof.nl  | [email protected]

Reply via email to