> -----Ursprüngliche Nachricht----- > Von: Patricia Jung [mailto:p...@censhare.com] > Gesendet: Montag, 21. März 2011 16:09 > An: icinga-users@lists.sourceforge.net > Betreff: Re: [icinga-users] How to retain history when hosts change > theirnames > > > Am 21.03.2011 um 14:59 schrieb Patricia Jung: > > > > > Am 21.03.2011 um 13:58 schrieb Patricia Jung: > >> when hosts change their host_name in the icinga/nagios configuration the > history of the relevant checks is obviously lost. How do I adapt historical > data > to the new host_name? What do I need to change -- any cooking recipes? > > > > > > Right, I should be more precise: Are the following steps sufficient? > > > > 1. Change host_names in configuration and check configuration 2. Take > > icinga down and sed retention.dat 3. Change icinga database (in my > > case mysql) > > > > Anyone with a proven sql statement? If not: What exactly do I have to > change in the database? > > > Would the following sql statement suffice? > > update icinga_objects set name1='new-host_name' where name1='old-
I think you have to change the hostname(alias,display_name) in the icinga_hosts table too? > host_name'; > > Thanks > > Patricia > -- > Patricia Jung > Senior Software and Support Engineer > > censhare AG > Paul-Gerhardt-Allee 50, 81245 Muenchen, Germany Fon +49 89 568236-311 > Fax +49 89 568236-501 http://www.censhare.com http://blog.censhare.com > Pflichtangaben/Mandatory Information: > http://www.censhare.com/pflichtangaben > > > > ------------------------------------------------------------------------------ > Colocation vs. Managed Hosting > A question and answer guide to determining the best fit > for your organization - today and in the future. > http://p.sf.net/sfu/internap-sfd2d > _______________________________________________ > icinga-users mailing list > icinga-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/icinga-users OOe. Gesundheits- und Spitals-AG Techcenter, Hafenstrasse 47-51, 4020 Linz DVR 2107870, ATU 51928204, Firmenbuchgericht: Landesgericht Linz, FN 210146 p ------------------------------------------------------------------------------ Enable your software for Intel(R) Active Management Technology to meet the growing manageability and security demands of your customers. Businesses are taking advantage of Intel(R) vPro (TM) technology - will your software be a part of the solution? Download the Intel(R) Manageability Checker today! http://p.sf.net/sfu/intel-dev2devmar _______________________________________________ icinga-users mailing list icinga-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/icinga-users
