Bug#887840: marked as done (Otrs blocks on receipt of a mail with too long headers)

[Debian Bug Tracking System]

Your message dated Thu, 5 Jul 2018 10:27:56 +0200
with message-id <26efa3c1-8c8a-dcc1-943d-e559df28c...@debian.org>
and subject line Closing
has caused the Debian Bug report #887840,
regarding Otrs blocks on receipt of a mail with too long headers
to be marked as done.

This means that you claim that the problem has been dealt with.
If this is not the case it is now your responsibility to reopen the
Bug report if necessary, and/or fix the problem forthwith.

(NB: If you are a system administrator and have no idea what this
message is talking about, this may indicate a serious mail system
misconfiguration somewhere. Please contact ow...@bugs.debian.org
immediately.)


-- 
887840: https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=887840
Debian Bug Tracking System
Contact ow...@bugs.debian.org with problems

--- Begin Message ---

Package: otrs2
Version: 3.3.18-1+deb8u4

Hi,

Recently a spammer sent a mail to our otrs address with way too many
recipients in To: and Cc:. This had the effect of completely stalling
otrs' mail processing. Rather than just skip over this faulty mail, and
move on to the other mails, the postmaster task just crashed. From then
on failed to process any mails, until we manually deleted this mail from
OTRS' imap mailbox.

Attached is the error message sent by otrs (2250.empl), as well as the
faulty mail that triggered this mess (marques.eml).

Thanks,

Alain

--- Begin Message ---

---------- Message transféré ----------
De : Filipe Marques <filipeleb...@gmail.com>
Date : 7 novembre 2017 à 11:44
Objet : Pour votre information.SMARTMETER.
À :
Cc : Ville de Dudelange <vi...@dudelange.lu>, Ville de Dudelange - Maison
relais <maison.rel...@dudelange.lu>, loris.sp...@dudelange.lu,
rene.mandersch...@dudelange.lu, dan.biancal...@dudelange.lu,
ecolo...@dudelange.lu, mediat...@dudelange.lu, "patrick.h...@dudelange.lu" <
patrick.h...@dudelange.lu>, "francine.zigli...@dudelange.lu" <
francine.zigli...@dudelange.lu>, Sarah Pétré <sarah.pe...@dudelange.lu>, "
dorothee.con...@dudelange.lu" <dorothee.con...@dudelange.lu>, "
melanie.ar...@dudelange.lu" <melanie.ar...@dudelange.lu>, "
danielle.ign...@dudelange.lu" <danielle.ign...@dudelange.lu>, François
Olivieri <francois.olivi...@dudelange.lu>, "victormatiasc...@dudelange.lu" <
victormatiasc...@dudelange.lu>, "guy.net...@dudelange.lu" <
guy.net...@dudelange.lu>, Alexis Cardoso <alexis.card...@dudelange.lu>, "
tom.bern...@dudelange.lu" <tom.bern...@dudelange.lu>, "
claire.dum...@dudelange.lu" <claire.dum...@dudelange.lu>, "
diogo.co...@dudelange.lu" <diogo.co...@dudelange.lu>, "
roby.goer...@dudelange.lu" <roby.goer...@dudelange.lu>, "
paulo.lo...@dudelange.lu" <paulo.lo...@dudelange.lu>, "
circulat...@dudelange.lu" <circulat...@dudelange.lu>, "
gilber.l...@dudelange.lu" <gilber.l...@dudelange.lu>, "
sabatino.sp...@dudelange.lu" <sabatino.sp...@dudelange.lu>, "
dudela...@flammang.lu" <dudela...@flammang.lu>, "serge.b...@dudelange.lu" <
serge.b...@dudelange.lu>, "claudia.dallagn...@dudelange.lu" <
claudia.dallagn...@dudelange.lu>, "chantal.nil...@dudelange.lu" <
chantal.nil...@dudelange.lu>, "jeanette.sin...@dudelange.lu" <
jeanette.sin...@dudelange.lu>, "annecaroleh...@dudelange.lu" <
annecaroleh...@dudelange.lu>, "michele.scha...@dudelange.lu" <
michele.scha...@dudelange.lu>, "manon.h...@dudelange.lu" <
manon.h...@dudelange.lu>, "muriel.hom...@dudelange.lu" <
muriel.hom...@dudelange.lu>, "tamara.monace...@dudelange.lu" <
tamara.monace...@dudelange.lu>, Nic krumlovsky <nic.krumlov...@dudelange.lu>,
"alain.pal...@dudelange.lu" <alain.pal...@dudelange.lu>, "
jose.fav...@dudelange.lu" <jose.fav...@dudelange.lu>, "
carly.bo...@dudelange.lu" <carly.bo...@dudelange.lu>, "
pascal.capit...@dudelange.lu" <pascal.capit...@dudelange.lu>, "
veronique.str...@dudelange.lu" <veronique.str...@dudelange.lu>, "
jeannette.sin...@dudelange.lu" <jeannette.sin...@dudelange.lu>, "
tatjana.greffr...@dudelange.lu" <tatjana.greffr...@dudelange.lu>, "
henri.glese...@dudelange.lu" <henri.glese...@dudelange.lu>, "
chistian.we...@dudelange.lu" <chistian.we...@dudelange.lu>, "
bibliothe...@dudelange.lu" <bibliothe...@dudelange.lu>, "
sven.loschei...@dudelange.lu" <sven.loschei...@dudelange.lu>, "
frank.c...@dudelange.lu" <frank.c...@dudelange.lu>, "
mandy.kre...@dudelange.lu" <mandy.kre...@dudelange.lu>, "
alain.b...@dudelange.lu" <alain.b...@dudelange.lu>, "
mayriam.ham...@dudelange.lu" <mayriam.ham...@dudelange.lu>, "
cult...@dudelange.lu" <cult...@dudelange.lu>, "sandy.b...@dudelange.lu" <
sandy.b...@dudelange.lu>, "marco.th...@dudelange.lu" <
marco.th...@dudelange.lu>, "nicole.arensd...@dudelange.lu" <
nicole.arensd...@dudelange.lu>, "robert.bigdow...@dudelange.lu" <
robert.bigdow...@dudelange.lu>, "daniel.welli...@dudelange.lu" <
daniel.welli...@dudelange.lu>, "myriam.kel...@dudelange.lu" <
myriam.kel...@dudelange.lu>, "natascha.pier...@dudelange.lu" <
natascha.pier...@dudelange.lu>, "julia.recktenw...@dudelange.lu" <
julia.recktenw...@dudelange.lu>, "gilbert.l...@dudelange.lu" <
gilbert.l...@dudelange.lu>, "nadine.gr...@dudelange.lu" <
nadine.gr...@dudelange.lu>, "veronique.her...@dudelange.lu" <
veronique.her...@dudelange.lu>, "biergerfo...@dudelange.lu" <
biergerfo...@dudelange.lu>, "josiane.piki...@dudelange.lu" <
josiane.piki...@dudelange.lu>, "cipa.dudela...@servior.lu" <
cipa.dudela...@servior.lu>, "romain.zeim...@dudelange.lu" <
romain.zeim...@dudelange.lu>, "patrick.capit...@dudelange.lu" <
patrick.capit...@dudelange.lu>, "romain.zu...@dudelange.lu" <
romain.zu...@dudelange.lu>, Claude Tritz <claude.tr...@dudelange.lu>, "
annabellelaboriersaf...@dudelange.lu" <annabellelaboriersaf...@dudelange.lu>


