a host deleted intentionally

[hbl]

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.

[magicbret]

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 :

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

[hbl]

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