Backend API SQL problem after update to Nagios XI 5.7.1

Support forum for Nagios Core, Nagios Plugins, NCPA, NRPE, NSCA, NDOUtils and more. Engage with the community of users including those using the open source solutions.
Locked
cekfud
Posts: 1
Joined: Wed Jul 17, 2019 9:25 am

Backend API SQL problem after update to Nagios XI 5.7.1

Post 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?
umunix
Posts: 21
Joined: Thu Dec 12, 2013 1:43 pm

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

Post 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
Locked