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

Below is the error log

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

[klausneil]

You can login to database with the user otrs, please check that the configuration of the database allow access by password or md5, example in mysql in my.cf i change the configuration in the last line a change md5 to password. Please tell me that database you used.

[mohsinkhan009]

Below is the configuration I am using

[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
max_allowed_packet = 20M
query_cache_size = 32M
innodb_log_file_size = 256M

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

also check the connection as below

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.

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.