Host added but not visible



  • Hello,
    my conf:
    fedora 22 64b
    fog: svn 4742
    I can’t add new host via GUI. It looks everything fine during adding host. I get message “Host added” but when trying list last added host get nothing.
    host.png
    Host is in database fog, table hosts but is not visible
    mariadb.png
    Regards



  • Hello,
    Problem solved.
    First of all, big thanks to Tom Elliott for support.
    The problem was the MAC, was registered as a “Pending MAC”.
    Regards.



  • @Tom-Elliott
    host name: knur-66
    and primary mac: 14:DD:A9:80:2F:63
    only these two values


  • Senior Developer

    @robza What are the exact values you’re putting into the text fields when you try adding a host?



  • @Tom-Elliott
    here is URL

    http://v1fog/fog/management/index.php?node=host&sub=edit&id=1600
    

    and screen from mysql
    3hosty.png
    Regs


  • Senior Developer

    @robza can you create a new host and show me the URL it is taking you to?



  • @Tom-Elliott Tom often when I login to fog I got this message
    pending.png
    Usually click to approve.
    Maybe this is issue.?
    But when I add new host I get info "Host added"
    hostadded.png
    Regards


  • Senior Developer

    @robza is there a possibility of hosts with the same MAC address? What you’re describing sounds very similar to the deleting hosts that I know has since been fixed. I can only think of three possible scenarios as to why you may be seeing this.

    My first thought is macs are jumping because the host you’re adding is “stealing” the primary mac from another host that has. This would present to you in much the same way as you are describing. It does not answer why one of your new hosts entered manually would have disappeared though.

    My second thought is your fog server is not actually running the current version. This should be very easy to identify as, in most cases of this type of problem, the version in the cloud icon of the page will not match the version you have downloaded. This would occur because the document root changes from system to system and sometimes ever version to version of the OS. As you’re describing the version, at the start of the topic, as 4742, I doubt this is the issue.

    The third way, I suspect, is more similar to what your describing almost directly. It does not explain other hosts disappearing on you, but it does describe how it could be possible for the host you just created to not appear. When you are saving the host it gives a whit page. At the point this white page occurs the object has not made it far enough to actually insert the new host Mac into the host Mac table.

    I realize this is a lengthy post and probably still won’t work, but I’m just throwing out potential possibilities as to how it is occurring.



  • @Uncle-Frank
    Hello,
    this is my error log from apache
    upw-15.png
    Regards


  • Developer

    Again the question: Do you see any errors in your apache error (not access!) log file when adding a host?



  • @Tom-Elliott
    Hello Tom,
    I removed disassociated host. But when trying add new still same result, host is not visible in GUI
    Below output from mysql.
    knur-mac2.png

    knur-mac1.png

    knur-mac.png
    I also noticed when I tryied change mac in different host also disapeared from gui and appear here:
    knur-mac3.png
    Regards.


  • Senior Developer

    WHat I would recommend may not be nice, but should correct the problem for you. It appears, from the output you have, that there are 37 disassociated hosts. This basically means the hosts that were returned exist in the host table, but do not have a relevant mac address associated with them. To refine it even further, you can get just the Hosts that do not have a Primary MAC, which is the important part.

    SELECT hostID from hosts WHERE hostID NOT IN (SELECT hmHostID FROM hostMAC WHERE hmPrimary=1)
    

    The above command will only show host ID’s that do not have an associated primary MAC and do not have an associated hostID entry in the hostMAC table.

    I’d recommend deleting the entries returned from the resultant set. I’d recommend doing these individually.

    The sql syntax to delete these hosts would be:

    DELETE FROM hosts WHERE hostID=relevantHostIDNumberHere;
    

    You can chain it if you need with:

    DELETE FROM hosts WHERE hostID IN (firstID,secondID,thirdID,etc....);
    

    Of course change the firstID, secondID, thirdID, and relevantHostIDNumberHere to the relevant and real host ID’s.



  • @Tom-Elliott
    besides this problematic host have got few other.
    Here is what I get after

    SELECT * FROM HOSTS WHERE hostID NOT IN (SELECT hmHostID FROM hostMAC) \G
    

    knur.png
    Regards


  • Senior Developer

    What do you get with the sql command:

    SELECT * FROM HOSTS WHERE hostID NOT IN (SELECT hmHostID FROM hostMAC) \G
    


  • @Uncle-Frank
    Hi, in my httpd/access_log got this:
    snapin.png
    Regs


  • Developer

    Do you see any errors in your apache log when adding or searching that ‘invisable’ host?


Log in to reply
 

354
Online

39.3k
Users

11.0k
Topics

104.4k
Posts

Looks like your connection to FOG Project was lost, please wait while we try to reconnect.