Aug 5, 2024: iRedMail-1.7.1 has been released.

**M Martinatti** · 2012-08-15 23:27:34

M Martinatti
Member
Offline

Registered: 2011-05-12
Posts: 36

Topic: Address resolver failure

==== Required information ====
- iRedMail version: 0.7.3 w/ iRedMail-Pro version: 1.3.0
- Store mail accounts in which backend (LDAP/MySQL/PGSQL): MySQL
- Linux/BSD distribution name and version: Debian Squeeze
- Related log if you're reporting an issue:
====

Hi Zhang,

I'm having a problem that can not find the reason.

I have seen very often the following error when trying to send mail from one user to another of the same domain:

>> 'Andres' on 13/08/2012 08:45
>>
>> <userdomain@domainexample.com> >> 451 4.3.0: Temporary lookup failure

(I changed the primary domain server for the domainexample.com)

When analyzing the queue every day there are a large number of messages, as follows:

root@smtp01:~# /usr/sbin/postqueue -p | more
51E5A33407E 1032 Wed Aug 15 12:00:07 double-bounce@smtp01.domainexample.com
667FC334068 1216 Wed Aug 15 12:00:00 double-bounce@smtp01.domainexample.com
6D3493340B7 1435 Wed Aug 15 10:40:06 double-bounce@smtp01.domainexample.com
6D2D234222 1111 Wed Aug 15 11:58:23 double-bounce@smtp01.domainexample.com
67DB733403D 953 Wed Aug 15 11:59:24 double-bounce@smtp01.domainexample.com
63C02334082 1170 Wed Aug 15 11:10:08 double-bounce@smtp01.domainexample.com
678603340DC 1484 Wed Aug 15 11:30:08 double-bounce@smtp01.domainexample.com
67A3D334010 1692 Wed Aug 15 11:58:47 double-bounce@smtp01.domainexample.com
A0612341D3 1430 Wed Aug 15 11:57:26 double-bounce@smtp01.domainexample.com
--More--

The content of these messages is always this:

<postmaster@smtp01.domainexample.com>: address resolver failure
recipient=postmaster@smtp01.domainexample.com
offset=206
status=4.3.0
action=delayed
reason=address resolver failure

Bind9 is installed and functioning normally. The file / etc / resolv.conf looks like:

nameserver 127.0.0.1

The file /etc/hosts is:

127.0.0.1 smtp01.domainexample.com smtp01 localhost

I have configured the server about 80 domains and very often these errors occur for users of these domains.

Some hint of what might be wrong?

Tks,

M Martinatti

----

Spider Email Archiver: On-Premises, lightweight email archiving software developed by iRedMail team. Supports Amazon S3 compatible storage and custom branding.

**ZhangHuangbin** · 2012-08-16 21:04:56

ZhangHuangbin
iRedMail Developers
Offline

Registered: 2009-05-06
Posts: 31,082

Re: Address resolver failure

M Martinatti wrote:

>> <userdomain@domainexample.com> >> 451 4.3.0: Temporary lookup failure

- Please always paste full original log message instead of part of them.
- Any other related log in Postfix log file?

**M Martinatti** · 2012-08-16 22:31:30

M Martinatti
Member
Offline

Registered: 2011-05-12
Posts: 36

Re: Address resolver failure

Hi Zhang,

How many messages are, I tried to get only a piece of log to see if I can improve the information:

