CVE-2024-1597
pgjdbc: PostgreSQL JDBC Driver allows attacker to inject SQL if using PreferQueryMode=SIMPLE
Kaynağa göre önem derecesi
Trivy'nin kendi etiketi CRITICAL. Kritik diyenler: NVD, GHSA, Bitnami. Daha düşük diyenler: Red Hat (yüksek), AlmaLinux (yüksek), Oracle (yüksek), Rocky Linux (yüksek), Ubuntu (orta).
Açıklama
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.
Etkilenen paketler ve düzeltilmiş sürümler
| Kaynak | Paket | Düzeltildiği sürüm |
|---|---|---|
| bitnami::Bitnami Vulnerability Database | postgresql-jdbc-driver | 42.2.28, 42.3.9, 42.4.4, 42.5.5, 42.6.1, 42.7.2 |
| maven::GitHub Security Advisory Maven | org.postgresql:postgresql | 42.2.28, 42.3.9, 42.4.4, 42.5.5, 42.6.1, 42.7.2 |
| alma 8 | postgresql-jdbc, postgresql-jdbc-javadoc | 42.2.14-3.el8_9 |
| alma 9 | postgresql-jdbc | 42.2.28-1.el9_3 |
| alpine 3.19 | java-postgresql-jdbc | 42.6.2-r0 |
| alpine 3.20 | java-postgresql-jdbc | 42.6.2-r0 |
| alpine 3.21 | java-postgresql-jdbc | 42.6.2-r0 |
| alpine 3.22 | java-postgresql-jdbc | 42.6.2-r0 |
| alpine 3.23 | java-postgresql-jdbc | 42.6.2-r0 |
| alpine 3.24 | java-postgresql-jdbc | 42.6.2-r0 |
| alpine edge | java-postgresql-jdbc | 42.6.2-r0 |
| chainguard | dependency-track, keycloak, mariadb-10.11 ve 3 tane daha | 4.10.1-r1 ve 5 tane daha |
27 kaynaktaki 43 kaydın hepsini göster
| Kaynak | Paket | Düzeltildiği sürüm |
|---|---|---|
| bitnami::Bitnami Vulnerability Database | postgresql-jdbc-driver | 42.2.28, 42.3.9, 42.4.4, 42.5.5, 42.6.1, 42.7.2 |
| maven::GitHub Security Advisory Maven | org.postgresql:postgresql | 42.2.28, 42.3.9, 42.4.4, 42.5.5, 42.6.1, 42.7.2 |
| alma 8 | postgresql-jdbc | 42.2.14-3.el8_9 |
| alma 8 | postgresql-jdbc-javadoc | 42.2.14-3.el8_9 |
| alma 9 | postgresql-jdbc | 42.2.28-1.el9_3 |
| alpine 3.19 | java-postgresql-jdbc | 42.6.2-r0 |
| alpine 3.20 | java-postgresql-jdbc | 42.6.2-r0 |
| alpine 3.21 | java-postgresql-jdbc | 42.6.2-r0 |
| alpine 3.22 | java-postgresql-jdbc | 42.6.2-r0 |
| alpine 3.23 | java-postgresql-jdbc | 42.6.2-r0 |
| alpine 3.24 | java-postgresql-jdbc | 42.6.2-r0 |
| alpine edge | java-postgresql-jdbc | 42.6.2-r0 |
| chainguard | dependency-track | 4.10.1-r1 |
| chainguard | keycloak | 23.0.7-r0 |
| chainguard | mariadb-10.11 | 10.11.8-r2 |
| chainguard | mariadb-10.6 | 10.6.17-r0 |
| chainguard | mariadb-11.2 | 11.2.3-r2 |
| chainguard | trino | 439-r2 |
| debian 10 | libpgjava | 42.2.5-2+deb10u4 |
| debian 11 | libpgjava | 42.2.15-1+deb11u2 |
| debian 12 | libpgjava | 42.5.5-0+deb12u1 |
| debian 13 | libpgjava | 42.7.2-1 |
| debian 14 | libpgjava | 42.7.2-1 |
| echo | libpgjava | 42.5.5-0+deb12u1 |
| minimos | mariadb-10.11 | 10.11.11-r1 |
| minimos | mariadb-10.5 | 10.5.28-r1 |
| minimos | mariadb-10.6 | 10.6.21-r1 |
| Oracle Linux 8 | postgresql-jdbc | 42.2.14-3.el8_9 |
| Oracle Linux 8 | postgresql-jdbc-javadoc | 42.2.14-3.el8_9 |
| Oracle Linux 9 | postgresql-jdbc | 42.2.28-1.el9_3 |
| rapidfort Oracle Linux 9 | postgresql-jdbc | 0:42.2.28-1.el9_3 |
| Red Hat | libreoffice:flatpak::postgresql-jdbc | düzeltme belirtilmemiş |
| Red Hat | libreoffice:flatpak::postgresql-jdbc-javadoc | düzeltme belirtilmemiş |
| rocky 8 | postgresql-jdbc | 42.2.14-3.el8_9 |
| rocky 8 | postgresql-jdbc-javadoc | 42.2.14-3.el8_9 |
| rocky 9 | postgresql-jdbc | 42.2.28-1.el9_3 |
| ubuntu 18.04-ESM | libpgjava | düzeltme belirtilmemiş |
| wolfi | dependency-track | 4.10.1-r1 |
| wolfi | keycloak | 23.0.7-r0 |
| wolfi | mariadb-10.11 | 10.11.8-r2 |
| wolfi | mariadb-10.6 | 10.6.17-r0 |
| wolfi | mariadb-11.2 | 11.2.3-r2 |
| wolfi | trino | 439-r2 |
Referanslar
- http://www.openwall.com/lists/oss-security/2024/04/02/6
- https://access.redhat.com/errata/RHSA-2024:1436
- https://access.redhat.com/security/cve/CVE-2024-1597
- https://bugzilla.redhat.com/2266523
- https://bugzilla.redhat.com/show_bug.cgi?id=2266523
- https://creativecommons.org/licenses/by/4.0/
- https://cve.mitre.org/cgi-bin/cvename.cgi?name=CVE-2024-1597
- https://errata.almalinux.org/9/ALSA-2024-1436.html
30 referansın hepsi
- https://errata.rockylinux.org/RLSA-2024:1436
- https://github.com/pgjdbc/pgjdbc
- https://github.com/pgjdbc/pgjdbc/commit/06abfb78a627277a580d4df825f210e96a4e14ee
- https://github.com/pgjdbc/pgjdbc/commit/06abfb78a627277a580d4df825f210e96a4e14ee%20%28REL42.7.2%29
- https://github.com/pgjdbc/pgjdbc/commit/1b1d6b53eca90409af0069d5327d4fdf8d40a255%20%28REL42.5.5%29
- https://github.com/pgjdbc/pgjdbc/commit/475e3e2af3033c666fc1c0015159b35455118ae5%20%28REL42.5.5%29
- https://github.com/pgjdbc/pgjdbc/commit/93b0fcb2711d9c1e3a2a03134369738a02a58b40
- https://github.com/pgjdbc/pgjdbc/commit/93b0fcb2711d9c1e3a2a03134369738a02a58b40%20%28REL42.7.2%29
- https://github.com/pgjdbc/pgjdbc/commit/990d63f6be401ab40de5eb303a75924c9e71903c%20%28REL42.2.28%29
- https://github.com/pgjdbc/pgjdbc/commit/b9b3777671c8a5cc580e1985f61337d39d47c730%20%28REL42.2.28%29
- https://github.com/pgjdbc/pgjdbc/security/advisories/GHSA-24rp-q3w6-vc56
- https://linux.oracle.com/cve/CVE-2024-1597.html
- https://linux.oracle.com/errata/ELSA-2024-1436.html
- https://lists.debian.org/debian-lts-announce/2024/05/msg00007.html
- https://lists.debian.org/debian-lts-announce/2024/12/msg00017.html
- https://lists.fedoraproject.org/archives/list/package-announce@lists.fedoraproject.org/message/TZQTSMESZD2RJ5XBPSXH3TIQVUW5DIUU/
- https://nvd.nist.gov/vuln/detail/CVE-2024-1597
- https://security.netapp.com/advisory/ntap-20240419-0008/
- https://www.cve.org/CVERecord?id=CVE-2024-1597
- https://www.enterprisedb.com/docs/jdbc_connector/latest/01_jdbc_rel_notes/
- https://www.enterprisedb.com/docs/security/assessments/cve-2024-1597/
- https://www.sonarsource.com/blog/double-dash-double-trouble-a-subtle-sql-injection-flaw/