Nagios upgrade with Centos end of life

[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 ?

[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

[umitsupport]

No im in the 5.5.8

[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

[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

[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.

[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