MAC already exists

[astrugatch]

Running FOG 1.5.8 on Ubuntu 18.04

Removed a Mac address from a machine so I could use a usb network adapter to image it. When I went to put the built in Wifi MAC address back into the machine config it says that it is already in use, but it is no longer on that machine’s entry or in use anywhere else.

[Sebastian Roth]

@astrugatch Please run the following two mysql querys on the command line to see if you can find it in the database:

SELECT * FROM hostMAC WHERE hmMAC LIKE '%aa:bb:cc:dd:ee:ff%';
SELECT * FROM hosts WHERE hostID IN (SELECT hmHostID FROM hostMAC WHERE hmMAC LIKE '%aa:bb:cc:dd:ee:ff%');

Put in the adapters MAC address instead of aa:bb:cc:dd:ee:ff.

I am wondering why you say “Wifi MAC address” at one point. Just a typo?

[astrugatch]

@Sebastian-Roth

The Mac shows up in the table. Assigned to my device, but under pending. So I went to pending and approved the Mac addresses. Though when I went back and tried to remove the temporary Mac that is in the primary field and move the built in MAC address to the primary field but it still gives the error when I save that the Mac is already assigned (to the machine who’s page I’m on).

There are 3 Mac addresses in the mix.

1. The temporary usb adapter
2. another USB adapter that the user usually has. This one doesn’t support PXE hence the temp adapter.
3. The Wifi Mac that I keep as a secondary because we use the client and I want the machine to still check in while on Wifi.

[Sebastian Roth]

@astrugatch As far as I remember there was an issue in this part of the web UI which is fixed in the latest release candidate version. Though we can’t be sure if it’s the same unless you update to the latest and test.

[astrugatch]

@Sebastian-Roth

Now that I have the necessary MAC addresses at least associated with the machine I am good for now. I will wait for a final release before I move. This isn’t a deal breaker kind of issue for me.