Am 28.12.2014 um 12:45 schrieb Reindl Harald (mobile):
It's a text field - that's why i asked to bounce at lmtp level :-)
BTW - as for the NULL-char DOS of dbmail-lmtpd with "message_reject_characters = \0" i also tried to mitigate that by restrict some header lengths at MTA level
# Restrict Headers/^Cc:.{32768}/ REJECT Administrative Prohibition (Cc-Header Too Long) /^Content\-Type:.{2048}/ REJECT Administrative Prohibition (Content-Type-Header Too Long) /^Date:.{2048}/ REJECT Administrative Prohibition (Date-Header Too Long) /^From:.{2048}/ REJECT Administrative Prohibition (From-Header Too Long) /^Importance:.{2048}/ REJECT Administrative Prohibition (Importance-Header Too Long) /^In\-Reply\-To:.{2048}/ REJECT Administrative Prohibition (In-Reply-To-Header Too Long) /^Message\-ID:.{2048}/ REJECT Administrative Prohibition (Message-ID-Header Too Long) /^Mime\-Version:.{2048}/ REJECT Administrative Prohibition (Mime-Version-Header Too Long) /^Newsgroups:.{2048}/ REJECT Administrative Prohibition (Newsgroups-Header Too Long) /^Priority:.{2048}/ REJECT Administrative Prohibition (Priority-Header Too Long) /^Received:.{2048}/ REJECT Administrative Prohibition (Received-Header Too Long) /^References:.{32768}/ REJECT Administrative Prohibition (References-Header Too Long) /^Reply\-To:.{2048}/ REJECT Administrative Prohibition (Reply-To-Header Too Long) /^Sender:.{2048}/ REJECT Administrative Prohibition (Sender-Header Too Long) /^Status:.{2048}/ REJECT Administrative Prohibition (Status-Header Too Long) /^Subject:.{2048}/ REJECT Administrative Prohibition (Subject-Header Too Long) /^Thread\-Index:.{2048}/ REJECT Administrative Prohibition (Thread-Index-Header Too Long) /^Thread\-Topic:.{2048}/ REJECT Administrative Prohibition (Thread-Topic-Header Too Long) /^To:.{32768}/ REJECT Administrative Prohibition (To-Header Too Long) /^User\-Agent:.{2048}/ REJECT Administrative Prohibition (User-Agent-Header Too Long) /^X\-Msmail\-Priority:.{2048}/ REJECT Administrative Prohibition (X-Msmail-Priority-Header Too Long) /^X\-Msoesrec:.{2048}/ REJECT Administrative Prohibition (X-Msoesrec-Header Too Long) /^X\-Priority:.{2048}/ REJECT Administrative Prohibition (X-Priority-Header Too Long) /^X\-Ref:.{2048}/ REJECT Administrative Prohibition (X-Ref-Header Too Long)
-------- Ursprüngliche Nachricht -------- Von: Paul J Stevens <p...@nfg.nl> Gesendet: 28. Dezember 2014 12:26:25 MEZ An: DBMail mailinglist <dbmail@dbmail.org> Betreff: Re: [Dbmail] Data too long for column 'envelope' Harry, did you change that column? It should be a TEXT column which means it's width is 64KB. If you didn't, it might be an idea to reject messages whose envelope exceeds a certain length. On 28-11-14 22:38, Reindl Harald wrote:can this please get fixed by just truncate the envelope data to the filed length or bounce that damned messages at LMTP level? :-(Nov 28 22:35:34 mail dbmail/maintenance[1862]: Error:[message] dbmail_message_cache_envelope(+1844): SQLException: Data too long for column 'envelope' at row 1 Nov 28 22:35:34 mail dbmail/maintenance[1862]: Error:[message] dbmail_message_cache_envelope(+1846): insert envelope failed [("Fri, 21 Nov 2014 15:55:30 +0000" "Free Application for Federal Student Aid (FAFSA) Deadline - Nov 28 22:35:35 mail dbmail/maintenance[1875]: Error:[message] dbmail_message_cache_envelope(+1844): SQLException: Data too long for column 'envelope' at row 1 Nov 28 22:35:35 mail dbmail/maintenance[1875]: Error:[message] dbmail_message_cache_envelope(+1846): insert envelope failed [("Fri, 21 Nov 2014 15:55:30 +0000" "Free Application for Federal Student Aid (FAFSA) Deadline - Nov 28 22:35:37 mail dbmail/maintenance[1879]: Error:[message] dbmail_message_cache_envelope(+1844): SQLException: Data too long for column 'envelope' at row 1 Nov 28 22:35:37 mail dbmail/maintenance[1879]: Error:[message] dbmail_message_cache_envelope(+1846): insert envelope failed [("Fri, 21 Nov 2014 15:55:30 +0000" "Free Application for Federal Student Aid (FAFSA) Deadline - Nov 28 22:35:41 mail dbmail/maintenance[1896]: Error:[message] dbmail_message_cache_envelope(+1844): SQLException: Data too long for column 'envelope' at row 1 Nov 28 22:35:41 mail dbmail/maintenance[1896]: Error:[message] dbmail_message_cache_envelope(+1846): insert envelope failed [("Fri, 21 Nov 2014 15:55:30 +0000" "Free Application for Federal Student Aid (FAFSA) Deadline - Nov 28 22:35:43 mail dbmail/maintenance[1899]: Error:[message] dbmail_message_cache_envelope(+1844): SQLException: Data too long for column 'envelope' at row 1 Nov 28 22:35:43 mail dbmail/maintenance[1899]: Error:[message] dbmail_message_cache_envelope(+1846): insert envelope failed [("Fri, 21 Nov 2014 15:55:30 +0000" "Free Application for Federal Student Aid (FAFSA) Deadline - Nov 28 22:35:44 mail dbmail/maintenance[1902]: Error:[message] dbmail_message_cache_envelope(+1844): SQLException: Data too long for column 'envelope' at row 1 Nov 28 22:35:44 mail dbmail/maintenance[1902]: Error:[message] dbmail_message_cache_envelope(+1846): insert envelope failed [("Fri, 21 Nov 2014 15:55:30 +0000" "Free Application for Federal Student Aid (FAFSA) Deadline
signature.asc
Description: OpenPGP digital signature
_______________________________________________ DBmail mailing list DBmail@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
