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)
Daemon Error: OTRS@127.0.0.1 access denied
Moderator: crythias
-
- 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
To whom much is given, much is expected from.
OTRS 5.0.14 | Newbie
| Glad to meet you all
OTRS 5.0.14 | Newbie

-
- 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
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.
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
-
- 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
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
| Glad to meet you all
OTRS 5.0.14 | Newbie

-
- 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
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)
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
| Glad to meet you all
OTRS 5.0.14 | Newbie

-
- 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
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 |
+----------------------------------------------------------------------------------------------------------------------------------------+
+----------------------------------------------------------------------------------------------------------------------------------------+
| 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
| Glad to meet you all
OTRS 5.0.14 | Newbie

-
- 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
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