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
Upgrade Nagios xi from 5.6.14 to 5.8.2 version
-
- 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
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
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!
Be sure to check out our Knowledgebase for helpful articles and solutions!
-
- Posts: 44
- Joined: Wed Sep 25, 2019 4:17 pm
Re: Upgrade Nagios xi from 5.6.14 to 5.8.2 version
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!
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
“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
-
- Posts: 30
- Joined: Fri Jan 11, 2019 5:05 am
Re: Upgrade Nagios xi from 5.6.14 to 5.8.2 version
Hi,
thanks both for the answers.
About mod-gearman, it is mandatory to update? and what is the latest supported version?
Regards
thanks both for the answers.
About mod-gearman, it is mandatory to update? and what is the latest supported version?
Regards
-
- 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
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
https://assets.nagios.com/downloads/nag ... ios_xi.pdf
Be sure to check out our Knowledgebase for helpful articles and solutions!