Mailing List Archive

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

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 DBmail@dbmail.org
> http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
>

- --
________________________________________________________________
Paul J Stevens pjstevns @ gmail, twitter, github, linkedin
www.nfg.nl/info@nfg.nl/+31.85.877.99.97
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1

iEYEARECAAYFAlSf6OEACgkQ8iITvBH4zTFcLgCdEW47vaj7nktEhWQxXgTPHlye
cI8An3mg0cLukBczhc52roqaSxM9ndVa
=Sq6j
-----END PGP SIGNATURE-----
_______________________________________________
DBmail mailing list
DBmail@dbmail.org
http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail

It's a text field - that's why i asked to bounce at lmtp level :-)


-------- Ursprüngliche Nachricht --------
Von: Paul J Stevens <paul@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'

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

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 DBmail@dbmail.org
> http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
>

- --
________________________________________________________________
Paul J Stevens pjstevns @ gmail, twitter, github, linkedin
www.nfg.nl/info@nfg.nl/+31.85.877.99.97
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1

iEYEARECAAYFAlSf6OEACgkQ8iITvBH4zTFcLgCdEW47vaj7nktEhWQxXgTPHlye
cI8An3mg0cLukBczhc52roqaSxM9ndVa
=Sq6j
-----END PGP SIGNATURE-----
_______________________________________________
DBmail mailing list
DBmail@dbmail.org
http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail


--

Reindl Harald (mobile)
the lounge interactive design GmbH
A-1060 Vienna, Hofmühlgasse 17
CTO / CISO / Software-Development
+43 (676) 40 221 40
http://www.thelounge.net
_______________________________________________
DBmail mailing list
DBmail@dbmail.org
http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail

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 <paul@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