Nagios XI 5.7.2

[jbrunkow]

Can you please try rebooting that system?

If that doesn't resolve it, can you please send us a more current profile to look at? You can download the profile by navigating to System Profile under System Config on the left pane > and clicking the Download Profile button on that page.

Please also send us the output from this command.

Code: Select all

echo "SELECT table_name AS 'Table', round(((data_length + index_length) / 1024 / 1024), 2) 'Size in MB' FROM information_schema.TABLES WHERE table_schema IN ('nagios', 'nagiosql', 'nagiosxi');" | mysql -h 127.0.0.1 -uroot -pnagiosxi --table

[dbcummings]

I have PM'd you the requested info. Rebooting did not resolve the issue.

[jbrunkow]

It appears that your system is having trouble connecting to the database.

Code: Select all

[1595935960] NDO-3: Unable to connect to mysql. Check your configuration
[1595935960] NDO-3: NDO was not able to initialize the database (main context) and will not start.

What do you get if you run the following command?

Code: Select all

mysql -h 127.0.0.1 -undoutils -p'n@gweb' nagios -e "STATUS;"

Please send the output that returns.

[dbcummings]

I sent you the info in a PM. I had to change the command because we have a different password for the database. But, I have provided that password during the install and it appeared to work.

[jbrunkow]

Great! Glad to hear it.

In that case, is it alright if we close this thread and lock it for editing?

[dbcummings]

Oh, no. I said it appeared to work, but didn't. Sorry, it isn't fixed. I just wanted to let you know that we use a different password than the default.

[jbrunkow]

Did you update the password in the NDO configuration file to match?

Code: Select all

/usr/local/nagios/etc/ndo.cfg

If not, please do so and then restart the nagios service.

Code: Select all

service nagios restart

CHANGING DEFAULT PASSWORDS IN NAGIOS XI

[dbcummings]

Ok. That helps. This is new file it looks like. I will make that change and then update the ticket.

[jbrunkow]

Sounds good. Please let us know if that resolves the issue.

[dbcummings]

This all worked. You may lock this post. Thank you.