SQL Injection in Pgjdbc
CVE-2024-1597
pgjdbc, the PostgreSQL JDBC Driver, allows attacker to inject SQL if using PreferQueryMode=SIMPLE. Note this is not the default. In the default mode there is no vulnerability. A placeholder for a numeric value must be immediately preceded by a minus. There must be a second placeholder for a string value after the first placeholder; both must be on the same line. By constructing a matching string payload, the attacker can inject SQL to alter the query,bypassing the protections that parameterized queries bring against SQL Injection attacks. Versions before 42.7.2, 42.6.1, 42.5.5, 42.4.4, 42.3.9, and 42.2.28 are affected.
Vulnerability class: SQL Injection
Published · last modified .
CVSS v3 metric
CVSS v3 base score 10.0 (Critical). Vector: CVSS:3.1/AV:N/AC:L/PR:N/UI:N/S:C/C:H/I:H/A:H.
EPSS exploit prediction
EPSS 0.048, 92.1th percentile (scored ); unchanged over 30 days. About EPSS.
Affected products
- Pgjdbc — versions < 42.7.2, < 42.6.1, < 42.5.5
- PostgreSQL Jdbc Driver
- Fedoraproject Fedora — versions 40
Weakness classification (CWE)
Public exploits and proof-of-concept code
Also mentioned in 4 other repositories (dbbaskette/ordersmcp, fkie-cad/nvd-json-data-feeds, leoambrus/artefactswithoutCVEonGitHubAdvisoryDatabase, …). These reference the CVE in a list, notes or a scanner and are not exploit code for it.
References
- github.com/pgjdbc/pgjdbc/security/advisories/GHSA-24rp-q3w6-vc56 (Third Party Advisory)
- www.enterprisedb.com/docs/security/assessments/cve-2024-1597/ (Third Party Advisory)
- www.enterprisedb.com/docs/jdbc_connector/latest/01_jdbc_rel_notes/ (Release Notes)
- lists.fedoraproject.org/archives/list/package-announce@lists.fedoraproject.org/… (Mailing List, Third Party Advisory)
- security.netapp.com/advisory/ntap-20240419-0008/
- www.openwall.com/lists/oss-security/2024/04/02/6
- lists.debian.org/debian-lts-announce/2024/05/msg00007.html
- lists.debian.org/debian-lts-announce/2024/12/msg00017.html
- www.sonarsource.com/blog/double-dash-double-trouble-a-subtle-sql-injection-flaw/