GHSA-7xw9-549r-8jrc: DIRAC: SQL injection and lack of access control in PilotManager service
Details A number of the functions in PilotManager pass parameters directly through to the database layer, which then does not do any escaping on the parameters. For example setPilotStatus: https://github.com/DIRACGrid/DIRAC/blob/1738e7c6d2f31d26f1364255d9d2e87b4896c922/src/DIRAC/WorkloadManagementSystem/Service/PilotManagerHandler.py#L343-L349…
Published Jul 13, 2026 · Updated Nov 10, 2026
Affected packages
DIRAC
- Ecosystem
- PyPI
- Affected
- >= 6, < 8.0.79
- Fixed in
- 8.0.79
- Check
pip show DIRAC
DIRAC
- Ecosystem
- PyPI
- Affected
- >= 8.1.0a1, < 9.0.22
- Fixed in
- 9.0.22
- Check
pip show DIRAC
DIRAC
- Ecosystem
- PyPI
- Affected
- >= 9.1.0, < 9.1.10
- Fixed in
- 9.1.10
- Check
pip show DIRAC
Advisory details
From the GitHub Advisory Database (CC BY 4.0).
Details
A number of the functions in PilotManager pass parameters directly through to the database layer, which then does not do any escaping on the parameters. For example setPilotStatus: https://github.com/DIRACGrid/DIRAC/blob/1738e7c6d2f31d26f1364255d9d2e87b4896c922/src/DIRAC/WorkloadManagementSystem/Service/PilotManagerHandler.py#L343-L349
https://github.com/DIRACGrid/DIRAC/blob/1738e7c6d2f31d26f1364255d9d2e87b4896c922/src/DIRAC/WorkloadManagementSystem/DB/PilotAgentsDB.py#L117
This won't accept multiple statements separated by a semicolon, but a carefully crafted set of parameters containing SQL escapes would likely be able to change or return other database entries.
Further to this, the PilotManager access control is only set to "authenticated"; this allows these functions to be called by any user. This allows any user to manage (e.g. delete, read output of) any pilot pilot job: https://github.com/DIRACGrid/DIRAC/blob/1738e7c6d2f31d26f1364255d9d2e87b4896c922/src/DIRAC/WorkloadManagementSystem/ConfigTemplate.cfg#L111-L118
This is fixed by changing the SQL statements to use proper parameter substitution and providing a suitable set of access rules for the exported pilot management functions.
Patched versions:
https://pypi.org/project/DIRAC/8.0.79/ https://pypi.org/project/DIRAC/9.0.22/ https://pypi.org/project/DIRAC/9.1.10/
Credited to sfayer, ranjiGT.
References
- https://github.com/DIRACGrid/DIRAC/security/advisories/GHSA-7xw9-549r-8jrc
- https://pypi.org/project/DIRAC/8.0.79
- https://pypi.org/project/DIRAC/9.0.22
- https://pypi.org/project/DIRAC/9.1.10
- https://github.com/DIRACGrid/DIRAC/commit/8731de576cf96826dbbf505508526ada31efb927
- https://github.com/DIRACGrid/DIRAC/commit/f67f754d4eef5bf40a8223dab77cf2591808031f
- https://github.com/advisories/GHSA-7xw9-549r-8jrc
How this page is made: the data panel comes from the GitHub Advisory Database, CISA’s KEV catalog, the NVD and FIRST EPSS, and updates twice a day. No analysis has been written for this entry yet. Methodology
More PyPI vulnerabilities
All PyPI entriesCVE-2026-45579
DIRAC is vulnerable to RCE in RequestManager due to eval on untrusted input
critical9.9Jul 13, 2026CVE-2026-61667
DIRAC is vulnerable to RCE in FileCatalog DatasetManager via SQL injection + eval
critical9.9Jul 13, 2026CVE-2026-61668
DIRAC: Pilot code downloaded over unverified HTTPS connection
high8.1Jul 13, 2026CVE-2024-29905
DIRAC: Unauthorized users can read proxy contents during generation
high8.1Apr 9, 2024CVE-2024-24825
DIRAC's TokenManager does not check permissions on cached tokens
critical9.1Feb 8, 2024
