The following issue has been SUBMITTED.
======================================================================
http://dbmail.org/mantis/view.php?id=900
======================================================================
Reported By: wqbbs
Assigned To:
======================================================================
Project: DBMail
Issue ID: 900
Category: Database layer
Reproducibility: always
Severity: major
Priority: normal
Status: new
target:
======================================================================
Date Submitted: 05-May-11 05:29 CEST
Last Modified: 05-May-11 05:29 CEST
======================================================================
Summary: long JP subject delivery failed
Description:
# dbmail-smtp -V
This is DBMail version 3.0.0-rc2
# cat /etc/dbmail.conf | grep encodi
encoding = utf8
default_msg_encoding = utf8
PostgreSQL DB - 8.4.7.1
DB use UTF8 encoding
dbmail=# SHOW client_encoding;
client_encoding
-----------------
UTF8
(1 row)
Sending email with long subject (<=255) , successful.
{
command:
# mail -s
"小沢氏告発外の告発外の4億円「犯罪事実」に小沢氏告発外の4億円「犯罪事実」に小沢氏小沢氏告発外の小沢氏告発外の氏告発外の4億氏告発外の4億読売新聞
- ?23 分前?読売新聞聞 23 分" test2@cws08
Length of subject:
# expr length
"小沢氏告発外の告発外の4億円「犯罪事実」に小沢氏告発外の4億円「犯罪事実」に小沢氏小沢氏告発外の小沢氏告発外の氏告発外の4億氏告発外の4億読売新聞
- ?23 分前?読売新聞聞 23 分"
255
}
Sending email with long subject (>255), failed.
{
Command:
# mail -s
"小沢氏告発外の告発外の4億円「犯罪事実」に小沢氏告発外の4億円「犯罪事実」に小沢氏小沢氏告発外の小沢氏告発外の氏告発外の4億氏告発外の4億読売新聞
- ?23 分前?読売新聞聞 23 分a" test2@cws08
Length of subject:
# expr length
"小沢氏告発外の告発外の4億円「犯罪事実」に小沢氏告発外の4億円「犯罪事実」に小沢氏小沢氏告発外の小沢氏告発外の氏告発外の4億氏告発外の4億読売新聞
- ?23 分前?読売新聞聞 23 分a"
256
Exim error log:
2011-05-05 11:08:39 SMTP connection from [192.168.196.102]:54863
I=[192.168.196.119]:25 (TCP/IP connection count = 1)
2011-05-05 11:08:39 no host name found for IP address 192.168.196.102
2011-05-05 11:08:39 H=(localhost.localdomain) [192.168.196.102]:54863
I=[192.168.196.119]:25 Warning: lookup in the sender_whitelist. Result is
deffered
2011-05-05 11:08:39 H=(localhost.localdomain) [192.168.196.102]:54863
I=[192.168.196.119]:25 Warning: not in whitelist
2011-05-05 11:08:39 H=(localhost.localdomain) [192.168.196.102]:54863
I=[192.168.196.119]:25 Warning: lookup in the sender_blacklist. Result is
accepted
2011-05-05 11:08:39 H=(localhost.localdomain) [192.168.196.102]:54863
I=[192.168.196.119]:25 Warning: not in blacklist
2011-05-05 11:08:39 1QHovf-0001pA-JR <= [email protected]
H=(localhost.localdomain) [192.168.196.102]:54863 I=[192.168.196.119]:25
P=esmtps X=TLSv1:AES256-SHA:256 S=1363
[email protected]
T="\345\260\217\346\262\242\346\260\217\345\221\212\347\231\272\345\244\226\343\201\256\345\221\212\347\231\272\345\244\226\343\201\256\357\274\224\345\204\204\345\206\206\343\200\214\347\212\257\347\275\252\344\272\213\345\256\237\343\200\215\343\201\253\345\260\217\346\262\242\346\260\217\345\221\212\347\231\272\345\244\226\343\201\256\357\274\224\345\204\204\345\206\206\343\200\214\347\212\257\347"
from <[email protected]> for [email protected]
2011-05-05 11:08:39 cwd=/var/spool/exim 3 args: /usr/sbin/exim -Mc
1QHovf-0001pA-JR
2011-05-05 11:08:39 SMTP connection from (localhost.localdomain)
[192.168.196.102]:54863 I=[192.168.196.119]:25 closed by QUIT
2011-05-05 11:08:39 1QHovf-0001pA-JR ** [email protected]
F=<[email protected]> R=dbmailuser T=dbmail_delivery: Child
process of dbmail_delivery transport (running command
"/usr/local/dbmail300-rc2/sbin/dbmail-deliver -d ${pipe_addresses}") was
terminated by signal 6 (Aborted)
2011-05-05 11:08:39 cwd=/var/spool/exim 7 args: /usr/sbin/exim -t -oem -oi
-f <> -E1QHovf-0001pA-JR
2011-05-05 11:08:39 1QHovf-0001pO-V5 <= <> R=1QHovf-0001pA-JR U=exim
P=local S=2188 T="Mail delivery failed: returning message to sender" from
<> for [email protected]
2011-05-05 11:08:40 1QHovf-0001pA-JR Completed
2011-05-05 11:08:40 cwd=/var/spool/exim 3 args: /usr/sbin/exim -Mc
1QHovf-0001pO-V5
2011-05-05 11:08:40 1QHovf-0001pO-V5 => test2 ([email protected])
<[email protected]> F=<> R=dbmailuser T=dbmail_delivery S=2188
2011-05-05 11:08:40 1QHovf-0001pO-V5 Completed
DB error log:
2011-05-05 11:08:39 CSTERROR: invalid byte sequence for encoding "UTF8":
0xe588
2011-05-05 11:08:39 CSTHINT: This error can also happen if the byte
sequence does not match the encoding expected by the server, which is
controlled by "client_encoding".
2011-05-05 11:08:39 CSTSTATEMENT: INSERT INTO dbmail_headervalue (hash,
headervalue, sortfield) VALUES ($1,$2,$3) RETURNING id
2011-05-05 11:08:39 CSTLOG: unexpected EOF on client connection
2011-05-05 11:08:39 CSTLOG: unexpected EOF on client connection
2011-05-05 11:08:39 CSTLOG: unexpected EOF on client connection
2011-05-05 11:08:39 CSTLOG: unexpected EOF on client connection
2011-05-05 11:08:39 CSTLOG: unexpected EOF on client connection
}
But if the 255th of subject is single character , even total length of
subject >255 , we can successful.
example:
# mail -s
"小沢氏告発外の告発外の4億円「犯罪事実」に小沢氏告発外の4億円「犯罪事実」に小沢氏小沢氏告発外の小沢氏告発外の氏告発外の4億氏告発外の4億読売新聞
- ?23 分前?読売新聞聞聞聞a分前?読売新聞聞聞聞"
test2@cws08
# expr length
"小沢氏告発外の告発外の4億円「犯罪事実」に小沢氏告発外の4億円「犯罪事実」に小沢氏小沢氏告発外の小沢氏告発外の氏告発外の4億氏告発外の4億読売新聞
- ?23 分前?読売新聞聞聞聞a分前?読売新聞聞聞聞"
283
255th character is 'a':
# expr length
"小沢氏告発外の告発外の4億円「犯罪事実」に小沢氏告発外の4億円「犯罪事実」に小沢氏小沢氏告発外の小沢氏告発外の氏告発外の4億氏告発外の4億読売新聞
- ?23 分前?読売新聞聞聞聞a"
255
======================================================================
Issue History
Date Modified Username Field Change
======================================================================
05-May-11 05:29 wqbbs New Issue
======================================================================
_______________________________________________
Dbmail-dev mailing list
[email protected]
http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail-dev