A NOTE has been added to this issue. 
====================================================================== 
http://dbmail.org/mantis/view.php?id=724 
====================================================================== 
Reported By:                hinote
Assigned To:                
====================================================================== 
Project:                    DBMail
Issue ID:                   724
Category:                   Database layer
Reproducibility:            sometimes
Severity:                   major
Priority:                   normal
Status:                     new
target:                      
====================================================================== 
Date Submitted:             01-Sep-08 23:55 CEST
Last Modified:              02-Sep-08 12:12 CEST
====================================================================== 
Summary:                    error storing message with malformed Message-Id
header field
Description: 
When a message with a non-ASCII char (for instance, a cyrillic char or
umlaut) in Message-Id is submitted with dbmail-smtp, the following error
messages appear in the log, and the message is not accepted:

Aug 29 12:16:12 maildb dbmail/smtp[23681]: Error:[sql]
dbpgsql.c,db_query(+287): query failed [INSERT INTO dbmail_envelope
(physmessage_id, envelope) VALUES (3575439,'("Fri, 29 Aug 2008 06:28:20
+0000" "[!! SPAM] =?koi8-r?B?7tXWxc4gy9XS2MXS?="
(("=?iso-8859-5?b?s9jb0NY=?=" NIL "aaa.bbb" "xxx.net"))
(("=?iso-8859-5?b?s9jb0NY=?=" NIL "aaa.bbb" "xxx.net"))
(("=?iso-8859-5?b?s9jb0NY=?=" NIL "aaa.bbb" "xxx.net")) ((NIL NIL "ccc"
"my.domain")) NIL NIL NIL {22}
 <[EMAIL PROTECTED]&http://dbmail.org/mantis/view.php?id=1081;>)')] : [ERROR: 
invalid byte sequence for encoding
"UTF8": 0xe93e29 HINT:  This error can also happen if the byte sequence
does not match the encoding expected by the server, which is controlled by
"client_encoding". ] 
Aug 29 12:16:12 maildb dbmail/smtp[23681]: Error:[message]
dbmail-message.c,dbmail_message_cache_envelope(+1277): insert envelope
failed [INSERT INTO dbmail_envelope (physmessage_id, envelope) VALUES
(3575439,'("Fri, 29 Aug 2008 06:28:20 +0000" ""[!! SPAM]
=?koi8-r?B?7tXWxc4gy9XS2MXS?=" (("=?iso-8859-5?b?s9jb0NY=?=" NIL "aaa.bbb"
"xxx.net")) (("=?iso-8859-5?b?s9jb0NY=?=" NIL "aaa.bbb" "xxx.net"))
(("=?iso-8859-5?b?s9jb0NY=?=" NIL "aaa.bbb" "xxx.net")) ((NIL NIL "ccc"
"my.domain")) NIL NIL NIL {22}
 <[EMAIL PROTECTED]&http://dbmail.org/mantis/view.php?id=1081;>)')]
Aug 29 12:16:12 maildb dbmail/smtp[23681]: Error:[db]
db.c,db_copymsg(+3865): error getting message size for message [7143942]
Aug 29 12:16:12 maildb dbmail/smtp[23681]: Error:[sort]
sort.c,sort_deliver_to_mailbox(+193): error copying message to user [4]
Aug 29 12:16:12 maildb dbmail/smtp[23681]: Error:[delivery]
pipe.c,insert_messages(+601): unknown temporary failure in
sort_and_deliver for useridnr [4]

====================================================================== 

---------------------------------------------------------------------- 
 hinote - 02-Sep-08 12:12  
---------------------------------------------------------------------- 
seems to be a gmime problem in my case, malformed Message-Id fields are not
taken by gmime and are substituted with newly generated values by dbmail on
other systems, I'll try to provide more info on how to reproduce the
issue... 

However, this bug is in the code anyway - the Message-Id value is not
transformed into utf8 (or db charset?) while (as the issue shows) gmime
may not recognize all malformed values and return a non utf8 content... 

Issue History 
Date Modified   Username       Field                    Change               
====================================================================== 
01-Sep-08 23:55 hinote         New Issue                                    
02-Sep-08 12:12 hinote         Note Added: 0002593                          
======================================================================

_______________________________________________
Dbmail-dev mailing list
[email protected]
http://twister.fastxs.net/mailman/listinfo/dbmail-dev

Reply via email to