---------- Original Message ----------------------------------
From: Brian Evans - Postfix List <grkni...@scent-team.com>
Reply-To: Postfix users <postfix-users@postfix.org>
Date:  Tue, 18 Aug 2009 12:58:43 -0400

>Len Conrad wrote:
>> ---------- Original Message ----------------------------------
>> From: "Len Conrad" <lcon...@go2france.com>
>> Reply-To: <lcon...@go2france.com>
>> Date:  Tue, 18 Aug 2009 18:08:59 +0200
>>
>>   
>>> mail_version = 2.3.3
>>>
>>> postconf | egrep virtual_alias_maps
>>>
>>> proxy_read_maps = $local_recipient_maps, $mydestination, 
>>> $virtual_alias_maps, $virtual_alias_domains, $virtual_mailbox_maps, 
>>> $virtual_mailbox_domains, $relay_recipient_maps, $relay_domains, 
>>> $canonical_maps, $sender_canonical_maps, $recipient_canonical_maps, 
>>> $relocated_maps, $transport_maps, $mynetworks
>>>
>>> virtual_alias_maps = proxy:mysql:/etc/postfix/mysql-
>>>
>>> virtual_forwardings.cf, mysql:/etc/postfix/mysql-virtual_email2email.cf
>>>
>>> On the mailbox server, the mysql table answers correctly:
>>>
>>> postmap -q "exst...@xxx.com" mysql:/etc/postfix/mysql-virtual_forwardings.cf
>>> exst...@yyy.net
>>>
>>> ... so the virtual_forwardings.cf is correct, the table is correct, 
>>> returing the right answer.
>>>
>>> but:
>>>
>>> Aug 18 10:56:54 ms1.zzz.net/ms1.zzz.net postfix/virtual[5386]: 854544E4066: 
>>> to=<exst...@xxx.com>, relay=virtual, delay=0.05, delays=0.04/0/0/0.01, 
>>> dsn=5.1.1, status=bounced (unknown user: "exst...@xxx.com")
>>>
>>> When we do "virtual -vv", we see virtual resolving recipients only with  
>>> virtual_mailbox_maps, and apparently not looking at virtual_alias_maps
>>>
>>> virtual_alias_maps worked fine for months until yesterday.  We can't find 
>>> what changed.
>>>
>>> Suggestions?
>>>
>>> Len
>>>     
>> ============
>>
>> it's not virtual, but smtpd that's acting strange:
>>
>> Aug 18 11:37:02 ms1.zzz.net/ms1.zzz.net postfix/smtpd[22753]: 
>> dict_proxy_lookup: table=mysql:/etc/postfix/mysql-virtual_forwardings.cf 
>> flags=lock|fold_fix key=exst...@xxx.com -> status=0 result=exst...@yyy.net
>>
>> Aug 18 11:37:02 ms1.zzz.net/ms1.zzz.net postfix/smtpd[22753]: maps_find: 
>> virtual_alias_maps: 
>> proxy:mysql:/etc/postfix/mysql-virtual_forwardings.cf(0,lock|fold_fix): 
>> exst...@xxx.com = exst...@yyy.net
>>
>> Aug 18 11:37:02 ms1.zzz.net/ms1.zzz.net postfix/smtpd[22753]: 
>> mail_addr_find: exst...@xxx.com -> exst...@yyy.net
>>
>> Aug 18 11:37:02 ms1.zzz.net/ms1.zzz.net postfix/virtual[22030]: 3EF9B4E407F: 
>> to=<exst...@xxx.com>, relay=virtual, delay=0.06, delays=0.05/0/0/0.01, 
>> dsn=5.1.1, status=bounced (unknown user: "exst...@xxx.com")
>>
>> The query is answered, so why is the msg bounced?
>>   
>
>First, turn OFF verbose logging and show a complete transaction for a
>message.

Aug 18 13:39:38 xxx postfix/smtpd[2328]: connect from xxx

Aug 18 13:39:38 xxx postfix/smtpd[2328]: NOQUEUE: warn: RCPT from xxx: 4tup
le_webmail_unfiltered; from=<x> to=<exst...@xxx.com> proto=ESMTP helo=<xxx>

Aug 18 13:39:38 xxx postfix/smtpd[2328]: 022FF4E4066: client=xxx

Aug 18 13:39:38 xxx postfix/cleanup[1359]: 022FF4E4066: 
message-id=<b0094bdf850b84002f7641797fc96c66.sq
uir...@xxx>

Aug 18 13:39:38 xxx postfix/qmgr[998]: 022FF4E4066: from=<xxx>, size=744, 
nrcpt=1 (queue a
ctive)

