Can't find the "Reset Encryption Data" button on any hosts.
-
@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?
-
@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.
-
@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?
-
@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.
-
@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 -
@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'); -
There’s an exact picture of what happened.
-
@alexf2132 And does that host continue to say multiple hosts?
-
@Tom-Elliott Yes.
-
@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 -
@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.
-
@alexf2132 The post I’m replying to here is why I’m asking about the mac addresses you gave me.
-
@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?
-
@alexf2132 What is output if you open a command prompt on that client and run the command
getmacaddress -
One of those is for Bluetooth. The one ending in “88-BD” is for Wi-Fi.
-
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'); -
@Tom-Elliott Still getting the same MAC error.
-
did you run the statement yet? I need to see the output.
-
@Tom-Elliott Here’s the output.
-
Are both of those hosts hosts you need?
You can find the name if you run:
select hostID,hostName from hosts where hostID IN (7,102);
