Upgrade from 5.8.10 to latest

[keiferb]

Hello,

I'm getting errors when trying to upgrade from 5.8.10 to the latest version of Nagios XI.

Per this page, I've used the linked instructions to attempt the upgrade.

The end of the upgrade output is below. Please let me know what my next steps should be. Happy to PM a system profile as well.

Code: Select all

make[1]: Leaving directory '/tmp/nagiosxi/subcomponents/ndo/ndo-3.1.0/src'
cd src/ && make ndo.so
make[1]: Entering directory '/tmp/nagiosxi/subcomponents/ndo/ndo-3.1.0/src'
make[1]: 'ndo.so' is up to date.
make[1]: Leaving directory '/tmp/nagiosxi/subcomponents/ndo/ndo-3.1.0/src'
/usr/bin/install -c -m 774 -o nagios -g nagios src/ndo.so /usr/local/nagios/bin/ndo.so
Shared module ndo.so installed
/usr/local/nagios/etc/nagios.cfg configured to use NDO
UPGRADE: POST-UPGRADE: NDO post upgrade started...
Performing upgrade...
 > Upgrading from version 3.0.7 (/tmp/nagiosxi/subcomponents/ndo/ndo-3.1.0/db/upgrade-from-3.0.7.sql)
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1292 (22007) at line 1: Incorrect datetime value: '0000-00-00 00:00:00' for column 'actual_start_time' at row 23
Automated migration failed on file upgrade-from-3.0.7.sql!
The 'nagios' database is not in a usable configuration.
Please revert to your pre-upgrade snapshot and reach out to the Support Team.

[keiferb]

Additionally, I'm getting the error "Object Does Not Exist" when I click on any host or service within CCM.

[gwesterman]

Hi @keiferb,

From this similar support question and this document, I recommend trying the following:

Run through the database repair:
- Run:

Code: Select all

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

- Go to your XI -> Configure -> Core Config Manager -> Config File Management -> [Delete Files], [Write Files], [Verify Files] -> Apply Configuration
- Run:

Code: Select all

systemctl restart nagios

- Run:

Code: Select all

/usr/local/nagios/bin/nagios -v /usr/local/nagios/etc/nagios.cfg

to verify everything looks good in pre-flight.

It may be worth trying the steps outlined here as well, but certainly try the above first.