SOLVED Fog All Hosts List Issue
Setup a second Fog Server today for testing purposes. I got the image that I use copied over from one to the other, (both running on Fedora 23). I can image a PC using the quick image option, but when I try to do full registration etc it goes through all the normal stuff, reboots and then just goes back to the fog pxe menu as if it was never registered. (If you do the same PC again at that point for registration it says that there is already a host with that name)
Under Host Management > All Hosts it returns “No Results Found”.
When I try to add one of the hosts that have already been imaged or import them via CSV it says they all already exist and cant be added. Any thoughts?
Let me know if there is any more info I can provide.
Ok just an update, I got the issue fixed. To do so I had to delete the entries manually from the MariaDB for Fog. (Mysql)
[root@localhost ~]# mysql -u root fog Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is 29 Server version: 10.0.23-MariaDB MariaDB Server Copyright (c) 2000, 2015, Oracle, MariaDB Corporation Ab and others. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. MariaDB [fog]> delete from hosts where hostName NOT LIKE ' '; Query OK, 51 rows affected (0.00 sec).
- mysql -u root fog
- delete from hosts where hostName NOT LIKE ’ ';
As a note the second line as I used it deletes all hosts, if you have a problem with only certain hosts then you would want to alter that.
Ok, I now have it accepting new hosts via registration, but I still have the same issue when trying to import.
Host Management Import Host Results Total Rows 50 Successful Hosts 0 Failed Hosts 50 Errors Row #1: Host already exists with this name: AG-EA-D012 Row #2: Host already exists with this name: AG-EA-D040 Row #3: Host already exists with this name: AG-EB-D064 Row #4: Host already exists with this name: AG-EB-D086
There are more “Row #*” entries but they are just the same with different names.
The “New” test server is running 8329.
The working server is 7961.
Tom Elliott last edited by
What version of FOG?