subject:"\[otrs\] OTRS Scheduler Daemon Cron\: MailAccountFetch"

[otrs] OTRS Scheduler Daemon Cron: MailAccountFetch

2018-03-07 Thread Santiago DIEZ

Hi,

I often receive the following warning (see bellow). Most of the time,
the message is spam so I don't care. But sometime it's a rightful
message and even for the sake of it, I'd like to fix the issue.

Apparently, I need to edit the database structure (collation) but I've
been instructed to never do so. What can I do to receive those
messages?


# BEGINNING OF WARNING #

[Wed Mar  7 17:48:04 2018] otrs.Daemon.pl: DBD::mysql::st execute
failed: Illegal mix of
collations (latin1_swedish_ci,IMPLICIT) and
(utf8_general_ci,COERCIBLE) for operation '='
at /rw/opt/otrs-5.0.20/Kernel/System/DB.pm line 679.
ERROR: OTRS-otrs.Console.pl-Maint::PostMaster::MailAccountFetch-59
Perl: 5.20.2 OS: linux
Time: Wed Mar  7 17:48:04 2018

Message: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and
(utf8_general_ci,COERCIBLE) for operation '=', SQL: 'SELECT id FROM
article WHERE
ticket_id = ? AND a_message_id = ? AND a_from = ? AND a_subject = ?
AND  incoming_time = ?
ORDER BY id DESC LIMIT 1'

Traceback (17337):
   Module: Kernel::System::Ticket::Article::_ArticleGetId Line: 2025
   Module: Kernel::System::Ticket::Article::ArticleCreate Line: 310
   Module: Kernel::System::PostMaster::NewTicket::Run Line: 455
   Module: Kernel::System::PostMaster::Run Line: 413
   Module: Kernel::System::MailAccount::IMAP::_Fetch Line: 220
   Module: Kernel::System::MailAccount::IMAP::Fetch Line: 86
   Module: Kernel::System::MailAccount::MailAccountFetch Line: 440
   Module: 
Kernel::System::Console::Command::Maint::PostMaster::MailAccountFetch::Run
Line: 94
   Module: (eval) Line: 460
   Module: Kernel::System::Console::BaseCommand::Execute Line: 454
   Module: (eval) Line: 150
   Module: Kernel::System::Daemon::DaemonModules::SchedulerTaskWorker::Cron::Run
Line: 129
   Module: Kernel::System::Daemon::DaemonModules::SchedulerTaskWorker::Run
Line: 250
   Module: (eval) Line: 316
   Module: main::Start Line: 316
   Module: /opt/otrs/bin/otrs.Daemon.pl Line: 138

ERROR: OTRS-otrs.Console.pl-Maint::PostMaster::MailAccountFetch-59
Perl: 5.20.2 OS: linux
Time: Wed Mar  7 17:48:04 2018

Message: Can't get ArticleID from insert (TicketID=18304,
MessageID=<20180307164731.A4F33249B5@tc3-app-mailmaster18>)!

Traceback (17337):
   Module: Kernel::System::Ticket::Article::ArticleCreate Line: 320
   Module: Kernel::System::PostMaster::NewTicket::Run Line: 455
   Module: Kernel::System::PostMaster::Run Line: 413
   Module: Kernel::System::MailAccount::IMAP::_Fetch Line: 220
   Module: Kernel::System::MailAccount::IMAP::Fetch Line: 86
   Module: Kernel::System::MailAccount::MailAccountFetch Line: 440
   Module: 
Kernel::System::Console::Command::Maint::PostMaster::MailAccountFetch::Run
Line: 94
   Module: (eval) Line: 460
   Module: Kernel::System::Console::BaseCommand::Execute Line: 454
   Module: (eval) Line: 150
   Module: Kernel::System::Daemon::DaemonModules::SchedulerTaskWorker::Cron::Run
Line: 129
   Module: Kernel::System::Daemon::DaemonModules::SchedulerTaskWorker::Run
Line: 250
   Module: (eval) Line: 316
   Module: main::Start Line: 316
   Module: /opt/otrs/bin/otrs.Daemon.pl Line: 138

