Skip to content

CVE-2024-1597 pgjdbc SQL Injection via line comment generation

CriticalCVSS 9.8 EPSS 4.8%
Published
Updated
Exploit status
No public exploit known
CISA SSVC
Proof of concept public · automatable: yes · technical impact: total
Technology
UbuntuDebian

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.

Upgrade path

17 packages: 12 fixed, 4 with no fix yet.

PackageAffectedFixed inStatus
ubuntu/libpgjava(Ubuntu 14.04) = 9.2-1002-1; All versions No fix listed No fix yet
ubuntu/libpgjava(Ubuntu 22.04) = 42.2.23-1; = 42.2.24-1; = 42.3.1-1; = 42.3.2-1 +2 more No fix listed No fix yet
ubuntu/libpgjava(Ubuntu Pro 18.04) = 9.4.1212-1; = 9.4.1212-1ubuntu0.1~esm1; All versions No fix listed No fix yet
ubuntu/libpgjava(Ubuntu Pro 20.04) = 42.2.6-1; = 42.2.8-1; = 42.2.9-1; = 42.2.10-1 +2 more No fix listed No fix yet
alpine/java-postgresql-jdbc(Alpine v3.19) < 42.6.2-r0 42.6.2-r0 Fixed
alpine/java-postgresql-jdbc(Alpine v3.20) < 42.6.2-r0 42.6.2-r0 Fixed
alpine/java-postgresql-jdbc(Alpine v3.21) < 42.6.2-r0 42.6.2-r0 Fixed
alpine/java-postgresql-jdbc(Alpine v3.22) < 42.6.2-r0 42.6.2-r0 Fixed
alpine/java-postgresql-jdbc(Alpine v3.23) < 42.6.2-r0 42.6.2-r0 Fixed
alpine/java-postgresql-jdbc(Alpine v3.24) < 42.6.2-r0 42.6.2-r0 Fixed
debian/libpgjava(Debian 12) < 42.5.5-0+deb12u1; = 42.5.4-1 42.5.5-0+deb12u1 Fixed
debian/libpgjava(Debian 13) < 42.7.2-1 42.7.2-1 Fixed
debian/libpgjava(Debian 14) < 42.7.2-1 42.7.2-1 Fixed
org.postgresql/postgresql(Maven) < 42.2.28; = 9.2-1002-jdbc4; = 9.2-1003-jdbc3; = 9.2-1003-jdbc4 +181 more 42.2.28, 42.3.9, 42.4.4, 42.5.5, 42.6.1, 42.7.2 Fixed
pgjdbc < 42.2.28; < 42.3.9; < 42.4.4; < 42.5.5 +8 more 42.2.28, 42.3.9, 42.4.4, 42.5.5, 42.6.1, 42.7.2 Fixed
postgresql jdbc driver < 42.2.28; >= 42.3.0, < 42.3.9; >= 42.4.0, < 42.4.4; >= 42.5.0, < 42.5.5 +2 more 42.2.28, 42.3.9, 42.4.4, 42.5.5, 42.6.1, 42.7.2 Fixed
fedoraproject fedora = 40 No fix listed Versions listed

Affected products

