Can't find the "Reset Encryption Data" button on any hosts.

[Tom Elliott]

@alexf2132 Something makes me think that the hosts have already been registered then, but removed a while ago?

[alexf2132]

@Tom-Elliott It’s possible that I deleted this host from the server, then re-added it later on. Does deleting a host from the server completely delete it? Or does it hang around for a certain amount of days?

[Tom Elliott]

@alexf2132 Normally it completely deletes it, but depending on when that delete occurred there was likely a bug that made it so that MAC was not removed from the DB.

[alexf2132]

@Tom-Elliott Ahhh interesting. So I should delete this host from the server, log into the MYSQL DB, and delete any traces of that MAC, then re-add to the server?

[Tom Elliott]

@alexf2132 Correct.

The simplest method, I imagine, would be if you know all the mac’s that the host is sending to the system, would be to find out what hostID’s are returned.

Ensure those hostID’s are not in use and remove them.

A simple cleanup sql statement might be:

delete from hosts where hostID NOT IN (select hmHostID from hostMAC);
delete from hostMAC where hmHostID NOT IN (select hostID from hosts);

Of course create a backup first, those are just coming from memory and my syntax may not be correct.

[alexf2132]

@Tom-Elliott I’m not amazing with MySQL. Your syntax, do I input the specific MAC somewhere in there? Or just run both of those lines in the DB?

[Tom Elliott]

@alexf2132 I don’t know the MAC’s that are causing conflicts. My statements there are just to cleanup any unmatching bits. The first will remove any Host’s that don’t have a an ID in the hostMAC table. The second will remove any mac’s that don’t have a relevant matching host from the hosts table.

Once you get those cleaned up, I need to know the MAC’s of the client presenting with the “Multiple hosts returned” and we can consolidate and narrow from there.

[alexf2132]

@Tom-Elliott Okay. Ran those lines, 0 rows were affected.

Ethernet MAC: 28-D2-44-34-3E-DF
WiFi MAC: 00-C2-C6-05-88-BD

[Tom Elliott]

@alexf2132 So now what happens if you run:

SELECT hmHostID from hostMAC where hmMAC IN ('28:d2:44:34:3e:df','00:c2:c6:05:88:bd');

[alexf2132]

@Tom-Elliott

There’s an exact picture of what happened.

[Tom Elliott]

@alexf2132 And does that host continue to say multiple hosts?

[alexf2132]

@Tom-Elliott Yes.

[Tom Elliott]

@alexf2132 How are you aware of the mac’s the host is reporting back then?

Can you open a CMD window on the client and run:

getmacaddress

[alexf2132]

@Tom-Elliott The only media connected is the ethernet MAC. But when I go into the fog.log file, it still says “Reponse Error multiple hosts returned for list of mac addresses”. That’s what I was responding “Yes” with.

[Tom Elliott]

@alexf2132 The post I’m replying to here is why I’m asking about the mac addresses you gave me.

[alexf2132]

@Tom-Elliott Okay. Still not making much sense to me. This all is very strange because I didn’t have any of these problems on FOG 1.2.0. Unfortunately I can’t use that version because it isn’t compatible with Intel NIC’s on that laptops that my company uses, unless there’s a patch/kernel I can add to 1.2.0 that allows Intel NIC’s to work?

[Tom Elliott]

@alexf2132 What is output if you open a command prompt on that client and run the command getmacaddress

[alexf2132]

@Tom-Elliott

One of those is for Bluetooth. The one ending in “88-BD” is for Wi-Fi.

[Tom Elliott]

So the select statement from earlier, try:

SELECT hmHostID from hostMAC where hmMAC IN ('28:d2:44:34:3e:df','00:c2:c6:05:88:bd','00:c2:c6:05:88:c1');

[alexf2132]

@Tom-Elliott Still getting the same MAC error.