Fog All Hosts List Issue

[BStalker]

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.

[Tom Elliott]

What version of FOG?

[BStalker]

The “New” test server is running 8329.
The working server is 7961.

[BStalker]

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.

[BStalker]

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).

So basically

1. mysql -u root fog
2. 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.