Daemon Error: OTRS@127.0.0.1 access denied

Moderator: crythias

Locked
JojoModjo
Znuny newbie
Posts: 38
Joined: 17 Mar 2016, 12:29
Znuny Version: 5.0.14
Real Name: Joseph Munyao
Company: Diamond Trust

Daemon Error: OTRS@127.0.0.1 access denied

Post by JojoModjo »

Hi Guys,

I keep getting the following error on my logs, what could be wrong?

Thu Nov 17 17:20:03 2016 error OTRS-otrs.Daemon.pl - Daemon Kernel::System::Daemon::DaemonModules::SchedulerFutureTaskManager-36 Access denied for user 'otrs'@'127.0.0.1' (using password: YES)
Thu Nov 17 17:20:03 2016 error OTRS-otrs.Daemon.pl - Daemon Kernel::System::Daemon::DaemonModules::SchedulerTaskWorker-36 Access denied for user 'otrs'@'127.0.0.1' (using password: YES)
Thu Nov 17 17:20:01 2016 error OTRS-otrs.Daemon.pl - Daemon Kernel::System::Daemon::DaemonModules::SchedulerGenericAgentTaskManager-36 Access denied for user 'otrs'@'127.0.0.1' (using password: YES)
To whom much is given, much is expected from.

OTRS 5.0.14 | Newbie :D | Glad to meet you all
RStraub
Znuny guru
Posts: 2210
Joined: 13 Mar 2014, 09:16
Znuny Version: 6.0.14
Real Name: Rolf Straub

Re: Daemon Error: OTRS@127.0.0.1 access denied

Post by RStraub »

Thats a MySQL error message. And it means very much what it reads.

The user 'otrs' accessing the DB from '127.0.0.1' has no access rights.
Currently using: OTRS 6.0.14 -- MariaDB -- Ubuntu 16 LTS
JojoModjo
Znuny newbie
Posts: 38
Joined: 17 Mar 2016, 12:29
Znuny Version: 5.0.14
Real Name: Joseph Munyao
Company: Diamond Trust

Re: Daemon Error: OTRS@127.0.0.1 access denied

Post by JojoModjo »

RStraub wrote:Thats a MySQL error message. And it means very much what it reads.

The user 'otrs' accessing the DB from '127.0.0.1' has no access rights.

How can i grant rights to the user?
I am using mariadb.
To whom much is given, much is expected from.

OTRS 5.0.14 | Newbie :D | Glad to meet you all
JojoModjo
Znuny newbie
Posts: 38
Joined: 17 Mar 2016, 12:29
Znuny Version: 5.0.14
Real Name: Joseph Munyao
Company: Diamond Trust

Re: Daemon Error: OTRS@127.0.0.1 access denied

Post by JojoModjo »

Guys kindly tell me where is it am i going wrong, below are the rights for the otrs user

show grants for 'otrs';
+------------------------------------------------------------------+
| Grants for otrs@% |
+------------------------------------------------------------------+
| GRANT ALL PRIVILEGES ON *.* TO 'otrs'@'%' WITH GRANT OPTION |
| GRANT ALL PRIVILEGES ON `otrs`.* TO 'otrs'@'%' WITH GRANT OPTION |
+------------------------------------------------------------------+
2 rows in set (0.00 sec)
To whom much is given, much is expected from.

OTRS 5.0.14 | Newbie :D | Glad to meet you all
JojoModjo
Znuny newbie
Posts: 38
Joined: 17 Mar 2016, 12:29
Znuny Version: 5.0.14
Real Name: Joseph Munyao
Company: Diamond Trust

Re: Daemon Error: OTRS@127.0.0.1 access denied

Post by JojoModjo »

show grants for 'otrs'@'127.0.0.1';
+----------------------------------------------------------------------------------------------------------------------------------------+
| Grants for otrs@127.0.0.1 |
+----------------------------------------------------------------------------------------------------------------------------------------+
| GRANT ALL PRIVILEGES ON *.* TO 'otrs'@'127.0.0.1' IDENTIFIED BY PASSWORD '*65FBB471E77A969DDE39A60B7D81B7E279A40F1C' WITH GRANT OPTION |
| GRANT ALL PRIVILEGES ON `otrs`.* TO 'otrs'@'127.0.0.1' WITH GRANT OPTION |
+----------------------------------------------------------------------------------------------------------------------------------------+
To whom much is given, much is expected from.

OTRS 5.0.14 | Newbie :D | Glad to meet you all
RStraub
Znuny guru
Posts: 2210
Joined: 13 Mar 2014, 09:16
Znuny Version: 6.0.14
Real Name: Rolf Straub

Re: Daemon Error: OTRS@127.0.0.1 access denied

Post by RStraub »

That's weird then. Could you check the mysql "bind"-address in the config? Somewhere /etc/mysql/...
Currently using: OTRS 6.0.14 -- MariaDB -- Ubuntu 16 LTS
Locked