Upgrade Nagios xi from 5.6.14 to 5.8.2 version

This support forum board is for support questions relating to Nagios xi, our flagship commercial network monitoring solution.
occ
Posts: 30
Joined: Fri Jan 11, 2019 5:05 am

Upgrade Nagios xi from 5.6.14 to 5.8.2 version

Post 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
benjaminsmith
Posts: 5324
Joined: Wed Aug 22, 2018 4:39 pm
Location: saint paul

Re: Upgrade Nagios xi from 5.6.14 to 5.8.2 version

Post 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
As of May 25th, 2018, all communications with Nagios Enterprises and its employees are covered under our new Privacy Policy.

Be sure to check out our Knowledgebase for helpful articles and solutions!
User avatar
inversecow
Posts: 44
Joined: Wed Sep 25, 2019 4:17 pm

Re: Upgrade Nagios xi from 5.6.14 to 5.8.2 version

Post 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! :-)
“And who better understands the Unix-nature?” Master Foo asked.
“Is it he who writes the ten thousand lines, or he who, perceiving the emptiness of the task, gains merit by not coding?”
Master Foo - The ten thousand Lines
Unix Koans of Master Foo
occ
Posts: 30
Joined: Fri Jan 11, 2019 5:05 am

Re: Upgrade Nagios xi from 5.6.14 to 5.8.2 version

Post by occ »

Hi,
thanks both for the answers.
About mod-gearman, it is mandatory to update? and what is the latest supported version?

Regards
User avatar
lmiltchev
Former Nagios Staff
Posts: 13589
Joined: Mon May 23, 2011 12:15 pm

Re: Upgrade Nagios xi from 5.6.14 to 5.8.2 version

Post 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
Be sure to check out our Knowledgebase for helpful articles and solutions!