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

Pending Hosts list is empty

Scheduled Pinned Locked Moved Solved
Bug Reports
3
23
7.3k
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.
  • X
    x23piracy
    last edited by x23piracy Nov 7, 2016, 9:45 AM Nov 7, 2016, 3:42 PM

    Server
    • FOG Version: RC20
    • OS: Ubuntu 14

    Hi,

    pending host list remains empty:

    alt text
    after a click on it i just get an empty list:

    alt text

    When i open the home page again it tells me that there are pending hosts again and again.

    Before that i applied the corresponding mac, there i could see the client entry “it4260”

    Regards X23

    ║▌║█║▌│║▌║▌█

    1 Reply Last reply Reply Quote 0
    • T
      Tom Elliott
      last edited by Nov 7, 2016, 9:59 PM

      I set one of my hosts to pending and I see what yo’re seeing.

      I don’t know german very well so I didn’t know what was being said there. Now I see it says:

      “Requires templates to process”

      I fixed it. Will be fixed for RC-21.

      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 2
      • W
        Wayne Workman
        last edited by Nov 7, 2016, 3:52 PM

        https://wiki.fogproject.org/wiki/index.php?title=Troubleshoot_MySQL#Hosts_think_they_are_not_registered_.2F_can.27t_register_.2F_other_weirdness

        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/

        X 1 Reply Last reply Nov 7, 2016, 4:09 PM Reply Quote 0
        • X
          x23piracy @Wayne Workman
          last edited by Nov 7, 2016, 4:09 PM

          @Wayne-Workman said in Pending Hosts list is empty:

          https://wiki.fogproject.org/wiki/index.php?title=Troubleshoot_MySQL#Hosts_think_they_are_not_registered_.2F_can.27t_register_.2F_other_weirdness

          well it found affected rows but didn’ solve the problem:

          alt text

          Still empty list.

          Regards X23

          ║▌║█║▌│║▌║▌█

          W 2 Replies Last reply Nov 7, 2016, 4:13 PM Reply Quote 0
          • W
            Wayne Workman @x23piracy
            last edited by Wayne Workman Nov 7, 2016, 10:22 AM Nov 7, 2016, 4:13 PM

            @x23piracy holy cow 12,126 hosts without a mac address? lol. That’s a new record.

            For the pending issue, if you would like all MACs to just instantly be approved, it’s this:

            UPDATE `hostMAC` SET `hmPending` = '0';
            UPDATE `hosts` SET `hostPending` = '0';
            

            That may solve it, however I still don’t know how your issue happened to begin with or why it’s not displaying anything at all.

            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/

            X 1 Reply Last reply Nov 7, 2016, 4:15 PM Reply Quote 0
            • X
              x23piracy @Wayne Workman
              last edited by x23piracy Nov 7, 2016, 10:16 AM Nov 7, 2016, 4:15 PM

              @Wayne-Workman said in Pending Hosts list is empty:

              @x23piracy holy cow 12,126 hosts without a mac address? lol. That’s a new record.

              For the pending issue, if you would like all MACs to just instantly be approved, it’s this:

              UPDATE `hostMAC` SET hmPending = '0';
              

              That may solve it, however I still don’t know how your issue happened to begin with or why it’s not displaying anything at all.

              i had the same some weeks ago with tom, i can remember that we resettet this and we had also a lot of entrys, i have no idea whats causing this! 😄

              Also after doing this i still have an empty list and system is telling me there are pending hosts.

              ║▌║█║▌│║▌║▌█

              T 1 Reply Last reply Nov 7, 2016, 4:17 PM Reply Quote 0
              • W
                Wayne Workman @x23piracy
                last edited by Wayne Workman Nov 7, 2016, 10:18 AM Nov 7, 2016, 4:16 PM

                @x23piracy There was a typo in that one SQL statement,

                DELETE FROM `hosts` WHERE `hostID` NOT IN (SELECT `hmhostID` FROM `hostMAC`);
                

                should have been

                DELETE FROM `hosts` WHERE `hostID` NOT IN (SELECT `hmHostID` FROM `hostMAC`);
                

                the difference is “hmHostID”

                So you might need to restore from the last db backup if you need to (in /home/fogDBbackups). I do apologize.

                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
                • T
                  Tom Elliott @x23piracy
                  last edited by Nov 7, 2016, 4:17 PM

                  @x23piracy Hosts can be put into a pending status and it’s defined by the host itself.

                  Try:

                  DELETE FROM hosts WHERE hostPending='1';

                  Then do the tricky stuff

                  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

                  X 1 Reply Last reply Nov 7, 2016, 4:18 PM Reply Quote 0
                  • X
                    x23piracy @Tom Elliott
                    last edited by Nov 7, 2016, 4:18 PM

                    @Tom-Elliott said in Pending Hosts list is empty:

                    @x23piracy Hosts can be put into a pending status and it’s defined by the host itself.

                    Try:

                    DELETE FROM hosts WHERE hostPending='1';

                    Then do the tricky stuff

                    that worked but why i do always have this problem?

                    ║▌║█║▌│║▌║▌█

                    T 1 Reply Last reply Nov 7, 2016, 4:20 PM Reply Quote 0
                    • T
                      Tom Elliott @x23piracy
                      last edited by Nov 7, 2016, 4:20 PM

                      @x23piracy I don’t know, but if I had to guess i couldn’t give a good status.

                      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

                      T 1 Reply Last reply Nov 7, 2016, 4:54 PM Reply Quote 0
                      • T
                        Tom Elliott @Tom Elliott
                        last edited by Nov 7, 2016, 4:54 PM

                        Please run as @Wayne-Workman suggested, followed by the hostPending cleanup.

                        Then let it run for a bit. I’m suspecting something else is injecting data at “strange” times. The reason why you’re seeing funny mac’s is because at the point that it’s trying to do something there is no network available. Maybe try putting your fogservice startup on a slight delay of 3 minutes?

                        Just a suggestion based on what I understand of the information.

                        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

                        X 1 Reply Last reply Nov 7, 2016, 5:32 PM Reply Quote 0
                        • X
                          x23piracy @Tom Elliott
                          last edited by Nov 7, 2016, 5:32 PM

                          @Tom-Elliott said in Pending Hosts list is empty:

                          Please run as @Wayne-Workman suggested, followed by the hostPending cleanup.

                          Then let it run for a bit. I’m suspecting something else is injecting data at “strange” times. The reason why you’re seeing funny mac’s is because at the point that it’s trying to do something there is no network available. Maybe try putting your fogservice startup on a slight delay of 3 minutes?

                          Just a suggestion based on what I understand of the information.

                          I have the older fog client 11.4 in my base image (not updated yet) maybe this i making problems. Today i deployed an image and fog service wasn’t there anymore, so i tried to repair fog client and getting cannot install ca cert error, i fully deinstalled and reinstalled from fog website.

                          Since some RC’s renaming and domain joining isn’t working propperly, i will try to embed latest client in my current image to see if this helps.

                          ║▌║█║▌│║▌║▌█

                          T 1 Reply Last reply Nov 7, 2016, 6:48 PM Reply Quote 0
                          • T
                            Tom Elliott @x23piracy
                            last edited by Nov 7, 2016, 6:48 PM

                            @x23piracy I don’t think it has anything to do with the rc’s or the version of the client any more.

                            Potentially by cleaning out these bad entries and ensuring your nodes/servers are all updated to the most current, I imagine this issue will no longer be present.

                            My “theory” on what was causing the bad entries is still just a theory. By trying with a delayed startup of the fog service we should notice relatively quickly if the issue is still present or not. Of course this means updating all your hosts to have the same delayed start, which I don’t think you would want to do right now.

                            I suppose it’s possible some of the older FOG Clients (prior to 0.11) could cause this issue as well, but i’m going to lean that what you saw was simply older RC versions cause I’m not a very good programmer :(.

                            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

                            X W 2 Replies Last reply Nov 7, 2016, 7:00 PM Reply Quote 0
                            • X
                              x23piracy @Tom Elliott
                              last edited by x23piracy Nov 7, 2016, 1:05 PM Nov 7, 2016, 7:00 PM

                              @Tom-Elliott said in Pending Hosts list is empty:

                              @x23piracy I don’t think it has anything to do with the rc’s or the version of the client any more.

                              Potentially by cleaning out these bad entries and ensuring your nodes/servers are all updated to the most current, I imagine this issue will no longer be present.

                              My “theory” on what was causing the bad entries is still just a theory. By trying with a delayed startup of the fog service we should notice relatively quickly if the issue is still present or not. Of course this means updating all your hosts to have the same delayed start, which I don’t think you would want to do right now.

                              I suppose it’s possible some of the older FOG Clients (prior to 0.11) could cause this issue as well, but i’m going to lean that what you saw was simply older RC versions cause I’m not a very good programmer :(.

                              from the past i kept the delayed start, this is still in my image base. 😉 this can’t be the reason.

                              alt text

                              So all my actual clients start the service delayed, anyway i can change the service start behaviour with pdq deploy when ever i want 🙂

                              i cannot exactly tell since when its not working fine anymore but only a few of the last clients cleanly renamed and joined the domain, this was working so perfectly before.

                              ║▌║█║▌│║▌║▌█

                              1 Reply Last reply Reply Quote 0
                              • W
                                Wayne Workman
                                last edited by Nov 7, 2016, 7:16 PM

                                I have the OP issue now… ugh… I’m going to dig into it in a minute.

                                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/

                                X 1 Reply Last reply Nov 7, 2016, 7:19 PM Reply Quote 0
                                • X
                                  x23piracy @Wayne Workman
                                  last edited by x23piracy Nov 7, 2016, 1:22 PM Nov 7, 2016, 7:19 PM

                                  @Wayne-Workman said in Pending Hosts list is empty:

                                  I have the OP issue now… ugh… I’m going to dig into it in a minute.

                                  what i did today was borrowing a hp x2 port rep to make a pxe boot with a new device without own port rep, therefore i had duplicate mac and pxe boot menu told me host already registered, sure same mac!, so i just renamed the host name of the existing one, deployed the image and after that i deleted the host from fog (to get sure i don’t produce accidents because of the port rep’s mac adress with the original client), little later i had that pending message on home page, sure client was knocking at fog door again, then i detected the error with the empty list after trying to approve it.

                                  ║▌║█║▌│║▌║▌█

                                  1 Reply Last reply Reply Quote 0
                                  • W
                                    Wayne Workman @Tom Elliott
                                    last edited by Nov 7, 2016, 8:40 PM

                                    @Tom-Elliott we have three computers that are causing our host pending issue. All three of them were last deployed today.

                                    So, something with the imaging process is causing them to change to pending.

                                    MariaDB [fog]> select hostID, hostName, hostPending from hosts where hostPending = '' or hostPending = '1';
                                    +--------+------------+-------------+
                                    | hostID | hostName   | hostPending |
                                    +--------+------------+-------------+
                                    |   2184 | ET5Q197    |             |
                                    |   2186 | ET5Q198    |             |
                                    |   2185 | L530Win10E | 1           |
                                    +--------+------------+-------------+
                                    3 rows in set (0.00 sec)
                                    
                                    MariaDB [fog]> select * from hostMAC where hmPending = '' or hmPending = '1';
                                    +------+----------+-------------------+--------+-----------+-----------+----------------+-----------------+
                                    | hmID | hmHostID | hmMAC             | hmDesc | hmPrimary | hmPending | hmIgnoreClient | hmIgnoreImaging |
                                    +------+----------+-------------------+--------+-----------+-----------+----------------+-----------------+
                                    | 8358 |     2184 | 18:db:f2:0e:25:06 |        | 1         |           |                |                 |
                                    | 8359 |     2185 | 9c:4e:36:5a:11:a1 |        | 1         |           |                |                 |
                                    | 8362 |     2186 | 18:db:f2:13:49:04 |        | 1         |           |                |                 |
                                    +------+----------+-------------------+--------+-----------+-----------+----------------+-----------------+
                                    3 rows in set (0.00 sec)
                                    
                                    MariaDB [fog]>
                                    
                                    

                                    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/

                                    T 1 Reply Last reply Nov 7, 2016, 9:14 PM Reply Quote 0
                                    • T
                                      Tom Elliott @Wayne Workman
                                      last edited by Nov 7, 2016, 9:14 PM

                                      @Wayne-Workman I only see one pending host

                                      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

                                      W 1 Reply Last reply Nov 7, 2016, 9:17 PM Reply Quote 0
                                      • W
                                        Wayne Workman @Tom Elliott
                                        last edited by Wayne Workman Nov 7, 2016, 3:18 PM Nov 7, 2016, 9:17 PM

                                        @Tom-Elliott I set all hosts to ‘0’ earlier. Now there are suddenly 3 that are not set to ‘0’. Nobody deleted them. The only thing they have in common is that they were imaged today.

                                        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/

                                        T 1 Reply Last reply Nov 7, 2016, 9:18 PM Reply Quote 0
                                        • T
                                          Tom Elliott @Wayne Workman
                                          last edited by Nov 7, 2016, 9:18 PM

                                          @Wayne-Workman that doesn’t matter

                                          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

                                          W 1 Reply Last reply Nov 7, 2016, 9:19 PM Reply Quote 0
                                          • W
                                            Wayne Workman @Tom Elliott
                                            last edited by Nov 7, 2016, 9:19 PM

                                            @Tom-Elliott it doesn’t matter that I set the hosts to 0 and they changed on their own to null ?

                                            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/

                                            T 2 Replies Last reply Nov 7, 2016, 9:25 PM Reply Quote 0
                                            • 1
                                            • 2
                                            • 1 / 2
                                            1 / 2
                                            • First post
                                              2/23
                                              Last post

                                            164

                                            Online

                                            12.0k

                                            Users

                                            17.3k

                                            Topics

                                            155.2k

                                            Posts
                                            Copyright © 2012-2024 FOG Project