Services are Missing while opening the Service escalations

[Gonela]

Hi Team,

We created Service escalation on the NagiosXI. When trying to add few more service to the existing service escalations.

While opening the popup of service box in the service escalation then it automatically the existing services mapping list are disappearing .

Existing Service escalations config has following mapped list:

2 Host Groups,
1 Contact Groups
5 Services.

After open the popup of existing service escalations mapping list:

2 Host Groups,
1 Contact Groups
1 Services.

Here 4 services are missing once open the popup.

[benjaminsmith]

Hi @Gonela,

Are logged in as an administrator when this is happening? If you are using RHEL/CentOS 7, please run the following commands:

Code: Select all

systemectl nagios stop
systemctl ndo2db stop
killall -9 nagios
for i in `ipcs -q | grep nagios |awk '{print $2}'`; do ipcrm -q $i; done
systemctl ndo2db start
systemctl nagios start

Replace systemctl with service fro CentOS 6.

And then try opening the service box again. If you still experience this issue, please send/share your System Profile in private message for us to review. You can download it from Admin > System Profile > Download Profile. Thanks.

[Gonela]

We tired all the commands which you were mentioned. but no luck.

Profile attached in the attachments.

[benjaminsmith]

Hi @Gonela,

The database log contains entries for crashed database tables. Please run the following from the command line.

1. Database repair script ( if you get any errors please post the output ):

Code: Select all

/usr/local/nagiosxi/scripts/repair_databases.sh

2. Then run the permissions reset script:

Code: Select all

/usr/local/nagiosxi/scripts/reset_config_perms.sh

Check the service box again and let me know if the issue is resolved.

References
Repairing The Nagios XI Databases

[Gonela]

We tired all the commands which you were mentioned. but no luck.

[benjaminsmith]

Hi @Gonela,

It looks like the service escalations are not being written to the core configuration files.

Go to Configure >CCM >Tools > Config File Management and follow these steps:

1. Delete Files
2. Write Configs
3. Verify ( Are there any errors? If so correct them and repeat steps 1 and 2)
4. Restart Nagios Core

If you're not able to get it corrected, please tail the subsystem log and then go to Configure > CCM > Quick Tools > Apply Configuration and post the output for us to review.

Code: Select all

tail -f /usr/local/nagiosxi/var/cmdsubsys.log

Thank you.

[Gonela]

We tried all the options which you were mentioned. still facing same issue.

While opening the popup of service box in the service escalation then it automatically the existing services mapping list are disappearing .

attaching log of tail -f /usr/local/nagiosxi/var/cmdsubsys.log

[benjaminsmith]

Hi @Gonela,

You have a large system of nearly 30K services, and it looks like the database is hitting the maximum number of connections allowed. Please increase the limit in the database options file.

1. Open up /etc/my.cnf in vi or another editor.

2. Change the following line and save.

Code: Select all

max_connections=1000

3. Now restart the Nagios server and test.

Code: Select all

systemctl stop nagios.service
systemctl stop ndo2db.service 

We have the process documented on our knowledgebase at:
Nagios XI - MySQL/MariaDB - Max Connections

If this does not resolve the issue for you, please open a support ticket along with a fresh system profile and reference this post.

[Gonela]

Already Max connection value is 1000

[root@nagihpcorp01 ~]# cat /etc/my.cnf |grep max_connections
max_connections =1000
[root@nagihpcorp01 ~]#

[benjaminsmith]

Hi @Gonela,

For faster resolution of this issue, please open a support ticket and reference this thread at:

https://support.nagios.com/tickets/

Let me know if you have any questions.

Thank you.