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.
====
----
Spider Email Archiver: On-Premises, lightweight email archiving software developed by iRedMail team. Supports Amazon S3 compatible storage and custom branding.