Page 1 of 2
Single service problem that won't show on Fusion
Posted: Wed Jun 18, 2014 9:15 am
by 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?
Re: Single service problem that won't show on Fusion
Posted: Wed Jun 18, 2014 10:49 am
by lmiltchev
Has the problem been acknowledged? Can you show us a screenshot of this service in XI (Home->Service Detail)?
Re: Single service problem that won't show on Fusion
Posted: Wed Jun 18, 2014 11:32 am
by vAJ
vstats32_memory.JPG
It's not acked.
ops_center.JPG
open_svc_issues.JPG
Re: Single service problem that won't show on Fusion
Posted: Wed Jun 18, 2014 1:23 pm
by 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?
Re: Single service problem that won't show on Fusion
Posted: Wed Jun 18, 2014 2:15 pm
by 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.
Re: Single service problem that won't show on Fusion
Posted: Wed Jun 18, 2014 4:15 pm
by 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
Re: Single service problem that won't show on Fusion
Posted: Wed Jun 18, 2014 4:20 pm
by 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...
Re: Single service problem that won't show on Fusion
Posted: Wed Jun 18, 2014 4:52 pm
by 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
Re: Single service problem that won't show on Fusion
Posted: Wed Jun 18, 2014 4:57 pm
by vAJ
That did the trick. I can see it in OC now.
Thanks!
Re: Single service problem that won't show on Fusion
Posted: Wed Jun 18, 2014 4:58 pm
by slansing
Awesome, are we good to lock this up?