Backend API SQL problem after update to Nagios XI 5.7.1

Engage with the community of users including those using the open source solutions.
Includes Nagios Core, Plugins, and NCPA

Backend API SQL problem after update to Nagios XI 5.7.1

Postby cekfud » Thu Jun 25, 2020 6:38 am

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?
cekfud
 
Posts: 1
Joined: Wed Jul 17, 2019 9:25 am

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

Postby umunix » Thu Jul 16, 2020 2:53 pm

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


Return to Community Support

Who is online

Users browsing this forum: No registered users and 13 guests