ProductAffected versionsFixed in
org.postgresql/postgresql(Maven) < 42.2.28 42.2.28
org.postgresql/postgresql(Maven) = 42.0.0 No fix listed
org.postgresql/postgresql(Maven) = 42.0.0.jre6 No fix listed
org.postgresql/postgresql(Maven) = 42.0.0.jre7 No fix listed
org.postgresql/postgresql(Maven) = 42.1.0 No fix listed
org.postgresql/postgresql(Maven) = 42.1.0.jre7 No fix listed
org.postgresql/postgresql(Maven) = 42.1.1 No fix listed
org.postgresql/postgresql(Maven) = 42.1.1.jre6 No fix listed
org.postgresql/postgresql(Maven) = 42.1.1.jre7 No fix listed
org.postgresql/postgresql(Maven) = 42.1.2 No fix listed
org.postgresql/postgresql(Maven) = 42.1.2.jre6 No fix listed
org.postgresql/postgresql(Maven) = 42.1.2.jre7 No fix listed
org.postgresql/postgresql(Maven) = 42.1.3 No fix listed
org.postgresql/postgresql(Maven) = 42.1.3.jre6 No fix listed
org.postgresql/postgresql(Maven) = 42.1.3.jre7 No fix listed
org.postgresql/postgresql(Maven) = 42.1.4 No fix listed
org.postgresql/postgresql(Maven) = 42.1.4.jre6 No fix listed
org.postgresql/postgresql(Maven) = 42.1.4.jre7 No fix listed
org.postgresql/postgresql(Maven) = 42.2.0 No fix listed
org.postgresql/postgresql(Maven) = 42.2.0.jre6 No fix listed
org.postgresql/postgresql(Maven) = 42.2.0.jre7 No fix listed
org.postgresql/postgresql(Maven) = 42.2.1 No fix listed
org.postgresql/postgresql(Maven) = 42.2.1.jre6 No fix listed
org.postgresql/postgresql(Maven) = 42.2.1.jre7 No fix listed
org.postgresql/postgresql(Maven) = 42.2.10 No fix listed
Show 175 more
ProductAffected versionsFixed in
org.postgresql/postgresql(Maven) = 42.2.10.jre6 No fix listed
org.postgresql/postgresql(Maven) = 42.2.10.jre7 No fix listed
org.postgresql/postgresql(Maven) = 42.2.11 No fix listed
org.postgresql/postgresql(Maven) = 42.2.11.jre6 No fix listed
org.postgresql/postgresql(Maven) = 42.2.11.jre7 No fix listed
org.postgresql/postgresql(Maven) = 42.2.12 No fix listed
org.postgresql/postgresql(Maven) = 42.2.12.jre6 No fix listed
org.postgresql/postgresql(Maven) = 42.2.12.jre7 No fix listed
org.postgresql/postgresql(Maven) = 42.2.13 No fix listed
org.postgresql/postgresql(Maven) = 42.2.13.jre6 No fix listed
org.postgresql/postgresql(Maven) = 42.2.13.jre7 No fix listed
org.postgresql/postgresql(Maven) = 42.2.14 No fix listed
org.postgresql/postgresql(Maven) = 42.2.14.jre6 No fix listed
org.postgresql/postgresql(Maven) = 42.2.14.jre7 No fix listed
org.postgresql/postgresql(Maven) = 42.2.15 No fix listed
org.postgresql/postgresql(Maven) = 42.2.15.jre6 No fix listed
org.postgresql/postgresql(Maven) = 42.2.15.jre7 No fix listed
org.postgresql/postgresql(Maven) = 42.2.16 No fix listed
org.postgresql/postgresql(Maven) = 42.2.16.jre6 No fix listed
org.postgresql/postgresql(Maven) = 42.2.16.jre7 No fix listed
org.postgresql/postgresql(Maven) = 42.2.17 No fix listed
org.postgresql/postgresql(Maven) = 42.2.17.jre6 No fix listed
org.postgresql/postgresql(Maven) = 42.2.17.jre7 No fix listed
org.postgresql/postgresql(Maven) = 42.2.18 No fix listed
org.postgresql/postgresql(Maven) = 42.2.18.jre6 No fix listed
org.postgresql/postgresql(Maven) = 42.2.18.jre7 No fix listed
org.postgresql/postgresql(Maven) = 42.2.19 No fix listed
org.postgresql/postgresql(Maven) = 42.2.19.jre6 No fix listed
org.postgresql/postgresql(Maven) = 42.2.19.jre7 No fix listed
org.postgresql/postgresql(Maven) = 42.2.2 No fix listed
org.postgresql/postgresql(Maven) = 42.2.2.jre6 No fix listed
org.postgresql/postgresql(Maven) = 42.2.2.jre7 No fix listed
org.postgresql/postgresql(Maven) = 42.2.20 No fix listed
org.postgresql/postgresql(Maven) = 42.2.20.jre6 No fix listed
org.postgresql/postgresql(Maven) = 42.2.20.jre7 No fix listed
org.postgresql/postgresql(Maven) = 42.2.21 No fix listed
org.postgresql/postgresql(Maven) = 42.2.21.jre6 No fix listed
org.postgresql/postgresql(Maven) = 42.2.21.jre7 No fix listed
org.postgresql/postgresql(Maven) = 42.2.22 No fix listed
org.postgresql/postgresql(Maven) = 42.2.22.jre6 No fix listed
org.postgresql/postgresql(Maven) = 42.2.22.jre7 No fix listed
org.postgresql/postgresql(Maven) = 42.2.23 No fix listed
org.postgresql/postgresql(Maven) = 42.2.23.jre6 No fix listed
org.postgresql/postgresql(Maven) = 42.2.23.jre7 No fix listed
org.postgresql/postgresql(Maven) = 42.2.24 No fix listed
org.postgresql/postgresql(Maven) = 42.2.24.jre6 No fix listed
org.postgresql/postgresql(Maven) = 42.2.24.jre7 No fix listed
org.postgresql/postgresql(Maven) = 42.2.25 No fix listed
org.postgresql/postgresql(Maven) = 42.2.25.jre6 No fix listed
org.postgresql/postgresql(Maven) = 42.2.25.jre7 No fix listed
org.postgresql/postgresql(Maven) = 42.2.26 No fix listed
org.postgresql/postgresql(Maven) = 42.2.26.jre6 No fix listed
org.postgresql/postgresql(Maven) = 42.2.26.jre7 No fix listed
org.postgresql/postgresql(Maven) = 42.2.27 No fix listed
org.postgresql/postgresql(Maven) = 42.2.27.jre6 No fix listed
org.postgresql/postgresql(Maven) = 42.2.27.jre7 No fix listed
org.postgresql/postgresql(Maven) = 42.2.3 No fix listed
org.postgresql/postgresql(Maven) = 42.2.3.jre6 No fix listed
org.postgresql/postgresql(Maven) = 42.2.3.jre7 No fix listed
org.postgresql/postgresql(Maven) = 42.2.4 No fix listed
org.postgresql/postgresql(Maven) = 42.2.4.jre6 No fix listed
org.postgresql/postgresql(Maven) = 42.2.4.jre7 No fix listed
org.postgresql/postgresql(Maven) = 42.2.5 No fix listed
org.postgresql/postgresql(Maven) = 42.2.5.jre6 No fix listed
org.postgresql/postgresql(Maven) = 42.2.5.jre7 No fix listed
org.postgresql/postgresql(Maven) = 42.2.6 No fix listed
org.postgresql/postgresql(Maven) = 42.2.6.jre6 No fix listed
org.postgresql/postgresql(Maven) = 42.2.6.jre7 No fix listed
org.postgresql/postgresql(Maven) = 42.2.7 No fix listed
org.postgresql/postgresql(Maven) = 42.2.7.jre6 No fix listed
org.postgresql/postgresql(Maven) = 42.2.7.jre7 No fix listed
org.postgresql/postgresql(Maven) = 42.2.8 No fix listed
org.postgresql/postgresql(Maven) = 42.2.8.jre6 No fix listed
org.postgresql/postgresql(Maven) = 42.2.8.jre7 No fix listed
org.postgresql/postgresql(Maven) = 42.2.9 No fix listed
org.postgresql/postgresql(Maven) = 42.2.9.jre6 No fix listed
org.postgresql/postgresql(Maven) = 42.2.9.jre7 No fix listed
org.postgresql/postgresql(Maven) = 9.2-1002-jdbc4 No fix listed
org.postgresql/postgresql(Maven) = 9.2-1003-jdbc3 No fix listed
org.postgresql/postgresql(Maven) = 9.2-1003-jdbc4 No fix listed
org.postgresql/postgresql(Maven) = 9.2-1004-jdbc3 No fix listed
org.postgresql/postgresql(Maven) = 9.2-1004-jdbc4 No fix listed
org.postgresql/postgresql(Maven) = 9.2-1004-jdbc41 No fix listed
org.postgresql/postgresql(Maven) = 9.3-1100-jdbc3 No fix listed
org.postgresql/postgresql(Maven) = 9.3-1100-jdbc4 No fix listed
org.postgresql/postgresql(Maven) = 9.3-1100-jdbc41 No fix listed
org.postgresql/postgresql(Maven) = 9.3-1101-jdbc3 No fix listed
org.postgresql/postgresql(Maven) = 9.3-1101-jdbc4 No fix listed
org.postgresql/postgresql(Maven) = 9.3-1101-jdbc41 No fix listed
org.postgresql/postgresql(Maven) = 9.3-1102-jdbc3 No fix listed
org.postgresql/postgresql(Maven) = 9.3-1102-jdbc4 No fix listed
org.postgresql/postgresql(Maven) = 9.3-1102-jdbc41 No fix listed
org.postgresql/postgresql(Maven) = 9.3-1103-jdbc3 No fix listed
org.postgresql/postgresql(Maven) = 9.3-1103-jdbc4 No fix listed
org.postgresql/postgresql(Maven) = 9.3-1103-jdbc41 No fix listed
org.postgresql/postgresql(Maven) = 9.3-1104-jdbc4 No fix listed
org.postgresql/postgresql(Maven) = 9.3-1104-jdbc41 No fix listed
org.postgresql/postgresql(Maven) = 9.4-1200-jdbc4 No fix listed
org.postgresql/postgresql(Maven) = 9.4-1200-jdbc41 No fix listed
org.postgresql/postgresql(Maven) = 9.4-1201-jdbc4 No fix listed
org.postgresql/postgresql(Maven) = 9.4-1201-jdbc41 No fix listed
org.postgresql/postgresql(Maven) = 9.4-1202-jdbc4 No fix listed
org.postgresql/postgresql(Maven) = 9.4-1202-jdbc41 No fix listed
org.postgresql/postgresql(Maven) = 9.4-1202-jdbc42 No fix listed
org.postgresql/postgresql(Maven) = 9.4-1203-jdbc4 No fix listed
org.postgresql/postgresql(Maven) = 9.4-1203-jdbc41 No fix listed
org.postgresql/postgresql(Maven) = 9.4-1203-jdbc42 No fix listed
org.postgresql/postgresql(Maven) = 9.4-1204-jdbc4 No fix listed
org.postgresql/postgresql(Maven) = 9.4-1204-jdbc41 No fix listed
org.postgresql/postgresql(Maven) = 9.4-1204-jdbc42 No fix listed
org.postgresql/postgresql(Maven) = 9.4-1205-jdbc4 No fix listed
org.postgresql/postgresql(Maven) = 9.4-1205-jdbc41 No fix listed
org.postgresql/postgresql(Maven) = 9.4-1205-jdbc42 No fix listed
org.postgresql/postgresql(Maven) = 9.4-1206-jdbc4 No fix listed
org.postgresql/postgresql(Maven) = 9.4-1206-jdbc41 No fix listed
org.postgresql/postgresql(Maven) = 9.4-1206-jdbc42 No fix listed
org.postgresql/postgresql(Maven) = 9.4.1207 No fix listed
org.postgresql/postgresql(Maven) = 9.4.1207.jre6 No fix listed
org.postgresql/postgresql(Maven) = 9.4.1207.jre7 No fix listed
org.postgresql/postgresql(Maven) = 9.4.1208 No fix listed
org.postgresql/postgresql(Maven) = 9.4.1208.jre6 No fix listed
org.postgresql/postgresql(Maven) = 9.4.1208.jre7 No fix listed
org.postgresql/postgresql(Maven) = 9.4.1209 No fix listed
org.postgresql/postgresql(Maven) = 9.4.1209.jre6 No fix listed
org.postgresql/postgresql(Maven) = 9.4.1209.jre7 No fix listed
org.postgresql/postgresql(Maven) = 9.4.1210 No fix listed
org.postgresql/postgresql(Maven) = 9.4.1210.jre6 No fix listed
org.postgresql/postgresql(Maven) = 9.4.1210.jre7 No fix listed
org.postgresql/postgresql(Maven) = 9.4.1211 No fix listed
org.postgresql/postgresql(Maven) = 9.4.1211.jre6 No fix listed
org.postgresql/postgresql(Maven) = 9.4.1211.jre7 No fix listed
org.postgresql/postgresql(Maven) = 9.4.1212 No fix listed
org.postgresql/postgresql(Maven) = 9.4.1212.jre6 No fix listed
org.postgresql/postgresql(Maven) = 9.4.1212.jre7 No fix listed
org.postgresql/postgresql(Maven) >= 42.3.0, < 42.3.9 42.3.9
org.postgresql/postgresql(Maven) = 42.3.0 No fix listed
org.postgresql/postgresql(Maven) = 42.3.1 No fix listed
org.postgresql/postgresql(Maven) = 42.3.2 No fix listed
org.postgresql/postgresql(Maven) = 42.3.3 No fix listed
org.postgresql/postgresql(Maven) = 42.3.4 No fix listed
org.postgresql/postgresql(Maven) = 42.3.5 No fix listed
org.postgresql/postgresql(Maven) = 42.3.6 No fix listed
org.postgresql/postgresql(Maven) = 42.3.7 No fix listed
org.postgresql/postgresql(Maven) = 42.3.8 No fix listed
org.postgresql/postgresql(Maven) >= 42.4.0, < 42.4.4 42.4.4
org.postgresql/postgresql(Maven) = 42.4.0 No fix listed
org.postgresql/postgresql(Maven) = 42.4.1 No fix listed
org.postgresql/postgresql(Maven) = 42.4.2 No fix listed
org.postgresql/postgresql(Maven) = 42.4.3 No fix listed
org.postgresql/postgresql(Maven) >= 42.5.0, < 42.5.5 42.5.5
org.postgresql/postgresql(Maven) = 42.5.0 No fix listed
org.postgresql/postgresql(Maven) = 42.5.1 No fix listed
org.postgresql/postgresql(Maven) = 42.5.2 No fix listed
org.postgresql/postgresql(Maven) = 42.5.3 No fix listed
org.postgresql/postgresql(Maven) = 42.5.4 No fix listed
org.postgresql/postgresql(Maven) >= 42.6.0, < 42.6.1 42.6.1
org.postgresql/postgresql(Maven) = 42.6.0 No fix listed
org.postgresql/postgresql(Maven) >= 42.7.0, < 42.7.2 42.7.2
org.postgresql/postgresql(Maven) = 42.7.0 No fix listed
org.postgresql/postgresql(Maven) = 42.7.1 No fix listed
debian/libpgjava(Debian:12) < 42.5.5-0+deb12u1 42.5.5-0+deb12u1
debian/libpgjava(Debian:12) = 42.5.4-1 No fix listed
debian/libpgjava(Debian:13) < 42.7.2-1 42.7.2-1
debian/libpgjava(Debian:14) < 42.7.2-1 42.7.2-1
ubuntu/libpgjava(Ubuntu:22.04) All versions No fix listed
pgjdbc = < 42.7.2 No fix listed
pgjdbc = < 42.6.1 No fix listed
pgjdbc = < 42.5.5 No fix listed
pgjdbc = < 42.4.4 No fix listed
pgjdbc = < 42.3.9 No fix listed
pgjdbc = < 42.2.28 No fix listed
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

References