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-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
