New Build 3.7.0.16 now available

[Cubert]

Chocolatey For Automate 3.7.0.16 is available
https://delivery.shopifyapps.com/-/3177 ... cf2052a942

We have added a fix for issues where groups would drop scheduled scripts afte a script update.

We added a new Plugin Server Script Function to LTScripting that will reset all groups, EDFs and Searches so that you can run a DBagent restart and fix the groups issue for good.

Everyone is suggested to review their Chocolatey groups to make sure the master group and each sub group has a script listed in the scheduled scripts section of group.

Screenshot 2025-03-27 150530.png (48.9 KiB) Viewed 5306 times

I you find that ytou have nissing scripots and need help to correct them. Start a forum post and we will help you fix any issues.

[frankbe]

do you post this in habitat, too ?
i have 1.53 and so 3.7.0.15 and it does not work anymore (right mouseclick, ro repos in the packet window) and log_table is empty

[Cubert]

Yes we did.


If you need to "fix" your settings then here is a good starting point.

Execute the following SQL code, It will not return any data if you are running it in Habitat SQL.

Code: Select all

-- Removes all Searches

DELETE FROM sensorchecks WHERE Name IN ('Chocolatey For Automate Ready','P4A Deploy Chocolatey','P4A Chocolatey Cache Managers','P4A Chocolatey Source Deployment','P4A Chocolatey UNC Deployment','P4A Chocolatey Auto Install Apps','P4A Chocolatey Standard Deployment');

-- Removes groups

DELETE FROM mastergroups WHERE Name IN ('Chocolatey For Automate','C4A Manage Sources','C4A Manage UNC Caches','C4A Deploy Chocolatey','C4A Manage UNC Sources','C4A Auto Install Approved Applications','C4A Manage Standard');
 
 -- Removes assigned scripts
 
 DELETE FROM `groupscript` WHERE `ScriptID` = (SELECT ScriptID FROM lt_scripts WHERE ScriptName = 'P4A Scan Chocolatey Packages');DELETE FROM `groupscript` WHERE `ScriptID` = (SELECT ScriptID FROM lt_scripts WHERE ScriptName = 'P4A Deploy Chocolatey');DELETE FROM `groupscript` WHERE `ScriptID` = (SELECT ScriptID FROM lt_scripts WHERE ScriptName = 'P4A Chocolatey Sources');DELETE FROM `groupscript` WHERE `ScriptID` = (SELECT ScriptID FROM lt_scripts WHERE ScriptName = 'P4A Chocolatey Cache Management');DELETE FROM `groupscript` WHERE `ScriptID` = (SELECT ScriptID FROM lt_scripts WHERE ScriptName = 'P4A Chocolatey Auto Install Approved Applications');DELETE FROM `groupscript` WHERE `ScriptID` = (SELECT ScriptID FROM lt_scripts WHERE ScriptName = 'P4A Chocolatey Standard');DELETE FROM `groupscript` WHERE `ScriptID` = (SELECT ScriptID FROM lt_scripts WHERE ScriptName = 'P4A Chocolatey Uninstall Applications');DELETE FROM `groupscript` WHERE `ScriptID` = (SELECT ScriptID FROM lt_scripts WHERE ScriptName = 'P4A Chocolatey Install Applications');DELETE FROM `groupscript` WHERE `ScriptID` = (SELECT ScriptID FROM lt_scripts WHERE ScriptName = 'P4A Chocolatey Update Applications');
 
 -- Removes the actual LTscripts
            
DELETE FROM lt_scripts WHERE ScriptName = 'P4A Scan Chocolatey Packages';DELETE FROM lt_scripts WHERE ScriptName = 'P4A Deploy Chocolatey';DELETE FROM lt_scripts WHERE ScriptName = 'P4A Chocolatey Sources';DELETE FROM lt_scripts WHERE ScriptName = 'P4A Chocolatey Cache Management';DELETE FROM lt_scripts WHERE ScriptName = 'P4A Chocolatey Auto Install Approved Applications';DELETE FROM lt_scripts WHERE ScriptName = 'P4A Chocolatey Standard';DELETE FROM lt_scripts WHERE ScriptName = 'P4A Chocolatey Uninstall Applications';DELETE FROM lt_scripts WHERE ScriptName = 'P4A Chocolatey Install Applications';DELETE FROM lt_scripts WHERE ScriptName = 'P4A Chocolatey Update Applications';

