There are no blank entries in the service group.
1) Can i check this from the database side and possibly delete something from there?
2) Can i export the servicegroup to a text file, rename the servicegroup and try to import it back in via import config files? Would that work? As there are no blank entries and links to previous deleted services it should recreate the servicegroup correctly.
servicegroup member status not shown
Re: servicegroup member status not shown
1.
First you would have to dump the service group names to get the id number associated with the name by running the following.
Example of the output
Next you would have to dump the services table to get the same info
Example of the output
Next you would have to dump the service to service group link table to get the id numbers for the services that are in the group
The idMaster field is the link to the hostgroup
The idSlaveS field is the link to the service you would have to go through to verify if it is valid and remove the invalid links if there are any.
2. Reimporting the servicegroup would probably work as well. You can find the existing group in this file
Copy out the group in to another file, rename the group and import it.
Try it out and if you have any more questions, let us know.
First you would have to dump the service group names to get the id number associated with the name by running the following.
Code: Select all
echo 'select * from tbl_servicegroup;' |mysql -u root -pnagiosxi nagiosql -tCode: Select all
+----+----------------------+----------------------+---------+----------------------+-------+-----------+------------+--------+---------------------+---------------+-----------+
| id | servicegroup_name | alias | members | servicegroup_members | notes | notes_url | action_url | active | last_modified | access_rights | config_id |
+----+----------------------+----------------------+---------+----------------------+-------+-----------+------------+--------+---------------------+---------------+-----------+
| 2 | SNMPTraps | SNMPTraps | 1 | 0 | | | | 1 | 2016-05-23 16:00:46 | NULL | 1 |
| 3 | WindowsServiceGroup | WindowsServiceGroup | 1 | 0 | | | | 1 | 2015-09-22 17:52:08 | NULL | 1 |Code: Select all
echo 'select * from tbl_service;' |mysql -u root -pnagiosxi nagiosql -tCode: Select all
| id | config_name | host_name | host_name_tploptions | hostgroup_name | hostgroup_name_tploptions | service_description | display_name | servicegroups | servicegroups_tploptions | use_template | use_template_tploptions | check_command | is_volatile | initial_state | max_check_attempts | check_interval | retry_interval | active_checks_enabled | passive_checks_enabled | check_period | parallelize_check | obsess_over_service | check_freshness | freshness_threshold | event_handler | event_handler_enabled | low_flap_threshold | high_flap_threshold | flap_detection_enabled | flap_detection_options | process_perf_data | retain_status_information | retain_nonstatus_information | notification_interval | first_notification_delay | notification_period | notification_options | notifications_enabled | contacts | contacts_tploptions | contact_groups | contact_groups_tploptions | stalking_options | notes | notes_url | action_url | icon_image | icon_image_alt | use_variables | name | active | last_modified | access_rights | config_id |
+------+--------------------------------------+-----------+----------------------+----------------+---------------------------+------------------------------------------------------------+----------------------------------------------------------------------------------------------------------------------------------------------+---------------+--------------------------+--------------+-------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-------------+---------------+--------------------+----------------+----------------+-----------------------+------------------------+--------------+-------------------+---------------------+-----------------+---------------------+---------------+-----------------------+--------------------+---------------------+------------------------+------------------------+-------------------+---------------------------+------------------------------+-----------------------+--------------------------+---------------------+----------------------+-----------------------+----------+---------------------+----------------+---------------------------+------------------+-------------+--------------------------------------------+------------------+----------------+----------------+---------------+------+--------+---------------------+---------------+-----------+
| 1 | localhost | 1 | 2 | 0 | 2 | PING Downtime Test | | 0 | 2 | 1 | 2 | 17!100.0,20%!500.0,60%!!!!!! | 2 | | NULL | NULL | NULL | 2 | 2 | 0 | 2 | 2 | 2 | NULL | 0 | 2 | NULL | NULL | 2 | | 2 | 2 | 2 | NULL | NULL | 0 | | 2 | 1 | 2 | 0 | 2 | | | | | | | 0 | | 1 | 2016-02-23 09:59:39 | NULL | 1 |
| 2 | localhost | 1 | 2 | 0 | 2 | Root Partition | | 0 | 2 | 1 | 2 | 191!7%!3%!!!!!! | 2 | | 1 | 1 | 1 | 2 | 2 | 0 | 2 | 2 | 2 | NULL | 0 | 2 | NULL | NULL | 2 | | 2 | 2 | 2 | NULL | NULL | 0 | | 1 | 1 | 2 | 0 | 2 | | | | | | | 0 | | 1 | 2017-03-10 09:02:03 | NULL | 1 |
| 3 | localhost | 1 | 2 | 0 | 2 | Current Users | | 0 | 2 | 1 | 2 | 8!20!50 | 2 | | NULL | NULL | NULL | 2 | 2 | 0 | 2 | 2 | 2 | NULL | 0 | 2 | NULL | NULL | 2 | | 2 | 2 | 2 | NULL | NULL | 0 | | 2 | 1 | 2 | 0 | 2 | | | | | | | 0 | | 1 | 2016-05-13 12:20:53 | NULL | 1 |
| 4 | localhost | 1 | 2 | 0 | 2 | Total Processes | | 0 | 2 | 1 | 2 | 7!250!400!RSZDT | 2 | | NULL | NULL | NULL | 2 | 2 | 0 | 2 | 2 | 2 | NULL | 0 | 2 | NULL | NULL | 2 | | 2 | 2 | 2 | NULL | NULL | 0 | | 2 | 1 | 2 | 0 | 2 | | | | | | | 0 | | 1 | 2016-02-12 09:10:11 | NULL | 1 |
| 5 | localhost | 1 | 2 | 0 | 2 | Current Load | Alias | 0 | 2 | 1 | 2 | 6!5.0,4.0,3.0!10.0,6.0,4.0!!!!!! | 2 | | NULL | NULL | NULL | 2 | 2 | 0 | 2 | 2 | 2 | NULL | 0 | 2 | NULL | NULL | 2 | | 2 | 2 | 2 | NULL | NULL | 0 | | 2 | 1 | 2 | 0 | 2 | | | | | | | 0 | | 1 | 2016-02-12 09:10:11 | NULL | 1 |
| 6 | localhost | 1 | 2 | 0 | 2 | Swap Usage | | 0 | 2 | 1 | 2 | 9!20!10 | 2 | | NULL | NULL | NULL | 2 | 2 | 0 | 2 | 2 | 2 | NULL | 0 | 2 | NULL | NULL | 2 | | 2 | 2 | 2 | NULL | NULL | 0 | | 2 | 1 | 2 | 0 | 2 | | | Next you would have to dump the service to service group link table to get the id numbers for the services that are in the group
Code: Select all
echo 'select * from tbl_lnkServicegroupToService;' |mysql -u root -pnagiosxi nagiosql -t Code: Select all
+----------+----------+-----------+----------+
| idMaster | idSlaveH | idSlaveHG | idSlaveS |
+----------+----------+-----------+----------+
| 2 | 2 | 0 | 418 |
| 2 | 42 | 0 | 473 |
| 4 | 5 | 0 | 68 |
| 4 | 7 | 0 | 79 |
| 4 | 2064 | 0 | 974 |
| 5 | 1 | 0 | 421 |
| 5 | 4083 | 0 | 1053 |
| 6 | 24 | 0 | 845 |
+----------+----------+-----------+----------+The idSlaveS field is the link to the service you would have to go through to verify if it is valid and remove the invalid links if there are any.
2. Reimporting the servicegroup would probably work as well. You can find the existing group in this file
Code: Select all
/usr/local/nagios/etc/servicegroups.cfgTry it out and if you have any more questions, let us know.
Be sure to check out our Knowledgebase for helpful articles and solutions!
Re: servicegroup member status not shown
1) Took servicegroup file, deleted everything else from that, changed name for servicegroup and tried to import that file, it said 1 file imported, but when restarting nagios, nothing was changed, no new servicegroup was created.
2) Found another servicegroup that had the same issue. I could correct it with adding members to the group. After that the servicegroup member count didnt change.
3) Problem remains with the servicegroup that i reallty need and that holds over 1200 services. Beside the fact that the members count changes, i also can not add members to that servicegroup. Open servicegroup, assign membership. If i add members to the group and save, nothing is actually done, nagios doesn't recognize changes and doesnt show me that i have changes and i need to apply configuration. Even if i apply changes, the new services wount be on the servicegroup.
2) Found another servicegroup that had the same issue. I could correct it with adding members to the group. After that the servicegroup member count didnt change.
3) Problem remains with the servicegroup that i reallty need and that holds over 1200 services. Beside the fact that the members count changes, i also can not add members to that servicegroup. Open servicegroup, assign membership. If i add members to the group and save, nothing is actually done, nagios doesn't recognize changes and doesnt show me that i have changes and i need to apply configuration. Even if i apply changes, the new services wount be on the servicegroup.
Re: servicegroup member status not shown
What version of Nagios XI is the server running?
Can you run the following commands on the Nagios server and post the output so I can verify the settings for the MYSQL tables?
Then run these as well to see if there is a possible time issue on the server.
Can you run the following commands on the Nagios server and post the output so I can verify the settings for the MYSQL tables?
Code: Select all
echo 'desc tbl_servicegroup;' |mysql -u root -pnagiosxi nagiosql -t
echo 'desc tbl_service;' |mysql -u root -pnagiosxi nagiosql -t
echo 'desc tbl_lnkServicegroupToService;' |mysql -u root -pnagiosxi nagiosql -t
echo 'desc tbl_lnkServiceToHost;' |mysql -u root -pnagiosxi nagiosql -t
echo 'select * from tbl_servicegroup;' |mysql -u root -pnagiosxi nagiosql -tCode: Select all
grep "date.timezone" /etc/php.ini
ls -l /etc/localtime
php -r 'echo date("D M j G:i:s T Y")."\n";'
date
echo "SELECT NOW();" | mysql -u root -pnagiosxiBe sure to check out our Knowledgebase for helpful articles and solutions!
Re: servicegroup member status not shown
NagiosXI Installed Version: 5.4.4
Date and timezones are correct, output of the commands is following (for the servicegroups, i deleted all but the problematic one)
+----------------------+---------------------+------+-----+-------------------+-----------------------------+
| Field | Type | Null | Key | Default | Extra |
+----------------------+---------------------+------+-----+-------------------+-----------------------------+
| id | int(10) unsigned | NO | PRI | NULL | auto_increment |
| servicegroup_name | varchar(255) | NO | MUL | NULL | |
| alias | varchar(255) | NO | | NULL | |
| members | tinyint(3) unsigned | NO | | 0 | |
| servicegroup_members | tinyint(3) unsigned | NO | | 0 | |
| notes | varchar(255) | YES | | NULL | |
| notes_url | varchar(255) | YES | | NULL | |
| action_url | varchar(255) | YES | | NULL | |
| active | enum('0','1') | NO | | 1 | |
| last_modified | timestamp | NO | | CURRENT_TIMESTAMP | on update CURRENT_TIMESTAMP |
| access_rights | varchar(8) | YES | | NULL | |
| config_id | tinyint(3) unsigned | NO | | 0 | |
+----------------------+---------------------+------+-----+-------------------+-----------------------------+
+------------------------------+---------------------+------+-----+-------------------+-----------------------------+
| Field | Type | Null | Key | Default | Extra |
+------------------------------+---------------------+------+-----+-------------------+-----------------------------+
| id | int(10) unsigned | NO | PRI | NULL | auto_increment |
| config_name | varchar(255) | NO | | NULL | |
| host_name | tinyint(3) unsigned | NO | | 0 | |
| host_name_tploptions | tinyint(3) unsigned | NO | | 2 | |
| hostgroup_name | tinyint(3) unsigned | NO | | 0 | |
| hostgroup_name_tploptions | tinyint(3) unsigned | NO | | 2 | |
| service_description | varchar(255) | NO | | NULL | |
| display_name | varchar(255) | NO | | NULL | |
| servicegroups | tinyint(3) unsigned | NO | | 0 | |
| servicegroups_tploptions | tinyint(3) unsigned | NO | | 2 | |
| use_template | tinyint(3) unsigned | NO | | 0 | |
| use_template_tploptions | tinyint(3) unsigned | NO | | 2 | |
| check_command | text | NO | | NULL | |
| is_volatile | tinyint(3) unsigned | NO | | 2 | |
| initial_state | varchar(20) | NO | | NULL | |
| max_check_attempts | int(11) | YES | | NULL | |
| check_interval | int(11) | YES | | NULL | |
| retry_interval | int(11) | YES | | NULL | |
| active_checks_enabled | tinyint(3) unsigned | NO | | 2 | |
| passive_checks_enabled | tinyint(3) unsigned | NO | | 2 | |
| check_period | int(11) | NO | | 0 | |
| parallelize_check | tinyint(3) unsigned | NO | | 2 | |
| obsess_over_service | tinyint(3) unsigned | NO | | 2 | |
| check_freshness | tinyint(3) unsigned | NO | | 2 | |
| freshness_threshold | int(11) | YES | | NULL | |
| event_handler | int(11) | NO | | 0 | |
| event_handler_enabled | tinyint(3) unsigned | NO | | 2 | |
| low_flap_threshold | int(11) | YES | | NULL | |
| high_flap_threshold | int(11) | YES | | NULL | |
| flap_detection_enabled | tinyint(3) unsigned | NO | | 2 | |
| flap_detection_options | varchar(20) | NO | | NULL | |
| process_perf_data | tinyint(3) unsigned | NO | | 2 | |
| retain_status_information | tinyint(3) unsigned | NO | | 2 | |
| retain_nonstatus_information | tinyint(3) unsigned | NO | | 2 | |
| notification_interval | int(11) | YES | | NULL | |
| first_notification_delay | int(11) | YES | | NULL | |
| notification_period | int(11) | NO | | 0 | |
| notification_options | varchar(20) | NO | | NULL | |
| notifications_enabled | tinyint(3) unsigned | NO | | 2 | |
| contacts | tinyint(3) unsigned | NO | | 0 | |
| contacts_tploptions | tinyint(3) unsigned | NO | | 2 | |
| contact_groups | tinyint(3) unsigned | NO | | 0 | |
| contact_groups_tploptions | tinyint(3) unsigned | NO | | 2 | |
| stalking_options | varchar(20) | NO | | | |
| notes | varchar(255) | NO | | NULL | |
| notes_url | varchar(255) | NO | | NULL | |
| action_url | varchar(255) | NO | | NULL | |
| icon_image | varchar(255) | NO | | NULL | |
| icon_image_alt | varchar(255) | NO | | NULL | |
| use_variables | tinyint(3) unsigned | NO | | 0 | |
| name | varchar(255) | NO | | | |
| active | enum('0','1') | NO | | 1 | |
| last_modified | timestamp | NO | | CURRENT_TIMESTAMP | on update CURRENT_TIMESTAMP |
| access_rights | varchar(8) | YES | | NULL | |
| config_id | tinyint(3) unsigned | NO | | 0 | |
+------------------------------+---------------------+------+-----+-------------------+-----------------------------+
+-----------+---------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-----------+---------+------+-----+---------+-------+
| idMaster | int(11) | NO | PRI | NULL | |
| idSlaveH | int(11) | NO | PRI | NULL | |
| idSlaveHG | int(11) | NO | PRI | NULL | |
| idSlaveS | int(11) | NO | PRI | NULL | |
+-----------+---------+------+-----+---------+-------+
+----------+------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+----------+------------+------+-----+---------+-------+
| idMaster | int(11) | NO | PRI | NULL | |
| idSlave | int(11) | NO | PRI | NULL | |
| exclude | tinyint(1) | NO | | NULL | |
+----------+------------+------+-----+---------+-------+
+----+-----------------------------+------------------------------------+---------+----------------------+------------------------------------+-------------------------------------------------------+-------------------------------------------------------+--------+---------------------+---------------+-----------+
| id | servicegroup_name | alias | members | servicegroup_members | notes | notes_url | action_url | active | last_modified | access_rights | config_id |
+----+-----------------------------+------------------------------------+---------+----------------------+------------------------------------+-------------------------------------------------------+-------------------------------------------------------+--------+---------------------+---------------+-----------+
| 46 | Critical_services | Critical services | 1 | 0 | NULL | NULL | NULL | 1 | 2017-04-07 14:32:30 | NULL | 1 |
+----+-----------------------------+------------------------------------+---------+----------------------+------------------------------------+-------------------------------------------------------+-------------------------------------------------------+--------+---------------------+---------------+-----------+
Date and timezones are correct, output of the commands is following (for the servicegroups, i deleted all but the problematic one)
+----------------------+---------------------+------+-----+-------------------+-----------------------------+
| Field | Type | Null | Key | Default | Extra |
+----------------------+---------------------+------+-----+-------------------+-----------------------------+
| id | int(10) unsigned | NO | PRI | NULL | auto_increment |
| servicegroup_name | varchar(255) | NO | MUL | NULL | |
| alias | varchar(255) | NO | | NULL | |
| members | tinyint(3) unsigned | NO | | 0 | |
| servicegroup_members | tinyint(3) unsigned | NO | | 0 | |
| notes | varchar(255) | YES | | NULL | |
| notes_url | varchar(255) | YES | | NULL | |
| action_url | varchar(255) | YES | | NULL | |
| active | enum('0','1') | NO | | 1 | |
| last_modified | timestamp | NO | | CURRENT_TIMESTAMP | on update CURRENT_TIMESTAMP |
| access_rights | varchar(8) | YES | | NULL | |
| config_id | tinyint(3) unsigned | NO | | 0 | |
+----------------------+---------------------+------+-----+-------------------+-----------------------------+
+------------------------------+---------------------+------+-----+-------------------+-----------------------------+
| Field | Type | Null | Key | Default | Extra |
+------------------------------+---------------------+------+-----+-------------------+-----------------------------+
| id | int(10) unsigned | NO | PRI | NULL | auto_increment |
| config_name | varchar(255) | NO | | NULL | |
| host_name | tinyint(3) unsigned | NO | | 0 | |
| host_name_tploptions | tinyint(3) unsigned | NO | | 2 | |
| hostgroup_name | tinyint(3) unsigned | NO | | 0 | |
| hostgroup_name_tploptions | tinyint(3) unsigned | NO | | 2 | |
| service_description | varchar(255) | NO | | NULL | |
| display_name | varchar(255) | NO | | NULL | |
| servicegroups | tinyint(3) unsigned | NO | | 0 | |
| servicegroups_tploptions | tinyint(3) unsigned | NO | | 2 | |
| use_template | tinyint(3) unsigned | NO | | 0 | |
| use_template_tploptions | tinyint(3) unsigned | NO | | 2 | |
| check_command | text | NO | | NULL | |
| is_volatile | tinyint(3) unsigned | NO | | 2 | |
| initial_state | varchar(20) | NO | | NULL | |
| max_check_attempts | int(11) | YES | | NULL | |
| check_interval | int(11) | YES | | NULL | |
| retry_interval | int(11) | YES | | NULL | |
| active_checks_enabled | tinyint(3) unsigned | NO | | 2 | |
| passive_checks_enabled | tinyint(3) unsigned | NO | | 2 | |
| check_period | int(11) | NO | | 0 | |
| parallelize_check | tinyint(3) unsigned | NO | | 2 | |
| obsess_over_service | tinyint(3) unsigned | NO | | 2 | |
| check_freshness | tinyint(3) unsigned | NO | | 2 | |
| freshness_threshold | int(11) | YES | | NULL | |
| event_handler | int(11) | NO | | 0 | |
| event_handler_enabled | tinyint(3) unsigned | NO | | 2 | |
| low_flap_threshold | int(11) | YES | | NULL | |
| high_flap_threshold | int(11) | YES | | NULL | |
| flap_detection_enabled | tinyint(3) unsigned | NO | | 2 | |
| flap_detection_options | varchar(20) | NO | | NULL | |
| process_perf_data | tinyint(3) unsigned | NO | | 2 | |
| retain_status_information | tinyint(3) unsigned | NO | | 2 | |
| retain_nonstatus_information | tinyint(3) unsigned | NO | | 2 | |
| notification_interval | int(11) | YES | | NULL | |
| first_notification_delay | int(11) | YES | | NULL | |
| notification_period | int(11) | NO | | 0 | |
| notification_options | varchar(20) | NO | | NULL | |
| notifications_enabled | tinyint(3) unsigned | NO | | 2 | |
| contacts | tinyint(3) unsigned | NO | | 0 | |
| contacts_tploptions | tinyint(3) unsigned | NO | | 2 | |
| contact_groups | tinyint(3) unsigned | NO | | 0 | |
| contact_groups_tploptions | tinyint(3) unsigned | NO | | 2 | |
| stalking_options | varchar(20) | NO | | | |
| notes | varchar(255) | NO | | NULL | |
| notes_url | varchar(255) | NO | | NULL | |
| action_url | varchar(255) | NO | | NULL | |
| icon_image | varchar(255) | NO | | NULL | |
| icon_image_alt | varchar(255) | NO | | NULL | |
| use_variables | tinyint(3) unsigned | NO | | 0 | |
| name | varchar(255) | NO | | | |
| active | enum('0','1') | NO | | 1 | |
| last_modified | timestamp | NO | | CURRENT_TIMESTAMP | on update CURRENT_TIMESTAMP |
| access_rights | varchar(8) | YES | | NULL | |
| config_id | tinyint(3) unsigned | NO | | 0 | |
+------------------------------+---------------------+------+-----+-------------------+-----------------------------+
+-----------+---------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-----------+---------+------+-----+---------+-------+
| idMaster | int(11) | NO | PRI | NULL | |
| idSlaveH | int(11) | NO | PRI | NULL | |
| idSlaveHG | int(11) | NO | PRI | NULL | |
| idSlaveS | int(11) | NO | PRI | NULL | |
+-----------+---------+------+-----+---------+-------+
+----------+------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+----------+------------+------+-----+---------+-------+
| idMaster | int(11) | NO | PRI | NULL | |
| idSlave | int(11) | NO | PRI | NULL | |
| exclude | tinyint(1) | NO | | NULL | |
+----------+------------+------+-----+---------+-------+
+----+-----------------------------+------------------------------------+---------+----------------------+------------------------------------+-------------------------------------------------------+-------------------------------------------------------+--------+---------------------+---------------+-----------+
| id | servicegroup_name | alias | members | servicegroup_members | notes | notes_url | action_url | active | last_modified | access_rights | config_id |
+----+-----------------------------+------------------------------------+---------+----------------------+------------------------------------+-------------------------------------------------------+-------------------------------------------------------+--------+---------------------+---------------+-----------+
| 46 | Critical_services | Critical services | 1 | 0 | NULL | NULL | NULL | 1 | 2017-04-07 14:32:30 | NULL | 1 |
+----+-----------------------------+------------------------------------+---------+----------------------+------------------------------------+-------------------------------------------------------+-------------------------------------------------------+--------+---------------------+---------------+-----------+
-
avandemore
- Posts: 1597
- Joined: Tue Sep 27, 2016 4:57 pm
Re: servicegroup member status not shown
Please use code tags to wrap long output.
Please provide the output for the following 2 commands:
Please provide the output for the following 2 commands:
Code: Select all
# mysql -uroot -pnagiosxi nagios -e "SELECT * from nagios_instances;"
# top -bcn1Previous Nagios employee
Re: servicegroup member status not shown
Code: Select all
+-------------+---------------+----------------------+
| instance_id | instance_name | instance_description |
+-------------+---------------+----------------------+
| 1 | localhost | |
+-------------+---------------+----------------------+
You do not have the required permissions to view the files attached to this post.
-
avandemore
- Posts: 1597
- Joined: Tue Sep 27, 2016 4:57 pm
Re: servicegroup member status not shown
XI > Admin > System Profile > Download Profile
Please include the zip file in your response. You can PM it to myself or other support personnel.
Please include the zip file in your response. You can PM it to myself or other support personnel.
Previous Nagios employee
Re: servicegroup member status not shown
Profile was sent to [email protected], subject: servicegroup member status not shown.
-
avandemore
- Posts: 1597
- Joined: Tue Sep 27, 2016 4:57 pm
Re: servicegroup member status not shown
That will open a ticket for this issue. Do you want to pursue this via ticket or the current thread?
Previous Nagios employee