After upgrade to 5.4.0.2 Database Backend error

This support forum board is for support questions relating to Nagios XI, our flagship commercial network monitoring solution.
Locked
mvndnburg
Posts: 64
Joined: Wed Sep 21, 2016 2:53 am

After upgrade to 5.4.0.2 Database Backend error

Post by mvndnburg »

I just upgraded from 5.3.3 to 5.4.0.2 on RHEL 6.8, using the package for standalone installation.

There were no errors during the installation, but afterwards the 'Database Backend' item in XI System Component Status in the GUI displayed the red error.

I checked the forum and found this post.

Commenting out the following code in /usr/local/nagiosxi/cron/sysstat.php solved the issue.

Code: Select all

#        # Check if we are on a systemctl or not and if we are checking ndo2db
#        if (file_exists('/usr/lib/systemd')) {
#            if ($darr["daemon"] == 'ndo2db') {
#                $cmdline = sprintf("systemctl status %s", $darr["daemon"]);
#            }
#        }
- was this error reintroduced in 5.4.0.2, or specifically in the standalone installation?
- what harm does it to remove this part from sysstat.php ?

For information, the md5sum of our sysstat.php is b6f16324d4dfd0a7156f3cf31db798b2.
--
Martijn
User avatar
BanditBBS
Posts: 2474
Joined: Tue May 31, 2011 12:57 pm
Location: Scio, OH
Contact:

Re: After upgrade to 5.4.0.2 Database Backend error

Post by BanditBBS »

5.4.1 Changelog has this fix in it:

Code: Select all

- Fixed issue where some systems would show ndo2db as not running in the GUI even though the daemon is running [TPS#10636] -JO
2 of XI5.6.14 Prod/DR/DEV - Nagios LogServer 2 Nodes
See my projects on the Exchange at BanditBBS - Also check out my Nagios stuff on my personal page at Bandit's Home and at github
mvndnburg
Posts: 64
Joined: Wed Sep 21, 2016 2:53 am

Re: After upgrade to 5.4.0.2 Database Backend error

Post by mvndnburg »

The systemctl line is not present in 5.3.3 (I checked this in the sysstat.php in our PRD environment, which has not yet been updated) but it is present in the code that I deployed with the standalone installation package.

Despite the developer component, it seems that it did make it into our version of 5.4.0.2...
--
Martijn
User avatar
BanditBBS
Posts: 2474
Joined: Tue May 31, 2011 12:57 pm
Location: Scio, OH
Contact:

Re: After upgrade to 5.4.0.2 Database Backend error

Post by BanditBBS »

mvndnburg wrote:The systemctl line is not present in 5.3.3 (I checked this in the sysstat.php in our PRD environment, which has not yet been updated) but it is present in the code that I deployed with the standalone installation package.

Despite the developer component, it seems that it did make it into our version of 5.4.0.2...
Not sure what version you are running, there is no 5.4.0.2. The versions are 5.4.0 and 5.4.1. If you are running 5.4.0 the fix is in the next release. You can see the versions and changelogs here: https://assets.nagios.com/downloads/nag ... NGES-5.TXT
2 of XI5.6.14 Prod/DR/DEV - Nagios LogServer 2 Nodes
See my projects on the Exchange at BanditBBS - Also check out my Nagios stuff on my personal page at Bandit's Home and at github
rkennedy
Posts: 6579
Joined: Mon Oct 05, 2015 11:45 am

Re: After upgrade to 5.4.0.2 Database Backend error

Post by rkennedy »

Thanks @BanditBBS!

@mvndnburg - Bandit is correct, this was fixed in the latest version, 5.4.1. Let us know if you have further questions.
Former Nagios Employee
mvndnburg
Posts: 64
Joined: Wed Sep 21, 2016 2:53 am

Re: After upgrade to 5.4.0.2 Database Backend error

Post by mvndnburg »

I installed the nagiosxi-5-4.0.2.el6.x86_64.tar.gz from https://repo.nagios.com. Hence my quoting it as 5.4.0.2.

The System Info says Nagios XI Version : 5.4.0.

We can update when a new Offline install becomes available.
--
Martijn
rkennedy
Posts: 6579
Joined: Mon Oct 05, 2015 11:45 am

Re: After upgrade to 5.4.0.2 Database Backend error

Post by rkennedy »

The offline versions are generally released only when a stable version is out, and has been running smoothly for a bit. It'll be some time as we're only on 5.4.1 currently.
Former Nagios Employee
tmcdonald
Posts: 9117
Joined: Mon Sep 23, 2013 8:40 am

Re: After upgrade to 5.4.0.2 Database Backend error

Post by tmcdonald »

Just checking in since we have not heard from you in a while. Did @rkennedy's post clear things up?
Former Nagios employee
mvndnburg
Posts: 64
Joined: Wed Sep 21, 2016 2:53 am

Re: After upgrade to 5.4.0.2 Database Backend error

Post by mvndnburg »

tmcdonald wrote:Just checking in since we have not heard from you in a while. Did @rkennedy's post clear things up?
Yes, it did, thanks.
You can go ahead and lock the thread, if you want.
--
Martijn
Locked