Re: relay_recipient_maps doens't work

H

Quoting mouss <mouss <at> netoyen.net>:

> chantal <at> antenna.nl wrote:
>> Hi list,
>>
>> I want to use relay_recipient_maps on a postfix 2.5.1 relay server   
>> but it doens't appear to be doing anything. I want to accept mail   
>> for existing users only but it accepts mail for all users.
>>
>> this is postconf -n
>>
>> append_at_myorigin = no
>> append_dot_mydomain = no
>> biff = no
>> config_directory = /etc/postfix
>> content_filter = smtp-amavis:[127.0.0.1]:10024
>> inet_interfaces = all
>> local_recipient_maps =
>> mailbox_size_limit = 0
>> message_size_limit = 25000000
>> mydestination =
>> myhostname = server.domain.com
>> mynetworks = 127.0.0.0/8 [::ffff:127.0.0.0]/104 [::1]/128
>> myorigin = domain.com
>> readme_directory = no
>> recipient_delimiter = +
>> relay_domains = mysql:$config_directory/mysql_relay_domains_maps.cf
>> relay_recipient_maps = mysql:$config_directory/mysql_relay_maps.cf
>> smtp_host_lookup = native,dns
>> smtpd_banner = $myhostname ESMTP $mail_name (Ubuntu)
>> transport_maps = mysql:$config_directory/mysql_transport_maps.cf
>> unknown_address_reject_code = 450
>> unknown_local_recipient_reject_code = 450
>> virtual_alias_maps = mysql:$config_directory/mysql_virtual_alias_maps.cf
>>
>> this is mysql_relay_maps.cf
>>
>> user = username
>> password = secret
>> dbname = database
>> hosts = maildb
>> query = SELECT user_name FROM database WHERE user_name='%s'
>>
>>
>> the mysql connection works (or else mail would not be delivered at all)
>>
>>
>>
>>
>
> chose an address that does not exist in your relay recipient maps,
> let's say foo <at> example.com (of course, example.com must be a relay
> domain) and post the results of the following three commands.
>
> # postmap -q example.com mysql:mysql_relay_domains_maps.cf
> # postmap -q foo <at> example.com mysql:mysql_relay_maps.cf
> # postmap -q foo <at> example.com mysql_virtual_alias_maps.cf
>
> Also show transaction logs.

Sorry I made a mistake in the postmap command, this is the output:

root <at> servername:/etc/postfix# postmap -q example.com  
mysql:/etc/postfix/mysql_relay_domains_maps.cf
@example.com

root <at> servername:/etc/postfix# postmap -q foo <at> example.com  
mysql:/etc/postfix/mysql_relay_maps.cf

root <at> servername:/etc/postfix# postmap -q foo <at> example.com  
mysql:/etc/postfix/mysql_virtual_alias_maps.cf

this looks normal to me, so why doesn't it work? Do I need to adjust  
some setting that reject is the default maybe?