Hi
I posted this message on Baruwa and Postfix mailing list since I don't
know where the problem is
Postfix is set to use a relayhost and a mysql based transport map for
some domain that are not hosted on the same server
/etc/postfix/main.cf:
transport_maps = mysql:/etc/postfix/mysql-transports.cf
relayhost = 10.0.1.11
/etc/postfix/mysql-transport.cf:
#mysql-transports
user = baruwa
password = ******
dbname = baruwa
query = select concat('smtp:[', mail_hosts.address, ']', ':', port)
'transport' from mail_hosts, user_addresses where user_addresses.address
= '%s' AND user_addresses.id = mail_hosts.useraddress_id;
hosts = 127.0.0.1
I have two domains in the transport map. Postfix is "sometime" ignoring
the transport map for ONE domain and send emails through the default
relayhost. Most of the emails received for this domain go through the
right server. I'd say 80% are OK.
Look at the mail.log entry for a mail that is sent through the wrong
server.
Jun 11 16:56:14 mx01 postfix/smtpd[855]: connect from
rfmnotes.fossnational.com[66.212.175.2]
Jun 11 16:56:15 mx01 postfix/smtpd[855]: NOQUEUE: reject: RCPT from
rfmnotes.fossnational.com[66.212.175.2]: 550 5.1.1 < recipient
@domain.ca>: Recipient address rejected: undeliverable address: host
10.0.1.11[10.0.1.11] said: 550 not local host domain.ca, not a gateway
(in reply to RCPT TO command); from=<sen...@anotherdomain.com>
to=<recipi...@domain.ca> proto=ESMTP helo=<rfmnotes.fossnational.com>
***IT SEND THROUGH THE WRONG SERVER (10.0.1.11) ***
Jun 11 16:56:15 mx01 postfix/cleanup[662]: 2093E56006D:
message-id=<20120611205615.2093e560...@mx01.reference.qc.ca>
Jun 11 16:56:15 mx01 postfix/qmgr[28563]: 2093E56006D:
from=<double-bou...@reference.qc.ca>, size=246, nrcpt=1 (queue active)
Jun 11 16:56:15 mx01 postfix/smtp[800]: 2093E56006D:
to=<recipi...@domain.ca>, relay=192.168.100.9[192.168.100.9]:25,
delay=0.01, delays=0/0/0/0, dsn=2.1.5, status=deliverable (250 2.1.5
Recipient <recipi...@domain.ca> ok (local)) ***IT CHECK RECIPIENT
VALIDITY WITH THE RIGHT SERVER (192.168.100.9)
(reject_unverified_recipient in main.cf) ***
Jun 11 16:56:15 mx01 postfix/qmgr[28563]: 2093E56006D: removed
Jun 11 16:56:15 mx01 postfix/smtpd[855]: disconnect from
rfmnotes.fossnational.com[66.212.175.2]
I tried to set a text transport map and postmap'd it instead of mysql
and I get the same issue.
Any help is greatly appreciated
Max
