Attempting To Send Inventory - Invalid Host? SVN 4193

[Raymond Bell]

@Uncle-Frank Nothing show up running
Ubuntu 12.04

fog@fog-virtual-machine2:~$ lsof -i :3306
fog@fog-virtual-machine2:~$```

[ch3i]

@Raymond-Bell Hi, is it new hosts or hosts that are disappeared that you want to register ? I’ve a same problem with my FOG server, some mac address are missing in the mac address table, I’ve to delete all hosts which are not in the mac address table to register it.

[Raymond Bell]

@ch3i This is a host that was reg and then was missing from fog a week later. I will check the mac address table

[Raymond Bell]

@ch3i I can see the host in the Host Listing Export and it does not have a mac address but when i do a search under host i can not find it. How would i delete it out of the Host Listing Export? Also i get a blank page when i try to look at report Hosts and Users

[ch3i]

@Raymond-Bell said:

@ch3i I can see the host in the Host Listing Export and it does not have a mac address but when i do a search under host i can not find it. How would i delete it out of the Host Listing Export? Also i get a blank page when i try to look at report Hosts and Users

You have the same bug than me, some mac address disappeard and I can’t view it in the host view… can you post the result of

SELECT hostName 
FROM hosts 
WHERE hostID NOT IN ( SELECT hmHostID FROM hostMAC );

[Raymond Bell]

@ch3i And all are missing from fog Host Search

mysql> SELECT hostName 
    -> FROM hosts 
    -> WHERE hostID NOT IN ( SELECT hmHostID FROM hostMAC );
+---------------+
| hostName      |
+---------------+
| es-54-01      |
| es-33-t       |
| jh-18-t2      |
| es-53-04      |
| es-53-01      |
| es-53-02      |
| es-53-06      |
| es-53-09      |
| es-53-08      |
| es-53-t       |
| es-53-10      |
| 0023ae5a3b86  |
| es-52-08      |
| es-52-05      |
| es-52-04      |
| es-52-03      |
| es-52-02      |
| es-52-01      |
| es-08-t       |
| ad-bmace-2015 |
| HS-104-08-Lap |
+---------------+
21 rows in set (0.01 sec)

[Sebastian Roth]

@Raymond-Bell Have you updated to current trunk since yesterday? I really wonder why you do not see any mysql connections on your FOG server. Maybe this issue was solved just by itself. Well then you might want to head for your initial problem and I think ch3i is pointing you the correct way!

[Raymond Bell]

@Uncle-Frank said:

@Raymond-Bell Have you updated to current trunk since yesterday? I really wonder why you do not see any mysql connections on your FOG server. Maybe this issue was solved just by itself. Well then you might want to head for your initial problem and I think ch3i is pointing you the correct way!

Yes i have updated to 4199
Hopefully @ch3i can help me delete these out of here and then i can re-register them

[Raymond Bell]

I have deleted all that where in the list and got the host to register.

[Wayne Workman]

For future readers, the select statement that @ch3i posted can be converted into a delete statement like so:

DELETE hostName 
FROM hosts 
WHERE hostID NOT IN ( SELECT hmHostID FROM hostMAC );