search

voodoodyne / subetha

SubEtha Mail is a J2EE-based mailing list manager
Other
13 stars 6 forks source link

Data truncation: Data too long for column 'messageId' at row 1 #54

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago 
What steps will reproduce the problem?
when send message to a list with big mail reference like that:

Message-ID: <79749859-B72B-4C18-931F-0A72AD86E4EB@xx.com>
References: 
<2.1.5.1100054017.1114542162.1011547672704@news.xxx.fr>,<FF3C68B456B1D548928074D
41D3E9961661A3C3E@EXCN012.xxx.local.ads>,<3f61460f96874057a2c425615b5f7261@EXCH0
10.xxx.local.ads>,<D779F109-184A-4DE0-94E7-4E2EAFCCBDBE@xxx.com>,<AA342A93-9291-
42F5-8361-EDCA3569E4CB@xxx.com>,<CBC3C85C-0E1E-4D24-98E3-F57CC55A7E05@xxx.com>

What is the expected output? What do you see instead?
the insertion of the message in the database and sending the message to the 
malling list 
instead i receve the message:
Server: 421 4.3.0 Mail system failure, closing transmission channel

What version of the product are you using? On what operating system?
the last git.

Please provide any additional information below.

the messageId field is 255 char long... the message reference 325...
i think that the message id and reference must be controled before use... and 
to protect over that type of probleme to hash (with md5 or sha1) the messageid 
before insterting it in database...

Original issue reported on code.google.com by mcarbonneaux on 27 Jul 2014 at 4:08

GoogleCodeExporter commented 9 years ago 
log sample:

[14-07-27 18:51:28.301] {org.subethamail.smtp.server.Session-/127.0.0.1:39703} 
Threading mail class org.subethamail.entity.Mail {id=9151, subject=[elus] 
Newsletter Social-RH de WK-RH n°337 du 24/07/2014}
[14-07-27 18:51:28.301] {org.subethamail.smtp.server.Session-/127.0.0.1:39704} 
Threading mail class org.subethamail.entity.Mail {id=9152, subject=[elus] 
Newsletter Social-RH de WK-RH n°337 du 24/07/2014}
[14-07-27 18:51:28.301] {org.subethamail.smtp.server.Session-/127.0.0.1:39703} 
Wanted references is [<CBC3C85C-0E1E-4D24-98E3-F57CC55A7E05@xxx.com>, 
<2.1.5.1100054017.1114542162.1011547672704@news.xxx.fr>,<FF3C68B456B1D548928074D
4
1D3E9961661A3C3E@EXCN012.xxxxx.local.ads>,<3f61460f96874057a2c425615b5f7261@EXCH
010.xxxxx.local.ads>,<D779F109-184A-4DE0-94E7-4E2EAFCCBDBE@xxx.com>,<AA342A93-92
91-42F5-8361-EDCA3569E4CB@xxx.com>,<CBC3C85C-0E1E-4D24-98E3-F57CC55A
7E05@xxx.com>]
[14-07-27 18:51:28.301] {org.subethamail.smtp.server.Session-/127.0.0.1:39704} 
Wanted references is [<CBC3C85C-0E1E-4D24-98E3-F57CC55A7E05@xxx.com>, 
<2.1.5.1100054017.1114542162.1011547672704@news.xxx.fr>,<FF3C68B456B1D548928074D
4
1D3E9961661A3C3E@EXCN012.xxxxx.local.ads>,<3f61460f96874057a2c425615b5f7261@EXCH
010.xxxxx.local.ads>,<D779F109-184A-4DE0-94E7-4E2EAFCCBDBE@xxx.com>,<AA342A93-92
91-42F5-8361-EDCA3569E4CB@xxx.com>,<CBC3C85C-0E1E-4D24-98E3-F57CC55A
7E05@xxx.com>]
                        {org.subethamail.smtp.server.Session-/127.0.0.1:39703} Finding Mail with Message-ID <CBC3C85C-0E1E-4D24-98E3-F57CC55A7E05@xxx.com>
[14-07-27 18:51:28.301] {org.subethamail.smtp.server.Session-/127.0.0.1:39704} 
Finding Mail with Message-ID <CBC3C85C-0E1E-4D24-98E3-F57CC55A7E05@xxx.com>
[14-07-27 18:51:28.309] {org.subethamail.smtp.server.Session-/127.0.0.1:39704} 
Finding Mail with Message-ID 
<2.1.5.1100054017.1114542162.1011547672704@news.xxx.fr>,<FF3C68B456B1D548928074D
41D3E9961661A3C3E@EXCN012.xxxxx.local.ads
>,<3f61460f96874057a2c425615b5f7261@EXCH010.xxxxx.local.ads>,<D779F109-184A-4DE0
-94E7-4E2EAFCCBDBE@xxx.com>,<AA342A93-9291-42F5-8361-EDCA3569E4CB@xxx.com>,<CBC3
C85C-0E1E-4D24-98E3-F57CC55A7E05@xxx.com>
[14-07-27 18:51:28.309] {org.subethamail.smtp.server.Session-/127.0.0.1:39703} 
Finding Mail with Message-ID 
<2.1.5.1100054017.1114542162.1011547672704@news.xxx.fr>,<FF3C68B456B1D548928074D
41D3E9961661A3C3E@EXCN012.xxxxx.local.ads
>,<3f61460f96874057a2c425615b5f7261@EXCH010.xxxxx.local.ads>,<D779F109-184A-4DE0
-94E7-4E2EAFCCBDBE@xxx.com>,<AA342A93-9291-42F5-8361-EDCA3569E4CB@xxx.com>,<CBC3
C85C-0E1E-4D24-98E3-F57CC55A7E05@xxx.com>
[14-07-27 18:51:28.313] {org.subethamail.smtp.server.Session-/127.0.0.1:39703} 
Finding mail with subject [elus] Newsletter n°337 du 24/07/2014 younger than 
Fri Jun 27 18:51:28 CEST 2014
[14-07-27 18:51:28.314] {org.subethamail.smtp.server.Session-/127.0.0.1:39704} 
Finding mail with subject [elus] Newsletter n°337 du 24/07/2014 younger than 
Fri Jun 27 18:51:28 CEST 2014
[14-07-27 18:51:28.403] {org.subethamail.smtp.server.Session-/127.0.0.1:39703} 
Best thread ancestor found is null
                        {org.subethamail.smtp.server.Session-/127.0.0.1:39704} Best thread ancestor found is null
[14-07-27 18:51:28.403] {org.subethamail.smtp.server.Session-/127.0.0.1:39703} 
Finding mail wanting ancestor with Message-ID 
<F3EC0920-B742-4DCB-8A62-B1D2FEC9C590@xxx.com>
                        {org.subethamail.smtp.server.Session-/127.0.0.1:39704} Finding mail wanting ancestor with Message-ID <79749859-B72B-4C18-931F-0A72AD86E4EB@xxx.com>
[14-07-27 18:51:28.407] {org.subethamail.smtp.server.Session-/127.0.0.1:39704} 
SQL Error: 1406, SQLState: 22001
                        {org.subethamail.smtp.server.Session-/127.0.0.1:39703} SQL Error: 1406, SQLState: 22001
[14-07-27 18:51:28.407] {org.subethamail.smtp.server.Session-/127.0.0.1:39703} 
Data truncation: Data too long for column 'messageId' at row 1
[14-07-27 18:51:28.407] {org.subethamail.smtp.server.Session-/127.0.0.1:39704} 
Data truncation: Data too long for column 'messageId' at row 1

Original comment by mcarbonneaux on 27 Jul 2014 at 4:57