Page 1 of 1
Nagios upgrade with Centos end of life
Posted: Thu Nov 04, 2021 10:43 am
by umitsupport
Hello, I need to upgrade nagiosxi 5.5.8 with centos 6.4 need to be version xi-5.7.3 because of the Centos version, I saw that there is a problems with the yum because of Centos eof, what is the best way to upgrade nagiosxi and centos 6.4 ?
Re: Nagios upgrade with Centos end of life
Posted: Thu Nov 04, 2021 4:25 pm
by benjaminsmith
Hi,
Just to confirm, you are currently running 5.7.3 on the Cent 6 system, correct? Also, what is your target operations system, Cent 7?
Let us know when you have a minute. Also here's our guide on XI migrations as a reference.
Migrating Nagios XI to a different Server
--Benjamin
Re: Nagios upgrade with Centos end of life
Posted: Fri Nov 05, 2021 1:16 pm
by umitsupport
No im in the 5.5.8
Re: Nagios upgrade with Centos end of life
Posted: Fri Nov 05, 2021 1:18 pm
by umitsupport
I tried to do the upgrade, after tried to do Im receiving the following message and is still in the 5.5.8:
SQL Error [nagiosxi] : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE user_id = 1' at line 3
Re: Nagios upgrade with Centos end of life
Posted: Fri Nov 05, 2021 3:24 pm
by benjaminsmith
Hi,
If you're going to upgrade the Cent 6 system. did you enable the vault repos?
See
https://www.getpagespeed.com/server-set ... 6-went-eol\
Regarding that error, try running the database repair script as root and then try again. If it fails, please attach the upgrade log along with the system profile.
Code: Select all
/usr/local/nagiosxi/scripts/repair_databases.sh
To send us your system profile.
Login to the Nagios XI GUI using a web browser.
Click the "Admin" > "System Profile" Menu
Click the "Download Profile" butto
--Benjamin
Re: Nagios upgrade with Centos end of life
Posted: Wed Nov 10, 2021 9:55 am
by umitsupport
Hello here the profile file
Moderator's Note: The profile has been shared with the support team but has been removed from the public forum.
Re: Nagios upgrade with Centos end of life
Posted: Wed Nov 10, 2021 5:36 pm
by benjaminsmith
Hi,
Did you try running the database repair script,
/usr/local/nagiosxi/scripts/repair_databases.sh ,as root?
I'm seeing corrupted tables in the log and that will likely cause any upgrades or backups to fail.
Code: Select all
211110 9:53:32 [ERROR] /usr/libexec/mysqld: Table './nagiosxi/xi_meta' is marked as crashed and last (automatic?) repair failed
211110 9:53:38 [ERROR] /usr/libexec/mysqld: Table './nagiosxi/xi_meta' is marked as crashed and last (automatic?) repair failed
211110 9:53:38 [ERROR] /usr/libexec/mysqld: Table './nagiosxi/xi_meta' is marked as crashed and last (automatic?) repair failed
I would highly recommend migrating this system to Cent 7 since this operating system is EOL and no longer supported. Let us know if you need assistance with the process.
--Benjamin