Nagiosql issue

This support forum board is for support questions relating to Nagios XI, our flagship commercial network monitoring solution.
Locked
wiproltdwiv
Posts: 281
Joined: Sat Sep 08, 2012 12:52 am

Nagiosql issue

Post by wiproltdwiv »

Hi,

While working suddenly all servicegroups and its member went decrease. When i saw servicegroups.cfg size, i found it became very low that original file.
After i restore backup of servicegroup.cfg and tried to import file but i got some below errors. After that i am not able see my original servicegroups and its members. also i can not generate servicegroups report. while checking httpd log i got below log.

error-
Entry servicegroup_name::aaaa inside tbl_servicegroup successfully inserted
Error: incorrect number of arguments - cannot import service group members

http log -
[root@EMSNagios1 etc]# tail /var/log/httpd/error_log
[Thu Feb 07 17:48:42 2013] [error] [client 10.128.17.4] PHP Notice: Undefined index: objectauthperms in /usr/local/nagiosxi/html/includes/dbauth.inc.php on line 358, referer: http://10.128.17.12/nagiosxi/reports/
[Thu Feb 07 17:48:43 2013] [error] [client 10.128.17.4] PHP Notice: Undefined index: objectauthperms in /usr/local/nagiosxi/html/includes/dbauth.inc.php on line 358, referer: http://10.128.17.12/nagiosxi/reports/
[Thu Feb 07 17:48:44 2013] [error] [client 10.128.17.4] PHP Notice: Undefined index: objectauthperms in /usr/local/nagiosxi/html/includes/dbauth.inc.php on line 358, referer: http://10.128.17.12/nagiosxi/reports/execsummary.php
[Thu Feb 07 17:48:44 2013] [error] [client 10.128.17.4] PHP Notice: Undefined index: objectauthperms in /usr/local/nagiosxi/html/includes/dbauth.inc.php on line 358, referer: http://10.128.17.12/nagiosxi/reports/execsummary.php
[Thu Feb 07 17:48:45 2013] [error] [client 10.128.17.4] PHP Notice: Undefined index: objectauthperms in /usr/local/nagiosxi/html/includes/dbauth.inc.php on line 358, referer: http://10.128.17.12/nagiosxi/reports/
[Thu Feb 07 17:48:47 2013] [error] [client 10.128.17.4] PHP Notice: Undefined index: objectauthperms in /usr/local/nagiosxi/html/includes/dbauth.inc.php on line 358, referer: http://10.128.17.12/nagiosxi/reports/
[Thu Feb 07 17:48:48 2013] [error] [client 10.128.17.4] PHP Notice: Undefined index: objectauthperms in /usr/local/nagiosxi/html/includes/dbauth.inc.php on line 358, referer: http://10.128.17.12/nagiosxi/reports/
[Thu Feb 07 17:48:49 2013] [error] [client 10.128.17.4] PHP Notice: Undefined index: objectauthperms in /usr/local/nagiosxi/html/includes/dbauth.inc.php on line 358, referer: http://10.128.17.12/nagiosxi/reports/
[Thu Feb 07 17:48:49 2013] [error] [client 10.128.17.4] PHP Notice: Undefined index: objectauthperms in /usr/local/nagiosxi/html/includes/dbauth.inc.php on line 358, referer: http://10.128.17.12/nagiosxi/reports/
[Thu Feb 07 17:54:13 2013] [error] [client 10.128.17.4] PHP Fatal error: Maximum execution time of 120 seconds exceeded in /usr/local/nagiosxi/html/includes/fpdf/pdftable/lib/pdftable.inc.php on line 120, referer: http://10.128.17.12/nagiosxi/reports/eventlog.php
Top
yancy
Posts: 523
Joined: Thu Oct 06, 2011 10:12 am

Re: Nagiosql issue

Post by yancy »

wiproltdwiv,

please provide details on the steps you used to restore servicegroup.cfg


Thanks,

-Yancy
Top
mguthrie
Posts: 4380
Joined: Mon Jun 14, 2010 10:21 am

Re: Nagiosql issue

Post by mguthrie »

Can you try restoring your config by using the Admin->Config Snapshots page? This will roll back the configuration database, and allow you to Apply Configuration from a previous working snapshot.
Top
wiproltdwiv
Posts: 281
Joined: Sat Sep 08, 2012 12:52 am

Re: Nagiosql issue

Post by wiproltdwiv »