ERROR: OTRS-otrs.Console.pl-Maint::PostMaster::MailAccountFetch-59
Perl: 5.20.2 OS: linux
Time: Wed Mar  7 17:48:04 2018

Message: Can't process email with MessageID
<<20180307164731.A4F33249B5@tc3-app-mailmaster18>>! Please create a
bug report with this
email (From: "Bax Music" , Located under
var/spool/problem-email*)
on http://bugs.otrs.org/!

Traceback (17337):
   Module: Kernel::System::PostMaster::NewTicket::Run Line: 483
   Module: Kernel::System::PostMaster::Run Line: 413
   Module: Kernel::System::MailAccount::IMAP::_Fetch Line: 220
   Module: Kernel::System::MailAccount::IMAP::Fetch Line: 86
   Module: Kernel::System::MailAccount::MailAccountFetch Line: 440
   Module: 
Kernel::System::Console::Command::Maint::PostMaster::MailAccountFetch::Run
Line: 94
   Module: (eval) Line: 460
   Module: Kernel::System::Console::BaseCommand::Execute Line: 454
   Module: (eval) Line: 150
   Module: Kernel::System::Daemon::DaemonModules::SchedulerTaskWorker::Cron::Run
Line: 129
   Module: Kernel::System::Daemon::DaemonModules::SchedulerTaskWorker::Run
Line: 250
   Module: (eval) Line: 316
   Module: main::Start Line: 316
   Module: /opt/otrs/bin/otrs.Daemon.pl Line: 138

ERROR: OTRS-otrs.Console.pl-Maint::PostMaster::MailAccountFetch-59
Perl: 5.20.2 OS: linux
Time: Wed Mar  7 17:48:04 2018

Message: IMAPS: Can't process mail, see log sub system
(/opt/otrs/var/spool/problem-email-4eae41ac6feef7212164fe0a9afe02be,
report it on
http://bugs.otrs.org/)!

Traceback (17337):
   Module: Kernel::System::MailAccount::IMAP::_Fetch Line: 224
   Module: Kernel::System::MailAccount::IMAP::Fetch Line: 86
   Module: Kernel::System::MailAccount::MailAccountFetch Line: 440
   Module: 
Kernel::System::Console::Command::Maint::PostMaster::MailAccountFetch::Run
Line: 94
   Module: (eval) Line: 460
   Module: Kernel::System::Console::BaseCommand::Execute Line: 454
   M

[otrs] OTRS Scheduler Daemon Cron: MailAccountFetch

2017-02-18 Thread Placide Lysias NJAMI

OTRS 5.0.16  has been installed.



The file  Kernel/System/MailAccount/POP3S.pm is patched as per below link.



Check the patch below

https://github.com/OTRS/otrs/commit/8cb87ff9ef9789606a38e3d70599e38a1f8e9246





But still, we received every 10 min below message :



[Sat Feb 18 14:20:02 2017] otrs.Daemon.pl: using SSL support of Net::POP3 3.05 
instead of SSLGlue at /opt/otrs/Kernel/cpan-lib/Net/SSLGlue/POP3.pm line 12.



Best Regards / Cordialement
-

Placide Lysias NJAMI | IT MANAGER
GOLDEN EXOTICS LTD – GHANA
P.O. Box K.I.A. 16105 - ACCRA
Email: p.nj...@gelgh.com



-Message d'origine-
De : Helpdesk GEL [mailto:helpd...@gelgh.com]
Envoyé : samedi 18 février 2017 14h 20
À : ad...@gelgh.com
Objet : OTRS Scheduler Daemon Cron: MailAccountFetch



[Sat Feb 18 14:20:02 2017] otrs.Daemon.pl: using SSL support of Net::POP3 3.05 
instead of SSLGlue at /opt/otrs/Kernel/cpan-lib/Net/SSLGlue/POP3.pm line 12.
-
OTRS mailing list: otrs - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/otrs
To unsubscribe: http://lists.otrs.org/mailman/listinfo/otrs

[otrs] OTRS Scheduler Daemon Cron: MailAccountFetch

[otrs] OTRS Scheduler Daemon Cron: MailAccountFetch

2 matches

Site Navigation

Mail list logo

Footer information