Change the mailbox_transport to use an IP address instead of a name.
The fact that postfix can't resolve localhost, even though it's defined in
/etc/hosts could mean several things. Some possibilities: you're running nscd
and added localhost to hosts without restarting nscd; you're /etc/resolv.conf is
incorrect; ...
Robert Gil wrote:
this is the only error i get now.. using mysql 4.1.9
Jan 27 21:28:15 mail postfix/lmtp[9043]: 5204B67CDCE:
to=<[EMAIL PROTECTED]>, relay=none, delay=0, status=bounced (Host or domain
name not found. Name service error for name=localhost type=A: Host not
found)
hosts
##########################################
127.0.0.1 localhost
<MAILSERVERIP> mail.<MYMAILSERVER>.com mail
main.cf
##########################################
myhostname = mail.<MYMAILSERVER>.com
inet_interfaces = mail.<MYMAILSERVER>.com
smtp_bind_address = <IP>
mydomain = criticalfault.com
myorigin = $mydomain
mynetworks = 127.0.0.1, \
192.168.1.1, \
<IP>, \
<IP>, \
mysql:/etc/postfix/sql-pbsp.cf
mydestination = criticalfault.com, \
localhost.DOMAIN.com, \
$myhostname
#transport_maps = hash:/etc/postfix/transport
#relay_transport = hash:/etc/postfix/transport
#local_recipient_maps =
relay_domains = $mydestination
local_recipient_maps = mysql:/etc/postfix/sql-recipients.cf
mailbox_transport = dbmail-lmtp:localhost:24
readme_directory = no
sample_directory = /etc/postfix
sendmail_path = /usr/sbin/sendmail
html_directory = no
setgid_group = postdrop
command_directory = /usr/sbin
manpage_directory = /usr/local/man
daemon_directory = /usr/libexec/postfix
newaliases_path = /usr/bin/newaliases
mailq_path = /usr/bin/mailq
queue_directory = /var/spool/postfix
mail_owner = postfix
unknown_local_recipient_reject_code = 450
From: "Robert Gil" <[EMAIL PROTECTED]>
Reply-To: DBMail mailinglist <[email protected]>
To: [email protected]
Subject: RE: [Dbmail] Permanent Failure
Date: Thu, 27 Jan 2005 17:51:02 -0500
MIME-Version: 1.0
X-Originating-IP: [24.187.219.92]
X-Originating-Email: [EMAIL PROTECTED]
X-Sender: [EMAIL PROTECTED]
Received: from elnino.fastxs.net ([213.214.98.20]) by
mc6-f5.hotmail.com with Microsoft SMTPSVC(6.0.3790.211); Thu, 27 Jan
2005 14:53:39 -0800
Received: from elnino (localhost [127.0.0.1])by elnino.fastxs.net
(Postfix) with ESMTPid 9F1801C00F; Thu, 27 Jan 2005 23:52:39 +0100 (CET)
Received: from hotmail.com (bay12-f31.bay12.hotmail.com
[64.4.35.31])by elnino.fastxs.net (Postfix) with ESMTP id
7404B1C10Efor <[email protected]>; Thu, 27 Jan 2005 23:52:03 +0100 (CET)
Received: from mail pickup service by hotmail.com with Microsoft
SMTPSVC;Thu, 27 Jan 2005 14:52:01 -0800
Received: from 24.187.219.92 by by12fd.bay12.hotmail.msn.com with
HTTP;Thu, 27 Jan 2005 22:51:02 GMT
X-Message-Info: UZmYcfFpTCcZL87eqCFKm9zL5x53jHglhP7AiHhJqdk=
X-OriginalArrivalTime: 27 Jan 2005 22:52:01.0453
(UTC)FILETIME=[D048DDD0:01C504C2]
X-BeenThere: [email protected]
X-Mailman-Version: 2.1.5
Precedence: list
List-Id: DBMail mailinglist <dbmail.dbmail.org>
List-Help: <mailto:[EMAIL PROTECTED]>
List-Post: <mailto:[email protected]>
List-Subscribe:
<https://mailman.fastxs.nl/mailman/listinfo/dbmail>,<mailto:[EMAIL PROTECTED]>
List-Archive: <http://mailman.fastxs.net/pipermail/dbmail>
List-Unsubscribe:
<https://mailman.fastxs.nl/mailman/listinfo/dbmail>,<mailto:[EMAIL PROTECTED]>
Errors-To: [EMAIL PROTECTED]
Return-Path: [EMAIL PROTECTED]
Seems redhat es uses mysql 3.x.... *shudder* im going to compile 4.x
on the mailserver and try that.
From: "Robert Gil" <[EMAIL PROTECTED]>
Reply-To: DBMail mailinglist <[email protected]>
To: [email protected]
Subject: RE: [Dbmail] Permanent Failure
Date: Wed, 26 Jan 2005 19:28:38 -0500
MIME-Version: 1.0
X-Originating-IP: [24.187.219.92]
X-Originating-Email: [EMAIL PROTECTED]
X-Sender: [EMAIL PROTECTED]
Received: from elnino.fastxs.net ([213.214.98.20]) by
MC8-F37.hotmail.com with Microsoft SMTPSVC(6.0.3790.211); Wed, 26 Jan
2005 16:35:16 -0800
Received: from elnino (localhost [127.0.0.1])by elnino.fastxs.net
(Postfix) with ESMTPid ADE7F1BD6F; Thu, 27 Jan 2005 01:30:49 +0100 (CET)
Received: from hotmail.com (bay12-f35.bay12.hotmail.com
[64.4.35.35])by elnino.fastxs.net (Postfix) with ESMTP id
99C881BFCAfor <[email protected]>; Thu, 27 Jan 2005 01:29:17 +0100 (CET)
Received: from mail pickup service by hotmail.com with Microsoft
SMTPSVC;Wed, 26 Jan 2005 16:29:02 -0800
Received: from 24.187.219.92 by by12fd.bay12.hotmail.msn.com with
HTTP;Thu, 27 Jan 2005 00:28:38 GMT
X-Message-Info: UZmYcfFpTCcH7LlJh+OLddZZI1g3loPUEb7X+ebJb3w=
X-OriginalArrivalTime: 27 Jan 2005 00:29:02.0576
(UTC)FILETIME=[3387FF00:01C50407]
X-BeenThere: [email protected]
X-Mailman-Version: 2.1.5
Precedence: list
List-Id: DBMail mailinglist <dbmail.dbmail.org>
List-Help: <mailto:[EMAIL PROTECTED]>
List-Post: <mailto:[email protected]>
List-Subscribe:
<https://mailman.fastxs.nl/mailman/listinfo/dbmail>,<mailto:[EMAIL PROTECTED]>
List-Archive: <http://mailman.fastxs.net/pipermail/dbmail>
List-Unsubscribe:
<https://mailman.fastxs.nl/mailman/listinfo/dbmail>,<mailto:[EMAIL PROTECTED]>
Errors-To: [EMAIL PROTECTED]
Return-Path: [EMAIL PROTECTED]
I had moved the database to a new server, and now im getting these
errors.
Jan 26 19:18:38 mail dbmail/lmtpd[2814]: dbmysql.c,db_query:
executing query [INSERT INTO dbmail_messages
(mailbox_idnr,physmessage_id, seen_flag, answered_flag, deleted_flag,
flagged_flag, recent_flag, draft_flag, unique_id, status) SELECT '3',
physmessage_id, seen_flag, answered_flag, deleted_flag, flagged_flag,
recent_flag, draft_flag, 'b5a7f7a41f6fd13150fdf1fb2eca2acc', status
FROM dbmail_messages WHERE message_idnr = '42323']
Jan 26 19:18:38 mail dbmail/lmtpd[2814]: dbmysql.c,db_query: query
[INSERT INTO dbmail_messages (mailbox_idnr,physmessage_id, seen_flag,
answered_flag, deleted_flag, flagged_flag, recent_flag, draft_flag,
unique_id, status) SELECT '3', physmessage_id, seen_flag,
answered_flag, deleted_flag, flagged_flag, recent_flag, draft_flag,
'b5a7f7a41f6fd13150fdf1fb2eca2acc', status FROM dbmail_messages WHERE
message_idnr = '42323'] failed
Jan 26 19:18:38 mail dbmail/lmtpd[2814]: dbmysql.c,db_query:
mysql_real_query failed: Not unique table/alias: 'dbmail_messages'
From: "Robert Gil" <[EMAIL PROTECTED]>
Reply-To: DBMail mailinglist <[email protected]>
To: [email protected]
Subject: [Dbmail] Permanent Failure Date: Wed, 26 Jan 2005 18:19:17
-0500
MIME-Version: 1.0
X-Originating-IP: [24.187.219.92]
X-Originating-Email: [EMAIL PROTECTED]
X-Sender: [EMAIL PROTECTED]
Received: from elnino.fastxs.net ([213.214.98.20]) by
mc5-f10.hotmail.com with Microsoft SMTPSVC(6.0.3790.211); Wed, 26
Jan 2005 15:26:19 -0800
Received: from elnino (localhost [127.0.0.1])by elnino.fastxs.net
(Postfix) with ESMTPid B09AF1BF5D; Thu, 27 Jan 2005 00:23:33 +0100
(CET)
Received: from hotmail.com (bay12-f10.bay12.hotmail.com
[64.4.35.10])by elnino.fastxs.net (Postfix) with ESMTP id
B42731BF88for <[email protected]>; Thu, 27 Jan 2005 00:20:20 +0100
(CET)
Received: from mail pickup service by hotmail.com with Microsoft
SMTPSVC;Wed, 26 Jan 2005 15:20:02 -0800
Received: from 24.187.219.92 by by12fd.bay12.hotmail.msn.com with
HTTP;Wed, 26 Jan 2005 23:19:17 GMT
X-Message-Info: UZmYcfFpTCcExZRvhG2vlH0aFBbVuFHyB8k8SgcfzsY=
X-OriginalArrivalTime: 26 Jan 2005 23:20:02.0110
(UTC)FILETIME=[8F9F05E0:01C503FD]
X-BeenThere: [email protected]
X-Mailman-Version: 2.1.5
Precedence: list
List-Id: DBMail mailinglist <dbmail.dbmail.org>
List-Help: <mailto:[EMAIL PROTECTED]>
List-Post: <mailto:[email protected]>
List-Subscribe:
<https://mailman.fastxs.nl/mailman/listinfo/dbmail>,<mailto:[EMAIL PROTECTED]>
List-Archive: <http://mailman.fastxs.net/pipermail/dbmail>
List-Unsubscribe:
<https://mailman.fastxs.nl/mailman/listinfo/dbmail>,<mailto:[EMAIL PROTECTED]>
Errors-To: [EMAIL PROTECTED]
Return-Path: [EMAIL PROTECTED]
Jan 26 18:02:35 mail postfix/lmtp[2833]: 7C0C067CD88:
to=<[EMAIL PROTECTED]>, relay=localhost.MYDOMAIN.com[127.0.0.1], delay=0,
status=deferred (host localhost.MYDOMAIN.com[127.0.0.1] said: 415
Recipient <[EMAIL PROTECTED]> Permanent Failure Address Status
Destination mailbox address valid (in reply to end of DATA command))
What does this error mean?!
Please help
~Rob
_______________________________________________
Dbmail mailing list
[email protected]
https://mailman.fastxs.nl/mailman/listinfo/dbmail
_______________________________________________
Dbmail mailing list
[email protected]
https://mailman.fastxs.nl/mailman/listinfo/dbmail
_______________________________________________
Dbmail mailing list
[email protected]
https://mailman.fastxs.nl/mailman/listinfo/dbmail
_______________________________________________
Dbmail mailing list
[email protected]
https://mailman.fastxs.nl/mailman/listinfo/dbmail
--
________________________________________________________________
Paul Stevens [EMAIL PROTECTED]
NET FACILITIES GROUP GPG/PGP: 1024D/11F8CD31
The Netherlands_______________________________________www.nfg.nl
