Page 1 of 3
Relation to tbl_host, entry - deletion not possible
Posted: Mon Apr 16, 2012 3:10 pm
by jbennett
I am trying to delete a user that is no longer with the company. In doing so, I am being presented with 6 lines as the following:
Relation to tbl_host, entry - deletion not possible
There is no host listed here, so I cannot remove the user from those hosts.
What are my options? Any help would be greatly appreciated!
Re: Relation to tbl_host, entry - deletion not possible
Posted: Mon Apr 16, 2012 3:40 pm
by scottwilkerson
Try the following to find the hosts this user may be contacts for
Code: Select all
cd /usr/local/nagios/etc
grep -lir "USERNAME" *
Re: Relation to tbl_host, entry - deletion not possible
Posted: Tue Apr 17, 2012 7:55 am
by jbennett
Looking at the results, I'm assuming that I must remove this individuals from ALL hosts & services, not just the ones that don't list an actual host?
There has to be an easier way of mass removing them from our list of thousands of hosts, right?
Re: Relation to tbl_host, entry - deletion not possible
Posted: Tue Apr 17, 2012 8:27 am
by jbennett
This shows me the rest of the list as well I'm sure. I was hoping to just be able to find the 6 hosts where it stated that deletion wasn't possible.
We have thousands of hosts. Surely there's a way to more easily remove this contact from the hosts and services than going to each item on this list individually? I have checked the templates, and unfortunately, in the template for the hosts and services, this individual is not selected under the contacts. Is there somewhere else that this can be done?
Re: Relation to tbl_host, entry - deletion not possible
Posted: Tue Apr 17, 2012 10:08 am
by mguthrie
Do you have any blank entries on your hosts page by chance? The only time I've seen something like this is when an import is done and some ghost relationships get created. They show up as empty hosts on the hosts page.
I'm going to attach our new CCM beta, it installs alongside the existing CCM through the Admin->Manage Components page. It might make things a little more intuitive as to where the relationships are. You can also use the "Bulk Modifications" page to remove a contact from a list of directly related hosts or services.
Re: Relation to tbl_host, entry - deletion not possible
Posted: Tue Apr 17, 2012 10:44 am
by jbennett
No blank entries that I can see. I'm assuming you mean it will just be blank all the way across the listing, yet have a check box next to it? I'm also assuming it would be at either the beginning or the end of the host list, and not in the middle of the 144 pages somewhere?
We are currently on Nagios 1.9. I will have to see if we can upgrade to 2.1 from here since they have everything locked down.
Re: Relation to tbl_host, entry - deletion not possible
Posted: Tue Apr 17, 2012 11:01 am
by scottwilkerson
The Beta CCM that mguthrie posted is your ticket to removing the contact from all in in the easiest way possible
Re: Relation to tbl_host, entry - deletion not possible
Posted: Tue Apr 17, 2012 1:37 pm
by jbennett
Thanks, since it says that it will only work with 2.1 or later, I suppose I need to get onto upgrading our system then!
Re: Relation to tbl_host, entry - deletion not possible
Posted: Wed Apr 18, 2012 4:39 pm
by jbennett
mguthrie wrote:I'm going to attach our new CCM beta, it installs alongside the existing CCM through the Admin->Manage Components page. It might make things a little more intuitive as to where the relationships are. You can also use the "Bulk Modifications" page to remove a contact from a list of directly related hosts or services.
Now that i'm up to date, I am looking at the info for this contact and it still only shows:
Code: Select all
Relation to tbl_host, entry - deletion not possible
Relation to tbl_host, entry - deletion not possible
Perhaps I'm not seeing it, but where do I access the bulk modifications page from?
Many thanks!
EDIT: Found it and successfully got the contact deleted!! Now to see if I can finally apply the new configuration.
Again, many many thanks!
Re: Relation to tbl_host, entry - deletion not possible
Posted: Thu Apr 19, 2012 2:18 am
by pouda
Hi,
where is this Bulk modifications Option ?