RemoteDB Error

[Brad Waller]

I am building a new PWM box with 2.0 on Ubuntu 20.0.4. Im at a wall trying to use a remote database, getting the following error:

Database Unavailable. If this error occurs repeatedly please contact your help desk. { 5051 ERROR_DB_UNAVAILABLE (database connection is not open) }

When I connect to the DB from the command line of the pwm server, with the same credentials, I can connect. Any ideas? When I tell it to use the LocalDB, it says that LocalDB should only be used for testing.

[jason.e...@gmail.com]

What is your db server listening on address? Localhost, ip address ? How are you entering this in PWM?

[Brad Waller]

in the RemoteDB connection settings I have it listed with it's DNS name, the string looks like this:

https://remote-db-fqdn.com:3306/pwm:

When I hit Test Connection, the box is blank:

[jason.e...@gmail.com]

Is MySQL listening on localhost only? Does the user name for database have any hostname restriction set?

[Brad Waller]

Those are good questions, how would I check that?

[Jason Rivard]

Also, check the logs during the test.....

[Brad Waller]

Which logs should I be checking? When I look at catalina-date.log i don't see any errors relating to mysql. I have attached that log.

[Jason Rivard]

Nope, not that one, the PWM logs in [applicationPath]/logs.

[Brad Waller]

that helped. I have found where it was erroring, turns out it didn't like the password I was using. Health has all green now. Thanks!