nagiosql_delete_service.php doesn't work after offloading DB

[thur686]

We are currently on Nagios XI 5.4.6.

[dwhitfield]

Can you PM me your Profile? You can download it by going to Admin > System Config > System Profile and click the ***Download Profile*** button towards the top. If for whatever reason you *cannot* download the profile, please put the output of View System Info (5.3.4+, Show Profile if older) in the thread (that will at least get us some info). This will give us access to many of the logs we would otherwise ask for individually. If security is a concern, you can unzip the profile take out what you like, and then zip it up again. We may end up needing something you remove, but we can ask for that specifically.

After you PM the profile, please update this thread. Updating this thread is the only way for it to show back up on our dashboard.

[thur686]

Ok, I sent the Profile via PM as requested.

[dwhitfield]

Considering the size of your system, I'd really like to see the profile. Can you send an email to [email protected] referencing this thread? You can attach the profile to that email, or we can send you a link once we have the email.

[bheden]

Open up the file nagiosql_delete_service.php for editing.

There should be a section on or around line 42 that looks like the following:

Code: Select all

if(empty($ids) && $id==0) 
	exit_with_error(1,"Unable find services in nagiosql database.\nUsage: ./nagiosql_delete_service.php [--id=<service id>] [--config=<config_name>]\n");

Right ABOVE this block, but after the previous block, add the following code:

Code: Select all

echo "config: $config\n";
echo "id: $id\n";
echo "ids: ";
print_r($ids);
echo "url: $url\n";
echo "\ncfg: ";
print_r($cfg['db_info']);

And then run the script again, and show the output here please. You can sanitize your data, just so long as if there is a special character that exists in any of the output you make sure that same character is displayed in the sanitized data.

[thur686]

I emailed the profile to Customer Service as requested. I have not edited 'nagiosql_delete_service.php' with the additional code yet. I have no more services\hosts to delete at this time because I spent 4 days last week removing them manually in the CCM.

I can create fake services\hosts to delete and test changes to 'nagiosql_delete_service.php' if it is necessary.

[dwhitfield]

Did you want to continue through the forum or through the ticket? It doesn't matter to me. You should have gotten notice via email that I received the email.

[thur686]

The ticket is better, thanks.