Search found 6 matches
- 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.
- 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.
- 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...
- 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.
- 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.
- 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...