1

Topic: transport_maps lookup failure

hello,

i get the following mail.log entries while sending a mail from my private (for years working) mailserver to my new one:

using: IRM 0.7.3 stable w. Debian 6.0.1 - changed my domain to "domain.com" - everything else is original.

Dec  2 15:21:32 xbox postfix/smtpd[4572]: connect from pandora.seener.de[178.63.209.50]
Dec  2 15:21:32 xbox postfix/proxymap[4573]: warning: mysql query failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
Dec  2 15:21:32 xbox postfix/trivial-rewrite[4575]: warning: transport_maps lookup failure
Dec  2 15:21:32 xbox postfix/trivial-rewrite[4575]: warning: transport_maps lookup failure
Dec  2 15:21:32 xbox postfix/smtpd[4572]: NOQUEUE: reject: RCPT from pandora.seener.de[178.63.209.50]: 451 4.3.0 <martin@seener.de>: Temporary lookup failure; from=<martin@seener.de> to=<test@domain.com> proto=ESMTP helo=<pandora.seener.de>
Dec  2 15:21:32 xbox postfix/cleanup[4576]: D943E72F: message-id=<20111202142132.D943E72F@xbox.domain.com>
Dec  2 15:21:32 xbox postfix/smtpd[4572]: disconnect from pandora.seener.de[178.63.209.50]
Dec  2 15:21:32 xbox postfix/qmgr[3935]: D943E72F: from=<double-bounce@xbox.domain.com>, size=1425, nrcpt=1 (queue active)
Dec  2 15:21:32 xbox postfix/trivial-rewrite[4575]: warning: transport_maps lookup failure
Dec  2 15:21:32 xbox postfix/error[4577]: D943E72F: to=<postmaster@xbox.domain.com>, relay=none, delay=0.04, delays=0.01/0.01/0/0.02, dsn=4.3.0, status=deferred (address resolver failure)

additonally to iredmail i installed postfixadmin (latest stable) and made the -> "AND transport<>" thing to my transport_maps_user.cf whereas the query looks like this:

query       = SELECT mailbox.transport FROM mailbox,domain WHERE mailbox.username='%s' AND mailbox.domain='%d' AND mailbox.domain=domain.domain AND mailbox.transport<>'' AND mailbox.active=1 AND mailbox.enabledeliver=1 AND domain.backupmx=0 AND domain.active=1 AND transport<>

and i made a xbox.domain.com/postfixadmin/upgrade.php thing whereas vmailadmin got CREATE and ALTER rights for its table temporary.

Any Suggestions?

Thank you all!

==== Provide basic information to help troubleshoot and get quick answer ====
- iRedMail version:
- Linux/BSD distribution name and version:
- Any related log? Log is helpful for troubleshooting.
====

2

Re: transport_maps lookup failure

ok it looks like the "AND transport<>" thing was the mistake but why is it mentioned in the postfixadmin integration tutorial??

3

Re: transport_maps lookup failure

martinseener wrote:

ok it looks like the "AND transport<>" thing was the mistake but why is it mentioned in the postfixadmin integration tutorial??

Sorry, which integration tutorial? URL?

4

Re: transport_maps lookup failure

below under important notes, after the first SQL Quote:
http://www.iredmail.org/wiki/index.php? … QL.Backend

i havent changed anything in this file and it works smile