NagiosXI 5.7.0 Issues

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:

Re: NagiosXI 5.7.0 Issues

Post by scottwilkerson »

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
Former Nagios employee
Creator:
Human Design Website
Get Your Human Design Chart
JohnWillette
Posts: 16
Joined: Mon Jun 18, 2018 1:59 pm

Re: NagiosXI 5.7.0 Issues

Post by JohnWillette »

Should I open a support ticket for this issue?
JohnWillette
Posts: 16
Joined: Mon Jun 18, 2018 1:59 pm

Re: NagiosXI 5.7.0 Issues

Post by JohnWillette »

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:

Re: NagiosXI 5.7.0 Issues

Post by scottwilkerson »

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
Former Nagios employee
Creator:
Human Design Website
Get Your Human Design Chart
JohnWillette
Posts: 16
Joined: Mon Jun 18, 2018 1:59 pm

Re: NagiosXI 5.7.0 Issues

Post by JohnWillette »

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:

Re: NagiosXI 5.7.0 Issues

Post by scottwilkerson »

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.
Former Nagios employee
Creator:
Human Design Website
Get Your Human Design Chart
JohnWillette
Posts: 16
Joined: Mon Jun 18, 2018 1:59 pm

Re: NagiosXI 5.7.0 Issues

Post by JohnWillette »

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

Re: NagiosXI 5.7.0 Issues

Post by JohnWillette »

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:

Re: NagiosXI 5.7.0 Issues

Post by scottwilkerson »

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 ...
Former Nagios employee
Creator:
Human Design Website
Get Your Human Design Chart
JohnWillette
Posts: 16
Joined: Mon Jun 18, 2018 1:59 pm

Re: NagiosXI 5.7.0 Issues

Post by JohnWillette »

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?
Locked