SQLi via preferQueryMode=simple in Amazon Redshift JDBC Driver <2.1.0.28
CVE-2024-32888 Published on May 15, 2024
Amazon JDBC Driver for Redshift SQL Injection via line comment generation
The Amazon JDBC Driver for Redshift is a Type 4 JDBC driver that provides database connectivity through the standard JDBC application program interfaces (APIs) available in the Java Platform, Enterprise Editions. Prior to version 2.1.0.28, SQL injection is possible when using the non-default connection property `preferQueryMode=simple` in combination with application code which has a vulnerable SQL that negates a parameter value. There is no vulnerability in the driver when using the default, extended query mode. Note that `preferQueryMode` is not a supported parameter in Redshift JDBC driver, and is inherited code from Postgres JDBC driver. Users who do not override default settings to utilize this unsupported query mode are not affected. This issue is patched in driver version 2.1.0.28. As a workaround, do not use the connection property `preferQueryMode=simple`. (NOTE: Those who do not explicitly specify a query mode use the default of extended query mode and are not affected by this issue.)
Vulnerability Analysis
CVE-2024-32888 is exploitable with network access, and does not require authorization privileges or user interaction. This vulnerability is considered to have a low attack complexity. The potential impact of an exploit of this vulnerability is considered to be critical as this vulnerability has a high impact to the confidentiality, integrity and availability of this component.
Weakness Type
What is a SQL Injection Vulnerability?
The software constructs all or part of an SQL command using externally-influenced input from an upstream component, but it does not neutralize or incorrectly neutralizes special elements that could modify the intended SQL command when it is sent to a downstream component.
CVE-2024-32888 has been classified to as a SQL Injection vulnerability or weakness.
Affected Versions
aws amazon-redshift-jdbc-driver:- Version < 2.1.0.28 is affected.
- Version - and below 2.1.0.28 is affected.
Vulnerable Packages
The following package name and versions may be associated with CVE-2024-32888
| Package Manager | Vulnerable Package | Versions | Fixed In |
|---|---|---|---|
| maven | com.amazon.redshift:redshift-jdbc42 | < 2.1.0.28 | 2.1.0.28 |
Exploit Probability
EPSS (Exploit Prediction Scoring System) scores estimate the probability that a vulnerability will be exploited in the wild within the next 30 days. The percentile shows you how this score compares to all other vulnerabilities.