sqlparse-0.4.4-py3-none-any.whl: 1 vulnerabilities (highest severity is: 7.5)

[mend-for-github-com]

Vulnerable Library - sqlparse-0.4.4-py3-none-any.whl

A non-validating SQL parser.

Library home page: https://files.pythonhosted.org/packages/98/5a/66d7c9305baa9f11857f247d4ba761402cea75db6058ff850ed7128957b7/sqlparse-0.4.4-py3-none-any.whl

Path to dependency file: /TrafficCapture/dockerSolution/src/main/docker/migrationConsole/console_api/requirements.txt

Path to vulnerable library: /TrafficCapture/dockerSolution/src/main/docker/migrationConsole/console_api/requirements.txt

Found in HEAD commit: 4c93fc8825bc831de5d22819f0c7f3d2f149b200

Vulnerabilities

CVE	Severity	CVSS	Dependency	Type	Fixed in (sqlparse version)	Remediation Possible**
CVE-2024-4340	High	7.5	sqlparse-0.4.4-py3-none-any.whl	Direct	sqlparse - 0.5.0	✅

**In some cases, Remediation PR cannot be created automatically for a vulnerability despite the availability of remediation

Details

CVE-2024-4340

Vulnerable Library - sqlparse-0.4.4-py3-none-any.whl

A non-validating SQL parser.

Library home page: https://files.pythonhosted.org/packages/98/5a/66d7c9305baa9f11857f247d4ba761402cea75db6058ff850ed7128957b7/sqlparse-0.4.4-py3-none-any.whl

Path to dependency file: /TrafficCapture/dockerSolution/src/main/docker/migrationConsole/console_api/requirements.txt

Path to vulnerable library: /TrafficCapture/dockerSolution/src/main/docker/migrationConsole/console_api/requirements.txt

Dependency Hierarchy:

• ❌ sqlparse-0.4.4-py3-none-any.whl (Vulnerable Library)

Found in HEAD commit: 4c93fc8825bc831de5d22819f0c7f3d2f149b200

Found in base branch: main

Vulnerability Details

Passing a heavily nested list to sqlparse.parse() leads to a Denial of Service due to RecursionError.

Publish Date: 2024-04-30

URL: CVE-2024-4340

CVSS 3 Score Details (7.5)

Base Score Metrics:

• Exploitability Metrics:
  • Attack Vector: Network
  • Attack Complexity: Low
  • Privileges Required: None
  • User Interaction: None
  • Scope: Unchanged
• Impact Metrics:
  • Confidentiality Impact: None
  • Integrity Impact: None
  • Availability Impact: High

For more information on CVSS3 Scores, click here.

Suggested Fix

Type: Upgrade version

Origin: https://www.cve.org/CVERecord?id=CVE-2024-4340

Release Date: 2024-04-30

Fix Resolution: sqlparse - 0.5.0

⛑️ Automatic Remediation will be attempted for this issue.

---

⛑️Automatic Remediation will be attempted for this issue.

[mikaylathompson]

This appears to be fixed in main: https://github.com/opensearch-project/opensearch-migrations/blob/main/TrafficCapture/dockerSolution/src/main/docker/migrationConsole/console_api/requirements.txt#L10