Nagios XI with external database configuration wizards

[gfreestone]

I have followed the documentation found at
https://assets.nagios.com/downloads/nag ... Server.pdf
to move our database to a separate server. The move went well. However, now we can only making changes through the core config manager. If we try and add a new check via a configuration wizard, the config claims to be applied correctly but changes are not written to the database and the new host fails to show up.

[abrist]

You probably missed a step. Verify that your db users,passwords, and ips/hostnames are correct in /usr/local/nagiosxi/html/config.inc.php.

[gfreestone]

Using copy and paste from the config.inc.php file I am able to connect to the database server just fine.

$ mysql -u app#nagios -h XXXXXXXXXXXX -p'XXXXXXXXXXX' nagios
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MySQL connection id is 45849
Server version: 5.6.24-enterprise-commercial-advanced-log MySQL Enterprise Server - Advanced Edition (Commercial)

Copyright (c) 2000, 2014, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.


and


$ mysql -u app#nagiosql -h XXXXXXXXXXX -p'XXXXXXXXXXX' nagiosql
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MySQL connection id is 45904
Server version: 5.6.24-enterprise-commercial-advanced-log MySQL Enterprise Server - Advanced Edition (Commercial)

Copyright (c) 2000, 2014, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MySQL [nagiosql]>

[abrist]

Are you current client?
If so, send an email to [email protected] with your profile.zip (admin --> system profile --> download) attached.
I will take the ticket, look over your profile, and may move to to a remote session sometime tomorrow.

[gfreestone]

We are in the process of purchasing. I sent the email but it was rejected.

[lmiltchev]

If you are not in our system, your email to [email protected] will bounce back.

Send your email to [email protected]. They will forward it to us.