Failed upgrade Nagios XI 5.6.14 to 5.8

[WilheimVZ]

I have been unable to upgrade Nagios 5.6.14 to anything higher. I've tried 5.7 and 5.8 both manual and scripted upgrades.

CentOS
7.9.2009
x86_64

The webpage displays several errors like this in the panels: SQL Error [nagiosxi] : You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'WHERE user_id = 1' at line 3

Attached is the log file for a 5.8 upgrade attempt.

Thanks!

[vtrac]

Hi,
I do not see any error in your upgrade log.

The best way to upgrade are:
- spin up a new clean VM
- install the same Nagios XI version of your OLD onto the new VM.
- restore from OLD backup onto new VM
- upgrade new VM to latest

Doing the step above will keep your OLD one running, just incase of errors like now.

Can you please run and post output here:

Code: Select all

yum list installed | grep "^nagios"
or
rpm -qa | grep nagios

Also, please run these:

Code: Select all

ps -ef | grep mysql

Please try repair the database and see if your GUI comes up:

Code: Select all

/usr/local/nagiosxi/scripts/repair_databases.sh

If issues still existed, please upload your "profile.zip" and "/etc/my.cnf" files.


Regards,
Vinh