Re: Data too long for column 'envelope'
Reindl Harald <[email protected]>
| Newsgroups | gmane.mail.imap.dbmail |
|---|---|
| Organization | the lounge interactive design |
| Message-ID | <[email protected]> |
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 <[email protected]>
> Gesendet: 28. Dezember 2014 12:26:25 MEZ
> An: DBMail mailinglist <[email protected]>
> 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
_______________________________________________
DBmail mailing list
[email protected]
http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
signature.asc
(application/pgp-signature, 181 B)
-----BEGIN PGP SIGNATURE----- Version: GnuPG v1 iEYEARECAAYFAlSf9eAACgkQhmBjz394AnnB+ACeNsHEYhofysVQUWpkWckJ5f6P enAAn2kxDNw79HYcEPE+xTBTS+jHcGUb =xeWk -----END PGP SIGNATURE-----