Facing issue in OTRS 5

[mohsinkhan009]

Hi all,

Facing below issue in otrs 5

[Mon Nov 16 17:18:58 2015][Error][Kernel::System::DB::Ping][1602] Access denied for user 'otrs'@'localhost' (using password: YES)

I am able to login in database with otrs user and password, the same is configure in Config.pm

any help will be appreciated.

[mohsinkhan009]

otrs.Daemon.pl: DBI connect('database=otrs;host=127.0.0.1','otrs',...) failed: Access denied for user 'otrs'@'localhost' (using password: YES) at /opt/otrs/Kernel/System/DB.pm line 190.
ERROR: OTRS-otrs.Daemon.pl - Daemon Kernel::System::Daemon::DaemonModules::SchedulerCronTaskManager-29 Perl: 5.10.1 OS: linux Time: Mon Nov 16 18:53:57 2015

Message: Access denied for user 'otrs'@'localhost' (using password: YES)

Traceback (17210):
Module: Kernel::System::DB::Ping Line: 1602
Module: Kernel::System::Daemon::DaemonModules::SchedulerCronTaskManager::PreRun Line: 94
Module: (eval) Line: 316
Module: main::Start Line: 316
Module: /opt/otrs//bin/otrs.Daemon.pl Line: 138

[crythias]

make sure mysql has otrs@localhost as a valid user with this password. not just "otrs".

[mohsinkhan009]

crythias below is my user table of mysql database where i have created the user otrs@localhost with the same password of otrs user, but still facing the same issue


mysql> select user,host, password from user
-> ;
+----------------+-----------+-------------------------------------------+
| user | host | password |
+----------------+-----------+-------------------------------------------+
| root | cvm-882 | *FAAFFE644E901CFAFAEC7562415E5FAEC243B8B2 |
| root | 127.0.0.1 | *FAAFFE644E901CFAFAEC7562415E5FAEC243B8B2 |
| mohsin | localhost | *EEF5833FC7EB669628159EDFC10A2DE354F2F512 |
| otrs@localhost | localhost | *261704C98034E8C5F2F60EDB02B792FA12286ECE |
| otrs | localhost | *261704C98034E8C5F2F60EDB02B792FA12286ECE |
| otrs | 127.0.0.1 | *261704C98034E8C5F2F60EDB02B792FA12286ECE |
| root | localhost | *FAAFFE644E901CFAFAEC7562415E5FAEC243B8B2 |
+----------------+-----------+-------------------------------------------+

can you please help out as issue still persist

[mohsinkhan009]

also have given grant all to otrs@localhost user, still error persist.

[crythias]

There's something I don't know what to ask but it's not here.

Code: Select all

bin/otrs.Console.pl Maint::Database::Check

[mohsinkhan009]

Below is the output of database connection:-

-bash-4.1$ perl /opt/otrs/bin/otrs.Console.pl Maint::Database::Check
Trying to connect to database 'DBI:mysql:database=otrs;host=localhost' with user 'otrs'...
Connection successful.

[crythias]

Please don't open multiple threads on the same issue.

Basically, I can't really help you here. It's either a bug or you have multiple installations of OTRS.

[mohsinkhan009]

Issue resolve after fresh reinstalling mysql and otrs software.

Thanks for help