NagiosXI 5.6 to 5.8 with Centos 7 migration

[bennyboy]

Hello,

I have a nice problem to solve in the next few weeks. I have to update NagiosXI from 5.6 to 5.8 and at the same time update Centos 7 to RHEL 8. I would have chosen to upgrade Centos 7 to Centos Stream but I haven't found a direct solution. As I will upgrade from Centos 7 to RHEL 8 I imagine that the MariaDB will not be at the same version. We are currently using version 5.5 and I imagine that on RHEL 8 it will not be this version anymore. We are also evaluating the possibility of migrating to postgresql. That's a lot of changes at the same time. Luckily we have support and Good thing we have support and I can ask you for advice. I would like to know your opinion on the subject. The recommended order of upgrades. Nagios XI first then a backup and restore to RHEL 8. A migration of the DB from MariaDB to PostgreSQL? Upgrade from MariaDB 5.5 to 10.X ?

Thank you very much for your advice

[kfanselow]

Hello,

We always recommend that when making a transition like this that you take advantage of the provisions of your XI license and test the transition using a test server. You should create an environment that reflects your Prod environment as closely as possible. Then go through the upgrade. Our licensing agreement allows you to do this.

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

With that being said it sounds like you have quite a project a head of you - a couple of quick notes:

1) Just a heads up CentOS 8 is scheduled to be EOL at the end of this year ( December 31st ) so it may not be the best move at the moment. CentOS 7 won't be EOL until July 2024 so it might make sense to stay on 7 for the mean time.

https://wiki.centos.org/About/Product

2) Regarding the switch to postgres we strongly advise against it. Currently we only support some legacy implementations and our development effort is focused on mysql and it's derivatives such MariaDB. The differences between MariaDB versions shouldn't be consequential and if you're staying with the version of MariaDB installed by the CentOS' package system(yum) it should be supported.

Beyond that if you can build the new system in parallel to your existing system the XI backup/restore process makes the upgrade pretty easy:

The process is this:
- Spin up new server running EL7/EL8 latest

- Install the exact same version of XI that the old server has on the new server, no need to configure it, just install it and go through the initial setup. Do not try to restore over different versions of XI it will cause issues. Old versions of XI can be found here:

https://assets.nagios.com/downloads/nag ... rsions.php

https://assets.nagios.com/downloads/nag ... -Linux.pdf

- If you have a RAMDisk installed, are using RRDCacheD, or are running Mod_Gearman on the old system, set them up before restoring:

https://assets.nagios.com/downloads/nag ... giosXI.pdf
https://assets.nagios.com/downloads/nag ... ios-XI.pdf
https://assets.nagios.com/downloads/nag ... ios_XI.pdf

If you are monitoring vmware/oracle you'll need to reinstall the proper supporting packages on the new server again following these guides:

https://assets.nagios.com/downloads/nag ... ios-XI.pdf
https://assets.nagios.com/downloads/nag ... ios-XI.pdf

- Backup the old/transfer to new/restore to the new

- Follow the After The Restore section from the backup/restore guide completely

- Since you're changing OS versions, run the restore_repair script from the backup/restore guide

https://assets.nagios.com/downloads/nag ... ios-XI.pdf

- Shutdown (or re-IP) the old, set the old IP on the new system so you don't have to update agent configs/FW rules

https://support.nagios.com/kb/article/c ... s-549.html

That's pretty much it.

Then apply configuration and upgrade the new server to the latest XI version.

If your current system is 32-bit you need to follow this as well to migrate the performance data ( no need if you're already 64bit ):

https://support.nagios.com/kb/article.php?id=166


Thanks and Best Regards,
Keith

[nagiostpm]

Hello,

I followed all the steps but i have this issue :

Importing into the CCM failed!

Actually i have in production a nagios 5.6.12 with centos 6.

I installed a new server with REHL 8.5 (with a new IP)
I installed nagios 5.6.12 sources
Imported the bakcup from the production server.
For the moment i keep the new IP (changed in the system settings)
I desactivated all the notifications (of course, for the moment everythink is in critical state)

At this state everythink seems ok and when i applied configuration in CCM menu there is no errors.

Yet, when i lauche the update to nagios 5.8.7 i have the CCM failed at the end.

Thanks for your help

[kfanselow]

Hi nagiostpm,

Are you upgrading via the CLI or through the interface ?

Could you generate and send to me via a PM your system profile (Admin {top} > System Profile {left} -> Download Profile button) along with the following files if they exist ?

/usr/local/nagiosxi/tmp/upgrade.log
/usr/local/nagios/var/nagios.log


Thanks and Best Regards,
Keith

[nagiostpm]

Hello,

Same pb via CLI or interface.

I sent you all the files you asked for.

And i put here some errors from the upgrade.log file :

Backing up MySQL databases...
mysqldump: [Warning] Using a password on the command line interface can be insecure.
mysqldump: Error: 'Access denied; you need (at least one of) the PROCESS privilege(s) for this operation' when trying to dump tablespaces
mysqldump: [Warning] Using a password on the command line interface can be insecure.
mysqldump: Error: 'Access denied; you need (at least one of) the PROCESS privilege(s) for this operation' when trying to dump tablespaces
....
- Importing: /usr/local/nagios/etc/import/configwizard-nsclient.cfg .. ERROR
Field 'service_description' doesn't have a default value<span class="greenmessage"....

thanks

[kfanselow]

Hi nagiostpm,

It looks like you might have multiple things going on. The good news is it appears that XI did update successfully and we just need to get core and the database updated appropriately. The first appears to be a problem with a config file in your import directory. The following file appears to be the culprit:

Code: Select all

 /usr/local/nagios/etc/import/configwizard-nsclient.cfg 

Let's have you remove the file and then perform the following:

Go to Configure -> CCM -> Config File Management

Click Delete Files
Write Configs
Verify Configs

If there aren't any problems Restart Nagios Core.

The third thing we'd like you to do is run the repair_database script:

Code: Select all

 /usr/local/nagiosxi/scripts/repair_databases.sh 

Then please give the upgrade another try. If you're still encountering problems let's have you generate a new system profile and start a new ticket so we can dig into some of the specifics of your environment.

Thanks and Best Regards,
Keith

[nagiostpm]

Hi,

I followed your recommandations and everything seems going fine. The CCM failed error doesn't appears anymore on the new upgrade try.

But there is another problem. The nagiosXi interface is now empty !

Yet, all the object (+3000) are present in the ccm menu > services and on the interface of nagios core. But empty in nagiosxi home > services status...

I'll open a ticket and send the new system profile.

thx

[kfanselow]

Thanks - we'll lock the thread.