Installing: Host 'serverotrs.mydomain' is not allowed to connect to this MariaDB server

Moderator: crythias

Post Reply
vilhs
Znuny newbie
Posts: 5
Joined: 15 Jan 2019, 12:56
Znuny Version: 6 patch level 15
Company: SGPCM

Installing: Host 'serverotrs.mydomain' is not allowed to connect to this MariaDB server

Post by vilhs »

Hello.

I'm currently trying to configure OTRS, and I'm bumping into this error in the step2 of installer.pl:
Can't connect to database, read comment!
Host 10.100.30.2 is not allowed to connect to this MariaDB server



Already gave permissions to the root user to connect itself to the DB:
Grants for root@10.100.30.2 |
+---------------------------------------------------------------------------------------------------------------------------------------------+
| GRANT ALL PRIVILEGES ON *.* TO 'root'@'10.100.30.2' IDENTIFIED BY PASSWORD '*72F294A362AC9B9C3FA02F4B1E513F41A3AB414E' WITH GRANT OPTION |


Tried to connect through remotly and it works as well:
myuser@10.100.30.2 ~$ mysql -u root -h 'serverotrs.mydomain -p
Enter password:
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 98
Server version: 5.5.60-MariaDB MariaDB Serve
r


I can't find nothing in the logs and I really can't understand why I can't connect :(

Can anyone help me?

Thanks a lot
skullz
Znuny superhero
Posts: 618
Joined: 24 Feb 2012, 03:58
Znuny Version: LTS and Features
Real Name: Mo Azfar
Location: Kuala Lumpur, MY
Contact:

Re: Installing: Host 'serverotrs.mydomain' is not allowed to connect to this MariaDB server

Post by skullz »

The app and db in same server ? if yes, try to use 127.0.0.1 or localhost

If not, perhaps, root login is disabled for remote.
Do create empty otrs db with user/password, then choose use existing db instead

good luck
Post Reply