Nagios xi Migration to New Server

This support forum board is for support questions relating to Nagios xi, our flagship commercial network monitoring solution.
azreenariff
Posts: 49
Joined: Tue Aug 21, 2018 7:58 am

Nagios xi Migration to New Server

Post by azreenariff »

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.
User avatar
kfanselow
Posts: 247
Joined: Tue Aug 31, 2021 3:25 pm

Re: Nagios xi Migration to New Server

Post by kfanselow »

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
azreenariff
Posts: 49
Joined: Tue Aug 21, 2018 7:58 am

Re: Nagios xi Migration to New Server

Post by azreenariff »

Hi Kfanselow,

Thank for the recommendation. We will try it out and update you back on the outcome.
azreenariff
Posts: 49
Joined: Tue Aug 21, 2018 7:58 am

Re: Nagios xi Migration to New Server

Post by azreenariff »

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.
systemstatus.png
Any idea how to resolve this?

I have also PM to you the profile.zip file
You do not have the required permissions to view the files attached to this post.
safuanmansor
Posts: 59
Joined: Mon Jul 16, 2018 9:16 pm

Re: Nagios xi Migration to New Server

Post by safuanmansor »

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
User avatar
kfanselow
Posts: 247
Joined: Tue Aug 31, 2021 3:25 pm

Re: Nagios xi Migration to New Server

Post by kfanselow »

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:

Code: Select all

mysql -h 127.0.0.1 -uroot -pnagiosxi nagios -e "ALTER TABLE nagios_hoststatus ADD check_options smallint(6) NOT NULL default '0' AFTER check_type;"

Code: Select all

mysql -h 127.0.0.1 -uroot -pnagiosxi nagios -e "ALTER TABLE nagios_servicestatus ADD check_options smallint(6) NOT NULL default '0' AFTER check_type;"
Thanks and good luck,
Keith
lakeshorelearning
Posts: 11
Joined: Mon Jul 21, 2014 9:55 pm

Re: Nagios xi Migration to New Server

Post by lakeshorelearning »

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.
azreenariff
Posts: 49
Joined: Tue Aug 21, 2018 7:58 am

Re: Nagios xi Migration to New Server

Post by azreenariff »

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.
User avatar
kfanselow
Posts: 247
Joined: Tue Aug 31, 2021 3:25 pm

Re: Nagios xi Migration to New Server

Post by kfanselow »

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

Code: Select all

/usr/bin/php  /usr/local/nagiosxi/cron/sysstat.php >> /usr/local/nagiosxi/var/sysstat.log 2>&1
Also could you post the output from the following command:

Code: Select all

chage -l nagios

Thanks and Best Regards,
Keith
azreenariff
Posts: 49
Joined: Tue Aug 21, 2018 7:58 am

Re: Nagios xi Migration to New Server

Post by azreenariff »

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?
systemstatus2.png
Thanks.
You do not have the required permissions to view the files attached to this post.