Disappearing hosts from host list
We noticed a strange issue since 1.3.0 installed. Formerly well known hosts are no visible if listed (like all hosts or group memberships). At first we thought those hosts are not there we only just remembering wrong, but in group list or host lists it is counted (group shows 5 pc but 4 listed) and if we try to create a new host by that name it says there are already a host with that name.
How can we kill this bug? :)
additional info: the mentioned hosts are for cloning processes only. Name is permanent, but sometimes MAC or image changed for the new cloning procedure.
Anyone have seen it maybe?
@Wayne-Workman It worked perfectly, Thanks.
@Wayne-Workman Thanks Wayne, I have followed your instructions and have a new fresh installation to work with.
I’ve backed up my database and exported my hosts, printers etc to csv files so I can copy paste the information back into the FOG GUI. How do I make a fresh empty FOG database but keep my settings?
I know you said you have copies of your data, but the instructions I give you will also include taking another backup.
SSH to your fog server (or log into it and open terminal). Become root with
backup the fog db with
mysqldump -D fog > /root/fogdbbackup.sql
Then just drop the fog database as so:
mysql drop database fog; exit
Then re-run the fog 1.3.0 installer. It’ll rebuild the DB for you.
If this goes south, you can always import the old db like this:
mysql -D fog < /root/fogdbbackup.sql
I upgraded from 1.2.0 to 1.3.0 yesterday and have the same problem as Foglalt. The hosts and printers are in the database but cannot be listed in the FOG web application. I’ve also done the steps detailed here https://wiki.fogproject.org/wiki/index.php?title=Troubleshoot_MySQL#Hosts_think_they_are_not_registered_.2F_can.27t_register_.2F_Already_Registered_.2F_other_weirdness
I would now like to try to get a fresh start as my database began it’s life in 2009. I’ve backed up my database and exported my hosts, printers etc to csv files so I can copy paste the information back into the FOG GUI. How do I make a fresh empty FOG database but keep my settings?
@Foglalt some of the trunk versions between 1.2.0 and 1.3.0 had serious issues. We’re confident those are resolved now in 1.3.0 onwards. You probably had the issue for a long time (junk data in your database) without even noticing an issue until just now.
Hm that article part for me was new, thanks, it helped (i checked some and they are gone now normally). How can it happen anyway?
I see. And how can i recover it? As if i dont see, i cant delete. (btw the new search function for me is strange a bit; i will post question in that regard if i have time to see if other info on that helps :) )
This can happen if the same mac exists across multiple hosts. This would leave the entry in the host table, but there would be no MAC Address associated with that host. If there’s no mac (in particular a primary mac address) then the host entry will exist in the host table (giving the hostname exists issue you’re referring to) but not appearing within the GUI as, for all intents and purposes, the host has become “invalid”.