Page 1 of 1

Backend API SQL problem after update to Nagios XI 5.7.1

Posted: Thu Jun 25, 2020 6:38 am
by cekfud
Hello good people,

last week I went on an journey to upgrade Nagios XI to newest version, 5.7.1. Before that I did some exploration for end-to-end check via backend API of Nagios, and it was going smoothly.

Since upgrade with GET API method I am getting some SQL error saying me that is syntax error somewhere in the call. I get the results back just fine, but above the results I am getting an error like this, c/p of terminal output:

Code: Select all

<p><pre>SQL Error [nagiosxi] : ERROR:  syntax error at or near "objects"
LINE 1: ...-25 13:36:21','API','username',16,'API endpoint \'objects/un...
                                                             ^</pre></p>
{
    "recordcount": 23,
    "unconfigured": [results that I got]
}
Can somebody resolve this issue?

Re: Backend API SQL problem after update to Nagios XI 5.7.1

Posted: Thu Jul 16, 2020 2:53 pm
by umunix
We had the same issue after upgrading to XI 5.7.1

The issue turned out to be related to the following problem:

https://support.nagios.com/kb/article/n ... r-754.html

The resolution suggested in the article solved the error from being displayed with the JSON output from the API