Unable to view host list after upgrade to 1.5.0-RC-9

[Tom Elliott]

can you try updating to RC-10. I seem to vaguely recall a problem like this and am fairly sure it has been fixed.

[jglessner]

@tom-elliott
Updated to RC-10 still experiencing the same issue.
I tried exporting the host list and the generated csv is blank. Also tried to import my most recent host list for this site and got the following message:

So it still seems that the hosts are in there somewhere but are not being displayed.

Maybe a permissions issue? Maybe I could remove the host information from the server side and try to re-import?

I’m a novice Linux user so I could use some direction in finding the files if you think that is a good idea.

[Sebastian Roth]

@jglessner So it seems like all your hosts are gone (mysql table hosts) but the associated MAC addresses (mysql table hostMAC) are still in the table. I think we need to look things up directly in your DB. First take a look at the file /var/www/fog/lib/fog/config.class.php to find your mysql user and password. Then connect to the DB and run queries like that:

shell> mysql -u root -p
Enter password:
...
mysql> use fog;
...
mysql> SELECT hostID,hostName FROM hosts;
...
mysql> SELECT hmID,hmHostID,hmMAC FROM hostMAC;
...
mysql> SELECT COUNT(hostID) FROM hosts;
...
mysql> SELECT COUNT(hmID) FROM hostMAC;
...
mysql> exit
shell>

You seem to have plenty of hosts so I can understand if you don’t want to post the full list here. But let us know how many entries were counted in each table. My guess would be zero for hosts and roughly 200 for hostMAC.

You seem to have a recent host list exported so we can correct this by purging all the entries from the DB before importing the CSV again. Please be very careful to not drop entries from other tables. I am not liable for any data being lost!

shell> mysql -u root -p
Enter password:
...
mysql> use fog;
...
mysql> DELETE FROM hosts;
...
mysql> DELETE FROM hostMAC;
...
mysql> exit
shell>

[jglessner]

@sebastian-roth
Thank you for your detailed response. Sorry for my delay in getting back to you.

I followed your instructions for listing the hosts and host MACs. It looks like all the data was actually still there.
193 hosts
251 host MACs

I removed the hosts and MACs anyway since I have a pretty recent exported host list. After removing them I returned to the web interface and saw that there was one pending host listed on the host management screen. This was the first time since updating that I’ve had any host information appear here.

So with the hosts and host MACs all removed, client machines are trying to register and successfully appearing as pending hosts.

I imported my host csv and successfully imported 189 hosts, however as soon as the import was done the host list appeared blank again just like in my previous snapshot.

Is my host data itself causing the issue?

I looked at the CSV and the entries are pretty varied. Perhaps I should clean it up more before uploading?

I don’t have a problem sharing it through a private message if you would like.

[Norm]

@sebastian-roth I’m having the same issue as @jglessner
running Ubuntu 14.04. Noticed issue in 1.5.0-RC-8, upgraded to 1.5.0-RC-10, same issue. When I click on list all hosts, “No results found” breifly appears, then it flips back to screen @jglessner posted at the top of this thread. If I enter a PC name in the search field in top left, my PC is there. If I search for a partial name my PC’s are there, but list all PC’s is blank. I changed FOG Configuration -> FOG Settings -> FOG View Settings -> to ‘Search’, no change, back to ‘list’, no change

[Tom Elliott]

http://fogserver/fog/management/index.php?node=host&sub=list

This direct link shows the same thing? (change fogserver with your hostname/ip for the fog server itself.

[davido38]

Same problem for me

Debian 8
1.5.0 RC10

If i search a host i can find it and deploy image.

But when i try list all host i have a message for 2 seconds “No result Found” and the same screen of the first post.

[Norm]

I have a screen capture video of the issue, but couldn’t upload it, and couldn’t trim it any smaller to post it. anyway, still no go. ‘List all hosts’ still gives me an an empty host list. I can search and find select hosts. Today I found several without a Windows product key. Copy from my speadsheet, paste into fog. next one I have to search again, copy and paste, again, I loose my search results. Forget this, I got work to do, I reverted back to release 1.4.4, all my hosts are there.

[davido38]

I test to a new install rc-10 and after import hosts same problem
I test again to a new install rc-10 without import just create new host and no problem

[Sebastian Roth]

@DJslimD1k May I ask you to open a new topic on this and post all your details there. You probably don’t use the same version mentioned in the topic headline and so this is one of the first important things we need to know to be able to help you.

Mixing this up with things from an old topic will likely cause confustion…

[george1421]

MOD Note: Topic of @DJslimD1k has been forked here: https://forums.fogproject.org/topic/14918/listing-all-hosts-gives-me-an-http-error-500