Page 1 of 1

SQL error when ack alerts

Posted: Fri Sep 15, 2017 9:43 am
by btemple
We started to receive this error possibly after the update to 5.4.8

SQL Error [nagiosxi] : ERROR: syntax error at or near "Critical"
LINE 1: ...,8,'User acknowledged problem state for service \'Critical C...
^
Problem Acknowledged

What next?

View Service Details
Go to the Nagios dashboard

Re: SQL error when ack alerts

Posted: Fri Sep 15, 2017 1:44 pm
by tgriep
If the Nagios server is running a newer version of Postgress, an option has to be changed in the Postgress configuration file to fix that error.
Take a look at this KB article for the instructions to fix this.
https://support.nagios.com/kb/article/n ... error.html

Re: SQL error when ack alerts

Posted: Tue Sep 19, 2017 9:46 am
by btemple
Article steps resolved the issue please close and thank you !