upgrade issue 5.6.14 -> 5.8.6
Posted: Wed Oct 06, 2021 10:03 am
Hi
OS:CentOS 7.8
we have upgraded our system from 5.6.14 to 5.8.6 with offline upgrade procedure..our system is in a closed network
although upgrade seems to be completed without any error when we look at our upgraded system we saw the following: (I have copied the following logs/files during our failed upgrade)
upgrade output:
GUI still shows old version (5.6.14)
GUI also shows: DB backend error
MariaDB log files are OK
nagios.log:
I have seen some forum posts about sysstat.php.. So I include ndo2db related lines below..
[root@nagios var]# ls -l /usr/local/nagiosxi/cron/sysstat.php
-rwxr-xr-x 1 nagios nagios 11712 Apr 30 2020 /usr/local/nagiosxi/cron/sysstat.php
cat sysstat.php
ndo.cfg file:
Note: we have roll backed the nagios from snapshot. now it is again in 5.6.14
OS:CentOS 7.8
we have upgraded our system from 5.6.14 to 5.8.6 with offline upgrade procedure..our system is in a closed network
although upgrade seems to be completed without any error when we look at our upgraded system we saw the following: (I have copied the following logs/files during our failed upgrade)
upgrade output:
Code: Select all
[root@nagios_server ~]# cd /tmp/rpms/
[root@nagios_server rpms]# tar xzf nagiosxi-5.8.6-1.el7.x86_64.tar.gz
[root@nagios_server rpms]# cd nagiosxi/
[root@nagios_server nagiosxi]# ./upgrade
nagiosxi-shellinabox-5.6.14-1.el7.x86_64
nagiosxi-nxti-5.6.14-1.el7.x86_64
perl-Nagios-Monitoring-Plugin-0.51-1.el7.noarch
Loaded plugins: fastestmirror, langpacks
Examining fping-3.10-4.el7.x86_64.rpm: fping-3.10-4.el7.x86_64
fping-3.10-4.el7.x86_64.rpm: does not update installed package.
Examining freetds-0.95.81-1.el7.x86_64.rpm: freetds-0.95.81-1.el7.x86_64
freetds-0.95.81-1.el7.x86_64.rpm: does not update installed package.
Examining jwhois-4.0-38.el7.x86_64.rpm: jwhois-4.0-38.el7.x86_64
jwhois-4.0-38.el7.x86_64.rpm: does not update installed package.
Examining libc-client-2007f-16.el7.x86_64.rpm: libc-client-2007f-16.el7.x86_64
libc-client-2007f-16.el7.x86_64.rpm: does not update installed package.
Examining libidn2-2.0.4-4.el7.x86_64.rpm: libidn2-2.0.4-4.el7.x86_64
libidn2-2.0.4-4.el7.x86_64.rpm: does not update installed package.
Examining libmcrypt-2.5.8-13.el7.x86_64.rpm: libmcrypt-2.5.8-13.el7.x86_64
libmcrypt-2.5.8-13.el7.x86_64.rpm: does not update installed package.
Examining nagiosxi-5.8.6-1.el7.x86_64.rpm: nagiosxi-5.8.6-1.el7.x86_64
Package nagiosxi not installed, cannot update it. Run yum install to install it instead.
Examining nagiosxi-mrtg-5.8.6-1.el7.x86_64.rpm: nagiosxi-mrtg-5.8.6-1.el7.x86_64
Marking nagiosxi-mrtg-5.8.6-1.el7.x86_64.rpm as an update to nagiosxi-mrtg-5.6.14-1.el7.x86_64
Examining nagiosxi-nagioscore-5.8.6-1.el7.x86_64.rpm: nagiosxi-nagioscore-5.8.6-1.el7.x86_64
Marking nagiosxi-nagioscore-5.8.6-1.el7.x86_64.rpm as an update to nagiosxi-nagioscore-5.6.14-1.el7.x86_64
Examining nagiosxi-nagiosplugins-5.8.6-1.el7.x86_64.rpm: nagiosxi-nagiosplugins-5.8.6-1.el7.x86_64
Marking nagiosxi-nagiosplugins-5.8.6-1.el7.x86_64.rpm as an update to nagiosxi-nagiosplugins-5.6.14-1.el7.x86_64
Examining nagiosxi-nagvis-5.8.6-1.el7.x86_64.rpm: nagiosxi-nagvis-5.8.6-1.el7.x86_64
Marking nagiosxi-nagvis-5.8.6-1.el7.x86_64.rpm as an update to nagiosxi-nagvis-5.6.14-1.el7.x86_64
Examining nagiosxi-ndoutils-5.8.6-1.el7.x86_64.rpm: nagiosxi-ndoutils-5.8.6-1.el7.x86_64
Marking nagiosxi-ndoutils-5.8.6-1.el7.x86_64.rpm as an update to nagiosxi-ndoutils-5.6.14-1.el7.x86_64
Examining nagiosxi-nrds-5.8.6-1.el7.x86_64.rpm: nagiosxi-nrds-5.8.6-1.el7.x86_64
Marking nagiosxi-nrds-5.8.6-1.el7.x86_64.rpm as an update to nagiosxi-nrds-5.6.14-1.el7.x86_64
Examining nagiosxi-nrpe-5.8.6-1.el7.x86_64.rpm: nagiosxi-nrpe-5.8.6-1.el7.x86_64
Marking nagiosxi-nrpe-5.8.6-1.el7.x86_64.rpm as an update to nagiosxi-nrpe-5.6.14-1.el7.x86_64
Examining nagiosxi-nsca-5.8.6-1.el7.x86_64.rpm: nagiosxi-nsca-5.8.6-1.el7.x86_64
Marking nagiosxi-nsca-5.8.6-1.el7.x86_64.rpm as an update to nagiosxi-nsca-5.6.14-1.el7.x86_64
Examining nagiosxi-nxti-5.8.6-1.el7.x86_64.rpm: nagiosxi-nxti-5.8.6-1.el7.x86_64
Marking nagiosxi-nxti-5.8.6-1.el7.x86_64.rpm as an update to nagiosxi-nxti-5.6.14-1.el7.x86_64
Examining nagiosxi-pnp-5.8.6-1.el7.x86_64.rpm: nagiosxi-pnp-5.8.6-1.el7.x86_64
Marking nagiosxi-pnp-5.8.6-1.el7.x86_64.rpm as an update to nagiosxi-pnp-5.6.14-1.el7.x86_64
Examining nagiosxi-shellinabox-5.8.6-1.el7.x86_64.rpm: nagiosxi-shellinabox-5.8.6-1.el7.x86_64
Marking nagiosxi-shellinabox-5.8.6-1.el7.x86_64.rpm as an update to nagiosxi-shellinabox-5.6.14-1.el7.x86_64
Examining nagiosxi-wkhtmltox-5.8.6-1.el7.x86_64.rpm: nagiosxi-wkhtmltox-5.8.6-1.el7.x86_64
Marking nagiosxi-wkhtmltox-5.8.6-1.el7.x86_64.rpm as an update to nagiosxi-wkhtmltox-5.6.14-1.el7.x86_64
Examining nagiosxi-wmic-5.8.6-1.el7.x86_64.rpm: nagiosxi-wmic-5.8.6-1.el7.x86_64
Marking nagiosxi-wmic-5.8.6-1.el7.x86_64.rpm as an update to nagiosxi-wmic-5.6.14-1.el7.x86_64
Examining nmap-6.47-2.x86_64.rpm: 2:nmap-6.47-2.x86_64
Marking nmap-6.47-2.x86_64.rpm as an update to 2:nmap-6.47-1.x86_64
Examining perl-Class-Accessor-0.34-12.el7.noarch.rpm: perl-Class-Accessor-0.34-12.el7.noarch
perl-Class-Accessor-0.34-12.el7.noarch.rpm: does not update installed package.
Examining perl-Config-IniFiles-2.79-1.el7.noarch.rpm: perl-Config-IniFiles-2.79-1.el7.noarch
perl-Config-IniFiles-2.79-1.el7.noarch.rpm: does not update installed package.
Examining perl-Crypt-Rijndael-1.12-1.el7.x86_64.rpm: perl-Crypt-Rijndael-1.12-1.el7.x86_64
perl-Crypt-Rijndael-1.12-1.el7.x86_64.rpm: does not update installed package.
Examining perl-Mail-IMAPClient-3.37-1.el7.noarch.rpm: perl-Mail-IMAPClient-3.37-1.el7.noarch
perl-Mail-IMAPClient-3.37-1.el7.noarch.rpm: does not update installed package.
Examining perl-Mail-POP3Client-2.19-5.el7.noarch.rpm: perl-Mail-POP3Client-2.19-5.el7.noarch
perl-Mail-POP3Client-2.19-5.el7.noarch.rpm: does not update installed package.
Examining perl-Math-Calc-Units-1.07-9.el7.noarch.rpm: perl-Math-Calc-Units-1.07-9.el7.noarch
perl-Math-Calc-Units-1.07-9.el7.noarch.rpm: does not update installed package.
Examining perl-Nagios-Monitoring-Plugin-0.51-1.el7.noarch.rpm: perl-Nagios-Monitoring-Plugin-0.51-1.el7.noarch
perl-Nagios-Monitoring-Plugin-0.51-1.el7.noarch.rpm: does not update installed package.
Examining perl-Net-SMTP-TLS-0.12-1.el7.noarch.rpm: perl-Net-SMTP-TLS-0.12-1.of.el7.noarch
perl-Net-SMTP-TLS-0.12-1.el7.noarch.rpm: does not update installed package.
Examining perl-Net-SNMP-6.0.1-7.el7.noarch.rpm: perl-Net-SNMP-6.0.1-7.el7.noarch
perl-Net-SNMP-6.0.1-7.el7.noarch.rpm: does not update installed package.
Examining perl-Number-Format-1.73-14.el7.noarch.rpm: perl-Number-Format-1.73-14.el7.noarch
perl-Number-Format-1.73-14.el7.noarch.rpm: does not update installed package.
Examining php-imap-5.4.16-7.el7.x86_64.rpm: php-imap-5.4.16-7.el7.x86_64
php-imap-5.4.16-7.el7.x86_64.rpm: does not update installed package.
Examining php-mcrypt-5.4.16-7.el7.x86_64.rpm: php-mcrypt-5.4.16-7.el7.x86_64
php-mcrypt-5.4.16-7.el7.x86_64.rpm: does not update installed package.
Examining php-mssql-5.4.16-7.el7.x86_64.rpm: php-mssql-5.4.16-7.el7.x86_64
php-mssql-5.4.16-7.el7.x86_64.rpm: does not update installed package.
Examining php-pear-HTML-Template-IT-1.3.0-2.el5.noarch.rpm: php-pear-HTML-Template-IT-1.3.0-2.el5.noarch
php-pear-HTML-Template-IT-1.3.0-2.el5.noarch.rpm: does not update installed package.
Examining php-pecl-ssh2-0.12-1.el7.x86_64.rpm: php-pecl-ssh2-0.12-1.el7.x86_64
php-pecl-ssh2-0.12-1.el7.x86_64.rpm: does not update installed package.
Examining python-bson-2.5.2-4.el7.x86_64.rpm: python-bson-2.5.2-4.el7.x86_64
python-bson-2.5.2-4.el7.x86_64.rpm: does not update installed package.
Examining python-pymongo-2.5.2-4.el7.x86_64.rpm: python-pymongo-2.5.2-4.el7.x86_64
python-pymongo-2.5.2-4.el7.x86_64.rpm: does not update installed package.
Examining python-pymssql-2.1.1-1.el7.x86_64.rpm: python-pymssql-2.1.1-1.el7.x86_64
python-pymssql-2.1.1-1.el7.x86_64.rpm: does not update installed package.
Examining python-simplejson-3.3.3-1.el7.x86_64.rpm: python-simplejson-3.3.3-1.el7.x86_64
python-simplejson-3.3.3-1.el7.x86_64.rpm: does not update installed package.
Examining rrdtool-1.4.9-1.el7.x86_64.rpm: rrdtool-1.4.9-1.el7.x86_64
rrdtool-1.4.9-1.el7.x86_64.rpm: does not update installed package.
Examining rrdtool-devel-1.4.9-1.el7.x86_64.rpm: rrdtool-devel-1.4.9-1.el7.x86_64
rrdtool-devel-1.4.9-1.el7.x86_64.rpm: does not update installed package.
Examining rrdtool-perl-1.4.9-1.el7.x86_64.rpm: rrdtool-perl-1.4.9-1.el7.x86_64
Package rrdtool-perl not installed, cannot update it. Run yum install to install it instead.
Examining rrdtool-python-1.4.9-1.el7.x86_64.rpm: rrdtool-python-1.4.9-1.el7.x86_64
rrdtool-python-1.4.9-1.el7.x86_64.rpm: does not update installed package.
Resolving Dependencies
--> Running transaction check
---> Package nagiosxi-mrtg.x86_64 0:5.6.14-1.el7 will be updated
---> Package nagiosxi-mrtg.x86_64 0:5.8.6-1.el7 will be an update
---> Package nagiosxi-nagioscore.x86_64 0:5.6.14-1.el7 will be updated
---> Package nagiosxi-nagioscore.x86_64 0:5.8.6-1.el7 will be an update
---> Package nagiosxi-nagiosplugins.x86_64 0:5.6.14-1.el7 will be updated
---> Package nagiosxi-nagiosplugins.x86_64 0:5.8.6-1.el7 will be an update
---> Package nagiosxi-nagvis.x86_64 0:5.6.14-1.el7 will be updated
---> Package nagiosxi-nagvis.x86_64 0:5.8.6-1.el7 will be an update
---> Package nagiosxi-ndoutils.x86_64 0:5.6.14-1.el7 will be updated
---> Package nagiosxi-ndoutils.x86_64 0:5.8.6-1.el7 will be an update
---> Package nagiosxi-nrds.x86_64 0:5.6.14-1.el7 will be updated
---> Package nagiosxi-nrds.x86_64 0:5.8.6-1.el7 will be an update
---> Package nagiosxi-nrpe.x86_64 0:5.6.14-1.el7 will be updated
---> Package nagiosxi-nrpe.x86_64 0:5.8.6-1.el7 will be an update
---> Package nagiosxi-nsca.x86_64 0:5.6.14-1.el7 will be updated
---> Package nagiosxi-nsca.x86_64 0:5.8.6-1.el7 will be an update
---> Package nagiosxi-nxti.x86_64 0:5.6.14-1.el7 will be updated
---> Package nagiosxi-nxti.x86_64 0:5.8.6-1.el7 will be an update
---> Package nagiosxi-pnp.x86_64 0:5.6.14-1.el7 will be updated
---> Package nagiosxi-pnp.x86_64 0:5.8.6-1.el7 will be an update
---> Package nagiosxi-shellinabox.x86_64 0:5.6.14-1.el7 will be updated
---> Package nagiosxi-shellinabox.x86_64 0:5.8.6-1.el7 will be an update
---> Package nagiosxi-wkhtmltox.x86_64 0:5.6.14-1.el7 will be updated
---> Package nagiosxi-wkhtmltox.x86_64 0:5.8.6-1.el7 will be an update
---> Package nagiosxi-wmic.x86_64 0:5.6.14-1.el7 will be updated
---> Package nagiosxi-wmic.x86_64 0:5.8.6-1.el7 will be an update
---> Package nmap.x86_64 2:6.47-1 will be updated
---> Package nmap.x86_64 2:6.47-2 will be an update
--> Finished Dependency Resolution
base | 3.6 kB
base/primary_db | 6.1 MB
http://10.50.100.23/Centos/Centos7.x/centosplus/repodata/repomd.xml: [Errno 14] HTTP Error 404 - Not Found
Trying other mirror.
To address this issue please refer to the below wiki article
https://wiki.centos.org/yum-errors
If above article doesn't help to resolve this issue please use https://bugs.centos.org/.
/var/cache/yum/x86_64/7/centosplus/gen/comps.xml: no element found: line 1, column 0
epel | 3.6 kB
epel/group_gz | 95 kB
epel/primary_db | 6.8 MB
http://10.50.100.23/Centos/Centos7.x/extras/repodata/repomd.xml: [Errno 14] HTTP Error 404 - Not Found
Trying other mirror.
/var/cache/yum/x86_64/7/extras/gen/comps.xml: no element found: line 1, column 0
nagios-base | 3.6 kB
/var/cache/yum/x86_64/7/nagios-base/gen/comps.xml: no element found: line 1, column 0
http://10.50.100.23/Centos/Centos7.x/updates/repodata/repomd.xml: [Errno 14] HTTP Error 404 - Not Found
Trying other mirror.
Dependencies Resolved
==========================================================================================================================================================
Package Arch Version Repository
==========================================================================================================================================================
Updating:
nagiosxi-mrtg x86_64 5.8.6-1.el7 /nagiosxi-mrtg-5.8.6-1.el7.x86_64
nagiosxi-nagioscore x86_64 5.8.6-1.el7 /nagiosxi-nagioscore-5.8.6-1.el7.x86_64
nagiosxi-nagiosplugins x86_64 5.8.6-1.el7 /nagiosxi-nagiosplugins-5.8.6-1.el7.x86_64
nagiosxi-nagvis x86_64 5.8.6-1.el7 /nagiosxi-nagvis-5.8.6-1.el7.x86_64
nagiosxi-ndoutils x86_64 5.8.6-1.el7 /nagiosxi-ndoutils-5.8.6-1.el7.x86_64
nagiosxi-nrds x86_64 5.8.6-1.el7 /nagiosxi-nrds-5.8.6-1.el7.x86_64
nagiosxi-nrpe x86_64 5.8.6-1.el7 /nagiosxi-nrpe-5.8.6-1.el7.x86_64
nagiosxi-nsca x86_64 5.8.6-1.el7 /nagiosxi-nsca-5.8.6-1.el7.x86_64
nagiosxi-nxti x86_64 5.8.6-1.el7 /nagiosxi-nxti-5.8.6-1.el7.x86_64
nagiosxi-pnp x86_64 5.8.6-1.el7 /nagiosxi-pnp-5.8.6-1.el7.x86_64
nagiosxi-shellinabox x86_64 5.8.6-1.el7 /nagiosxi-shellinabox-5.8.6-1.el7.x86_64
nagiosxi-wkhtmltox x86_64 5.8.6-1.el7 /nagiosxi-wkhtmltox-5.8.6-1.el7.x86_64
nagiosxi-wmic x86_64 5.8.6-1.el7 /nagiosxi-wmic-5.8.6-1.el7.x86_64
nmap x86_64 2:6.47-2 /nmap-6.47-2.x86_64
Transaction Summary
==========================================================================================================================================================
Upgrade 14 Packages
Total size: 199 M
Downloading packages:
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
Updating : nagiosxi-mrtg-5.8.6-1.el7.x86_64
Updating : nagiosxi-nagioscore-5.8.6-1.el7.x86_64
warning: /lib/systemd/system/nagios.service created as /lib/systemd/system/nagios.service.rpmnew
Updating : nagiosxi-nsca-5.8.6-1.el7.x86_64
Updating : nagiosxi-ndoutils-5.8.6-1.el7.x86_64
Updating : 2:nmap-6.47-2.x86_64
Updating : nagiosxi-nrpe-5.8.6-1.el7.x86_64
Updating : nagiosxi-nxti-5.8.6-1.el7.x86_64
Updating : nagiosxi-shellinabox-5.8.6-1.el7.x86_64
Updating : nagiosxi-nrds-5.8.6-1.el7.x86_64
Updating : nagiosxi-pnp-5.8.6-1.el7.x86_64
Updating : nagiosxi-wkhtmltox-5.8.6-1.el7.x86_64
Updating : nagiosxi-wmic-5.8.6-1.el7.x86_64
Updating : nagiosxi-nagiosplugins-5.8.6-1.el7.x86_64
Updating : nagiosxi-nagvis-5.8.6-1.el7.x86_64
Cleanup : nagiosxi-mrtg-5.6.14-1.el7.x86_64
Cleanup : nagiosxi-nagioscore-5.6.14-1.el7.x86_64
Cleanup : nagiosxi-nsca-5.6.14-1.el7.x86_64
Cleanup : nagiosxi-ndoutils-5.6.14-1.el7.x86_64
Cleanup : 2:nmap-6.47-1.x86_64
Cleanup : nagiosxi-nrpe-5.6.14-1.el7.x86_64
Cleanup : nagiosxi-nxti-5.6.14-1.el7.x86_64
Cleanup : nagiosxi-shellinabox-5.6.14-1.el7.x86_64
Cleanup : nagiosxi-nrds-5.6.14-1.el7.x86_64
Cleanup : nagiosxi-pnp-5.6.14-1.el7.x86_64
Cleanup : nagiosxi-wkhtmltox-5.6.14-1.el7.x86_64
Cleanup : nagiosxi-wmic-5.6.14-1.el7.x86_64
Cleanup : nagiosxi-nagiosplugins-5.6.14-1.el7.x86_64
Cleanup : nagiosxi-nagvis-5.6.14-1.el7.x86_64
Verifying : nagiosxi-nagvis-5.8.6-1.el7.x86_64
Verifying : nagiosxi-nagiosplugins-5.8.6-1.el7.x86_64
Verifying : nagiosxi-wmic-5.8.6-1.el7.x86_64
Verifying : nagiosxi-wkhtmltox-5.8.6-1.el7.x86_64
Verifying : nagiosxi-pnp-5.8.6-1.el7.x86_64
Verifying : nagiosxi-nrds-5.8.6-1.el7.x86_64
Verifying : nagiosxi-shellinabox-5.8.6-1.el7.x86_64
Verifying : nagiosxi-nxti-5.8.6-1.el7.x86_64
Verifying : nagiosxi-nrpe-5.8.6-1.el7.x86_64
Verifying : 2:nmap-6.47-2.x86_64
Verifying : nagiosxi-ndoutils-5.8.6-1.el7.x86_64
Verifying : nagiosxi-nsca-5.8.6-1.el7.x86_64
Verifying : nagiosxi-nagioscore-5.8.6-1.el7.x86_64
Verifying : nagiosxi-mrtg-5.8.6-1.el7.x86_64
Verifying : nagiosxi-nagvis-5.6.14-1.el7.x86_64
Verifying : nagiosxi-pnp-5.6.14-1.el7.x86_64
Verifying : nagiosxi-nagioscore-5.6.14-1.el7.x86_64
Verifying : nagiosxi-nxti-5.6.14-1.el7.x86_64
Verifying : nagiosxi-nagiosplugins-5.6.14-1.el7.x86_64
Verifying : nagiosxi-shellinabox-5.6.14-1.el7.x86_64
Verifying : nagiosxi-nsca-5.6.14-1.el7.x86_64
Verifying : nagiosxi-mrtg-5.6.14-1.el7.x86_64
Verifying : nagiosxi-ndoutils-5.6.14-1.el7.x86_64
Verifying : nagiosxi-nrds-5.6.14-1.el7.x86_64
Verifying : nagiosxi-wmic-5.6.14-1.el7.x86_64
Verifying : nagiosxi-wkhtmltox-5.6.14-1.el7.x86_64
Verifying : nagiosxi-nrpe-5.6.14-1.el7.x86_64
Verifying : 2:nmap-6.47-1.x86_64
Updated:
nagiosxi-mrtg.x86_64 0:5.8.6-1.el7 nagiosxi-nagioscore.x86_64 0:5.8.6-1.el7 nagiosxi-nagiosplugins.x86_64 0:5.8.6-1.el7 nagiosxi-nagvis.x86_64 0:5.8
nagiosxi-ndoutils.x86_64 0:5.8.6-1.el7 nagiosxi-nrds.x86_64 0:5.8.6-1.el7 nagiosxi-nrpe.x86_64 0:5.8.6-1.el7 nagiosxi-nsca.x86_64 0:5.8.6
nagiosxi-nxti.x86_64 0:5.8.6-1.el7 nagiosxi-pnp.x86_64 0:5.8.6-1.el7 nagiosxi-shellinabox.x86_64 0:5.8.6-1.el7 nagiosxi-wkhtmltox.x86_64 0:
nagiosxi-wmic.x86_64 0:5.8.6-1.el7 nmap.x86_64 2:6.47-2
Complete!
[root@nagios_server nagiosxi]# echo $?
0
[root@nagios_server nagiosxi]#
GUI still shows old version (5.6.14)
GUI also shows: DB backend error
MariaDB log files are OK
nagios.log:
Code: Select all
[1633527676] Nagios 4.4.6 starting... (PID=26319)
[1633527676] Local time is Wed Oct 06 16:41:16 +03 2021
[1633527676] LOG VERSION: 2.0
[1633527676] qh: Socket '/usr/local/nagios/var/rw/nagios.qh' successfully initialized
[1633527676] qh: core query handler registered
[1633527676] qh: echo service query handler registered
[1633527676] qh: help for the query handler registered
[1633527676] wproc: Successfully registered manager as @wproc with query handler
[1633527676] wproc: Registry request: name=Core Worker 26323;pid=26323
[1633527676] wproc: Registry request: name=Core Worker 26330;pid=26330
[1633527676] wproc: Registry request: name=Core Worker 26322;pid=26322
[1633527676] wproc: Registry request: name=Core Worker 26331;pid=26331
[1633527676] wproc: Registry request: name=Core Worker 26332;pid=26332
[1633527676] wproc: Registry request: name=Core Worker 26327;pid=26327
[root@elma var]# [1633527676] wproc: Registry request: name=Core Worker 26326;pid=26326
[1633527676] wproc: Registry request: name=Core Worker 26333;pid=26333
[1633527676] wproc: Registry request: name=Core Worker 26329;pid=26329
[1633527676] wproc: Registry request: name=Core Worker 26328;pid=26328
[1633527676] wproc: Registry request: name=Core Worker 26325;pid=26325
[1633527676] wproc: Registry request: name=Core Worker 26324;pid=26324
[1633527676] NDO-3: NDO 3.0.7 (c) Copyright 2009-2020 Nagios - Nagios Core Development Team
[1633527676] NDO-3: Unable to prepare statement for query (27): Unknown column 'check_options' in 'field list'
[1633527676] NDO-3: Unable to prepare statement for query (28): Unknown column 'check_options' in 'field list'
[1633527676] NDO-3: Error preparing statements
[1633527676] NDO-3: Unable to prepare statement for query (27): Unknown column 'check_options' in 'field list'
[1633527676] NDO-3: Unable to prepare statement for query (28): Unknown column 'check_options' in 'field list'
[1633527676] NDO-3: Error preparing statements
[1633527676] NDO-3: Callbacks registered
[1633527676] NDO-3: Callbacks registered
[1633527676] Event broker module '/usr/local/nagios/bin/ndo.so' initialized successfully.
[1633527676] NDO-3: Unable to prepare statement for query (27): Unknown column 'check_options' in 'field list'
[1633527676] NDO-3: Unable to prepare statement for query (28): Unknown column 'check_options' in 'field list'
[1633527676] NDO-3: Error preparing statements
[1633527676] NDO-3: Started event_handler thread
[1633527676] NDO-3: Started service_status thread
[1633527676] NDO-3: Started notification thread
[1633527676] NDO-3: Started host_check thread
[1633527676] NDO-3: Started host_status thread
[1633527676] NDO-3: Started downtime thread
[1633527676] NDO-3: Started flapping thread
[1633527676] NDO-3: Started contact_status thread
[1633527676] NDO-3: Started timed_event thread
[1633527676] NDO-3: Started acknowledgement thread
[1633527676] NDO-3: Started comment thread
[1633527676] NDO-3: Started statechange thread
[1633527676] NDO-3: Unable to prepare statement for query (27): Unknown column 'check_options' in 'field list'
[1633527676] NDO-3: Unable to prepare statement for query (28): Unknown column 'check_options' in 'field list'
[1633527676] NDO-3: Error preparing statements
[1633527676] NDO-3: Started service_check thread
[1633527677] NDO-3: Unable to prepare statement for query (27): Unknown column 'check_options' in 'field list'
[1633527677] NDO-3: Unable to prepare statement for query (28): Unknown column 'check_options' in 'field list'
[1633527677] NDO-3: Error preparing statements
[1633527677] NDO-3: Unable to prepare statement for query (27): Unknown column 'check_options' in 'field list'
[1633527677] NDO-3: Unable to prepare statement for query (28): Unknown column 'check_options' in 'field list'
[1633527677] NDO-3: Unable to prepare statement for query (27): Unknown column 'check_options' in 'field list'
[1633527677] NDO-3: Unable to prepare statement for query (28): Unknown column 'check_options' in 'field list'
[1633527677] NDO-3: Unable to prepare statement for query (27): Unknown column 'check_options' in 'field list'
[1633527677] NDO-3: Unable to prepare statement for query (28): Unknown column 'check_options' in 'field list'
[1633527677] NDO-3: Error preparing statements
[1633527677] NDO-3: Error preparing statements
[1633527677] NDO-3: Unable to prepare statement for query (27): Unknown column 'check_options' in 'field list'
[1633527677] NDO-3: Unable to prepare statement for query (28): Unknown column 'check_options' in 'field list'
[1633527677] NDO-3: Error preparing statements
[1633527677] NDO-3: Error preparing statements
[1633527677] NDO-3: Unable to prepare statement for query (27): Unknown column 'check_options' in 'field list'
[1633527677] NDO-3: Unable to prepare statement for query (28): Unknown column 'check_options' in 'field list'
[1633527677] NDO-3: Unable to prepare statement for query (27): Unknown column 'check_options' in 'field list'
[1633527677] NDO-3: Unable to prepare statement for query (27): Unknown column 'check_options' in 'field list'
[1633527677] NDO-3: Unable to prepare statement for query (28): Unknown column 'check_options' in 'field list'
[1633527677] NDO-3: Unable to prepare statement for query (28): Unknown column 'check_options' in 'field list'
[1633527677] NDO-3: Error preparing statements
[1633527677] NDO-3: Unable to prepare statement for query (27): Unknown column 'check_options' in 'field list'
[1633527677] NDO-3: Unable to prepare statement for query (28): Unknown column 'check_options' in 'field list'
[1633527677] NDO-3: Error preparing statements
[1633527677] NDO-3: Unable to prepare statement for query (27): Unknown column 'check_options' in 'field list'
[1633527677] NDO-3: Unable to prepare statement for query (28): Unknown column 'check_options' in 'field list'
[1633527677] NDO-3: Unable to prepare statement for query (27): Unknown column 'check_options' in 'field list'
[1633527677] NDO-3: Unable to prepare statement for query (28): Unknown column 'check_options' in 'field list'
[1633527677] NDO-3: Error preparing statements
[1633527677] NDO-3: Unable to prepare statement for query (27): Unknown column 'check_options' in 'field list'
[1633527677] NDO-3: Unable to prepare statement for query (28): Unknown column 'check_options' in 'field list'
[1633527677] NDO-3: Error preparing statements
[1633527677] NDO-3: Error preparing statements
[1633527677] NDO-3: Error preparing statements
[1633527677] NDO-3: Error preparing statements
[1633527679] NDO-3: The following query failed while MySQL appears to be connected:
[1633527679] NDO-3: SELECT object_id FROM nagios_objects WHERE objecttype_id = 9 AND name1 = 'GR_notification_times'
[1633527679] NDO-3: ndo_return = 1 (Commands out of sync; you can't run this command now)
[1633527679] NDO-3: ndo_get_object_id_name1(ndo.c:1266): Unable to store results
[1633527679] NDO-3: The following query failed while MySQL appears to be connected:
....
[1633527208] NDO-3: ndo_handle_service_status(ndo-handlers.c:1156): Unable to bind parameters
[1633527208] NDO-3: ndo_return = 1 (Statement not prepared)
[1633527208] NDO-3: ndo_handle_service_status(ndo-handlers.c:1156): Unable to bind parameters
[1633527208] NDO-3: ndo_return = 1 (Statement not prepared)
[1633527208] NDO-3: ndo_handle_service_status(ndo-handlers.c:1156): Unable to bind parameters
[1633527208] NDO-3: ndo_return = 1 (Statement not prepared)
[1633527208] NDO-3: ndo_handle_service_status(ndo-handlers.c:1156): Unable to bind parameters
[1633527208] NDO-3: ndo_return = 1 (Statement not prepared)
[1633527208] NDO-3: ndo_handle_service_status(ndo-handlers.c:1156): Unable to bind parameters
[1633527208] NDO-3: ndo_return = 1 (Statement not prepared)
[1633527208] NDO-3: ndo_handle_service_status(ndo-handlers.c:1156): Unable to bind parameters
[1633527208] NDO-3: ndo_return = 1 (Statement not prepared)
[1633527208] NDO-3: ndo_handle_service_status(ndo-handlers.c:1156): Unable to bind parameters
....
I have seen some forum posts about sysstat.php.. So I include ndo2db related lines below..
[root@nagios var]# ls -l /usr/local/nagiosxi/cron/sysstat.php
-rwxr-xr-x 1 nagios nagios 11712 Apr 30 2020 /usr/local/nagiosxi/cron/sysstat.php
cat sysstat.php
Code: Select all
...
"ndoutils" => array(
"daemon" => "ndo2db",
"output" => "",
"return_code" => 0,
"status" => SUBSYS_COMPONENT_STATUS_UNKNOWN
)
...
// If the daemon is ndo2db and offloaded, we overwrite the
// return/output
if ($return_code != 0 && $darr["daemon"] == "ndo2db") {
if (!empty($cfg["ndo2db_offloaded"])) {
$return_code = 0;
$output = "NDO2DB is offloaded.";
}
}
...
Code: Select all
[root@nagios var]# cat ../etc/ndo.cfg
# Default NDO config for Nagios XI
db_user=ndoutils
#i have deleted the following string intentionally
db_pass=...
db_name=nagios
db_host=localhost
db_port=3306
#db_socket=/var/lib/mysql.sock
db_max_reconnect_attempts=5
acknowledgement_data=1
comment_data=1
contact_status_data=1
downtime_data=1
event_handler_data=1
external_command_data=1
flapping_data=1
host_check_data=1
host_status_data=1
log_data=1
main_config_data=1
notification_data=1
object_config_data=1
process_data=1
program_status_data=1
retention_data=1
service_check_data=1
service_status_data=1
state_change_data=1
system_command_data=1
timed_event_data=1
config_output_options=2
max_object_insert_count=250
mysql_set_charset_name=utf8
#log_failed_queries=1
***
Note: we have roll backed the nagios from snapshot. now it is again in 5.6.14