This support forum board is for support questions relating to
Nagios XI , our flagship commercial network monitoring solution.
scottwilkerson
DevOps Engineer
Posts: 19396 Joined: Tue Nov 15, 2011 3:11 pm
Location: Nagios Enterprises
Contact:
Post
by scottwilkerson » Wed Jun 10, 2020 9:07 am
Can you show the output of the following:
Code: Select all
echo "describe nagios_hoststatus;" |mysql -pnagiosxi nagios |grep check_options
echo "describe nagios_servicestatus;" |mysql -pnagiosxi nagios |grep check_options
I believe it is possible the DB migration wasn't successful
JohnWillette
Posts: 16 Joined: Mon Jun 18, 2018 1:59 pm
Post
by JohnWillette » Wed Jun 10, 2020 10:00 am
Should I open a support ticket for this issue?
JohnWillette
Posts: 16 Joined: Mon Jun 18, 2018 1:59 pm
Post
by JohnWillette » Wed Jun 10, 2020 10:14 am
Submitted both echo commands and each just returned a prompt, no other messages.
scottwilkerson
DevOps Engineer
Posts: 19396 Joined: Tue Nov 15, 2011 3:11 pm
Location: Nagios Enterprises
Contact:
Post
by scottwilkerson » Wed Jun 10, 2020 10:27 am
JohnWillette wrote: Submitted both echo commands and each just returned a prompt, no other messages.
I believe we found the issue, let's run the following 2 commands:
Code: Select all
echo "ALTER TABLE nagios_hoststatus ADD check_options smallint(6) NOT NULL default '0' AFTER check_type;"|mysql -pnagiosxi nagios
echo "ALTER TABLE nagios_servicestatus ADD check_options smallint(6) NOT NULL default '0' AFTER check_type;"|mysql -pnagiosxi nagios
Then restart the nagios service
JohnWillette
Posts: 16 Joined: Mon Jun 18, 2018 1:59 pm
Post
by JohnWillette » Wed Jun 10, 2020 11:05 am
That worked and hosts and services are now reporting in expected status.
Is this something that needs to be corrected in the upgrade package?
I cannot apply the upgrade to my production XI environment and have this cause all kinds of problems.
I am also still receiving this message on logon -
Nagios XI seems to be running on a different IP address than the one in the Program URL field
scottwilkerson
DevOps Engineer
Posts: 19396 Joined: Tue Nov 15, 2011 3:11 pm
Location: Nagios Enterprises
Contact:
Post
by scottwilkerson » Wed Jun 10, 2020 11:11 am
JohnWillette wrote: That worked and hosts and services are now reporting in expected status.
Is this something that needs to be corrected in the upgrade package?
I cannot apply the upgrade to my production XI environment and have this cause all kinds of problems.
I am also still receiving this message on logon -
Nagios XI seems to be running on a different IP address than the one in the Program URL field
Yes, fixes for both of these are being added for 5.7.1 due out later this week or early next.
JohnWillette
Posts: 16 Joined: Mon Jun 18, 2018 1:59 pm
Post
by JohnWillette » Wed Jun 10, 2020 11:25 am
This message occurred from localhost -
Service status for ndo2db - Second parameter must be one of: postgresql httpd mysqld nagios npcd snmptt ntpd crond shellinaboxd snmptrapd
JohnWillette
Posts: 16 Joined: Mon Jun 18, 2018 1:59 pm
Post
by JohnWillette » Wed Jun 10, 2020 11:26 am
Looks like the message occurred when the upgrade was installed, but a force immediate check reports the same result
scottwilkerson
DevOps Engineer
Posts: 19396 Joined: Tue Nov 15, 2011 3:11 pm
Location: Nagios Enterprises
Contact:
Post
by scottwilkerson » Wed Jun 10, 2020 11:39 am
JohnWillette wrote: This message occurred from localhost -
Service status for ndo2db - Second parameter must be one of: postgresql httpd mysqld nagios npcd snmptt ntpd crond shellinaboxd snmptrapd
Because NDO3 replaces NDO2DB and the service/daemon for it no longer exists, the check is no longer necessary. You can remove the check from your system. ...
in 5.7.1 we are going to change the plugin to remain OK but give a deprecated message ...
JohnWillette
Posts: 16 Joined: Mon Jun 18, 2018 1:59 pm
Post
by JohnWillette » Wed Jun 10, 2020 12:06 pm
The localhost services are created when the application is initially installed.
Can the service monitoring for ndo2db be changed to monitor ndo3, or is that even necessary anymore?