Fused Nagios xi server stopped displaying

This support forum board is for questions relating to Nagios Fusion.
cbeattie-unitrends
Posts: 84
Joined: Mon Oct 10, 2016 2:51 pm

Fused Nagios xi server stopped displaying

Post by cbeattie-unitrends »

The other day, one of my fused xi servers stopped getting displayed in Fusion. It had been working for months before it stopped. I deleted the fused xi server and re-added it, re-entered the credentials, still no joy. However, when I switched it to use Nagios Core in Fusion (and changed its URL from /nagiosxi/ to /nagios/), it started working again.

Nagios Fusion 2014R1.1 on CentOS 7
Both the non-displaying server and one other working server are Nagios xi 5.3.3 on CentOS 7.
If it makes a difference, den (not displaying) has 23598 services, lal (displaying) has 16607 services, and cae (also working) has just 17.

I looked at /usr/local/nagiosfusion/var/poller.log and found some errors:

Code: Select all

Polling Recent Alerts...
NAGIOSxi ALERT FETCH den
COUNT :396
NAGIOSxi ALERT FETCH lal
COUNT :22
NAGIOSCORE ALERT FETCHcae
COUNT :0
2 callbacks run
Loop time: 32 seconds
.***GET DATA!***
RUNTIME: 79 INTERVAL: 10 POLL INTERVAL: 10
PHP Warning:  simplexml_load_string(): Entity: line 2: parser error : Start tag expected, '<' not found in /usr/local/nagiosfusion/html/includes/utils-tacdata.inc.php on line 69
PHP Notice:  Undefined index: SERVER_PORT in /usr/local/nagiosfusion/html/includes/utils.inc.php on line 581
PHP Notice:  Undefined index: SERVER_PORT in /usr/local/nagiosfusion/html/includes/utils.inc.php on line 582
PHP Notice:  Undefined index: SERVER_NAME in /usr/local/nagiosfusion/html/includes/utils.inc.php on line 586
Saving Tac Data to DB: den
        SQL: INSERT INTO fusion_tac_data (server_id,server_sid,server_name,last_update_time,error,error_message)
                                                        VALUES (0,'o7c3tg','den',1,NOW(),1,'1','<span class="tacserverparseerror"><img src="http://:/nagiosfusion/images/critical_small.png"> Unable to parse server response.</span>') SQL Error [nagiosfusion] :</b> ERROR:  INSERT has more expressions than target columns
LINE 2:        VALUES (0,'o7c3tg','den',1,NOW(),1,'1','<span class="...
                                                  ^Saving Tac Data to DB: lal
PHP Notice:  Undefined index: query in /usr/local/nagiosfusion/html/includes/utilsx.inc.php on line 80
Saving Tac Data to DB: cae
Polling Recent Alerts...
NAGIOSxi ALERT FETCH den
COUNT :402
NAGIOSxi ALERT FETCH lal
COUNT :22
NAGIOSCORE ALERT FETCHcae
COUNT :0
2 callbacks run
Loop time: 32 seconds
After changing den to Nagios Core in Fusion, poller.log looked like this:

Code: Select all

...***GET DATA!***
RUNTIME: 224 INTERVAL: 30 POLL INTERVAL: 30
PHP Notice:  Undefined index: query in /usr/local/nagiosfusion/html/includes/utilsx.inc.php on line 80
Saving Tac Data to DB: den
Saving Tac Data to DB: lal
PHP Notice:  Undefined index: query in /usr/local/nagiosfusion/html/includes/utilsx.inc.php on line 80
Saving Tac Data to DB: cae
Polling Recent Alerts...
NAGIOSCORE ALERT FETCHden
COUNT :415
NAGIOSxi ALERT FETCH lal
COUNT :17
NAGIOSCORE ALERT FETCHcae
COUNT :0
2 callbacks run
Loop time: 17 seconds
...***GET DATA!***
Top
User avatar
mcapra
Posts: 3739
Joined: Thu May 05, 2016 3:54 pm

Re: Fused Nagios xi server stopped displaying

Post by mcapra »

I identified this as a bug in your version of Nagios Fusion. For the time being, if keeping it listed as a Core machine is ok with you, we'll stick with that as the fix. Basically, there's some SQL on the back-end that's doing things it shouldn't be doing. I've verified that this particular bug isn't present in the current beta version of Nagios Fusion 4.

Apologies for the inconvenience. Let us know if you have additional questions regarding this!
Former Nagios employee
https://www.mcapra.com/
Top
cbeattie-unitrends
Posts: 84
Joined: Mon Oct 10, 2016 2:51 pm

Re: Fused Nagios xi server stopped displaying

Post by cbeattie-unitrends »

Thanks! We can cope with it until the next version of Fusion is available.
Top
User avatar
cdienger
Support Tech
Posts: 5045
Joined: Tue Feb 07, 2017 11:26 am

Re: Fused Nagios xi server stopped displaying

Post by cdienger »

Are we okay closing this thread?
As of May 25th, 2018, all communications with Nagios Enterprises and its employees are covered under our new Privacy Policy.
Top
cbeattie-unitrends
Posts: 84
Joined: Mon Oct 10, 2016 2:51 pm

Re: Fused Nagios xi server stopped displaying

Post by cbeattie-unitrends »

Yes, you can close this thread, please.
Top

Return to “Nagios Fusion”