Nagios Support Forum

Dear Support,

We have an existing Nagios XI server (Nagios XI 5.5.9 on CentOS 6)which we need to upgrade. Due to the OS is CentOS 6 that is already End-Of-Life, we have to migrate to a new server, which will be on CentOS 8 with the latest current version of Nagios XI, 5.8.6.

However, Nagios XI 5.5.9 is not able to be installed on CentOS 8. Is there any other way that we can migrate Nagios XI without having to install with the same current version on the new server? Or any other recommendations?

Appreciate your help.


Thank you.

Hi azreenariff,

It should be possible to migrate your 5.5.9 instance to 5.8.6 by transitioning through version 5.7.5. You should be able to install 5.7.5 on your new CentOS 8 system and migrate through the restore process as outlined in the migration document and then upgrade to 5.8.6.

Migrating NagiosXI to a new server:

https://support.nagios.com/kb/article/m ... r-892.html

Older versions of nagiosxi, including 5.7.5, can be found here:

https://www.nagios.com/downloads/nagios ... -releases/

As always we would encourage you to go through this transition first in a test environment prior to attempting the upgrade in production. This is specifically allowed by our licensing agreement.:

Nagios XI License Policy

With every purchase we offer 3 separate activation of XI licenses. One for production, one for testing, and one for high availability. We always recommend upgrading on a test server first before making changes to the production server.

`Nagios License Entitlements
https://support.nagios.com/kb/article.php?id=145

Hi Kfanselow,

Thank for the recommendation. We will try it out and update you back on the outcome.

Hi Kfanselow,

We have managed to perform the migration to the new server, and also upgraded Nagios XI to 5.8.6.

But there is a problem now where in the GUI it shows the 'Monitoring Engine' and 'Performance Grapher' not running. However, NPCD is actually running if checked from the command line.
Any idea how to resolve this?

I have also PM to you the profile.zip file

Hi support,

To add detailed on the above post

Troubleshooting Done:
- Restart nagios,
- restart db,
- restart npcd
- run reset_config_perms.sh script
- run reconfigure_nagios.sh script

Thanks,
Safuan

Hi Azreenariff and Safuanmansor,

We're glad to hear that things are running the upgrade went relatively smoothly. If "Monitoring Engine" and "Performance Grapher" are still showing red please run the following commands as root on the NagiosXI server (change the username and passowrd as required) and restart the service:
Thanks and good luck,
Keith

Apologies, but I'm kind of in the same position too. After migrating/restoring to a new server however, I'm receiving '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 = 2' at line 3'. I tried searching the forums, but couldn't find anything related to that exact error.

Hi Kefanselow,

Thanks again for the suggestion. We have managed to perform the db alteration as you suggested. The graphs are updating normally and the checks are running. However, on the GUI still shows the "Monitoring Engine" and "Performance Grapher" as red.

Appreciate your advice. I will also PM to you the profile.zip file again.

Thanks.

Hi Azreenariff,

Could you run the following as the user nagios and PM me a copy of the sysstat.log file along with your nagios crontab (/etc/cron.d/nagiosxi) ?
Also could you post the output from the following command:
Thanks and Best Regards,
Keith

Hi Keith,

Maybe this could be of help. I find that Nagios XI is displaying the same PID (which is in exited status) on the GUI as below. From where does Nagios XI actually checks this, and how can we resolve this so it will check the actual status?
Thanks.