Aug 13 07:28:15 smtp01 postfix/proxymap[2171]: warning: mysql query failed: Illegal mix of collations (ascii_general_ci,IMPLICIT) and (latin1_swedish_ci,COERCIBLE) for operation '='
Aug 13 07:28:15 smtp01 postfix/trivial-rewrite[32420]: warning: transport_maps lookup failure
Aug 13 07:28:15 smtp01 postfix/smtpd[1514]: NOQUEUE: reject: RCPT from pm04-4346.recantododesconto.allinmedia.com.br[177.136.30.81]: 451 4.3.0 < user@otherdomainlocal.com>: Temporary lookup failure; from=<retorno682932@recantododesconto.allinmedia.com.br> to=<?user@otherdomainlocal.com> proto=ESMTP helo=<pm04-4346.recantododesconto.allinmedia.com.br>
Aug 13 07:28:15 smtp01 postfix/cleanup[1599]: 1B9D034133: message-id=<20120813102815.1B9D034133@smtp01.domainexample.com>
Aug 13 07:28:15 smtp01 postfix/smtpd[1597]: disconnect from mx113.send.esp.br[200.146.61.113]
Aug 13 07:28:15 smtp01 postfix/smtpd[1514]: disconnect from pm04-4346.recantododesconto.allinmedia.com.br[177.136.30.81]
Aug 13 07:28:15 smtp01 postfix/qmgr[19467]: 1B9D034133: from=<double-bounce@smtp01.domainexample.com>, size=1202, nrcpt=1 (queue active)
Aug 13 07:28:15 smtp01 postfix/trivial-rewrite[2163]: warning: transport_maps lookup failure
Aug 13 07:28:15 smtp01 postfix/error[2250]: 1B9D034133: to=<postmaster@smtp01.domainexample.com>, relay=none, delay=0.18, delays=0.09/0.01/0/0.07, dsn=4.3.0, status=deferred (address resolver failure)
Aug 13 07:28:15 smtp01 postfix-policyd: rcpt=2048258, greylist=new, host=189.50.54.148 (skirt.mailinc.com.br), from=mharteecozinha.com.br.2358071.marialuiza@skirt.mailinc.co, to=marialuiza@mharteecozinha.com.br, size=0
Aug 13 07:28:15 smtp01 postfix/smtpd[1553]: NOQUEUE: reject: RCPT from skirt.mailinc.com.br[189.50.54.148]: 450 4.7.1 <marialuiza@mharteecozinha.com.br>: Recipient address rejected: Policy Rejection- Please try later.; from=<mharteecozinha.com.br.2358071.marialuiza@skirt.mailinc.com.br> to=<marialuiza@mharteecozinha.com.br> proto=SMTP helo=<skirt.mailinc.com.br>
Aug 13 07:28:15 smtp01 postfix/smtpd[1553]: disconnect from skirt.mailinc.com.br[189.50.54.148]
Aug 13 07:28:15 smtp01 postfix/smtpd[1598]: connect from pm04-4364.recantododesconto.allinmedia.com.br[177.136.30.99]
Aug 13 07:28:15 smtp01 postfix/trivial-rewrite[32420]: warning: transport_maps lookup failure
Aug 13 07:28:15 smtp01 postfix/trivial-rewrite[32420]: warning: transport_maps lookup failure
Aug 13 07:28:15 smtp01 postfix/smtpd[1598]: NOQUEUE: reject: RCPT from pm04-4364.recantododesconto.allinmedia.com.br[177.136.30.99]: 451 4.3.0 <retorno682932@recantododesconto.allinmedia.com.br>: Temporary lookup failure; from=<retorno682932@recantododesconto.allinmedia.com.br> to=<?vendas@interativasul.com.br> proto=ESMTP helo=<pm04-4364.recantododesconto.allinmedia.com.br>
Aug 13 07:28:16 smtp01 postfix/cleanup[1556]: 00AA834138: message-id=<20120813102816.00AA834138@smtp01.domainexample.com>
Aug 13 07:28:16 smtp01 postfix/smtpd[1598]: disconnect from pm04-4364.recantododesconto.allinmedia.com.br[177.136.30.99]
Aug 13 07:28:16 smtp01 postfix/qmgr[19467]: 00AA834138: from=<double-bounce@smtp01.domainexample.com>, size=1229, nrcpt=1 (queue active)
Aug 13 07:28:16 smtp01 postfix/error[2250]: 00AA834138: to=<postmaster@smtp01.domainexample.com>, relay=none, delay=0.18, delays=0.11/0/0/0.07, dsn=4.3.0, status=deferred (address resolver failure)
Aug 13 07:28:21 smtp01 postfix/smtpd[1596]: connect from mta44.newsenvpost.com.br[177.152.222.171]
Aug 13 07:28:21 smtp01 postfix/trivial-rewrite[32420]: warning: transport_maps lookup failure
Aug 13 07:28:21 smtp01 postfix/smtpd[1596]: NOQUEUE: reject: RCPT from mta44.newsenvpost.com.br[177.152.222.171]: 451 4.3.0 <multsign@multsign.com.br>: Temporary lookup failure; from=<bounce@bounce.newsenvpost.com.br> to=<multsign@multsign.com.br> proto=ESMTP helo=<mta44.newsenvpost.com.br>
Aug 13 07:28:21 smtp01 postfix/cleanup[1600]: 71D6034151: message-id=<20120813102821.71D6034151@smtp01.connexion.com.br>
Aug 13 07:28:21 smtp01 postfix/smtpd[1596]: disconnect from mta44.newsenvpost.com.br[177.152.222.171]
Aug 13 07:28:21 smtp01 postfix/qmgr[19467]: 71D6034151: from=<double-bounce@smtp01.domainexample.com>, size=1147, nrcpt=1 (queue active)
Aug 13 07:28:21 smtp01 postfix/error[2250]: 71D6034151: to=<postmaster@smtp01.domainexample.com>, relay=none, delay=0.14, delays=0.08/0/0/0.07, dsn=4.3.0, status=deferred (address resolver failure)
Aug 13 07:28:28 smtp01 postfix/smtpd[1597]: connect from mail5.suportevendasmkt.com.br[189.84.17.174]
Aug 13 07:28:28 smtp01 postfix/trivial-rewrite[32420]: warning: transport_maps lookup failure
Aug 13 07:28:28 smtp01 postfix/trivial-rewrite[32420]: warning: transport_maps lookup failure
Aug 13 07:28:28 smtp01 postfix/smtpd[1597]: NOQUEUE: reject: RCPT from mail5.suportevendasmkt.com.br[189.84.17.174]: 451 4.3.0 <super@suportevendasmkt.com.br>: Temporary lookup failure; from=<super@suportevendasmkt.com.br> to=<hbuarque@azevedooleos.com.br> proto=ESMTP helo=<mail5.suportevendasmkt.com.br>
Aug 13 07:28:28 smtp01 postfix/cleanup[1599]: CDC7534175: message-id=<20120813102828.CDC7534175@smtp01.domainexample.com>
Aug 13 07:28:28 smtp01 postfix/smtpd[1597]: disconnect from mail5.suportevendasmkt.com.br[189.84.17.174]

