Troubleshooting Guide : My poller was deleted and my hosts are now orphaned.


One of your pollers / collectors has been deleted and your hosts are now orphaned.


Solutions : 

When a poller is deleted by mistake, we recommend that you take the following steps:

Check that orphaned hosts are returned via this query (initially attached to the deleted poller)

mysql -e "select host_id,host_name from where host_register='1' and host.host_id not in (select host_host_id from centreon.ns_host_relation);"

If yes, you can continue the procedure.
If not, please contact our Customer Care department with a new ticket.

Find out the ID of the poller you've created (to replace the old one) :
mysql -e “select id from centreon.nagios_server where ns_ip_address = ‘ip_du_nouveau_poller’;”

Or via the interface :


  • Create the script as shown below (be careful to fill in these 3 parts VOTREUSER VOTREPASSWORD id_du_nouveau_poller)

host_id=`mysql -u VOTREUSER -pVOTREPASSWORD centreon --skip-column-names --execute="select host_id from host where host_register='1' and host.host_id not in (select host_host_id from ns_host_relation);"`
while read line;do
mysql -u VOTREUSER -pVOTREPASSWORD centreon --execute="insert into ns_host_relation (nagios_server_id,host_host_id) values('id_du_nouveau_poller', '$line');"
done <<< "$host_id"


  • Add execution rights :
chmod +x


  • Then run it:



This should attach all orphaned hosts to your new poller.
Then you can export the poller + host configuration and the problem should be solved.

Was this article helpful?

0 out of 0 found this helpful