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

[staging-whitesource-for-github-com]

Vulnerable Library - sqlparse-0.3.0-py2.py3-none-any.whl

Non-validating SQL parser

Library home page: https://files.pythonhosted.org/packages/ef/53/900f7d2a54557c6a37886585a91336520e5539e3ae2423ff1102daf4f3a7/sqlparse-0.3.0-py2.py3-none-any.whl

Path to dependency file: /requirements.txt

Path to vulnerable library: /requirements.txt

Found in HEAD commit: 96a0ce6d706fdd1b34cc2dc3657aee06805cd525

Vulnerabilities

CVE	Severity	CVSS	Dependency	Type	Fixed in (sqlparse version)	Remediation Possible**
WS-2021-0369	High	7.5	sqlparse-0.3.0-py2.py3-none-any.whl	Direct	0.4.2	✅

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

Details

WS-2021-0369

Vulnerable Library - sqlparse-0.3.0-py2.py3-none-any.whl

Non-validating SQL parser

Library home page: https://files.pythonhosted.org/packages/ef/53/900f7d2a54557c6a37886585a91336520e5539e3ae2423ff1102daf4f3a7/sqlparse-0.3.0-py2.py3-none-any.whl

Path to dependency file: /requirements.txt

Path to vulnerable library: /requirements.txt

Dependency Hierarchy:

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

Found in HEAD commit: 96a0ce6d706fdd1b34cc2dc3657aee06805cd525

Found in base branch: master

Vulnerability Details

StripComments filter contains a regular expression that is vulnerable to ReDOS (Regular Expression Denial of Service)
The formatter function that strips comments from a SQL contains a regular expression that is vulnerable to ReDoS (Regular Expression Denial of Service). The regular expression may cause exponential backtracking on strings containing many repetitions of '\r\n' in SQL comments.

Publish Date: 2021-09-10

URL: WS-2021-0369

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: GHSA-p5w8-wqhj-9hhf

Release Date: 2021-09-10

Fix Resolution: 0.4.2

⛑️ Automatic Remediation will be attempted for this issue.

---

⛑️Automatic Remediation will be attempted for this issue.