upgrade issue 5.6.14 -> 5.8.6

This support forum board is for support questions relating to Nagios XI, our flagship commercial network monitoring solution.
Locked
erkanerturk
Posts: 53
Joined: Wed Jan 16, 2019 4:35 am

upgrade issue 5.6.14 -> 5.8.6

Post by erkanerturk »

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:

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.";
            }
        }
...
ndo.cfg file:

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
Top
benjaminsmith
Posts: 5324
Joined: Wed Aug 22, 2018 4:39 pm
Location: saint paul

Re: upgrade issue 5.6.14 -> 5.8.6

Post by benjaminsmith »

Hi,

So the following errors suggest that some of the tables in the nagios database did not get updated properly to work with the new backend database service, ndo3.
[1633527208] NDO-3: ndo_return = 1 (Statement not prepared)
[1633527208] NDO-3: ndo_handle_service_status(ndo-handlers.c:1156): Unable to bind parameters
Do you have a test server setup that we could dump the database info and update without impacting your production monitoring server?

Another option would be to update to the latest version of XI and then install ndo2db instead of ndo3 for handling writes to the nagios database.

Regards,
Benjamin
As of May 25th, 2018, all communications with Nagios Enterprises and its employees are covered under our new Privacy Policy.

Be sure to check out our Knowledgebase for helpful articles and solutions!
Top
erkanerturk
Posts: 53
Joined: Wed Jan 16, 2019 4:35 am

Re: upgrade issue 5.6.14 -> 5.8.6

Post by erkanerturk »

Hi
we do not have a test server setup. but i think we can produce one, by copying a new VM from our monitoring server!
can you guide me to repair our DB?

i can not share the whole DB backup , but there is a way to backup only DB schema we can do this. what about this one:

Code: Select all

mysqldump -h yourhostnameorIP -u root -p --no-data dbname > schema.sql
Note: i do not prefer to work with ndo2db as it will cause inconveniance for future upgrades..
Top
ssax
Dreams In Code
Posts: 7682
Joined: Wed Feb 11, 2015 12:54 pm

Re: upgrade issue 5.6.14 -> 5.8.6

Post by ssax »

If you run the upgrade on an RPM install and the RPMs show the new version but the XI web interface shows the old version then the nagiosxi RPM failed to install properly on one of the subscripts.

For that specific NDO3 error, this would likely resolve it:

Code: Select all

mysql -h 127.0.0.1 -uroot -pnagiosxi nagios -e "ALTER TABLE nagios_hoststatus ADD check_options smallint(6) NOT NULL default '0' AFTER check_type;"
mysql -h 127.0.0.1 -uroot -pnagiosxi nagios -e "ALTER TABLE nagios_servicestatus ADD check_options smallint(6) NOT NULL default '0' AFTER check_type;"
But given we know it didn't upgrade properly (if it did the new version would show in the XI web interface), you would need to perform these steps to determine what is failing on it to work through the issues and then after it's finished it should be upgraded properly:

You would cd into the directory you ran ./upgrade from, then as root run these commands on your XI server:

Code: Select all

rpm2cpio nagiosxi-5.8.6-1.el7.x86_64.rpm​ | cpio -idmv
cd tmp/nagiosxi
./rpmupgrade
That's the only way I know how to see what RPM subscripts are failing, to work through the issues (don't skip anything in the ./rpmupgrade script, if you get any errors send them to us so we can investigate and properly remediate them), and to get it successfully upgraded when this scenario occurs.
Top
erkanerturk
Posts: 53
Joined: Wed Jan 16, 2019 4:35 am

Re: upgrade issue 5.6.14 -> 5.8.6

Post by erkanerturk »

hi

here is the process... i have sent the logs to you as a PM

1- I have upgraded with "./upgrade" command. it gave no error. but when i look at web UI i have still seen version 5.6
2- i have tried your rpmupgrade command. when i see web UI, it was still 5.6. but when i logged back and in. i have seen 5.8.6
3- i have looked at nagios.log to check NDO-3 errors..i have seen the following errors

[1635925285] NDO-3: ndo_return = 1 (Statement not prepared)
[1635925285] NDO-3: ndo_handle_service_status(ndo-handlers.c:1156): Unable to bind parameters

4- i have stopped nagios and tried to ctahc errors from start..i have seen the following errors

[1635925340] NDO-3: Unable to prepare statement for query (27): Unknown column 'check_options' in 'field list'
[1635925340] NDO-3: Unable to prepare statement for query (28): Unknown column 'check_options' in 'field list'

i have applied your sql commands to repair

5- i have seen other db errors , like the following

