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.8 are affected.
:heavy_check_mark: This issue was automatically closed by Mend because the vulnerable library in the specific branch(es) was either marked as ignored or it is no longer part of the Mend inventory.
Vulnerable Library - postgresql-42.7.1.jar
PostgreSQL JDBC Driver Postgresql
Library home page: https://jdbc.postgresql.org
Path to dependency file: /openmetadata-service/pom.xml
Path to vulnerable library: /openmetadata-service/pom.xml
Found in HEAD commit: a1bc39af08ce6784b48d915ebf95bdde37e7465a
Vulnerabilities
**In some cases, Remediation PR cannot be created automatically for a vulnerability despite the availability of remediation
Details
CVE-2024-1597
### Vulnerable Library - postgresql-42.7.1.jarPostgreSQL JDBC Driver Postgresql
Library home page: https://jdbc.postgresql.org
Path to dependency file: /openmetadata-service/pom.xml
Path to vulnerable library: /openmetadata-service/pom.xml
Dependency Hierarchy: - :x: **postgresql-42.7.1.jar** (Vulnerable Library)
Found in HEAD commit: a1bc39af08ce6784b48d915ebf95bdde37e7465a
Found in base branch: main
### Vulnerability Detailspgjdbc, 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.8 are affected.
Publish Date: 2024-02-19
URL: CVE-2024-1597
### CVSS 3 Score Details (10.0)Base Score Metrics: - Exploitability Metrics: - Attack Vector: Network - Attack Complexity: Low - Privileges Required: None - User Interaction: None - Scope: Changed - Impact Metrics: - Confidentiality Impact: High - Integrity Impact: High - Availability Impact: High
For more information on CVSS3 Scores, click here. ### Suggested FixType: Upgrade version
Origin: https://www.cve.org/CVERecord?id=CVE-2024-1597
Release Date: 2024-02-19
Fix Resolution: 42.7.2
In order to enable automatic remediation, please create workflow rules
In order to enable automatic remediation for this issue, please create workflow rules