Nagios Support Forum

Hi Team,

While performing upgrade from Nagios XI 5.6.14 to 5.7.4 , we are getting stuck in upgrade steps and its exiting without proper upgrade.

Also, the Nagios XI license is getting removed & its reflecting as expired. Please check attached logs and screenshots and help us to fix it.

Error details:
/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...
2.1.2
Failed to stop ndo2db.service: Unit ndo2db.service not loaded.
]0;root@eu1papu002:/tmp/nagiosxiYou have mail in /var/spool/mail/root
[root@eu1papu002 nagiosxi]#

HI,

Let's open up the configuration file for nagios and make sure the system is loading the new database broker module, ndo3.

Open up /usr/local/nagios/etc/nagios.cfg and make sure this line is commented: Make sure this line is uncommented: Then start the nagios service: Next Run the following command to test if this server is using postgres for the nagiosxi database. If this outputs a number 2, then the error in the user interface looks like the following issue. Please follow the steps in the article and let me know if the issue is resolved. If not please send me your system profile. Thanks, Benjamin

Nagios XI - SQL Error [nagiosxi] : ERROR: syntax error

To send us your system profile.
Login to the Nagios XI GUI using a web browser.
Click the "Admin" > "System Profile" Menu
Click the "Download Profile" button
Save the profile.zip file and share in a private message or upload it to the post/ticket, and then reply to this post to bring it up in the queue.