Luis Amaro wrote: > Hi > > > well, actually it's not > > > mysql> select host_object_id,alias from icinga_hosts; > +----------------+------------------+ > | host_object_id | alias | > +----------------+------------------+ > | 96 | myITVm1 (M001) | > | 79 | myITdc3 | > | 111 | vShuttle monitor | > | 39 | localhost | > +----------------+------------------+ > 4 rows in set (0.07 sec) > > mysql> select hoststatus_id,host_object_id,check_command from > icinga_hoststatus; > +---------------+----------------+--------------------------------------------------------+ > | hoststatus_id | host_object_id | check_command > | > +---------------+----------------+--------------------------------------------------------+ > | 1 | 39 | check-host-alive > | > | 22 | 49 | check-host-alive > | > | 23 | 50 | check-host-alive > | > | 30 | 51 | check_ping!4!5 > | > | 32 | 52 | check-host-alive > | > | 157 | 78 | check_ping!4!5 > | > | 159 | 79 | check-host-alive > | > | 215 | 96 | check-host-alive > | > | 598 | 109 | > check_esx3_host!/usr/local/icinga/etc/objects/auth_128 | > | 1004 | 111 | check-host-alive!50!25 > | > +---------------+----------------+--------------------------------------------------------+ > 10 rows in set (0.01 sec) > > > the icinga_hoststatus tables still has references to the old hosts
that would need a proper join on the objects table while identifying active / non-active entries. select * from icinga_hoststatus join icinga_objects on host_object_id=object_id where is_active=1; or similar. > why isn't it updating? > > Luis Amaro > > > ----- Original Message ----- > From: "Michael Friedrich"<michael.friedr...@univie.ac.at> > To: icinga-users@lists.sourceforge.net > Sent: Friday, 23 September, 2011 5:00:02 PM > Subject: Re: [icinga-users] Hosts don't desappear from top part of icinga-web > > Luis Amaro wrote: >> Hi >> >> I'm running icinga 1.5.1, icinga-web 1.5.0 with nagiosql and i have a problem >> >> on the top part of the web interface, the resume of hosts and services, the >> bars that say how many are up, down, unreacheable, pending and total, etc... >> still show hosts i've deleted. >> >> The services i add and remove are updated, the hosts i add too, but the >> hosts i remove don't, they show up as down, although they don't appear >> anywhere else in the >> web interface > verify that the data in the backend is ok too. > >> Luis Amaro >> >> >> The contents of this e-mail (including attachments) are private and >> confidential and may also be subject to legal privilege. It is intended only >> for the use of the addressee. If you are not the addressee, or the person >> responsible for delivering it to the addressee, you may not copy or deliver >> this e-mail or any attachments to anyone else or make any use of its >> contents; you should not read any part of this e-mail or any attachments. >> Unauthorised disclosure or communication or other use of the contents of >> this e-mail or any part thereof may be prohibited by law and may constitute >> a criminal offence. If you feel you may have received this e-mail in error >> please notify i...@myitdepartment.ie >> >> >> ------------------------------------------------------------------------------ >> All of the data generated in your IT infrastructure is seriously valuable. >> Why? It contains a definitive record of application performance, security >> threats, fraudulent activity, and more. Splunk takes this data and makes >> sense of it. IT sense. And common sense. >> http://p.sf.net/sfu/splunk-d2dcopy2 >> _______________________________________________ >> icinga-users mailing list >> icinga-users@lists.sourceforge.net >> https://lists.sourceforge.net/lists/listinfo/icinga-users > -- DI (FH) Michael Friedrich Vienna University Computer Center Universitaetsstrasse 7 A-1010 Vienna, Austria email: michael.friedr...@univie.ac.at phone: +43 1 4277 14359 mobile: +43 664 60277 14359 fax: +43 1 4277 14338 web: http://www.univie.ac.at/zid http://www.aco.net Icinga Core& IDOUtils Developer http://www.icinga.org ------------------------------------------------------------------------------ All of the data generated in your IT infrastructure is seriously valuable. Why? It contains a definitive record of application performance, security threats, fraudulent activity, and more. Splunk takes this data and makes sense of it. IT sense. And common sense. http://p.sf.net/sfu/splunk-d2dcopy2 _______________________________________________ icinga-users mailing list icinga-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/icinga-users
