Facing issue in OTRS 5
-
- Znuny newbie
- Posts: 64
- Joined: 02 Sep 2015, 08:47
- Znuny Version: OTRS-Rel-5
Facing issue in OTRS 5
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.
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.
-
- Znuny newbie
- Posts: 64
- Joined: 02 Sep 2015, 08:47
- Znuny Version: OTRS-Rel-5
Re: Facing issue in OTRS 5
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
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
-
- Moderator
- Posts: 10169
- Joined: 04 May 2010, 18:38
- Znuny Version: 5.0.x
- Location: SouthWest Florida, USA
- Contact:
Re: Facing issue in OTRS 5
make sure mysql has otrs@localhost as a valid user with this password. not just "otrs".
OTRS 6.0.x (private/testing/public) on Linux with MySQL database.
Please edit your signature to include your OTRS version, Operating System, and database type.
Click Subscribe Topic below to get notifications. Consider amending your topic title to include [SOLVED] if it is so.
Need help? Before you ask
Please edit your signature to include your OTRS version, Operating System, and database type.
Click Subscribe Topic below to get notifications. Consider amending your topic title to include [SOLVED] if it is so.
Need help? Before you ask
-
- Znuny newbie
- Posts: 64
- Joined: 02 Sep 2015, 08:47
- Znuny Version: OTRS-Rel-5
Re: Facing issue in OTRS 5
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
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
-
- Znuny newbie
- Posts: 64
- Joined: 02 Sep 2015, 08:47
- Znuny Version: OTRS-Rel-5
Re: Facing issue in OTRS 5
also have given grant all to otrs@localhost user, still error persist.
-
- Moderator
- Posts: 10169
- Joined: 04 May 2010, 18:38
- Znuny Version: 5.0.x
- Location: SouthWest Florida, USA
- Contact:
Re: Facing issue in OTRS 5
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
OTRS 6.0.x (private/testing/public) on Linux with MySQL database.
Please edit your signature to include your OTRS version, Operating System, and database type.
Click Subscribe Topic below to get notifications. Consider amending your topic title to include [SOLVED] if it is so.
Need help? Before you ask
Please edit your signature to include your OTRS version, Operating System, and database type.
Click Subscribe Topic below to get notifications. Consider amending your topic title to include [SOLVED] if it is so.
Need help? Before you ask
-
- Znuny newbie
- Posts: 64
- Joined: 02 Sep 2015, 08:47
- Znuny Version: OTRS-Rel-5
Re: Facing issue in OTRS 5
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.
-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.
-
- Moderator
- Posts: 10169
- Joined: 04 May 2010, 18:38
- Znuny Version: 5.0.x
- Location: SouthWest Florida, USA
- Contact:
Re: Facing issue in OTRS 5
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.
Basically, I can't really help you here. It's either a bug or you have multiple installations of OTRS.
OTRS 6.0.x (private/testing/public) on Linux with MySQL database.
Please edit your signature to include your OTRS version, Operating System, and database type.
Click Subscribe Topic below to get notifications. Consider amending your topic title to include [SOLVED] if it is so.
Need help? Before you ask
Please edit your signature to include your OTRS version, Operating System, and database type.
Click Subscribe Topic below to get notifications. Consider amending your topic title to include [SOLVED] if it is so.
Need help? Before you ask
-
- Znuny newbie
- Posts: 64
- Joined: 02 Sep 2015, 08:47
- Znuny Version: OTRS-Rel-5
Re: Facing issue in OTRS 5
Issue resolve after fresh reinstalling mysql and otrs software.
Thanks for help
Thanks for help