Results 1 to 3 of 3

Thread: a host deleted intentionally

  1. #1
    Join Date
    Aug 2011
    Location
    ock
    Posts
    5

    Default a host deleted intentionally

    Hi,

    i'm new to Centreon and i intentionally deleted a host on a poller, can i have the graphs and the configuration back of this host i didn't restart Nagios yet. Please the host is a very critical firewall and we need the graphs and data of this. i will be in big trouble if the graphs are lost.

    I't a very urgent matter.
    Thank you sincerely for your help.

  2. #2
    Join Date
    Sep 2009
    Location
    Toulouse
    Posts
    716

    Default

    No backup of the Centreon Database ?

    It will be a bit hard to recover your host. The problem is that to recover the graphs, even if you create a new host with the same name, the ID will be different in the DB.

    The data for the graphs are stored in the centstorage DB. The table, where are stored the hosts and the services is `centstorage`.`index_data`. You can first try to check if your host is still there or not, with this SQL request :

    Code:
    SELECT `centstorage`.`index_data`.`host_name`,  `centstorage`.`index_data`.`id` FROM `centstorage`.`index_data` WHERE `centstorage`.`index_data`.`host_name` = "XXXXX"
    Obviously, XXX is the exact Hostname of your firewall.

    If you have an entry (or more, depend of the number of services you had), you are lucky. If not, so it won't be possible (or i am not aware of a solution).

    Cheers
    Ubuntu server 10.04 LTS 64 Bits - Haute dispo 4 serveurs centraux (réplication MySQL + VIP + Rsync)
    Nagios 3.3.1 | Centreon 2.3.9 | Centreon-Broker 2.1.1 | 2000 hôtes - 5000 services | 6 Remote Pollers

    Dev : CES 2.2 - Centengine - Centreon 2.4.1

  3. #3
    Join Date
    Aug 2011
    Location
    ock
    Posts
    5

    Default

    Hi,

    Thank you for the reply, actiouly someone told me that i might get the data if i created another host with the same name, i got the services of the host but no graphs,

    when i enter the folowing SQL request on the database "centreon2_storage", by the way i'm using Nagios Core 3.2.3 and centreon 2.1.13 of the distribution called FAN:
    select id, host_id, service_id, storage_type from index_data where host_name = "XXXX";

    i got the folowing table

    +-----+---------+------------+--------------+
    | id | host_id | service_id | storage_type |
    +-----+---------+------------+--------------+
    | 592 | 140 | 1068 | 2 |
    | 591 | 140 | 1065 | 2 |
    | 590 | 140 | 1066 | 2 |
    | 589 | 140 | 1062 | 2 |
    | 588 | 140 | 1067 | 2 |
    | 587 | 140 | 1063 | 2 |
    | 586 | 140 | 1056 | 2 |
    | 585 | 140 | 1057 | 2 |
    | 584 | 140 | 1049 | 2 |
    | 594 | 140 | 1060 | 2 |
    | 593 | 140 | 1064 | 2 |
    +-----+---------+------------+--------------+

    can this help?

    thank you any way magicbret.
    Best Regards

Similar Threads

  1. Recover RRD from deleted service
    By yold in forum Centreon Project
    Replies: 3
    Last Post: 16th May 2011, 18:39
  2. Replies: 0
    Last Post: 3rd February 2011, 19:38
  3. Replies: 0
    Last Post: 31st October 2010, 19:30
  4. Unknow Services from deleted host
    By bbyrnes in forum Miscellaneous
    Replies: 0
    Last Post: 19th February 2009, 17:49
  5. Oops, I think I've deleted all the configs
    By tibcent in forum Setup
    Replies: 2
    Last Post: 27th January 2009, 18:20

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •