Mailinhalt wird nicht akzeptiert

Hilfe zu OTRS Problemen aller Art
Forum rules
Post Reply
hildeb
Znuny newbie
Posts: 42
Joined: 25 Jun 2019, 11:06
Znuny Version: 6.5.4
Real Name: Ralf Hildebrandt
Company: Charite
Contact:
Contact hildeb

Mailinhalt wird nicht akzeptiert

Post by hildeb »

Wir haben hier das Problem, daß eine Mail schlichtweg nicht akzeptiert wird, offenbar weil der Inhalt nicht genehm ist (znuny-6.5.4) :

Code: Select all

[Sun Sep 24 09:42:54 2023] otrs.Console.pl: DBD::mysql::db do failed: Incorrect string value: '\xED\xA0\xBC\xED\xBC\x9F...' for column 'a_body' at row 1 at /opt/znuny-6.5.4/Kernel/System/DB.pm line 497. ERROR: OTRS-otrs.Console.pl-Maint::PostMaster::Read-10 Perl: 5.34.0 OS: linux Time: Sun Sep 24 09:42:54 2023   Message: Incorrect string value: '\xED\xA0\xBC\xED
\xBC\x9F...' for column 'a_body' at row 1, SQL: '             INSERT INTO article_data_mime (                 article_id, a_from, a_reply_to, a_to, a_cc, a_bcc, a_subject, a_message_id,     
            a_message_id_md5, a_in_reply_to, a_references, a_content_type, a_body,                 incoming_time, content_path, create_time, create_by, change_time, change_by)             VALUES (                 ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, '2023-09-24 09:42:54', ?, '2023-09-24 09:42:54', ?             )         '   Traceback (2270411):     Module: Kernel::System::Ticket::Article::Backend::MIMEBase::ArticleCreate Line: 402    Module: Kernel::System::PostMaster::NewTicket::Run Line: 575    Module: Kernel::System::PostMaster::Run Line: 434    Module: (eval) Line: 123    Module: Kernel::System::Console::Command::Maint::PostMaster::Read::Run Line: 105    Module: (eval) Line: 461    Module: Kernel::System::Console::BaseCommand::Execute Line: 455    Module: Kernel::System::Console::InterfaceConsole::Run Line: 81    Module: /opt/otrs/bin/otrs.Console.pl Line: 37  ERROR: OTRS-otrs.Console.pl-Maint::PostMaster::Read-10 Perl: 5.3
4.0 OS: linux Time: Sun Sep 24 09:42:54 2023   Message: CommunicationLog(ID:3032952,AccountType:-,AccountID:-,Direction:Incoming,Transport:Email,ObjectLogType:Message,ObjectLogID:3983086)::K
ernel::System::PostMaster::NewTicket => Can't process email with MessageID <<564bddd4687a1ae3f93de32cddabc0d4@www.charite.de>>! Please create a bug re
... und a war es dann abgeschnitten.

Ich habe mal das Queuefile im Postfix extrahiert:

Code: Select all

# postcat -h -q 4RsxQB21Zjz2B > mail.txt
# postcat -b -q 4RsxQB21Zjz2B >> mail.txt
und dann das ganze gepiped, wie im .forward file des otrs Users:

Code: Select all

"|/opt/otrs/bin/otrs.Console.pl Maint::PostMaster::Read --untrusted"
also so:

Code: Select all

$ cat mail.txt |/opt/otrs/bin/otrs.Console.pl Maint::PostMaster::Read --untrusted
Der Output war dann besser lesbar:

Code: Select all

[Sun Sep 24 09:54:49 2023] otrs.Console.pl: DBD::mysql::db do failed: Incorrect string value: '\xED\xA0\xBC\xED\xBC\x9F...' for column 'a_body' at row 1 at /opt/znuny-6.5.4/Kernel/System/DB.pm line 497.
ERROR: OTRS-otrs.Console.pl-Maint::PostMaster::Read-10 Perl: 5.34.0 OS: linux Time: Sun Sep 24 09:54:49 2023

 Message: Incorrect string value: '\xED\xA0\xBC\xED\xBC\x9F...' for column 'a_body' at row 1, SQL: '
            INSERT INTO article_data_mime (
                article_id, a_from, a_reply_to, a_to, a_cc, a_bcc, a_subject, a_message_id,
                a_message_id_md5, a_in_reply_to, a_references, a_content_type, a_body,
                incoming_time, content_path, create_time, create_by, change_time, change_by)
            VALUES (
                ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, '2023-09-24 09:54:49', ?, '2023-09-24 09:54:49', ?
            )
        '

 Traceback (2270807): 
   Module: Kernel::System::Ticket::Article::Backend::MIMEBase::ArticleCreate Line: 402
   Module: Kernel::System::PostMaster::NewTicket::Run Line: 575
   Module: Kernel::System::PostMaster::Run Line: 434
   Module: (eval) Line: 123
   Module: Kernel::System::Console::Command::Maint::PostMaster::Read::Run Line: 105
   Module: (eval) Line: 461
   Module: Kernel::System::Console::BaseCommand::Execute Line: 455
   Module: Kernel::System::Console::InterfaceConsole::Run Line: 81
   Module: /opt/otrs/bin/otrs.Console.pl Line: 37

ERROR: OTRS-otrs.Console.pl-Maint::PostMaster::Read-10 Perl: 5.34.0 OS: linux Time: Sun Sep 24 09:54:49 2023

 Message: CommunicationLog(ID:3032967,AccountType:-,AccountID:-,Direction:Incoming,Transport:Email,ObjectLogType:Message,ObjectLogID:3983106)::Kernel::System::PostMaster::NewTicket => Can't process email with MessageID <<564bddd4687a1ae3f93de32cddabc0d4@www.charite.de>>! Please create a bug report with this email (From: "Charité – Universitätsmedizin Berlin" <noreply@charite.de>, Located under var/spool/problem-email*) on https://github.com/znuny/Znuny/issues/new/choose !

 Traceback (2270807): 
   Module: Kernel::System::CommunicationLog::_LogError Line: 535
   Module: Kernel::System::CommunicationLog::ObjectLog Line: 303
   Module: Kernel::System::PostMaster::NewTicket::Run Line: 586
   Module: Kernel::System::PostMaster::Run Line: 434
   Module: (eval) Line: 123
   Module: Kernel::System::Console::Command::Maint::PostMaster::Read::Run Line: 105
   Module: (eval) Line: 461
   Module: Kernel::System::Console::BaseCommand::Execute Line: 455
   Module: Kernel::System::Console::InterfaceConsole::Run Line: 81
   Module: /opt/otrs/bin/otrs.Console.pl Line: 37

ERROR: OTRS-otrs.Console.pl-Maint::PostMaster::Read-10 Perl: 5.34.0 OS: linux Time: Sun Sep 24 09:54:49 2023

 Message: Need Value!

 Traceback (2270807): 
   Module: Kernel::System::Cache::Set Line: 204
   Module: Kernel::System::Ticket::Article::Backend::MIMEBase::Base::_ArticleContentPathGet Line: 340
   Module: Kernel::System::Ticket::Article::Backend::MIMEBase::ArticleStorageFS::ArticleDeleteAttachment Line: 190
   Module: Kernel::System::Ticket::Article::Backend::MIMEBase::ArticleStorageFS::ArticleDelete Line: 103
   Module: Kernel::System::Ticket::Article::Backend::MIMEBase::ArticleDelete Line: 1029
   Module: Kernel::System::Ticket::TicketDelete Line: 780
   Module: Kernel::System::PostMaster::NewTicket::Run Line: 604
   Module: Kernel::System::PostMaster::Run Line: 434
   Module: (eval) Line: 123
   Module: Kernel::System::Console::Command::Maint::PostMaster::Read::Run Line: 105
   Module: (eval) Line: 461
   Module: Kernel::System::Console::BaseCommand::Execute Line: 455
   Module: Kernel::System::Console::InterfaceConsole::Run Line: 81
   Module: /opt/otrs/bin/otrs.Console.pl Line: 37

[Sun Sep 24 09:54:49 2023] otrs.Console.pl: Use of uninitialized value $ContentPath in concatenation (.) or string at /opt/znuny-6.5.4/Kernel/System/Ticket/Article/Backend/MIMEBase/ArticleStorageFS.pm line 191.
ERROR: OTRS-otrs.Console.pl-Maint::PostMaster::Read-10 Perl: 5.34.0 OS: linux Time: Sun Sep 24 09:54:49 2023

 Message: Need Value!

 Traceback (2270807): 
   Module: Kernel::System::Cache::Set Line: 204
   Module: Kernel::System::Ticket::Article::Backend::MIMEBase::Base::_ArticleContentPathGet Line: 340
   Module: Kernel::System::Ticket::Article::Backend::MIMEBase::ArticleStorageFS::ArticleDeletePlain Line: 144
   Module: Kernel::System::Ticket::Article::Backend::MIMEBase::ArticleStorageFS::ArticleDelete Line: 109
   Module: Kernel::System::Ticket::Article::Backend::MIMEBase::ArticleDelete Line: 1029
   Module: Kernel::System::Ticket::TicketDelete Line: 780
   Module: Kernel::System::PostMaster::NewTicket::Run Line: 604
   Module: Kernel::System::PostMaster::Run Line: 434
   Module: (eval) Line: 123
   Module: Kernel::System::Console::Command::Maint::PostMaster::Read::Run Line: 105
   Module: (eval) Line: 461
   Module: Kernel::System::Console::BaseCommand::Execute Line: 455
   Module: Kernel::System::Console::InterfaceConsole::Run Line: 81
   Module: /opt/otrs/bin/otrs.Console.pl Line: 37

[Sun Sep 24 09:54:49 2023] otrs.Console.pl: Use of uninitialized value $ContentPath in concatenation (.) or string at /opt/znuny-6.5.4/Kernel/System/Ticket/Article/Backend/MIMEBase/ArticleStorageFS.pm line 145.
ERROR: OTRS-otrs.Console.pl-Maint::PostMaster::Read-10 Perl: 5.34.0 OS: linux Time: Sun Sep 24 09:54:49 2023

 Message: Need Value!

 Traceback (2270807): 
   Module: Kernel::System::Cache::Set Line: 204
   Module: Kernel::System::Ticket::Article::Backend::MIMEBase::Base::_ArticleContentPathGet Line: 340
   Module: Kernel::System::Ticket::Article::Backend::MIMEBase::Base::_ArticleDeleteDirectory Line: 275
   Module: Kernel::System::Ticket::Article::Backend::MIMEBase::ArticleStorageFS::ArticleDelete Line: 115
   Module: Kernel::System::Ticket::Article::Backend::MIMEBase::ArticleDelete Line: 1029
   Module: Kernel::System::Ticket::TicketDelete Line: 780
   Module: Kernel::System::PostMaster::NewTicket::Run Line: 604
   Module: Kernel::System::PostMaster::Run Line: 434
   Module: (eval) Line: 123
   Module: Kernel::System::Console::Command::Maint::PostMaster::Read::Run Line: 105
   Module: (eval) Line: 461
   Module: Kernel::System::Console::BaseCommand::Execute Line: 455
   Module: Kernel::System::Console::InterfaceConsole::Run Line: 81
   Module: /opt/otrs/bin/otrs.Console.pl Line: 37

[Sun Sep 24 09:54:49 2023] otrs.Console.pl: Use of uninitialized value $ContentPath in concatenation (.) or string at /opt/znuny-6.5.4/Kernel/System/Ticket/Article/Backend/MIMEBase/Base.pm line 276.
ERROR: OTRS-otrs.Console.pl-Maint::PostMaster::Read-10 Perl: 5.34.0 OS: linux Time: Sun Sep 24 09:54:49 2023

 Message: CommunicationLog(ID:3032967,AccountType:-,AccountID:-,Direction:Incoming,Transport:Email,ObjectLogType:Message,ObjectLogID:3983106)::Kernel::System::Console::Command::Maint::PostMaster::Read => PostMaster module exited with errors, could not process email. Please refer to the log!

 Traceback (2270807): 
   Module: Kernel::System::CommunicationLog::_LogError Line: 535
   Module: Kernel::System::CommunicationLog::ObjectLog Line: 303
   Module: (eval) Line: 129
   Module: Kernel::System::Console::Command::Maint::PostMaster::Read::Run Line: 105
   Module: (eval) Line: 461
   Module: Kernel::System::Console::BaseCommand::Execute Line: 455
   Module: Kernel::System::Console::InterfaceConsole::Run Line: 81
   Module: /opt/otrs/bin/otrs.Console.pl Line: 37

ERROR: OTRS-otrs.Console.pl-Maint::PostMaster::Read-10 Perl: 5.34.0 OS: linux Time: Sun Sep 24 09:54:49 2023

 Message: CommunicationLog(ID:3032967,AccountType:-,AccountID:-,Direction:Incoming,Transport:Email,ObjectLogType:Message,ObjectLogID:3983106)::Kernel::System::Console::Command::Maint::PostMaster::Read => An unexpected error occurred, message: Could not process email. Please refer to the log!


 Traceback (2270807): 
   Module: Kernel::System::CommunicationLog::_LogError Line: 535
   Module: Kernel::System::CommunicationLog::ObjectLog Line: 303
   Module: Kernel::System::Console::Command::Maint::PostMaster::Read::Run Line: 161
   Module: (eval) Line: 461
   Module: Kernel::System::Console::BaseCommand::Execute Line: 455
   Module: Kernel::System::Console::InterfaceConsole::Run Line: 81
   Module: /opt/otrs/bin/otrs.Console.pl Line: 37

ERROR: OTRS-otrs.Console.pl-Maint::PostMaster::Read-10 Perl: 5.34.0 OS: linux Time: Sun Sep 24 09:54:50 2023

 Message: No such TicketID (470425)!

 Traceback (2270807): 
   Module: Kernel::System::Ticket::TicketGet Line: 1303
   Module: Kernel::System::Ticket::Event::NotifyOnEmptyProcessTickets::Run Line: 73
   Module: Kernel::System::EventHandler::EventHandler Line: 224
   Module: Kernel::System::EventHandler::EventHandlerTransaction Line: 264
   Module: Kernel::System::ObjectManager::ObjectEventsHandle Line: 426
   Module: Kernel::System::ObjectManager::ObjectsDiscard Line: 474
   Module: Kernel::System::ObjectManager::DESTROY Line: 643
   Module: (eval) Line: 37
   Module: /opt/otrs/bin/otrs.Console.pl Line: 37
Top
Post Reply

Return to “Hilfe”