Fused Nagios XI server stopped displaying

[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!***

[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!

[cbeattie-unitrends]

Thanks! We can cope with it until the next version of Fusion is available.

[cdienger]

Are we okay closing this thread?

[cbeattie-unitrends]

Yes, you can close this thread, please.