Using Bulk Modifications Tool to copy services fails

[ajwilliamson]

Hi,

I am attempting to use the Bulk Modifications Tool to copy services from one host to several others.

I select the "+Add Service(s)" button, choose the services I want to use as a template, then select the hosts I wish to push the services to.

Everything goes without an issue...no errors. I am directed to the next page, where the system says the updates were saved successfully, and asks me to apply the configuration.

After applying the configuration, the new services are nowhere to be found.

In case it matters at all, the services I'm attempting to copy/duplicate are snmp checks that use a specific MIB.

Thanks in advance for your help.

[tgriep]

One thing I do see in the profile is that there may be some corrupted MYSQL databases and they need to be fixed.
Run this as root to do that.

Code: Select all

systemctl stop nagios
mysqlcheck -f -r -u nagios -pnagios --databases nagios --use-frm -h 169.254.1.2
systemctl start nagios

Your MYSQL server has been offloaded and if the above password for the MYSQL database does not match my example, change it.

What is the full name of the service you selected when running the Bulk Modification tool?
What are the names of the Hosts you tried to copy the service too?

We would need this information to see if the configurations updated or not in the profile.

[ajwilliamson]

I ran the mysqlcheck as requested...the output is attached.

The names of the services are: "CPU Utilization", "Current Sessions", and "Memory Utilization"
They currently exist, manually created, on two hosts: USPRL-FWL001 and USPRL-LAB-FWL001

This morning, after running the mysqlcheck, I attempted to run the Bulk Modifications Tool again to copy those services from USPRL-LAB-FWL001 to AUSDC-FWL001.
It doesn't appear that the copy worked, even though the GUI gave me no indication of an error, as the new services are not seen in anywhere under CCM.

Do you want me to grab a new copy of the System Profile?

[tgriep]

First do this. Open a root shell to the server and run the following tail command.

Code: Select all

tail  -f /var/log/httpd/*_log /usr/local/nagiosxi/var/cmdsubsys.log

Try adding the service to the hosts again. Save the change and Apply the Configuration.

Stop the tail command, copy the output to the shell to a text file and attach it to the post as well as a new Profile.

Thanks.

[ajwilliamson]

Please see attached.

[tgriep]

There are no errors in the output which is bad news.

One thing I found in the profile is a stuck recurring_downtime cron job from the 14th.

nagios 7931 7920 0 Feb14 ? 00:00:00 /bin/sh -c /usr/bin/php -q /usr/local/nagiosxi/cron/recurring_downtime.php >> /usr/local/nagiosxi/var/recurringdowntime.log 2>&1
nagios 7941 7931 0 Feb14 ? 00:00:00 /usr/bin/php -q /usr/local/nagiosxi/cron/recurring_downtime.php

It needs to be stopped.
Run this to kill it off.

Code: Select all

kill -9 7931

Login to the XI interface and go to the Admin > Audit Log menu and see if there is a log entry with the source called "Bulk Modifications Tool" showing that the service was added to the hosts.
Let me know if it is there.

If you see the entry, then the tool is getting to the function that writes the changes to the MYSQL database so we will have to look at the offloaded MYSQL database.

What OS and release is the MYSQL server running?
Can you get the MYSQL server configuration files and post them here?
This file
/etc/my.cnf
and all of the files from the
/etc/my.cnf.d folder.

Login to the MYSQL server and get the version of MYSQl by running the following as root and post it here.

Code: Select all

mysql -V

If the version of MYSQL is greater than these versions, [MySQL 5.7.5] and [MariaDB 10.2.4] follow the instructions in the following KB article.
https://support.nagios.com/kb/article/n ... s-780.html

[ajwilliamson]

I have killed the recurring downtime process.

The Audit Log does indeed show that it added the services to the host I was trying to add it to.

The database server is also RHEL 7.9 running MariaDb v10.4.17

I stepped through the doc you linked...I have actually done that before, but STRICT_TRANS_TABLES was indeed set.

Looks like that was the problem. I ran the Bulk edit again, and this time it worked...the new service is there.

Thanks for your help!

[tgriep]

Your very welcome! Glad it is fixed. I'll close the post as solved but feel free to open a new one in the future for any new issues or questions.