See who has something different that is not normal:

Aug 13 07:28:15 smtp01 postfix/proxymap[2171]: warning: mysql query failed: Illegal mix of collations

What would it be? It will be another problem, unrelated to what I'm referring?

Very tks.

M Martinatti

**ZhangHuangbin** · 2012-08-16 22:45:11

ZhangHuangbin
iRedMail Developers
Offline

Registered: 2009-05-06
Posts: 31,082

Re: Address resolver failure

M Martinatti wrote:

warning: mysql query failed: Illegal mix of collations (ascii_general_ci,IMPLICIT) and (latin1_swedish_ci,COERCIBLE) for operation '='

This log message makes sense.

Please follow this forum topic to solve it:
http://www.iredmail.org/forum/topic2474 … olved.html

**M Martinatti** · 2012-08-17 02:39:38

M Martinatti
Member
Offline

Registered: 2011-05-12
Posts: 36

Re: Address resolver failure

Zhang,

Thanks, but I did not understand the relationship between the error in the MySQL query and the problem with name resolution.

The messages are being returned to the double-bounce@smtp01..... because of the problem in MySQL query?

Unfortunately I read the other topics but did not understand how to fix it. I will update this server with the latest versions of iRedMail-Pro, but wanted to make it running smoothly first, because it is a production server with many domains.

I hope your help.

Very Tks.

M Martinatti

**ZhangHuangbin** · 2012-08-17 18:30:22

ZhangHuangbin
iRedMail Developers
Offline

Registered: 2009-05-06
Posts: 31,082

Re: Address resolver failure

The "lookup" in log message is not DNS lookup, but SQL lookup.
Oops, seems i pasted a wrong url. Use this one instead:
http://www.iredmail.org/forum/post10361.html#p10361

**M Martinatti** · 2012-08-17 21:07:17

M Martinatti
Member
Offline

Registered: 2011-05-12
Posts: 36

Re: Address resolver failure

Then I change tables described in the post ascii_general_ci to utf8_general_ci?

**ZhangHuangbin** · 2012-08-18 07:43:59

ZhangHuangbin
iRedMail Developers
Offline

Registered: 2009-05-06
Posts: 31,082

Re: Address resolver failure

Yes.

**M Martinatti** · 2012-08-21 03:02:30

M Martinatti
Member
Offline

Registered: 2011-05-12
Posts: 36

Re: Address resolver failure

Tks!

Solved. Now I'll provide the update.

M Martinatti

Aug 5, 2024: iRedMail-1.7.1 has been released.

[ Closed ] Address resolver failure

Posts: 9

1 Topic by M Martinatti 2012-08-15 23:27:34

Topic: Address resolver failure

2 Reply by ZhangHuangbin 2012-08-16 21:04:56

Re: Address resolver failure

3 Reply by M Martinatti 2012-08-16 22:31:30

Re: Address resolver failure

4 Reply by ZhangHuangbin 2012-08-16 22:45:11

Re: Address resolver failure

5 Reply by M Martinatti 2012-08-17 02:39:38

Re: Address resolver failure

6 Reply by ZhangHuangbin 2012-08-17 18:30:22

Re: Address resolver failure

7 Reply by M Martinatti 2012-08-17 21:07:17

Re: Address resolver failure

8 Reply by ZhangHuangbin 2012-08-18 07:43:59

Re: Address resolver failure

9 Reply by M Martinatti 2012-08-21 03:02:30

Re: Address resolver failure

Posts: 9