Nagios Support Forum

Hi, we are currently upgrade Nagios Xi from 5.7.5 to 5.10.0, then upgrade from 5.10.0 to the latest Nagios Xi version 2024R1.3.2. But for somehow, after we upgraded from 5.7.5 to 5.10.0 successfully, when we checked version, it's still showing 5.7.5, not 5.10.0. Is the upgrade completed successfully?

I checked upgrade log xi-upgrade.log, I observed this error.
ERROR 1060 (42S21) at line 5: Duplicate column name 'exclude'
UPGRADE: POST-UPGRADE: NDO post upgrade started...
2.1.2
Failed to stop ndo2db.service: Unit ndo2db.service not loaded.

Would it be reason?

Hi @caqin,

What instructions did you follow? Did you convert the database from PostgreSQL to MySQL?

For reference, here are the Nagios XI upgrade instructions, and here are the instructions on how to convert your database.

Are you running the upgrade as root?

If you have already taken these steps or it failed before you could, let us know and we can continue to troubleshoot. If not, let us know if it works.

Thank you!

Hi @gwesterman
Sorry to reply late. Yes, we already converted database from PostgreSQL to MariaDB when upgraded to current version 5.7.5 in 2023.
We will re-run upgrade again. I will let you know if it works or not.

Thank you!

Yes, we did follow up Nagios upgrade instruction and run upgrade with root. But for somehow, still showing old version 5.7.5, not 5.10.0

Here is our upgrade process:
We did offline upgrade and downloaded package nagiosxi-5.10.0-1.el7.x86_64.tar.gz and ran upgrade with root. The upgrade process seems good, but in Nagios web, it's still showing version 5.7.5, not version 5.10.0.

From upgrade log, seems ndo2db service not loaded. I have impression this service is removed from version 5.7.x, right?

Below is last few lines in xi-upgrade.log.
SKIPPING NAGIOS CORE RESTART...
CHECKING FOR INSTALL SCRIPT '/usr/local/nagiosxi/html/includes/configwizards/hyperv/install.sh'...
INSTALL SCRIPT DOES NOT EXIST.
CMD: . /usr/local/nagiosxi/var/xi-sys.cfg && chown -R $nagiosuser /usr/local/nagiosxi/html/includes/configwizards/hyperv


Done!
UPGRADE: POST-UPGRADE: NDO post upgrade started...
2.1.2
Failed to stop ndo2db.service: Unit ndo2db.service not loaded.

Thanks

Never mind. We upgraded to 5.10.0.
The reason is ndo2db service was not running. I rolled back ndo to previous version and run upgrade again. It works now.
Next, will upgrade from 5.10.0 to 2024R1.1.5.