Nagios Support Forum

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

wiproltdwiv,

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


Thanks,

-Yancy

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.

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.

What version of Nagios Xi are you currently using?

please find the system profile

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?:

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

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:

Thanks for support,

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