• Recent
    • Unsolved
    • Tags
    • Popular
    • Users
    • Groups
    • Search
    • Register
    • Login

    Host Stuck in Database?

    Scheduled Pinned Locked Moved
    FOG Problems
    2
    2
    819
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • A
      Asher Kenerly
      last edited by

      One of the first hosts that I added to Fog trough the full reg from the PXE menu was interrupted during the registration process. From the fog web interface, I can see the host but if I go to edit the host (Like to assign an image) the changes don’t appear. If I try to delete the host, after I hit the confirm button to delete, the web page says it can’t display the page, and the host doesn’t go away. Please help resolve this, maybe I have to manually edit the MySQL database? Also, as a spin off on this question, I had to add an entire lab of computers to Fog and I did it by collecting the host names and MAC’s from each machine, putting them in a .csv file and importing. It worked, except my formatting was off and I left a trailing space behind each host name, so I deleted each host, fixed the .csv, but when I go to add the .csv again it tells me there is a host already with that mac address. However, I can edit other hosts that I added through .csv and from PXE boot registration. Please help me with these problems!

      1 Reply Last reply Reply Quote 0
      • Tom ElliottT
        Tom Elliott
        last edited by

        If you know the information such as the host ID you can remove with an sql statement. Why you can’t now is probably because the hostID is currently set to 0 which FOG can’t recognize. That said, normally the host wouldn’t even appear to the system, so the only other guess is maybe and image isn’t set to this host?

        To remove the host:
        [code]mysql -u root -h’<YOUR FOG IP HERE>’ [-p’<YOUR MYSQL ROOT PASSWORD>’ #ONLY IF SET]
        DELETE FROM hosts WHERE hostName=‘HOSTNAMEOFSYSTEMTOREMOVE’;
        [/code]

        Please help us build the FOG community with everyone involved. It's not just about coding - way more we need people to test things, update documentation and most importantly work on uniting the community of people enjoying and working on FOG! Get in contact with me (chat bubble in the top right corner) if you want to join in.

        Web GUI issue? Please check apache error (debian/ubuntu: /var/log/apache2/error.log, centos/fedora/rhel: /var/log/httpd/error_log) and php-fpm log (/var/log/php*-fpm.log)

        Please support FOG if you like it: https://wiki.fogproject.org/wiki/index.php/Support_FOG

        1 Reply Last reply Reply Quote 0
        • 1 / 1
        • First post
          Last post

        223

        Online

        12.0k

        Users

        17.3k

        Topics

        155.2k

        Posts
        Copyright © 2012-2024 FOG Project