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

Persistent Groups - Snapins added to host but not deployed

Scheduled Pinned Locked Moved
Feature Request
5
39
7.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.
  • G
    george1421 Moderator @GeorgeBells
    last edited by Feb 10, 2021, 3:12 PM

    @georgebells I haven’t had a lot of bandwidth to look into this, but I just tested the updated php code from my earlier post on our production FOG server and it installs what it should. I need to test to see if it creates the snapin tasks correctly, but I also need to create a few fake snapins because we don’t use snapins on my campus so that will take a bit more time than I have at the moment.

    I installed the updated php code as outlined below
    rebooted the apache server
    went into the web ui and uninstalled the persistent group plugin
    reinstalled the persistent group plugin
    logged into the mysql server as root and attached to the fog database
    expanded my putty window very wide
    ran this sql command show CREATE TRIGGER persistentGroups;

    I reviewed the sql program near the bottom and saw the “patched” code

            INSERT INTO `printerAssoc` (`paHostID`,`paPrinterID`,`paIsDefault`,`paAnon1`,`paAnon2`,`paAnon3`,`paAnon4`)
                SELECT @myHostID as `paHostID`,`paPrinterID`,`paIsDefault`,`paAnon1`,`paAnon2`,`paAnon3`,`paAnon4`
                FROM `printerAssoc` WHERE `paHostID`=@myTemplateID;
    
            SET @myDBTest = (SELECT count(`saSnapinID`) FROM `snapinAssoc` WHERE `saHostID`=@myTemplateID LIMIT 1);
            IF (@myDBTest > 0) THEN
                INSERT INTO `snapinAssoc` (`saHostID`,`saSnapinID`)
                    SELECT @myHostID as `saHostID`,`saSnapinID`
                    FROM `snapinAssoc` WHERE `saHostID`=@myTemplateID;
    
                SET @sjDate = (SELECT NOW());
                INSERT INTO `snapinJobs` (`sjHostID`,`sjStateID`,`sjCreateTime`)
                    SELECT @myHostID as `sjHostID`,1 as `sjStateID`,@sjDate as `sjCreateTime`;
    
                SET @mysjID = (SELECT `sjID` FROM `snapinJobs` WHERE `sjCreateTime`=@sjDate);
                INSERT INTO `snapinTasks` (`stJobID`,`stState`,`stCheckinDate`,`stCompleteDate`,`stSnapinID`,`stReturnCode`,`stReturnDetails`)
                    SELECT @mysjID as `stJobID`,1 as `stState`,@sjDate as `stCheckinDate`,STR_TO_DATE('00,00,0000','%d,%m,%Y') as `stCompleteDate`,`saSnapinID` as `stSnapinID`,0,''
                    FROM `snapinAssoc` WHERE `saHostID`=@myHostID;
            END IF;
    
            INSERT INTO `moduleStatusByHost` (`msHostID`,`msModuleID`,`msState`)
                SELECT @myHostID as `msHostID`,`msModuleID`,`msState`
    
    

    This is what was inserted

            SET @myDBTest = (SELECT count(`saSnapinID`) FROM `snapinAssoc` WHERE `saHostID`=@myTemplateID LIMIT 1);
            IF (@myDBTest > 0) THEN
                INSERT INTO `snapinAssoc` (`saHostID`,`saSnapinID`)
                    SELECT @myHostID as `saHostID`,`saSnapinID`
                    FROM `snapinAssoc` WHERE `saHostID`=@myTemplateID;
    
                SET @sjDate = (SELECT NOW());
                INSERT INTO `snapinJobs` (`sjHostID`,`sjStateID`,`sjCreateTime`)
                    SELECT @myHostID as `sjHostID`,1 as `sjStateID`,@sjDate as `sjCreateTime`;
    
                SET @mysjID = (SELECT `sjID` FROM `snapinJobs` WHERE `sjCreateTime`=@sjDate);
                INSERT INTO `snapinTasks` (`stJobID`,`stState`,`stCheckinDate`,`stCompleteDate`,`stSnapinID`,`stReturnCode`,`stReturnDetails`)
                    SELECT @mysjID as `stJobID`,1 as `stState`,@sjDate as `stCheckinDate`,STR_TO_DATE('00,00,0000','%d,%m,%Y') as `stCompleteDate`,`saSnapinID` as `stSnapinID`,0,''
                    FROM `snapinAssoc` WHERE `saHostID`=@myHostID;
            END IF;
    
    

    Or if you see this line

    SET @sjDate = (SELECT NOW());
    

    for sure the patch is installed.

    (I still need to confirm this works on my production server)
    In my home testing when I registered the computer I assigned it to the persistent group and selected deploy image right from the registration program.

    I powered it off after registration and confirmed the tasks were created using the fog server web ui

    I powered on the vm and it began imaging. That is where I stopped.

    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!

    1 Reply Last reply Reply Quote 0
    • G
      GeorgeBells
      last edited by Feb 10, 2021, 4:26 PM

      @george1421

      This is the output for mysql - After inserting that file, restarting the apache server, uninstalling and reinstalling the plugin

      ef70f074-6a79-43a4-87d6-393752a15035-image.png

      G 1 Reply Last reply Feb 10, 2021, 4:48 PM Reply Quote 0
      • G
        george1421 Moderator @GeorgeBells
        last edited by Feb 10, 2021, 4:48 PM

        @georgebells it appears that the file hasn’t been replaced on the server for some reason.

        When you view the /var/www/fog/lib/plugins/persistentgroups/class/ directory does persistentgroupsmanager.class.php have a different date than the rest of the files?

        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!

        1 Reply Last reply Reply Quote 0
        • G
          GeorgeBells
          last edited by GeorgeBells Feb 10, 2021, 10:57 AM Feb 10, 2021, 4:56 PM

          @george1421

          It does, it has todays date.

          7c5b76fc-6aa9-498e-800c-ad41f10f1685-image.png

          G 2 Replies Last reply Feb 10, 2021, 4:58 PM Reply Quote 0
          • G
            george1421 Moderator @GeorgeBells
            last edited by Feb 10, 2021, 4:58 PM

            @georgebells Well once that file is updated you need to uninstall and reinstall the plugin. When you uninstall that plugin it will drop that trigger from mysql. When you add the plugin back in via the web ui it will recreate that trigger. The updated file from the google drive has the changes made to the create trigger command. You don’t reinstall FOG because it will overwrite the patched file I sent you.

            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!

            G 1 Reply Last reply Feb 10, 2021, 4:58 PM Reply Quote 0
            • G
              GeorgeBells @george1421
              last edited by Feb 10, 2021, 4:58 PM

              @george1421

              Makes sense - Edited my previous response because I immediately realised this is likely the case, just to clarify incase I did word it wrong, I had been reinstalling just the plugin through the UI, not fog itself.

              1 Reply Last reply Reply Quote 0
              • G
                george1421 Moderator @GeorgeBells
                last edited by Feb 10, 2021, 5:00 PM

                @georgebells well the plugin file has the right number of bytes to the size so I think its the same as the file on my production server.

                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!

                G 1 Reply Last reply Feb 10, 2021, 5:02 PM Reply Quote 0
                • G
                  GeorgeBells @george1421
                  last edited by Feb 10, 2021, 5:02 PM

                  @george1421

                  Interesting…

                  I’ve been going to the fog web management > plugins > installed plugins and uninstalling persistent groups…

                  I have then gone into install plugins, and reinstalled it.
                  I have also tried going to install plugins, deleting it, back to activate plugins, activating it and installing.

                  1 Reply Last reply Reply Quote 0
                  • G
                    GeorgeBells
                    last edited by Mar 1, 2021, 9:24 AM

                    @george1421

                    Do you have any other advice on this? Haven’t had much chance to play around with it lately but hoping to revisit it soon

                    1 Reply Last reply Reply Quote 0
                    • G
                      GeorgeBells
                      last edited by Jun 28, 2021, 3:55 PM

                      @george1421 Hey. Finally got around to looking at this again. Is it possible you have made any updates to the plugin since?

                      1 Reply Last reply Reply Quote 0
                      • A
                        alphamine
                        last edited by Feb 6, 2022, 6:25 PM

                        Hello,

                        I am using fog to manage a data center deployment consisting of over 1000 servers.

                        I am replying here as the UX feedback provided by @GeorgeBells here perfectly sums up issues I’ve been having as well.

                        If a feature request / ‘fix’ per details referenced above is NOT possible or planned, then I sincerely urge the dev team to consider allowing users to assign Snapins directly to images.

                        All of my equipment is of a similar spec, and the image I flash to them contains pre-configured FOG client as well as auto-setup scripts to configure UUID-based values on first boot.
                        All of my “snapins” are entirely image-specific by design.

                        I would like to quick register all new equipment, immediately flash the same specific image, and then deploy the same snapin every time.

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

                        197

                        Online

                        12.0k

                        Users

                        17.3k

                        Topics

                        155.2k

                        Posts
                        Copyright © 2012-2024 FOG Project