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!
Failed upgrade Nagios xi 5.6.14 to 5.8
-
WilheimVZ
- Posts: 1
- Joined: Fri Feb 03, 2017 6:55 pm
Failed upgrade Nagios xi 5.6.14 to 5.8
You do not have the required permissions to view the files attached to this post.
-
vtrac
- Posts: 903
- Joined: Tue Oct 27, 2020 1:35 pm
Re: Failed upgrade Nagios xi 5.6.14 to 5.8
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
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
Code: Select all
ps -ef | grep mysql
Code: Select all
/usr/local/nagiosxi/scripts/repair_databases.sh
Regards,
Vinh