Hi again the only hosts that seem active are 4
mysql> select host_id,alias,is_active from icinga_objects,icinga_hoststatus,icinga_hosts where is_active=1 group by host_id; +---------+------------------+-----------+ | host_id | alias | is_active | +---------+------------------+-----------+ | 375 | myITVm1 (M001) | 1 | | 376 | myITdc3 | 1 | | 377 | vShuttle monitor | 1 | | 378 | localhost | 1 | +---------+------------------+-----------+ 4 rows in set (0.01 sec) Luis Amaro ----- Original Message ----- From: "Michael Friedrich" <michael.friedr...@univie.ac.at> To: icinga-users@lists.sourceforge.net Sent: Friday, 23 September, 2011 5:28:07 PM Subject: Re: [icinga-users] Hosts don't desappear from top part of icinga-web 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 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 the data continuously generated in your IT infrastructure contains a definitive record of customers, application performance, security threats, fraudulent activity and more. Splunk takes this data and makes sense of it. Business sense. IT sense. Common sense. http://p.sf.net/sfu/splunk-d2dcopy1 _______________________________________________ icinga-users mailing list icinga-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/icinga-users