i restored, now i can see all servicegroups and its members, but i am not getting servicegroup reports. Host or Hostgroup report i am getting.
Top
mguthrie
Posts: 4380
Joined: Mon Jun 14, 2010 10:21 am

Re: Nagiosql issue

Post by mguthrie »

What version of Nagios Xi are you currently using?
Top
wiproltdwiv
Posts: 281
Joined: Sat Sep 08, 2012 12:52 am

Re: Nagiosql issue

Post by wiproltdwiv »

please find the system profile
You do not have the required permissions to view the files attached to this post.
Top
slansing
Posts: 7698
Joined: Mon Apr 23, 2012 4:28 pm
Location: Travelling through time and space...

Re: Nagiosql issue

Post by slansing »

What reports are you looking at that you are not able to get results on? Servicegroup Overview, Summary, Usage Reports, etc?

Can you also tail the http error log and send the results back to us here?:

Code: Select all

tail /var/log/httpd/error_log
Top
wiproltdwiv
Posts: 281
Joined: Sat Sep 08, 2012 12:52 am

Re: Nagiosql issue

Post by wiproltdwiv »

We are not getting servicegroup availability reports

[root@EMSNagios1 ~]# tail /var/log/httpd/error_log
[Wed Feb 13 10:33:56 2013] [error] Exception KeyError: KeyError(140467521882080,) in <module 'threading' from '/usr/lib64/python2.6/threading.pyc'> ignored
[Wed Feb 13 10:34:00 2013] [error] Exception KeyError: KeyError(140467521882080,) in <module 'threading' from '/usr/lib64/python2.6/threading.pyc'> ignored
[Wed Feb 13 10:34:41 2013] [error] Exception KeyError: KeyError(140467521882080,) in <module 'threading' from '/usr/lib64/python2.6/threading.pyc'> ignored
[Wed Feb 13 10:35:06 2013] [error] Exception KeyError: KeyError(140467521882080,) in <module 'threading' from '/usr/lib64/python2.6/threading.pyc'> ignored
[Wed Feb 13 10:40:19 2013] [error] [client 10.128.17.4] PHP Notice: Undefined index: objectauthperms in /usr/local/nagiosxi/html/includes/dbauth.inc.php on line 358, referer: http://10.128.17.12/nagiosxi/reports/execsummary.php
[Wed Feb 13 10:40:20 2013] [error] [client 10.128.17.4] PHP Notice: Undefined index: objectauthperms in /usr/local/nagiosxi/html/includes/dbauth.inc.php on line 358, referer: http://10.128.17.12/nagiosxi/reports/execsummary.php
[Wed Feb 13 10:40:21 2013] [error] [client 10.128.17.4] PHP Notice: Undefined index: objectauthperms in /usr/local/nagiosxi/html/includes/dbauth.inc.php on line 358, referer: http://10.128.17.12/nagiosxi/reports/execsummary.php
[Wed Feb 13 10:41:03 2013] [error] [client 10.128.17.4] PHP Notice: Undefined index: objectauthperms in /usr/local/nagiosxi/html/includes/dbauth.inc.php on line 358, referer: http://10.128.17.12/nagiosxi/reports/ex ... =BSCB+Bank
[Wed Feb 13 10:45:47 2013] [error] [client 10.128.17.4] PHP Notice: Undefined index: objectauthperms in /usr/local/nagiosxi/html/includes/dbauth.inc.php on line 358, referer: http://10.128.17.12/nagiosxi/reports/ex ... =BSCB+Bank
[Wed Feb 13 10:45:47 2013] [error] [client 10.128.17.4] PHP Notice: Undefined index: objectauthperms in /usr/local/nagiosxi/html/includes/dbauth.inc.php on line 358, referer: http://10.128.17.12/nagiosxi/reports/ex ... =BSCB+Bank
Top
slansing
Posts: 7698
Joined: Mon Apr 23, 2012 4:28 pm
Location: Travelling through time and space...

Re: Nagiosql issue

Post by slansing »

I believe an upgrade to the latest version of Xi, 2012 1.6 should fix this. This was reported as a bug previously, and when upgraded to 1.6 the system returned to normal.

Also, if you can not upgrade to 2012 1.6, please show the output of this:

Code: Select all

ll /usr/local/nagiosxi/html/includes/
Top
wiproltdwiv
Posts: 281
Joined: Sat Sep 08, 2012 12:52 am

Re: Nagiosql issue

Post by wiproltdwiv »

Thanks for support,

This solution we have already tried and now it working fine.
Top
Locked

Return to “Nagios XI”