I removed the php files from offline-nagiosxi directory as we need to use a currently supported PHP already installed
Code: Select all
# yum list installed | grep ^php.x86_64
php.x86_64 8.1.31-1.el8.remi @pfs_8_php81I rebooted the server and ran tests for the alerts and notifications, everything seemed to be working ok.
Looking closer at the server it still showed the old version number. Looking at /tmp/xi-upgrade.log, it passed the preflight check, but failed on a DB command.
This happened on both our years old XI server, which has been steadily upgraded and our new (fresh install about 4 months old) test server.
As there were no errors on the commandline we nearly missed the upgrade had failed.
/tmp/xi-upgrade.log
=====================================================
Code: Select all
Checking install type...
Install type: rpm
Installation check passed.
Archive: sourceguardian/ixed4.lin.x86-64.zip
inflating: /usr/lib64/php/modules/ixed.8.1.lin
Sourceguardian extension found for PHP version 8.1
Removing backup loader...
Sourceguardian extension already in php.ini
Redirecting to /bin/systemctl restart httpd.service
Checking required prereqs...
Please wait...
mysql: [Warning] Using a password on the command line interface can be insecure.
Nagios Core 4.5.3
Copyright (c) 2009-present Nagios Core Development Team and Community Contributors
Copyright (c) 1999-2009 Ethan Galstad
Last Modified: 2024-06-11
License: GPL
Website: https://www.nagios.org
Reading configuration data...
Read main config file okay...
Read object config files okay...
Running pre-flight check on configuration data...
Checking objects...
Checked 12 services.
Checked 1 hosts.
Checked 1 host groups.
Checked 0 service groups.
Checked 1 contacts.
Checked 2 contact groups.
Checked 149 commands.
Checked 8 time periods.
Checked 0 host escalations.
Checked 0 service escalations.
Checking for circular paths...
Checked 1 hosts
Checked 0 service dependencies
Checked 0 host dependencies
Checked 8 timeperiods
Checking global event handlers...
Checking obsessive compulsive processor commands...
Checking misc settings...
Total Warnings: 0
Total Errors: 0
Things look okay - No serious problems were detected during the pre-flight check
Checking if any NEB Modules are installed besides NDO
Adding ModSecurity Rules...
Restarting httpd with ModSecurity applied...
PHP Fatal error: Uncaught mysqli_sql_exception: Unknown column 'mrtgconfig' in 'field list' in /tmp/nagiosxi/nagiosxi/basedir/html/db/adodb/drivers/adodb-mysqli.inc.php:789
Stack trace:
#0 /tmp/nagiosxi/nagiosxi/basedir/html/db/adodb/drivers/adodb-mysqli.inc.php(789): mysqli_query(Object(mysqli), 'SELECT mrtgconf...', 0)
#1 /tmp/nagiosxi/nagiosxi/basedir/html/db/adodb/adodb.inc.php(1268): ADODB_mysqli->_query('SELECT mrtgconf...', false)
#2 /tmp/nagiosxi/nagiosxi/basedir/html/db/adodb/adodb.inc.php(1246): ADOConnection->_Execute('SELECT mrtgconf...', false)
#3 /tmp/nagiosxi/nagiosxi/basedir/html/includes/db.inc.php(657): ADOConnection->Execute('SELECT mrtgconf...')
#4 /tmp/nagiosxi/nagiosxi/basedir/scripts/import_mrtg_configuration.php(25): exec_sql_query('nagiosql', 'SELECT mrtgconf...')
#5 {main}
thrown in /tmp/nagiosxi/nagiosxi/basedir/html/db/adodb/drivers/adodb-mysqli.inc.php on line 789xi-sys.cfg
=====================================================
Code: Select all
...
xiver='2024r1.3.2'
distro='RedHatEnterpriseServer'
version='8.10'
...xiversion
=====================================================
Code: Select all
###################################
# DO NOT DELETE THIS FILE!
# Nagios XI version information
###################################
full=2024R1.1.5
major=2024
minor=1.1.5
releasedate=2024-07-23
release=60105