Exception configuring gateway

[Hariharan Thiagarajan]

Hi,

I am using CentOS 10.1. I tried passing a config file to configure and also tried using the ssgconfig software to configure and got the same error both times.

Error saving configuration 'Error during node configuration 'Database connection error 'Access denied for user 'ssgdb'@'172.19.72.39' (using password: YES)'.''

I can successfully MySQL using the username and password into the remote database. But when passed to Gateway - it fails to save configuration. Is this something to do with the folder permissions or something ?

Thank you

[Jay MacDonald]

Confirm that ssgdb and 172.19.72.39 are related in a record in the mysql.user table. By default they are probably not and you will need to add them. Here is what is in my DB:


mysql> SELECT user, host FROM mysql.user;
+------------------+-------------------------+
| user | host |
+------------------+-------------------------+
| gateway | % |
| gateway | localhost |
| mysql.infoschema | localhost |
| mysql.session | localhost |
| mysql.sys | localhost |
| root | localhost |
| gateway | localhost.localdomain |
| gateway | localhost6 |
| gateway | localhost6.localdomain6 |
+------------------+-------------------------+
9 rows in set (0.00 sec)

mysql>

------------------------------
Jay MacDonald - Adoption Architect - Broadcom API Management (Layer 7)
------------------------------