SOLVED FOG Sql
How can i properly remove a host and all others files( Adress Mac, Serial number, …) in fog with sql request ?
Tom Elliott last edited by
Wayne Workman last edited by
Why when I delete a hots on fog 1.2.0 in GUI, all the table with a hosts are not delete ?
For example in table inventory when a host is delete, this is not delete in the inventory table and another table why ?
I think when a host is deleted, the host must be deleted in the following table :
hosts, hostmac, greenfog, groupmembers, hostautologout, hostscreensetting, inventory, modulestatusbyhosts, nfsfailures, pendingmacs, printerassoc, sheduledTasks,snapinassoc, snapinjob, usertracking, imaginlog.
We delete a host with a script python with with url : “http://localhost/fog/management/index.php?node=host&sub=delete&id=%s”
Where “%s” is a hostid.
Sorry for my bad english.
Wayne Workman last edited by Wayne Workman
there are two ways.
mysql use fog truncate table hosts; truncate table hostMAC;
mysql use fog delete from table hosts where 1; delete from table hostMAC where 1;