Page 2 of 3

Re: Nagios XI 5.7.2

Posted: Mon Jul 27, 2020 4:34 pm
by 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

Re: Nagios XI 5.7.2

Posted: Tue Jul 28, 2020 6:47 am
by dbcummings
I have PM'd you the requested info. Rebooting did not resolve the issue.

Re: Nagios XI 5.7.2

Posted: Tue Jul 28, 2020 3:37 pm
by 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.

Re: Nagios XI 5.7.2

Posted: Wed Jul 29, 2020 6:56 am
by 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.

Re: Nagios XI 5.7.2

Posted: Wed Jul 29, 2020 10:51 am
by jbrunkow
Great! :D Glad to hear it.

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

Re: Nagios XI 5.7.2

Posted: Wed Jul 29, 2020 12:56 pm
by 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.

Re: Nagios XI 5.7.2

Posted: Thu Jul 30, 2020 11:17 am
by 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

Re: Nagios XI 5.7.2

Posted: Thu Jul 30, 2020 11:38 am
by dbcummings
Ok. That helps. This is new file it looks like. I will make that change and then update the ticket.

Re: Nagios XI 5.7.2

Posted: Thu Jul 30, 2020 4:13 pm
by jbrunkow
Sounds good. Please let us know if that resolves the issue.

Re: Nagios XI 5.7.2

Posted: Mon Aug 24, 2020 8:53 am
by dbcummings
This all worked. You may lock this post. Thank you. :)