Hosts are missing

[Matt Derrick]

I was in the middle on imaging some laptops and the server locked up. Not responding in fog at all. Rebooted server and all my hosts came up as not registered. When I went to the host in fog there was no MAC address listed for any hosts. Updated server to newest trunk and now the host table is empty. I tried to import the hosts and it says “Row #1: A host with this name already exists” For all hosts in the csv file.

[Wayne Workman]

Because you have a host export available, you can do this:

mysql
use fog
DELETE FROM `hosts` WHERE 1;
DELETE FROM `hostMAC` WHERE 1;
quit

And then try to import.
The above commands dump all host data.

[Tom Elliott]

What version of FOG is this?

[Wayne Workman]

@Tom-Elliott Yeah… the tables change… the version does matter…

The answer I posted is for r3709, didn’t even think about it… But it does point people in the right direction

[Matt Derrick]

That worked. I cleared the databases and reimported all of my hosts. I am getting an error now on them being added to Active Directory. Not sure if related to the import or the trunk version I am on. which is 3735.

Error is : 7/9/2015 4:23 PM FOG::HostnameChanger Domain Error! (‘Unknown Error’ Code: 1326)