sqlparse-0.4.1-py3-none-any.whl: 4 vulnerabilities (highest severity is: 7.5)

[mend-for-github-com]

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

A non-validating SQL parser.

Library home page: https://files.pythonhosted.org/packages/14/05/6e8eb62ca685b10e34051a80d7ea94b7137369d8c0be5c3b9d9b6e3f5dae/sqlparse-0.4.1-py3-none-any.whl

Path to dependency file: /data-files/benchmarks/bm_django_template/requirements.txt

Path to vulnerable library: /data-files/benchmarks/bm_django_template/requirements.txt,/data-files/benchmarks/bm_django_template/requirements.txt

Found in HEAD commit: b4e24341e4c07ef7401fadd16a39617d287a4d1e

Vulnerabilities

Vulnerability	Severity	CVSS	Dependency	Type	Fixed in (sqlparse version)	Remediation Possible**
WS-2021-0369	High	7.5	sqlparse-0.4.1-py3-none-any.whl	Direct	sqlparse - 0.4.2	✅
CVE-2024-4340	High	7.5	sqlparse-0.4.1-py3-none-any.whl	Direct	sqlparse - 0.5.0	❌
CVE-2021-32839	High	7.5	sqlparse-0.4.1-py3-none-any.whl	Direct	sqlparse - 0.4.2	❌
CVE-2023-30608	Medium	5.5	sqlparse-0.4.1-py3-none-any.whl	Direct	sqlparse - 0.4.4	❌

**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.4.1-py3-none-any.whl

A non-validating SQL parser.

Library home page: https://files.pythonhosted.org/packages/14/05/6e8eb62ca685b10e34051a80d7ea94b7137369d8c0be5c3b9d9b6e3f5dae/sqlparse-0.4.1-py3-none-any.whl

Path to dependency file: /data-files/benchmarks/bm_django_template/requirements.txt

Path to vulnerable library: /data-files/benchmarks/bm_django_template/requirements.txt,/data-files/benchmarks/bm_django_template/requirements.txt

Dependency Hierarchy:

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

Found in HEAD commit: b4e24341e4c07ef7401fadd16a39617d287a4d1e

Found in base branch: main

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: sqlparse - 0.4.2

⛑️ Automatic Remediation will be attempted for this issue.

CVE-2024-4340

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

A non-validating SQL parser.

Library home page: https://files.pythonhosted.org/packages/14/05/6e8eb62ca685b10e34051a80d7ea94b7137369d8c0be5c3b9d9b6e3f5dae/sqlparse-0.4.1-py3-none-any.whl

Path to dependency file: /data-files/benchmarks/bm_django_template/requirements.txt

Path to vulnerable library: /data-files/benchmarks/bm_django_template/requirements.txt,/data-files/benchmarks/bm_django_template/requirements.txt

Dependency Hierarchy:

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

Found in HEAD commit: b4e24341e4c07ef7401fadd16a39617d287a4d1e

Found in base branch: main

Vulnerability Details

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

Mend Note: The description of this vulnerability differs from MITRE.

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: GHSA-2m57-hf25-phgg

Release Date: 2024-04-30

Fix Resolution: sqlparse - 0.5.0

CVE-2021-32839

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

A non-validating SQL parser.

Library home page: https://files.pythonhosted.org/packages/14/05/6e8eb62ca685b10e34051a80d7ea94b7137369d8c0be5c3b9d9b6e3f5dae/sqlparse-0.4.1-py3-none-any.whl

Path to dependency file: /data-files/benchmarks/bm_django_template/requirements.txt

Path to vulnerable library: /data-files/benchmarks/bm_django_template/requirements.txt,/data-files/benchmarks/bm_django_template/requirements.txt

Dependency Hierarchy:

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

Found in HEAD commit: b4e24341e4c07ef7401fadd16a39617d287a4d1e

Found in base branch: main

Vulnerability Details

sqlparse is a non-validating SQL parser module for Python. In sqlparse versions 0.4.0 and 0.4.1 there is a regular Expression Denial of Service in sqlparse vulnerability. The regular expression may cause exponential backtracking on strings containing many repetitions of '\r\n' in SQL comments. Only the formatting feature that removes comments from SQL statements is affected by this regular expression. As a workaround don't use the sqlformat.format function with keyword strip_comments=True or the --strip-comments command line flag when using the sqlformat command line tool. The issues has been fixed in sqlparse 0.4.2.

Publish Date: 2021-09-20

URL: CVE-2021-32839

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-20

Fix Resolution: sqlparse - 0.4.2

CVE-2023-30608

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

A non-validating SQL parser.

Library home page: https://files.pythonhosted.org/packages/14/05/6e8eb62ca685b10e34051a80d7ea94b7137369d8c0be5c3b9d9b6e3f5dae/sqlparse-0.4.1-py3-none-any.whl

Path to dependency file: /data-files/benchmarks/bm_django_template/requirements.txt

Path to vulnerable library: /data-files/benchmarks/bm_django_template/requirements.txt,/data-files/benchmarks/bm_django_template/requirements.txt

Dependency Hierarchy:

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

Found in HEAD commit: b4e24341e4c07ef7401fadd16a39617d287a4d1e

Found in base branch: main

Vulnerability Details

sqlparse is a non-validating SQL parser module for Python. In affected versions the SQL parser contains a regular expression that is vulnerable to ReDoS (Regular Expression Denial of Service). This issue was introduced by commit e75e358. The vulnerability may lead to Denial of Service (DoS). This issues has been fixed in sqlparse 0.4.4 by commit c457abd5f. Users are advised to upgrade. There are no known workarounds for this issue.

Mend Note: The description of this vulnerability differs from MITRE.

Publish Date: 2023-04-18

URL: CVE-2023-30608

CVSS 3 Score Details (5.5)

Base Score Metrics:

• Exploitability Metrics:
  • Attack Vector: Local
  • Attack Complexity: Low
  • Privileges Required: None
  • User Interaction: Required
  • 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-rrm6-wvj7-cwh2

Release Date: 2023-04-18

Fix Resolution: sqlparse - 0.4.4

---

⛑️Automatic Remediation will be attempted for this issue.