[1635925542] NDO-3: The following query failed while MySQL appears to be connected:
[1635925542] NDO-3: SELECT object_id FROM nagios_objects WHERE objecttype_id = 9 AND name1 = 'Vik_zleme_notification_times'
[1635925542] NDO-3: ndo_return = 1 (Commands out of sync; you can't run this command now)

6- ihave checked nagios.cfg and see the ndo line correctly
....
broker_module=/usr/local/nagios/bin/ndo.so /usr/local/nagios/etc/ndo.cfg
....

7- i have run repair_databases.sh but problem persists
Top
ssax
Dreams In Code
Posts: 7682
Joined: Wed Feb 11, 2015 12:54 pm

Re: upgrade issue 5.6.14 -> 5.8.6

Post by ssax »

1 and 2: Should now be resolved.

3 and 4: Please try running these commands against your DB server:
- NOTE: You may need to adjust the -h 127.0.0.1, the -uroot, and -pnagiosxi in the command if your DB is offloaded to another server and/or you've changed the root mysql password

Code: Select all

mysql -h 127.0.0.1 -uroot -pnagiosxi nagios -e "ALTER TABLE nagios_hoststatus ADD check_options smallint(6) NOT NULL default '0' AFTER check_type;"
mysql -h 127.0.0.1 -uroot -pnagiosxi nagios -e "ALTER TABLE nagios_servicestatus ADD check_options smallint(6) NOT NULL default '0' AFTER check_type;"
That should fix those.

Then Apply Configuration, wait 10 minutes, and then:

Please PM me a FRESH copy of your profile.zip, you can download it from Admin > System Profile by clicking the Download Profile button.
Top
erkanerturk
Posts: 53
Joined: Wed Jan 16, 2019 4:35 am

Re: upgrade issue 5.6.14 -> 5.8.6

Post by erkanerturk »

Hi
thanks for your help...

yes your fixes helped me to advance in my problem.
the only problem is DB issue..the errors mentioned in my list as 5. you can see all the details in my previous PM

due to organizational regulations, i can't share my profile. you can request specific configurations or we can continue through a ticket. our servers are in a closed network..

thanks..
Top
ssax
Dreams In Code
Posts: 7682
Joined: Wed Feb 11, 2015 12:54 pm

Re: upgrade issue 5.6.14 -> 5.8.6

Post by ssax »

What is the output of this command?

Code: Select all

ps aux | grep nagios
PM santized versions of these files:

Code: Select all

/usr/local/nagiosxi/html/config.inc.php
/usr/local/nagios/etc/nagios.cfg
Edit this file:

Code: Select all

/usr/local/nagios/etc/ndo.cfg
Change this:

Code: Select all

#log_failed_queries=1
To this:

Code: Select all

log_failed_queries=1
debugging=1
Then edit this file:

Code: Select all

/usr/local/nagios/etc/nagios.cfg
And change these:

Code: Select all

debug_level=0
debug_verbosity=1
To:

Code: Select all

debug_level=-1 # that is minus one
debug_verbosity=2
Then restart nagios:

Code: Select all

systemctl restart nagios
Then wait for that DB error to occur again and PM me these files:

Code: Select all

/usr/local/nagios/var/nagios.log
/usr/local/nagios/var/nagios.debug
NOTE: Those debug settings may fill up your disk if left enabled, revert the debug changes after, and restart the nagios service again.
Top
erkanerturk
Posts: 53
Joined: Wed Jan 16, 2019 4:35 am

Re: upgrade issue 5.6.14 -> 5.8.6

Post by erkanerturk »

I have sent you a PM
Top
ssax
Dreams In Code
Posts: 7682
Joined: Wed Feb 11, 2015 12:54 pm

Re: upgrade issue 5.6.14 -> 5.8.6

Post by ssax »

EDIT: Please PM me this file:

Code: Select all

/usr/local/nagios/etc/ndo.cfg
Please edit your /usr/local/nagios/etc/config.inc.php and add this:

Code: Select all

        "charset" => 'utf8',
Under each of these lines (lines 44, 58, 78):

Code: Select all

        "db" => 'nagiosxi',
...
        "db" => 'nagios',
...
        "db" => 'nagiosql',
So it looks like this:

Code: Select all

        "db" => 'nagiosxi',
        "charset" => 'utf8',
...
        "db" => 'nagios',
        "charset" => 'utf8',
...
        "db" => 'nagiosql',
        "charset" => 'utf8',
Then restart these services:

Code: Select all

systemctl restart mariadb httpd crond nagios
Then see if that allows it to work properly.
Top
Locked

Return to “Nagios XI”