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

    Full Registration, causing rogue snapins to apply

    Scheduled Pinned Locked Moved Solved
    FOG Problems
    3
    20
    3.8k
    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.
    • Tom ElliottT
      Tom Elliott @adukes40
      last edited by

      @adukes40 I believe the issue was the same as before I figured out the issue with the random disassociations/associations.

      The working-RC-11 side of things had a bug in how it was interpreting code. Basically it wasn’t cleaning up for the next loop cycle. This caused random pieces of data to get inserted/removed unexpectedly.

      I suspect you had more random associations due to this which are only showing up as you register new hosts.

      If you run the mysql statement before, my guess is you’ll see quite a few items being cleaned up.

      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

      adukes40A 1 Reply Last reply Reply Quote 0
      • adukes40A
        adukes40 @Tom Elliott
        last edited by

        @Tom-Elliott You mean the DELETE mysql statement?

        And the (SELECT hostID FROM hosts) sections is part I just run in the command correct? Im not actually getting hostID from the hosts table?

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

          @adukes40 It’s a single statement.

          DELETE FROM snapinAssoc WHERE saHostID NOT IN (SELECT hostID FROM hosts);

          You can also try:
          DELETE FROM snapinAssoc WHERE saSnapinID NOT IN (SELECT sID FROM snapins);

          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

          adukes40A 1 Reply Last reply Reply Quote 0
          • adukes40A
            adukes40 @Tom Elliott
            last edited by adukes40

            @Tom-Elliott

            Database changed
            mysql> DELETE FROM snapinAssoc WHERE saHostID NOT IN (SELECT hostID FROM hosts);
            Query OK, 0 rows affected (0.02 sec)

            mysql> DELETE FROM snapinAssoc WHERE saSnapinID NOT IN (SELECT sID FROM snapins);
            Query OK, 1 row affected (0.01 sec)

            mysql>

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

              @adukes40 So I’m just guessing, that Snapin D in your case was probably that one item?

              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

              adukes40A 2 Replies Last reply Reply Quote 0
              • adukes40A
                adukes40 @Tom Elliott
                last edited by

                @Tom-Elliott I will test some registrations today and see what happens. Getting bombed with early morning emails at the moment.

                1 Reply Last reply Reply Quote 0
                • adukes40A
                  adukes40 @Tom Elliott
                  last edited by

                  @Tom-Elliott Just had a Tech register a machine today. Same outcome all the previous snapins, plus a new one from the room they were in this morning.

                  Havent had time ti test anything else yet.

                  1 Reply Last reply Reply Quote 0
                  • adukes40A
                    adukes40
                    last edited by

                    Ok, just tested this myself.

                    Soo… went to a machine. Registered it with snapin that wasn’t currently in the “rogue” list. When I check the snapins, the new snapin shows, along with the like 8 others, plus the 2 every machine gets. Which mean the next time a machines Regs thru PXE, it will be getting that snapin plus the other stuck in the loop.

                    Wayne WorkmanW 1 Reply Last reply Reply Quote 0
                    • Wayne WorkmanW
                      Wayne Workman @adukes40
                      last edited by

                      @adukes40 This is probably because your DB is still dirty. we need to figure out some queries that will clean it up.

                      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/

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

                        @Wayne-Workman I say simplest would be to truncate snapinAssoc snapinJobs and snapinTasks then rrapply

                        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
                        • adukes40A
                          adukes40
                          last edited by

                          There other I am seeing is sometimes the 1- snapins remove themselves from association after an image. I am looking at two hosts, where that just happened. 1- removes itself, but 2- and 3- always stay.

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

                            @adukes40 had me remote in. We found about 3200 + hosts that hadn’t been properly removed. The older db crud was still left over though which was why it seems to be “rogue” items. Removed the “bad” hosts and all seemed to correct itself.

                            I’m going to resolve for now.

                            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

                            adukes40A 1 Reply Last reply Reply Quote 1
                            • adukes40A
                              adukes40 @Tom Elliott
                              last edited by

                              @Tom-Elliott Its doing it again.

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

                                @adukes40 What’s happening again? All nodes are at the same version?

                                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

                                adukes40A 1 Reply Last reply Reply Quote 0
                                • adukes40A
                                  adukes40 @Tom Elliott
                                  last edited by adukes40

                                  @Tom-Elliott All nodes at RC-11, It back to assigning recently used snapin associations from recent image deployments

                                  0_1475507131758_upload-32d5e685-9979-44a5-844e-e07b3c6cd59b

                                  Nothing has changed here. Just going about day-to-day operation. Tried with same host name, and never before used host name, same result.

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

                                  215

                                  Online

                                  12.0k

                                  Users

                                  17.3k

                                  Topics

                                  155.2k

                                  Posts
                                  Copyright © 2012-2024 FOG Project