Search found 6 matches

by Scot Fackler
Tue Jun 09, 2020 5:23 pm
Forum: Nagios XI
Topic: SQL Error [nagiosxi] after upgrade to Nagios 5.7.
Replies: 9
Views: 117316

Re: SQL Error [nagiosxi] after upgrade to Nagios 5.7.

No. I opened Support Ticket #927906 due to continued ndo bind errors being see in the nagios.log. Uploaded that log and the update.log to the support ticket.
by Scot Fackler
Tue Jun 09, 2020 3:06 pm
Forum: Nagios XI
Topic: SQL Error [nagiosxi] after upgrade to Nagios 5.7.
Replies: 9
Views: 117316

Re: SQL Error [nagiosxi] after upgrade to Nagios 5.7.

Well, we figured that one out. All the devices were set to skip on the checks. Not sure why the upgrade would have done that, but we did have a failed first attempt. Anyway, it all seems to be working for the time being. The UI updater will take a while to earn my faith back.
by Scot Fackler
Tue Jun 09, 2020 3:01 pm
Forum: Nagios XI
Topic: SQL Error [nagiosxi] after upgrade to Nagios 5.7.
Replies: 9
Views: 117316

Re: SQL Error [nagiosxi] after upgrade to Nagios 5.7.

The manual upgrade resolved the display issue and the UI now shows 5.7.0. However, I am seeing a ton of checks pending and even after 20 minutes, no statuses. I stopped and restarted nagios via systemctrl and we are seeing no host or service checks updating. Tried a restart of the VM and still no jo...
by Scot Fackler
Tue Jun 09, 2020 12:32 pm
Forum: Nagios XI
Topic: SQL Error [nagiosxi] after upgrade to Nagios 5.7.
Replies: 9
Views: 117316

Re: SQL Error [nagiosxi] after upgrade to Nagios 5.7.

A refresh (including a restart of the browser and cache cleared) still shows the version 5.6.14 with the same errors. This was updated via the UI with DB errors found and rectified by a DB rebuild, then rerun of the update which was successful.
by Scot Fackler
Tue Jun 09, 2020 11:42 am
Forum: Nagios XI
Topic: SQL Error [nagiosxi] after upgrade to Nagios 5.7.
Replies: 9
Views: 117316

Re: SQL Error [nagiosxi] after upgrade to Nagios 5.7.

Update: This appears to be an authorization issue as the user number in the error changes with the user.
by Scot Fackler
Tue Jun 09, 2020 11:30 am
Forum: Nagios XI
Topic: SQL Error [nagiosxi] after upgrade to Nagios 5.7.
Replies: 9
Views: 117316

SQL Error [nagiosxi] after upgrade to Nagios 5.7.

Getting the following error in several UI dialogs blocking the display after Nagios 5.7 update: SQL Error [nagiosxi] : You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'WHERE user_id = 206' at line 3 (See Attached...