http://www.chd.lu/wps/portal/public/Accueil/TravailALaChambre/Recherche/
RoleDesAffaires?action=doQuestpaDetails&id=15846

--- End Message ---

--- Begin Message ---

DBD::Pg::db do failed: ERROR:  value too long for type character varying(3800) 
at /usr/share/otrs/Kernel/System/DB.pm line 494.
ERROR: OTRS-otrs.PostMasterMailbox.pl-10 Perl: 5.20.2 OS: linux Time: Wed Jan 
17 17:50:01 2018

 Message: ERROR:  value too long for type character varying(3800), SQL: 'INSERT 
INTO article (ticket_id, article_type_id, article_sender_type_id, a_from, 
a_reply_to, a_to, a_cc, a_subject, a_message_id, a_message_id_md5, 
a_in_reply_to, a_references, a_body, a_content_type, content_path, valid_id, 
incoming_time, create_time, create_by, change_time, change_by) VALUES (?, ?, ?, 
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, 
        '2018-01-17 17:50:01'
    , ?, 
        '2018-01-17 17:50:01'
    , ?)'

 Traceback (18618): 
   Module: Kernel::System::Ticket::Article::ArticleCreate (OTRS 3.3.18) Line: 
275
   Module: Kernel::System::PostMaster::NewTicket::Run (OTRS 3.3.18) Line: 374
   Module: Kernel::System::PostMaster::Run (OTRS 3.3.18) Line: 393
   Module: Kernel::System::MailAccount::IMAPTLS::_Fetch (OTRS 3.3.18) Line: 219
   Module: Kernel::System::MailAccount::IMAPTLS::Fetch (OTRS 3.3.18) Line: 77
   Module: Kernel::System::MailAccount::MailAccountFetch (OTRS 3.3.18) Line: 450
   Module: main::Fetch (unknown version) Line: 176
   Module: /usr/share/otrs/bin/otrs.PostMasterMailbox.pl (unknown version) 
Line: 89

ERROR: OTRS-otrs.PostMasterMailbox.pl-10 Perl: 5.20.2 OS: linux Time: Wed Jan 
17 17:50:01 2018

 Message: Can't process email with MessageID 
<<CANE_C=bwStKU=-Si3YFyB+b5-tFw=nop7ue6m2fzzfvqnf0...@mail.gmail.com>>! Please 
create a bug report with this email (From: Filipe Marques 
<filipeleb...@gmail.com>, Located under var/spool/problem-email*) on 
http://bugs.otrs.org/!

 Traceback (18618): 
   Module: Kernel::System::PostMaster::NewTicket::Run (OTRS 3.3.18) Line: 402
   Module: Kernel::System::PostMaster::Run (OTRS 3.3.18) Line: 393
   Module: Kernel::System::MailAccount::IMAPTLS::_Fetch (OTRS 3.3.18) Line: 219
   Module: Kernel::System::MailAccount::IMAPTLS::Fetch (OTRS 3.3.18) Line: 77
   Module: Kernel::System::MailAccount::MailAccountFetch (OTRS 3.3.18) Line: 450
   Module: main::Fetch (unknown version) Line: 176
   Module: /usr/share/otrs/bin/otrs.PostMasterMailbox.pl (unknown version) 
Line: 89

Can't locate object method "get" via package "Mail::IMAPClient" at 
/usr/share/otrs/Kernel/System/MailAccount/IMAPTLS.pm line 221.

--- End Message ---

--- End Message ---

--- Begin Message ---

Closing because of missing feedback. Also this settings is configureable

-- 
/*
Mit freundlichem Gruß / With kind regards,
 Patrick Matthäi
 GNU/Linux Debian Developer

  Blog: http://www.linux-dev.org/
E-Mail: pmatth...@debian.org
        patr...@linux-dev.org
*/

--- End Message ---