I'm having a very strange issue, I restored a backup on a different OTRS environment, where the difference between the two is that where the backup was taken, the database is external and is accessed through the hostname mariadb that has been added to /etc/hosts. Where I'm restoring the backup, the database server runs on the same machine as the OTRS install. Config.pm has been updated to point the database server to localhost, and everything seems to be working fine, BUT I have millions of log files in less than 24 hours with this error:
Code: Select all
Daemon]# more SchedulerFutureTaskManagerERR.log
[Thu Jul 27 06:08:12 2017] otrs.Daemon.pl: DBI connect('database=otrs;host=maria
db','otrs',...) failed: Unknown MySQL server host 'mariadb' (0) at /opt/otrs/Ker
nel/System/DB.pm line 202.
ERROR: OTRS-otrs.Daemon.pl - Daemon Kernel::System::Daemon::DaemonModules::Sched
ulerFutureTaskManager-100 Perl: 5.16.3 OS: linux Time: Thu Jul 27 06:08:12 2017
Message: Unknown MySQL server host 'mariadb' (0)
Traceback (22698):
Module: Kernel::System::DB::Ping Line: 1623
Module: Kernel::System::Daemon::DaemonModules::SchedulerFutureTaskManager::Pr
eRun Line: 97
Module: (eval) Line: 316
Module: main::Start Line: 316
Module: /opt/otrs/bin/otrs.Daemon.pl Line: 138
Code: Select all
# more /opt/otrs/Kernel/Config.pm|grep DatabaseHost
$Self->{'DatabaseHost'} = 'localhost';
Code: Select all
# su -c "bin/otrs.Console.pl Maint::Database::Check" -s /bin/bash
Trying to connect to database 'DBI:mysql:database=otrs;host=localhost' with user 'otrs'...
Connection successful.
This is on an OTRS 5.0.18 install. Any ideas ??