Afterwards, You will need to restart the DBagent and allow a few minutes for the DBagent to recreate all the stuff you just deleted. This time however, all the ID's will match correctly and your groups, searches and scripts will all align.

This should not effect your data or EDF settings so this should cleanly put you back on the correct scripts and schedules.

Why is this necessary?

We found some failing logic for updating LTscripts. What worked in the past will not work when you are managing groups. In a standard plugin (without groups), when the plugin gets updated and a newer version of the LTscript for that plugin is updated, we delete the old entry and insert the new version. The failure for groups is, a new LTScriptID will be created, and that will cause any group using that script to lose it's ID and such drop the script schedule.

This is one of the fixes we have in build 3.7.0.16. This no longer happens.

[frankbe]

i try the sql commands, when habitat 1.54 is available - or do you have a direct link to download ?

[Cubert]

Sorry, I was off by one, its in Habitat build 1.0.1.53. 1.0.1.53 now has build 3.7.0.16 of C4A. This fixes the issue moving forward. Anyone broken will want to either readd the schedules scripts that are missing manually from the 2 groups current affected by the issue or run the SQL code above to remove them and have the DBagent re add them with correct script association.

viewtopic.php?t=6558

[frankbe]

Sorry, but habitat 1.53 does not work anymore.

right mouse click does not open the menu window, repositories shown as missing (not in the global or local packages)

i did execute the sql statements and Groups are rebuilt - cleared cache etc, but nothing helps

Screenshot 2025-04-02 114335.png (54.52 KiB) Viewed 4198 times

[Cubert]

We changed how and where we get the values for available packages versions.

If your seeing "none" then the agent has not scanned since the update.

On the first scan after update , agent should be replacing the "none" with actualy data.

Also, just to be sure.

Are you running or have installed any other Chocolatey for Automate plugins Version 3.6 or 3.7 in plugin manager? if so disable them. The different versions may conflict with each other, especially if the are pre 3.7.0.16.

Confirm that you indeed have a the agent in question in the list of agents in the Chocolatey For Automate group.

Screenshot 2025-04-02 100320.png (72.62 KiB) Viewed 4121 times

Then validate that the group has a scheduled script available.

Screenshot 2025-04-02 100402.png (50.35 KiB) Viewed 4121 times

If agent is missing from list, the check agents EDFs

The following EDFs allows agents to join the main group and thus receive scan schedules.

Screenshot 2025-04-02 100900.png (91.54 KiB) Viewed 4121 times

If Script is not scheduled in group, the the SQL above can be run to fix issue once the DBagent is restarted. It is plausable that your user does not have the permissions to execute one or more of the SQL statments above. In this case, running SQL statments and restarting DBagent will not work as the data in SQL still remained after the commends ran. You should then make sure that your are able to have SQL executed as root SQL user or user with elevated permissions.


"Habitat Users Only" (C4A already has this function)
What I can do is add a Server Script Function to Habitat that will act as the root user for SQL and allow the commands to run without security blocks. This is now available in Build 1.0.1.54. Get build 1.0.1.54 here
https://delivery.shopifyapps.com/-/fd12 ... ce0b2761f7


To clear Groups, create a one line script, add Script Server Function - Habitat Clear Chocolatey Groups and execute script once on any agent, just one agent one time. Go restart the DBagent, allow several minutes for DBagent to do it's thing then, as a good measure, go validate the main group has the correct script schedule applied. This should resolve any issues you are having.

Screenshot 2025-04-02 103606.png (30.58 KiB) Viewed 4121 times

Next either manually run a scan across the client or allow automation to do it during next cycle. Afterwords all agent will be reporting correct and up to date information, the operations should start working correctly.

Let me know if you would like my assistance, I can be available for a ScreenConnect session if needed.

[frankbe]

ok, i now have the repo version again

But i still have no right mouse click menu

screen connect session would be fine, so i can show you the problem.

[frankbe]

can you pleas look at this problem - in the left windows there was a menu, when i right click
since habitat 1.53 the menu window does not open. i testet this on different workstation and users

i really want to use this great plugin but for now it is not possible

04-04-2025_13-47-08.png (56.02 KiB) Viewed 3539 times

[Cubert]

Thanks for the report, Oh Gees, bloddy Visual Studios, It dropped context menu tied to the datagridview object. Not sure why it decided to do that on last build but I have gone back and corrected the issue.


here is updated build 1.0.1.55
https://delivery.shopifyapps.com/-/9b9f ... e5573263f9


This was only effecting Habitat's version and not Chocolatey 4 Automate directly.