CVE-2026-29080 Rucio SQL Injection in FilterEngine Oracle JSON Path via DID Search API
- Published
- Updated
- Exploit status
- No public exploit known
- CISA SSVC
- No known exploitation · automatable: no · technical impact: total
- Technology
- MySQL
Description
A SQL injection vulnerability in FilterEngine.create_sqla_query() allows any authenticated Rucio user to execute arbitrary SQL against the backend database through the DID search endpoint (GET /dids/<scope>/dids/search). On Oracle deployments attacker-controlled filter keys and values are interpolated directly into sqlalchemy.text() via Python .format(), completely bypassing parameterization. This enables full database compromise including extraction of authentication tokens, password hashes, and all managed data identifiers. This affects versions 1.27.0 and later before 35.8.5, 38.5.5, 39.4.2, and 40.1.1.
The vulnerability exists in lib/rucio/core/did_meta_plugins/filter_engine.py within the create_sqla_query() method. When the database dialect is Oracle, filter expressions for JSON metadata columns are constructed using text() with Python string formatting. Both key and value are attacker-controlled strings derived from HTTP query parameters. The text() function creates a raw SQL fragment — it does not escape or parameterize its contents.
Any authenticated Rucio user can exploit this through the DID search API to execute arbitrary SQL against the backend database. This can expose all managed data identifiers and sensitive tables such as identities, tokens, accounts, rse_settings, and rules, and may allow modification of database contents. The issue affects Oracle deployments using the default json_meta plugin and does not affect PostgreSQL or MySQL deployments using that plugin.
This vulnerability has been fixed in versions 35.8.5, 38.5.5, 39.4.2, and 40.1.1.
Upgrade path
3 packages: 2 fixed.
| Package | Affected | Fixed in | Status |
|---|---|---|---|
| cern rucio | >= 1.27.0, < 35.8.5; >= 36.0.0, < 38.5.5; >= 39.0.0, < 39.4.2; >= 40.0.0, < 40.1.1 | 35.8.5, 38.5.5, 39.4.2, 40.1.1 | Fixed |
| pypi rucio(PyPI) | = 1.27.0; = 1.27.0.post1; = 1.27.1; = 1.27.2 +182 more | 35.8.5, 38.5.5, 39.4.2, 40.1.1 | Fixed |
| rucio | = >= 1.27.0, < 35.8.5; = >= 35.9.0, < 38.5.5; = >= 38.6.0, < 39.4.2; = >= 40.0.0, < 40.1.1 | No fix listed | Versions listed |
Affected products
| Product | Affected versions | Fixed in |
|---|---|---|
| pypi rucio(PyPI) | >= 1.27.0, < 35.8.5 | 35.8.5 |
| pypi rucio(PyPI) | = 1.27.0 | No fix listed |
| pypi rucio(PyPI) | = 1.27.0.post1 | No fix listed |
| pypi rucio(PyPI) | = 1.27.1 | No fix listed |
| pypi rucio(PyPI) | = 1.27.10 | No fix listed |
| pypi rucio(PyPI) | = 1.27.11 | No fix listed |
| pypi rucio(PyPI) | = 1.27.12 | No fix listed |
| pypi rucio(PyPI) | = 1.27.2 | No fix listed |
| pypi rucio(PyPI) | = 1.27.3 | No fix listed |
| pypi rucio(PyPI) | = 1.27.4 | No fix listed |
| pypi rucio(PyPI) | = 1.27.4.post1 | No fix listed |
| pypi rucio(PyPI) | = 1.27.5 | No fix listed |
| pypi rucio(PyPI) | = 1.27.7 | No fix listed |
| pypi rucio(PyPI) | = 1.27.9 | No fix listed |
| pypi rucio(PyPI) | = 1.28.0 | No fix listed |
| pypi rucio(PyPI) | = 1.28.0rc1 | No fix listed |
| pypi rucio(PyPI) | = 1.28.0rc2 | No fix listed |
| pypi rucio(PyPI) | = 1.28.1 | No fix listed |
| pypi rucio(PyPI) | = 1.28.2 | No fix listed |
| pypi rucio(PyPI) | = 1.28.3 | No fix listed |
| pypi rucio(PyPI) | = 1.28.4 | No fix listed |
| pypi rucio(PyPI) | = 1.28.5 | No fix listed |
| pypi rucio(PyPI) | = 1.28.6 | No fix listed |
| pypi rucio(PyPI) | = 1.28.7 | No fix listed |
| pypi rucio(PyPI) | = 1.29.0 | No fix listed |
Show 169 more
| Product | Affected versions | Fixed in |
|---|---|---|
| pypi rucio(PyPI) | = 1.29.0rc1 | No fix listed |
| pypi rucio(PyPI) | = 1.29.0rc2 | No fix listed |
| pypi rucio(PyPI) | = 1.29.1 | No fix listed |
| pypi rucio(PyPI) | = 1.29.10 | No fix listed |
| pypi rucio(PyPI) | = 1.29.11 | No fix listed |
| pypi rucio(PyPI) | = 1.29.12 | No fix listed |
| pypi rucio(PyPI) | = 1.29.13 | No fix listed |
| pypi rucio(PyPI) | = 1.29.14 | No fix listed |
| pypi rucio(PyPI) | = 1.29.15 | No fix listed |
| pypi rucio(PyPI) | = 1.29.16 | No fix listed |
| pypi rucio(PyPI) | = 1.29.17 | No fix listed |
| pypi rucio(PyPI) | = 1.29.18 | No fix listed |
| pypi rucio(PyPI) | = 1.29.19 | No fix listed |
| pypi rucio(PyPI) | = 1.29.2 | No fix listed |
| pypi rucio(PyPI) | = 1.29.2.post1 | No fix listed |
| pypi rucio(PyPI) | = 1.29.2.post2 | No fix listed |
| pypi rucio(PyPI) | = 1.29.3 | No fix listed |
| pypi rucio(PyPI) | = 1.29.3.post1 | No fix listed |
| pypi rucio(PyPI) | = 1.29.4 | No fix listed |
| pypi rucio(PyPI) | = 1.29.5 | No fix listed |
| pypi rucio(PyPI) | = 1.29.6 | No fix listed |
| pypi rucio(PyPI) | = 1.29.7 | No fix listed |
| pypi rucio(PyPI) | = 1.29.7.post1 | No fix listed |
| pypi rucio(PyPI) | = 1.29.8 | No fix listed |
| pypi rucio(PyPI) | = 1.29.9 | No fix listed |
| pypi rucio(PyPI) | = 1.30.0 | No fix listed |
| pypi rucio(PyPI) | = 1.30.0rc1 | No fix listed |
| pypi rucio(PyPI) | = 1.30.0rc2 | No fix listed |
| pypi rucio(PyPI) | = 1.30.0rc3 | No fix listed |
| pypi rucio(PyPI) | = 1.30.1 | No fix listed |
| pypi rucio(PyPI) | = 1.30.2 | No fix listed |
| pypi rucio(PyPI) | = 1.30.3 | No fix listed |
| pypi rucio(PyPI) | = 1.30.4 | No fix listed |
| pypi rucio(PyPI) | = 1.30.5 | No fix listed |
| pypi rucio(PyPI) | = 1.30.6 | No fix listed |
| pypi rucio(PyPI) | = 1.30.7 | No fix listed |
| pypi rucio(PyPI) | = 1.30.8 | No fix listed |
| pypi rucio(PyPI) | = 1.31.0 | No fix listed |
| pypi rucio(PyPI) | = 1.31.0rc1 | No fix listed |
| pypi rucio(PyPI) | = 1.31.0rc2 | No fix listed |
| pypi rucio(PyPI) | = 1.31.0rc3 | No fix listed |
| pypi rucio(PyPI) | = 1.31.1 | No fix listed |
| pypi rucio(PyPI) | = 1.31.2 | No fix listed |
| pypi rucio(PyPI) | = 1.31.3 | No fix listed |
| pypi rucio(PyPI) | = 1.31.4 | No fix listed |
| pypi rucio(PyPI) | = 1.31.5 | No fix listed |
| pypi rucio(PyPI) | = 1.31.6 | No fix listed |
| pypi rucio(PyPI) | = 1.31.7 | No fix listed |
| pypi rucio(PyPI) | = 32.0.0 | No fix listed |
| pypi rucio(PyPI) | = 32.0.0rc1 | No fix listed |
| pypi rucio(PyPI) | = 32.0.0rc2 | No fix listed |
| pypi rucio(PyPI) | = 32.1.0 | No fix listed |
| pypi rucio(PyPI) | = 32.2.0 | No fix listed |
| pypi rucio(PyPI) | = 32.3.0 | No fix listed |
| pypi rucio(PyPI) | = 32.3.1 | No fix listed |
| pypi rucio(PyPI) | = 32.4.0 | No fix listed |
| pypi rucio(PyPI) | = 32.5.0 | No fix listed |
| pypi rucio(PyPI) | = 32.5.0.post1 | No fix listed |
| pypi rucio(PyPI) | = 32.5.1 | No fix listed |
| pypi rucio(PyPI) | = 32.6.0 | No fix listed |
| pypi rucio(PyPI) | = 32.6.0.post1 | No fix listed |
| pypi rucio(PyPI) | = 32.7.0 | No fix listed |
| pypi rucio(PyPI) | = 32.8.0 | No fix listed |
| pypi rucio(PyPI) | = 32.8.1 | No fix listed |
| pypi rucio(PyPI) | = 32.8.2 | No fix listed |
| pypi rucio(PyPI) | = 32.8.3 | No fix listed |
| pypi rucio(PyPI) | = 32.8.4 | No fix listed |
| pypi rucio(PyPI) | = 32.8.5 | No fix listed |
| pypi rucio(PyPI) | = 32.8.6 | No fix listed |
| pypi rucio(PyPI) | = 33.0.0 | No fix listed |
| pypi rucio(PyPI) | = 33.0.0rc1 | No fix listed |
| pypi rucio(PyPI) | = 33.0.0rc2 | No fix listed |
| pypi rucio(PyPI) | = 33.0.0rc3 | No fix listed |
| pypi rucio(PyPI) | = 33.1.0 | No fix listed |
| pypi rucio(PyPI) | = 33.2.0 | No fix listed |
| pypi rucio(PyPI) | = 33.2.1 | No fix listed |
| pypi rucio(PyPI) | = 33.3.0 | No fix listed |
| pypi rucio(PyPI) | = 33.4.0 | No fix listed |
| pypi rucio(PyPI) | = 33.4.0.post1 | No fix listed |
| pypi rucio(PyPI) | = 33.5.0 | No fix listed |
| pypi rucio(PyPI) | = 33.6.0 | No fix listed |
| pypi rucio(PyPI) | = 33.6.1 | No fix listed |
| pypi rucio(PyPI) | = 34.0.0 | No fix listed |
| pypi rucio(PyPI) | = 34.0.0rc1 | No fix listed |
| pypi rucio(PyPI) | = 34.0.0rc2 | No fix listed |
| pypi rucio(PyPI) | = 34.1.0 | No fix listed |
| pypi rucio(PyPI) | = 34.2.0 | No fix listed |
| pypi rucio(PyPI) | = 34.3.0 | No fix listed |
| pypi rucio(PyPI) | = 34.4.0 | No fix listed |
| pypi rucio(PyPI) | = 34.4.1 | No fix listed |
| pypi rucio(PyPI) | = 34.4.2 | No fix listed |
| pypi rucio(PyPI) | = 34.4.3 | No fix listed |
| pypi rucio(PyPI) | = 34.5.0 | No fix listed |
| pypi rucio(PyPI) | = 34.6.0 | No fix listed |
| pypi rucio(PyPI) | = 35.0.0 | No fix listed |
| pypi rucio(PyPI) | = 35.0.0rc1 | No fix listed |
| pypi rucio(PyPI) | = 35.0.0rc2 | No fix listed |
| pypi rucio(PyPI) | = 35.0.1 | No fix listed |
| pypi rucio(PyPI) | = 35.1.0 | No fix listed |
| pypi rucio(PyPI) | = 35.1.1 | No fix listed |
| pypi rucio(PyPI) | = 35.2.0 | No fix listed |
| pypi rucio(PyPI) | = 35.2.1 | No fix listed |
| pypi rucio(PyPI) | = 35.3.0 | No fix listed |
| pypi rucio(PyPI) | = 35.4.0 | No fix listed |
| pypi rucio(PyPI) | = 35.4.1 | No fix listed |
| pypi rucio(PyPI) | = 35.5.0 | No fix listed |
| pypi rucio(PyPI) | = 35.6.0 | No fix listed |
| pypi rucio(PyPI) | = 35.6.1 | No fix listed |
| pypi rucio(PyPI) | = 35.7.0 | No fix listed |
| pypi rucio(PyPI) | = 35.8.0 | No fix listed |
| pypi rucio(PyPI) | = 35.8.1 | No fix listed |
| pypi rucio(PyPI) | = 35.8.2 | No fix listed |
| pypi rucio(PyPI) | = 35.8.3 | No fix listed |
| pypi rucio(PyPI) | = 35.8.4 | No fix listed |
| pypi rucio(PyPI) | >= 36.0.0, < 38.5.5 | 38.5.5 |
| pypi rucio(PyPI) | = 36.0.0 | No fix listed |
| pypi rucio(PyPI) | = 36.0.0.post1 | No fix listed |
| pypi rucio(PyPI) | = 36.0.0.post2 | No fix listed |
| pypi rucio(PyPI) | = 36.1.0 | No fix listed |
| pypi rucio(PyPI) | = 36.2.0 | No fix listed |
| pypi rucio(PyPI) | = 36.3.0 | No fix listed |
| pypi rucio(PyPI) | = 36.4.0 | No fix listed |
| pypi rucio(PyPI) | = 36.5.0 | No fix listed |
| pypi rucio(PyPI) | = 37.0.0 | No fix listed |
| pypi rucio(PyPI) | = 37.0.0rc1 | No fix listed |
| pypi rucio(PyPI) | = 37.0.0rc2 | No fix listed |
| pypi rucio(PyPI) | = 37.0.0rc3 | No fix listed |
| pypi rucio(PyPI) | = 37.0.0rc4 | No fix listed |
| pypi rucio(PyPI) | = 37.1.0 | No fix listed |
| pypi rucio(PyPI) | = 37.1.0.post1 | No fix listed |
| pypi rucio(PyPI) | = 37.2.0 | No fix listed |
| pypi rucio(PyPI) | = 37.3.0 | No fix listed |
| pypi rucio(PyPI) | = 37.4.0 | No fix listed |
| pypi rucio(PyPI) | = 37.5.0 | No fix listed |
| pypi rucio(PyPI) | = 37.6.0 | No fix listed |
| pypi rucio(PyPI) | = 37.7.0 | No fix listed |
| pypi rucio(PyPI) | = 37.7.1 | No fix listed |
| pypi rucio(PyPI) | = 38.0.0 | No fix listed |
| pypi rucio(PyPI) | = 38.0.0rc1 | No fix listed |
| pypi rucio(PyPI) | = 38.0.0rc2 | No fix listed |
| pypi rucio(PyPI) | = 38.0.0rc3 | No fix listed |
| pypi rucio(PyPI) | = 38.1.0 | No fix listed |
| pypi rucio(PyPI) | = 38.2.0 | No fix listed |
| pypi rucio(PyPI) | = 38.3.0 | No fix listed |
| pypi rucio(PyPI) | = 38.4.0 | No fix listed |
| pypi rucio(PyPI) | = 38.5.0 | No fix listed |
| pypi rucio(PyPI) | = 38.5.1 | No fix listed |
| pypi rucio(PyPI) | = 38.5.2 | No fix listed |
| pypi rucio(PyPI) | = 38.5.3 | No fix listed |
| pypi rucio(PyPI) | = 38.5.4 | No fix listed |
| pypi rucio(PyPI) | >= 39.0.0, < 39.4.2 | 39.4.2 |
| pypi rucio(PyPI) | = 39.0.0 | No fix listed |
| pypi rucio(PyPI) | = 39.1.0 | No fix listed |
| pypi rucio(PyPI) | = 39.2.0 | No fix listed |
| pypi rucio(PyPI) | = 39.3.0 | No fix listed |
| pypi rucio(PyPI) | = 39.3.1 | No fix listed |
| pypi rucio(PyPI) | = 39.4.0 | No fix listed |
| pypi rucio(PyPI) | = 39.4.1 | No fix listed |
| pypi rucio(PyPI) | >= 40.0.0, < 40.1.1 | 40.1.1 |
| pypi rucio(PyPI) | = 40.0.0 | No fix listed |
| pypi rucio(PyPI) | = 40.1.0 | No fix listed |
| rucio | = >= 1.27.0, < 35.8.5 | No fix listed |
| rucio | = >= 35.9.0, < 38.5.5 | No fix listed |
| rucio | = >= 38.6.0, < 39.4.2 | No fix listed |
| rucio | = >= 40.0.0, < 40.1.1 | No fix listed |
| cern rucio | >= 1.27.0, < 35.8.5 | 35.8.5 |
| cern rucio | >= 36.0.0, < 38.5.5 | 38.5.5 |
| cern rucio | >= 39.0.0, < 39.4.2 | 39.4.2 |
| cern rucio | >= 40.0.0, < 40.1.1 | 40.1.1 |
References
- https://github.com/rucio/rucio/security/advisories/GHSA-vjr5-c9qv-hgm3 vendor-advisory
- nvd.nist.gov third-party-advisory vendor-advisory
- github.com vendor-advisory
- github.com
- github.com product
- pypi.org product