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

Pending hosts notification

Scheduled Pinned Locked Moved Solved
FOG Problems
3
8
2.4k
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.
  • H
    Hanz
    last edited by Oct 15, 2015, 4:13 PM

    I’m running svn 4972 on Fedora 22

    I have the pending hosts notification permanently both, after accepting pending host, and if none are even present on “Pending hosts” page.

    1 Reply Last reply Reply Quote 0
    • J
      Joseph Hales Testers
      last edited by Oct 15, 2015, 5:19 PM

      I and several others had this issue what happened is during a certain SVN version the MAC addresses were being randomly deleted but this has since been fixed what you need to do is go into MySQL and remove the orphaned records manually. See this thread https://forums.fogproject.org/topic/5811/service-settings-not-enabled-by-default/3

      RTFM

      1 Reply Last reply Reply Quote 1
      • H
        Hanz
        last edited by Oct 15, 2015, 5:24 PM

        Ran it, but even after reboot problem persists.

        1 Reply Last reply Reply Quote 0
        • J
          Joseph Hales Testers
          last edited by Oct 15, 2015, 5:27 PM

          what was the response in mysql rows selected ect?

          RTFM

          1 Reply Last reply Reply Quote 0
          • H
            Hanz
            last edited by Oct 15, 2015, 5:30 PM

            0 rows affected

            1 Reply Last reply Reply Quote 0
            • W
              Wayne Workman
              last edited by Wayne Workman Oct 15, 2015, 4:38 PM Oct 15, 2015, 10:33 PM

              Look at this: https://forums.fogproject.org/topic/5834/host-added-but-not-visible

              and this: https://forums.fogproject.org/topic/5716/some-clients-disappear-from-web-interface-but-are-still-present-in-databse

              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!
              Daily Clean Installation Results:
              https://fogtesting.fogproject.us/
              FOG Reporting:
              https://fog-external-reporting-results.fogproject.us/

              1 Reply Last reply Reply Quote 0
              • H
                Hanz
                last edited by Oct 15, 2015, 10:58 PM

                Thanks Wayne, I had some 20 disassociated hosts and ID’s. The pending host issue is resolved after deleting hosts from output of
                SELECT hostID from hosts WHERE hostID NOT IN (SELECT hmHostID FROM hostMAC WHERE hmPrimary=1);

                by

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

                W 1 Reply Last reply Oct 15, 2015, 11:25 PM Reply Quote 0
                • W
                  Wayne Workman @Hanz
                  last edited by Oct 15, 2015, 11:25 PM

                  @Hanz Glad you got it fixed.

                  For others future reference, This command:
                  SELECT hostID from hosts WHERE hostID NOT IN (SELECT hmHostID FROM hostMAC WHERE hmPrimary=1);

                  can be changed into a command to delete all that it returns by simply changing select to delete like this:

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

                  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!
                  Daily Clean Installation Results:
                  https://fogtesting.fogproject.us/
                  FOG Reporting:
                  https://fog-external-reporting-results.fogproject.us/

                  1 Reply Last reply Reply Quote 1
                  • 1 / 1
                  1 / 1
                  • First post
                    7/8
                    Last post

                  161

                  Online

                  12.0k

                  Users

                  17.3k

                  Topics

                  155.2k

                  Posts
                  Copyright © 2012-2024 FOG Project