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 <= root@localhost.localdomain H=(localhost.localdomain) [192.168.196.102]:54863 I=[192.168.196.119]:25 P=esmtps X=TLSv1:AES256-SHA:256 S=1363 id=201105050308.p4538a0D001846@localhost.localdomain 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 <root@localhost.localdomain> for test2@cws08.localdomain 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 ** test2@cws08.localdomain F=<root@localhost.localdomain> 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 root@localhost.localdomain 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 (test2@cws08.localdomain) <root@localhost.localdomain> 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 Dbmail-dev@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail-dev