Mail fetching problem (after upgrade to 5.0.16)

[jlima]

Hi
after upgrading to 5.0.16 otrs is failing to automatically fetch email.

Although I get password errors in the logs, it fetches ok if I do it manually.

It seems that otrs is using a password defined elsewhere when using the Daemon.
Any ideas on where could be my misconfiguration?

In /var/log/syslog I have lots of these errors:

Code: Select all

Feb 27 10:32:52 ubuntu OTRS-otrs.Daemon.pl - Daemon Kernel::System::Daemon::DaemonModules::SchedulerCronTaskManager-45[53879]: [Error][Kernel::System::DB::Ping][Line:1623]: FATAL:  password authentication failed for user "otrs"#012FATAL:  password authentication failed for user "otrs"
Feb 27 10:32:52 ubuntu OTRS-otrs.Daemon.pl - Daemon Kernel::System::Daemon::DaemonModules::SchedulerTaskWorker-45[53878]: [Error][Kernel::System::DB::Ping][Line:1623]: FATAL:  password authentication failed for user "otrs"#012FATAL:  password authentication failed for user "otrs"
Feb 27 10:32:53 ubuntu OTRS-otrs.Daemon.pl - Daemon Kernel::System::Daemon::DaemonModules::SchedulerFutureTaskManager-45[53880]: [Error][Kernel::System::DB::Ping][Line:1623]: FATAL:  password authentication failed for user "otrs"#012FATAL:  password authentication failed for user "otrs"
Feb 27 10:32:59 ubuntu OTRS-otrs.Daemon.pl - Daemon Kernel::System::Daemon::DaemonModules::SchedulerGenericAgentTaskManager-45[53889]: [Error][Kernel::System::DB::Ping][Line:1623]: FATAL:  password authentication failed for user "otrs"#012FATAL:  password authentication failed for user "otrs"

and in /opt/otrs/var/log/Daemon/SchedulerTaskWorkerERR.log (same for the other log files in this dir):

Code: Select all

[Mon Feb 27 10:43:12 2017] otrs.Daemon.pl: DBI connect('dbname=otrs;host=upg02;','otrs',...) failed: FATAL:  password authentication failed for user "otrs"
[Mon Feb 27 10:43:12 2017] otrs.Daemon.pl: FATAL:  password authentication failed for user "otrs" at /opt/otrs/Kernel/System/DB.pm line 206.
ERROR: OTRS-otrs.Daemon.pl - Daemon Kernel::System::Daemon::DaemonModules::SchedulerTaskWorker-45 Perl: 5.22.1 OS: linux Time: Mon Feb 27 10:43:12 2017

 Message: FATAL:  password authentication failed for user "otrs"
FATAL:  password authentication failed for user "otrs"

 Traceback (54539):
   Module: Kernel::System::DB::Ping Line: 1623
   Module: Kernel::System::Daemon::DaemonModules::SchedulerTaskWorker::PreRun Line: 125
   Module: (eval) Line: 316
   Module: main::Start Line: 316
   Module: /opt/otrs/bin/otrs.Daemon.pl Line: 138

[root]

Looks like the database password does not match. What the result of

Code: Select all

otrs.Console.de Maint::Database::Check

[jlima]

I guess you meant Console.pl

Code: Select all

otrs@ubuntu:~$ bin/otrs.Console.pl Maint::Database::Check
Trying to connect to database 'DBI:Pg:dbname=otrs;host=upg02;' with user 'otrs'...
Connection successful.

[root]

Under which user does the otrs.Daemon.pl run?

[jlima]

otrs.
Is it normal to have these many?

Code: Select all

otrs@ubuntu:~$ ps -ef |grep Daemon
otrs       5183      1  0 Feb17 ?        00:08:16 /usr/bin/perl -X /opt/otrs/bin/otrs.Daemon.pl start
otrs      69445   5183 14 14:15 ?        00:00:01 /usr/bin/perl -X /opt/otrs/bin/otrs.Daemon.pl start
otrs      69449   5183 21 14:15 ?        00:00:01 /usr/bin/perl -X /opt/otrs/bin/otrs.Daemon.pl start
otrs      69450   5183 22 14:15 ?        00:00:01 /usr/bin/perl -X /opt/otrs/bin/otrs.Daemon.pl start
otrs      69457   5183 41 14:15 ?        00:00:01 /usr/bin/perl -X /opt/otrs/bin/otrs.Daemon.pl start
otrs      69461  63471  0 14:15 pts/3    00:00:00 grep Daemon