SQL Injection Affecting postgresql-jdbc package, versions <0:42.2.28-1.el9_2


Severity

Recommended
high

Based on Red Hat Enterprise Linux security rating.

Threat Intelligence

EPSS
0.11% (45th percentile)

Do your applications use this vulnerable package?

In a few clicks we can analyze your entire application and see what components are vulnerable in your application, and suggest you quick fixes.

Test your applications

Snyk Learn

Learn about SQL Injection vulnerabilities in an interactive lesson.

Start learning
  • Snyk IDSNYK-RHEL9-POSTGRESQLJDBC-6517078
  • published3 Apr 2024
  • disclosed19 Feb 2024

Introduced: 19 Feb 2024

CVE-2024-1597  (opens in a new tab)
CWE-89  (opens in a new tab)

How to fix?

Upgrade RHEL:9 postgresql-jdbc to version 0:42.2.28-1.el9_2 or higher.
This issue was patched in RHSA-2024:1649.

NVD Description

Note: Versions mentioned in the description apply only to the upstream postgresql-jdbc package and not the postgresql-jdbc package as distributed by RHEL. See How to fix? for RHEL:9 relevant fixed versions and status.

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.

CVSS Scores

version 3.1