Cannot delete host - dependency

[belvdr]

So, I configured a BPI some time ago to monitor our Linux systems for system updates. Now, we no longer need this so I deleted the BPI config and so forth.

At my last step, I'm trying to delete the dummy host that was required for this. I've cleared the configuration of the host, such that no templates, parents, contacts, contactgroups, etc exist. Trying to delete, I get this:

Code: Select all

Database Relationships for host : Yum_Updates
Items labeled as: 'Dependent relationships' will prohibit deletion
Object ID: 609 of table tbl_host:

Any thoughts on what's holding it up?

[tmcdonald]

Please run the following command from the Nagios server command line as root and post the results:

Code: Select all

echo "use nagiosql; select id,host_name from tbl_host where id=609;" | mysql -u root -pnagiosxi

[belvdr]

Code: Select all

# echo "use nagiosql; select id,host_name from tbl_host where id=609;" | mysql -u root -pnagiosxi
id      host_name
609     Yum_Updates

[tmcdonald]

What XI version and BPI version is this? For the BPI version, go to Admin -> Manage Components, and find the entry for Nagios BPI. The version will be on the right.

[belvdr]

NagiosXI 2014R1.4
BPI 2.31

I have cleared all the BPI configuration. There's only the host left now.

EDIT: This occurred in 2014R1.3 as well.

EDIT 2: Is it possible to get the SQL CCM uses to determine if there's a dependency?

[abrist]

EDIT 2: Is it possible to get the SQL CCM uses to determine if there's a dependency?

Not really, as it is a group of php functions that build the dependency query. I can tell you where to look though:
You are looking for the infoRelation() function in the file:

Code: Select all

/usr/local/nagiosxi/html/includes/components/ccm/classes/data_class.php

[belvdr]

I have scoured a number of tables but cannot locate the dependency.

[sreinhardt]

Could you send us a copy of your configs or system profile via pm and we can verify that nothing has been missed there? Hoping that this is not just a db conflict, but its possible.

[belvdr]

Sorry for the delay. Was able to get some time off!

I saw another thread about clearing cache but that didn't help. How exactly do I gather the configs and/or system profile?

And now, I have yet another host I cannot delete. It is exhibiting the exact same behavior.

EDIT: I found how to download the system profile. I have sent that to tmcdonald, abrist, and sreinhardt. Did you want the Nagios backup too?

EDIT 2: I am now finding I cannot delete any host. They all have dependency problems. I have ran database repair successfully, but it did not fix the issue. I see these in the Apache error logs each time a deletion fails:

Code: Select all

[Mon Aug 25 15:24:43 2014] [error] [client 1.1.1.1] PHP Notice:  Undefined variable: ac_needed_js_inject in /usr/local/nagiosxi/html/includes/components/ccm/page_templates/ccm_table.php on line 175, referer: http://servername/nagiosxi/includes/components/ccm/index.php
[Mon Aug 25 15:24:43 2014] [error] [client 1.1.1.1] PHP Notice:  Undefined variable: sync_table_status in /usr/local/nagiosxi/html/includes/components/ccm/page_templates/ccm_table.php on line 195, referer: http://servername/nagiosxi/includes/components/ccm/index.php

EDIT 3: I was finally able to delete them. I checked the box next to the hosts in question and selected the dropdown "With Checked: Delete", and it removed them. Clicking the red X button next to each individual host did not work. The above errors were still logged but the hosts were deleted.

[abrist]

EDIT 3: I was finally able to delete them. I checked the box next to the hosts in question and selected the dropdown "With Checked: Delete", and it removed them. Clicking the red X button next to each individual host did not work. The above errors were still logged but the hosts were deleted.

This is a bug. It has already been fixed for the next version.