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

    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.

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

  • What version of FOG?