Aug 18 13:39:38 xxx postfix/smtpd[2328]: disconnect from x

Aug 18 13:39:38 xxx postfix/virtual[1400]: 022FF4E4066: to=<exst...@xx.com>, 
relay=virtual, delay=0
.07, delays=0.06/0/0/0.01, dsn=5.1.1, status=bounced (unknown user: 
"exst...@xxx.com")


>Also provide 'postconf -n' hiding domains with example.(com|net|org) if
>required.

postconf -n

address_verify_map = btree:/var/db/postfix/address_verify.map
address_verify_negative_cache = yes
address_verify_negative_expire_time = 7d
address_verify_negative_refresh_time = 3h
address_verify_poll_count = 3
address_verify_poll_delay = 3s
address_verify_positive_expire_time = 31d
address_verify_positive_refresh_time = 7d
address_verify_relayhost = 
address_verify_sender = address_verification
broken_sasl_auth_clients = yes
command_directory = /usr/sbin
config_directory = /etc/postfix
daemon_directory = /usr/libexec/postfix
default_destination_concurrency_limit = 20
disable_vrfy_command = yes
header_checks = pcre:/etc/postfix/header_checks.pcre
home_mailbox = Maildir/
html_directory = no
inet_interfaces = all
local_destination_concurrency_limit = 2
mail_owner = postfix
mailq_path = /usr/bin/mailq.postfix
manpage_directory = /usr/share/man
message_size_limit = 20480000
mydestination = xxxxxxx, localhost, localhost.localdomain
myhostname = ms1.xxx.net
mynetworks = 127.0.0.0/8, xxx
newaliases_path = /usr/bin/newaliases.postfix
proxy_read_maps = $local_recipient_maps, $mydestination, $virtual_alias_maps, 
$virtual_alias_domains, $virtual_mailbox_maps, $virtual_mailbox_domains, 
$relay_recipient_maps, $relay_domains, $canonical_maps, $sender_canonical_maps, 
$recipient_canonical_maps, $relocated_maps, $transport_maps, $mynetworks
queue_directory = /mail/spool/postfix
readme_directory = /usr/share/doc/postfix-2.3.3/README_FILES
receive_override_options = no_address_mappings
recipient_delimiter = +
relayhost = xxx
sample_directory = /usr/share/doc/postfix-2.3.3/samples
sendmail_path = /usr/sbin/sendmail.postfix
setgid_group = postdrop
smtpd_banner = $myhostname ESMTP $mail_name
smtpd_client_event_limit_exceptions = xxx
smtpd_delay_reject = yes
smtpd_etrn_restrictions = reject
smtpd_hard_error_limit = 4
smtpd_helo_required = yes
smtpd_recipient_restrictions = check_client_access 
hash:/etc/postfix/webmail_client.class, check_helo_access 
pcre:/etc/postfix/4tuple_main_unfiltered.pcre, reject_unauth_pipelining, 
reject_unknown_recipient_domain, warn_if_reject reject_unverified_sender, 
check_client_access hash:/etc/postfix/mta_clients_black.map, permit_mynetworks, 
check_client_access hash:/etc/postfix/mta_clients_bw.map, 
permit_sasl_authenticated, reject
smtpd_restriction_classes = webmail_client.class
smtpd_sasl_auth_enable = yes
smtpd_soft_error_limit = 4
smtpd_tls_cert_file = /etc/postfix/smtpd.cert
smtpd_tls_key_file = /etc/postfix/smtpd.key
smtpd_use_tls = yes
transport_maps = hash:/etc/postfix/transport.map, 
proxy:mysql:/etc/postfix/mysql-virtual_transports.cf
unknown_address_reject_code = 554
unknown_client_reject_code = 554
unknown_hostname_reject_code = 554
unknown_local_recipient_reject_code = 550
unverified_recipient_reject_code = 554
unverified_sender_reject_code = 554
virtual_alias_domains = 
virtual_alias_maps = proxy:mysql:/etc/postfix/mysql-virtual_forwardings.cf,  
mysql:/etc/postfix/mysql-virtual_email2email.cf
virtual_gid_maps = static:200
virtual_mailbox_base = /mail/accounts
virtual_mailbox_domains = proxy:mysql:/etc/postfix/mysql-virtual_domains.cf
virtual_mailbox_maps = proxy:mysql:/etc/postfix/mysql-virtual_mailboxes.cf,
virtual_uid_maps = static:200


>In addition, provide any changes you made to master.cf.

none that we know of

>Know that virtual_alias_maps are NOT handled by the virtual(8) agent.
>This is the job of cleanup(8) and smtpd(8)

ok

Len

Reply via email to