CVE-2026-104129 — CWE-89
CVE-2026-104129 is a HIGH severity SQL Injection (SQLi) vulnerability (CWE-89) (CVSS 8.1/10) affecting affected software system. Technical vector analysis shows that an attacker can exploit this flaw remotely over the network with low-privileged access (PR:L) with zero user interaction (UI:N), resulting in complete compromise of system confidentiality and integrity (C:H/I:H).
📄 Official NVD / MITRE Original Record Text
pREST (PostgreSQL REST) is an API that delivers an application on top of a Postgres database. Prior to 2.4.0, the vulnerable parameter is _groupby, handled by GroupByClause in adapters/postgres/postgres.go. adapters/postgres/postgres.go uses the weaker isSafeSQLExpression check for this function-expression branch instead of the stricter single-field validator used for _select. That check validates only the outer function name against a 13-function allowlist and permits nested subqueries, trailing UNION syntax, and inner pg_ functions. controllers/crud.go concatenates the GROUP BY expression while parameterizing only WHERE values, allowing attacker-controlled SQL structure into the clause. Default configuration permits unauthenticated access; a restricted installation may require a low-privilege table reader. UNION-based extraction requires compatible column counts and types and was not verified end to end, but a delay-producing function can cause denial of service without that alignment. This issue is fixed in 2.4.0.
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━
CVE-2026-104129
CVSS 8.1/10 · HIGH · 19.11.2026
CWE: CWE-89
Vector: CVSS:3.1/AV:N/AC:L/PR:L/UI:N/S:U/C:H/I:H/A:N
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━
🎯 WHAT IS THIS VULNERABILITY?
SQL Injection (SQLi)
Summary: pREST (PostgreSQL REST) is an API that delivers an application on top of a Postgres database. Prior to 2.4.0, the vulnerable parameter is _groupby, handled by GroupByClause in adapters/postgres/postgres.go. adapters/postgres/postgres.go uses the weaker isSafeSQLExpression check for this function-expression branch instead of the stricter single-field validator used for _select.
⚡ ATTACK CHAIN
Attack steps:
1. Identify injectable parameters (URL params, form fields, HTTP headers, cookies).
2. Basic test: ' OR '1'='1 — look for errors or behavior changes.
3. UNION-based extraction: ' UNION SELECT user(),database()--
4. Automated: sqlmap -u 'TARGET_URL' --dbs --dump --batch
5. Time-based blind: '; IF(1=1) WAITFOR DELAY '0:0:5'--
6. Post-exploitation: dump credentials, write webshell via INTO OUTFILE '/var/www/shell.php'.
🔧 Tools: sqlmap, Burp Suite (Intruder), manual
🗺️ MITRE ATT&CK: T1190 (Exploit Public-Facing Application), T1078 (Valid Accounts)
🌍 REAL WORLD IMPACT
All confidential data readable/stealable; data can be modified or deleted.
🛡️ REMEDIATION
→ Apply the vendor-released patch immediately.
→ Use prepared statements and parameterized queries.
→ Add WAF rule, create IDS alert for anomalous traffic.
⚠️ URGENCY
⚠️ Planned maintenance (2 weeks).
────────────────────────────────────────
[Kural Tabanlı Otomatik Güvenlik Analizi]