The following issue requires your FEEDBACK.
======================================================================
http://www.dbmail.org/mantis/view.php?id=196
======================================================================
Reported By: mrbarletta
Assigned To:
======================================================================
Project: DBMail
Issue ID: 196
Category: Database layer
Reproducibility: always
Severity: major
Priority: low
Status: feedback
======================================================================
Date Submitted: 13-Apr-05 19:59 CEST
Last Modified: 29-Aug-05 22:17 CEST
======================================================================
Summary: Yahoo messages fail to insert into database
Description:
Weird. Messages from yahoo with attachments failed to insert into DB pgsql
(8.0.2). Any other email from any other free or private mail service will
succeed. (hotmail, gmail etc.
dbpgsql.c, db_query: Error executing query [INSERT INTO dbmail_messageblks
(is_header, messageblk, blocksize, physmessage_id) VALUES ('0','This is a
multi-part message in MIME forma.................. -->keep going the
message <---
dbpgsql.c, db_query: Error executing query [INSERT INTO dbmail_messageblks
(is_header, messageblk, blocksize, physmessage_id) VALUES ('0','This is a
multi-part message in MIME forma
======================================================================
----------------------------------------------------------------------
paul - 19-Apr-05 09:47
----------------------------------------------------------------------
mrbarletta,
Could you please upload such a yahoo email to the bugtracker so I can fix
this?
Thanks,
Paul.
----------------------------------------------------------------------
rhys - 26-Aug-05 01:12
----------------------------------------------------------------------
There is a similar problem with spam (particularly those found by Spam
Assassin). Possibly because the email itself is a malformed MIME email. It
is however also affecting spam that is not caught by spam assassin (Indeed,
DB Mail is proving better at spam handling than the dated version of Spam
assassin I have installed)
Occassionally messages do actually make it through and come out like
this:
<snip>
>From - Sat Aug 13 09:10:57 2005
X-Mozilla-Status: 0001
X-Mozilla-Status2: 00000000
from: [EMAIL PROTECTED]
subject: dbmail IMAP server info: this message could not be parsed
Received: by pbf.org.au (Postfix, from userid 99)
id E5A0C128594; Sat, 13 Aug 2005 02:02:14 +1000 (EST)
Received: from TCL-M1U4TDIHGFQ (unknown [221.15.180.154])
by pbf.org.au (Postfix) with SMTP id 0554A12828F
for <[EMAIL PROTECTED]>; Sat, 13 Aug 2005 02:02:05 +1000 (EST)
X-Message-Info: %RNDUCCHAR15hU865bZtrUOUgbd4NCBg3+URwu6tZDF
Received: from ahx11.allsaintsfan.com (59) by y499-b55.168city.com with
Microsoft SMTPSVC(5.0.2195.6824);
Fri, 12 Aug 2005 20:01:08 +0300
Received: from Ulyssesi56jol508mua99lsp (32) by ljsios72.168city.com
(InterMail vM.5.01.06.05 081-727-976-238-694-724011770) with
SMTP
id
<[EMAIL PROTECTED]>
for <[EMAIL PROTECTED]>; Fri, 12 Aug 2005 17:58:08 +0100
Message-ID: <[EMAIL PROTECTED]>
From: "" Hiram Owens "" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Subject: Re: ..advertising for your organization
Date: Fri, 12 Aug 2005 11:04:08 -0600
MIME-Version: 1.0
Content-Type: multipart/alternative;
boundary="--504139870600539063"
X-Spam-Status: No, hits=3.5 required=7.0
tests=OPT_IN,RCVD_IN_BL_SPAMCOP_NET
version=2.55
X-Spam-Level: ***
X-Spam-Checker-Version: SpamAssassin 2.55 (1.174.2.19-2003-05-19-exp)
X-Pyzor: Reported 0 times.
----387261715514859821
Content-Type: text/plain;
Content-Transfer-Encoding: quoted-printable
<<< Crazy spam message was here>>>
----056451046156215873--
</snip>
My guess is that it has to do with the boundaries not matching up. However
the boundaries do match in the email attached by mrbarletta.
I am also using PostgreSQL (7.3) on Red Hat Enterprise Linux 3.
----------------------------------------------------------------------
paul - 29-Aug-05 22:17
----------------------------------------------------------------------
I still want such a allegedly malformed yahoo mail. :-) Until then I'm not
convinced this is a problem in the mime-parser.
Mrbarletta: please check the encoding on the database! Make sure it's in
us-ascii.
Issue History
Date Modified Username Field Change
======================================================================
13-Apr-05 19:59 mrbarletta New Issue
19-Apr-05 09:47 paul Note Added: 0000659
22-Apr-05 04:40 mrbarletta File Added: [Fwd: Re: Hola necesito un favor].eml
26-Aug-05 01:11 rhys Note Added: 0000882
26-Aug-05 01:11 rhys Issue Monitored: rhys
26-Aug-05 01:12 rhys Note Edited: 0000882
29-Aug-05 22:17 paul Note Added: 0000890
29-Aug-05 22:17 paul Priority normal => low
29-Aug-05 22:17 paul Status new => feedback
29-Aug-05 22:17 paul Resolution open => unable to
reproduce
======================================================================
