CVE-2024-1597

Name
CVE-2024-1597
Description
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.
NVD Severity
high
Other trackers
Mailing lists
Exploits
Forges
GitHub (code, issues), Aports (code, issues)

References

Type URI
f86ef6dc-4d3a-42ad-8f28-e6d5547a5007 https://github.com/pgjdbc/pgjdbc/security/advisories/GHSA-24rp-q3w6-vc56
f86ef6dc-4d3a-42ad-8f28-e6d5547a5007 https://www.enterprisedb.com/docs/jdbc_connector/latest/01_jdbc_rel_notes/
f86ef6dc-4d3a-42ad-8f28-e6d5547a5007 https://www.enterprisedb.com/docs/security/assessments/cve-2024-1597/
f86ef6dc-4d3a-42ad-8f28-e6d5547a5007 https://lists.fedoraproject.org/archives/list/package-announce@lists.fedoraproject.org/message/TZQTSMESZD2RJ5XBPSXH3TIQVUW5DIUU/
f86ef6dc-4d3a-42ad-8f28-e6d5547a5007 https://security.netapp.com/advisory/ntap-20240419-0008/
f86ef6dc-4d3a-42ad-8f28-e6d5547a5007 http://www.openwall.com/lists/oss-security/2024/04/02/6
https://lists.debian.org/debian-lts-announce/2024/05/msg00007.html

Match rules

CPE URI Source package Min version Max version
pgjdbc == < 42.7.2 == < 42.7.2
pgjdbc == < 42.6.1 == < 42.6.1
pgjdbc == < 42.5.5 == < 42.5.5
pgjdbc == < 42.4.4 == < 42.4.4
pgjdbc == < 42.3.9 == < 42.3.9
pgjdbc == < 42.2.28 == < 42.2.28

Vulnerable and fixed packages

Source package Branch Version Maintainer Status
java-postgresql-jdbc edge-community 42.6.2-r0 Jakub Jirutka <jakub@jirutka.cz> fixed
java-postgresql-jdbc 3.19-community 42.6.2-r0 Jakub Jirutka <jakub@jirutka.cz> fixed
java-postgresql-jdbc 3.20-community 42.6.2-r0 Jakub Jirutka <jakub@jirutka.cz> fixed
java-postgresql-jdbc 3.21-community 42.6.2-r0 Jakub Jirutka <jakub@jirutka.cz> fixed