Page 1 of 1

Upgrade Nagios xi from 5.6.14 to 5.8.2 version

Posted: Tue Mar 16, 2021 7:13 am
by occ
Good Evening,
We need to update the our nagiosxi server to version 5.8.2 from 5.6.14 version.
Unfortunately, we do not have a test environment on which to perform upgrade tests. Can you tell us a procedure that minimizes the risks?
Any specific information about our system that you need to know?
I can anticipate that we use the mod_gearman.

Thank you for your availability

Re: Upgrade Nagios xi from 5.6.14 to 5.8.2 version

Posted: Tue Mar 16, 2021 4:11 pm
by benjaminsmith
Hi @occ,

It's a pretty smooth transition from 5.6.14 to 5.8.2 assuming this system isn't heavily customized and is not currently experiencing any issue (e.g load or slowness).

If possible, I highly recommend setting up a test server for any major and minor updates to XI.

You'll want to take a full backup before proceeding and if possible a VM snapshot.

Let us know if you have more questions.

Documentation
Backing Up And Restoring Your Nagios XI System
Nagios XI Upgrade Instructions

Re: Upgrade Nagios xi from 5.6.14 to 5.8.2 version

Posted: Tue Mar 16, 2021 6:30 pm
by inversecow
Ahoy @occ,

I did this just last week with one of my PROD XI ENVs (5.6.14 --> 5.8.1 in my case, since 5.8.2 is not in the Nagios repos yet).

Glad to report this largely went off OK.
There are two primary "gotcahs" I can think of (2nd one has "bit me" upon every upgrade attempt of going from 5.6.x to 5.7.x series, and 5.8.x thus far):

1.) verify your config has been updated for the new broker (ndo2db --> ndo3)

`grep 'broker_module' /usr/local/nagios/etc/nagios.cfg`

Should return:
```
broker_module=/usr/local/nagios/bin/ndo.so /usr/local/nagios/etc/ndo.cfg
```

If not, review and fix the configs, restart `nagios` and re-verify.
2.) watch your APP logs for a dB error (also shows up when the monitors are not "updating" their status)

```
[1600091657] NDO-3: ndo_handle_service_status(ndo-handlers.c:953): Could not reconnect to MySQL database
[1600091658] NDO-3: Unable to prepare statement for query (27): Unknown column 'check_options' in 'field list'
[1600091658] NDO-3: Unable to prepare statement for query (28): Unknown column 'check_options' in 'field list'
[1600091658] NDO-3: Error preparing statements
```

[fix detailed here](https://support.nagios.com/forum/viewto ... 16&t=60062)

If you have your dB "off-box", make sure you are not using it to "share" with other Nagios dBs (can be only one `nagios`, `nagiosxi`, `nagiosql`).
If there are multiple, things get confused and one of your ENVs will be left in a bad state.

Good luck! :-)

Re: Upgrade Nagios xi from 5.6.14 to 5.8.2 version

Posted: Wed Mar 17, 2021 4:11 am
by occ
Hi,
thanks both for the answers.
About mod-gearman, it is mandatory to update? and what is the latest supported version?

Regards

Re: Upgrade Nagios xi from 5.6.14 to 5.8.2 version

Posted: Wed Mar 17, 2021 2:32 pm
by lmiltchev
This would depend on the version of Nagios Core that you are currently using. I believe all of the information you need is listed in the document below:

https://assets.nagios.com/downloads/nag ... ios_XI.pdf