Single service problem that won't show on Fusion

[vAJ]

I've got a weird issue with one service problem on an XI instance (2014r1.1) that won't show on the Fusion OC screen.

I get other newer service problems from that instance, but still doesn't show one that is currently showing a warning status on the XI instance...

Should I restart DB backend on that XI instance?

[lmiltchev]

Has the problem been acknowledged? Can you show us a screenshot of this service in XI (Home->Service Detail)?

[vAJ]

vstats32_memory.JPG

It's not acked.

ops_center.JPG

open_svc_issues.JPG

[lmiltchev]

Run the following commands on the Nagios XI server:

Code: Select all

service nagios stop
killall nagios
service ndo2db stop
service ndo2db start
service nagios start

Let me know if this fixed your issue.

BTW, in Nagios Fusion, when you go to Home->Tactical Overview and click on the "Warning" link to "drill down" your XI server, do you see the "Current Memory Usage" service?

[vAJ]

The restarts didn't help. I left it for 10 minutes after the restarts with no change. I also tried a passive check result to clear it and reset. No dice.

Scratch that. I can see it on the tactical overview, but still doesn't show in the Ops Center.

[lmiltchev]

Is there any useful info in the logs on the Fusion box?

Code: Select all

tail -50 /var/log/httpd/error_log
tail -50 /usr/local/nagiosfusion/var/components/noc.log

[vAJ]

error_log:

Code: Select all

[Wed Jun 18 04:02:34 2014] [error] [client 10.20.44.18] PHP Notice:  Undefined index: user_id in /usr/local/nagiosfusion/html/includes/utils-dashboards.inc.php on line 14, referer: http://fusion.ads.volusion.com/nagiosfusion/login.php?redirect=/nagiosfusion/index.php%3f
[Wed Jun 18 13:37:10 2014] [error] [client 10.20.40.117] PHP Notice:  Undefined index: user_id in /usr/local/nagiosfusion/html/includes/utils-dashboards.inc.php on line 14
[Wed Jun 18 13:43:20 2014] [error] [client 10.20.44.112] PHP Notice:  Undefined index: user_id in /usr/local/nagiosfusion/html/includes/utils-dashboards.inc.php on line 14
[Wed Jun 18 14:01:51 2014] [error] [client 10.20.44.112] PHP Notice:  Undefined index: user_id in /usr/local/nagiosfusion/html/includes/utils-dashboards.inc.php on line 14

But the noc log is more forthcoming:

Code: Select all

SQL: INSERT INTO fusion_noc
                (server_sid,type,host,service,status_update_time,status,output)
                VALUES ('j58mpi',1,'vstats32','Current Memory Usage','2014-06-18 21:16:46','1','WARNING: physical memory: Total: 4G - Used: 3.3G (82%) - Free: 712M (18%) > warning, virtual memory: Total: 8T - Used: 83.2M (0%) - Free: 8T (100%), paged bytes: Total: 8G - Used: 3.01G (37%) - Free: 4.98G (63%), page file: Total: 8G - Used: 3.01G (37%) -')    SQL Error [nagiosfusion] :</b> ERROR:  value too long for type character varying(255)5 unhandled problems saved to DB

Looks like the check return is too long for the field constraint...

[lmiltchev]

You can probably try to increase the column size:

Code: Select all

psql nagiosfusion nagiosfusion
ALTER TABLE fusion_noc ALTER COLUMN output TYPE character varying(2000);
\q

[vAJ]

That did the trick. I can see it in OC now.

Thanks!

[slansing]

Awesome, are we good to lock this up?