Nagios Support Forum

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!

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: Also, please run these: Please try repair the database and see if your GUI comes up: If issues still existed, please upload your "profile.zip" and "/etc/my.cnf" files.


Regards,
Vinh