PYSEC-2023-87

    Dashboard / Vulnerabilities / PYSEC-2023-87

    PYSEC-2023-87

    Published: 18 Apr 2023Last Modified: 8 Nov 2023

    Summary:

    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.

    References: https://github.com/andialbrecht/sqlparse/security/advisories/GHSA-rrm6-wvj7-cwh2, https://owasp.org/www-community/attacks/Regular_expression_Denial_of_Service_-_ReDoS, https://github.com/andialbrecht/sqlparse/commit/c457abd5f097dd13fb21543381e7cfafe7d31cfb, https://github.com/andialbrecht/sqlparse/commit/e75e35869473832a1eb67772b1adfee2db11b85a, https://lists.debian.org/debian-lts-announce/2023/05/msg00017.html

    Affected packages

    Package

    Name: sqlparse

    Purl: pkg:pypi/sqlparse

    Affected ranges

    Type: GIT

    Events:

    Introduced- 0
    Fixed -c457abd5f097dd13fb21543381e7cfafe7d31cfb

    Affected versions

    0.1.15
    0.1.16
    0.1.17
    0.1.18
    0.1.19

    Common Vulnerability Scoring System

    Attack Vector
    Network
    Adjacent
    Local
    Physical
    Privileges Required
    None
    Low
    High
    User Interaction
    None
    Required
    Scope
    Unchanged
    Changed
    Confidentiality
    None
    Low
    High
    Integrity
    None
    Low
    High
    Availability
    None
    Low
    High
    PYSEC-2023-87 | CVE-DB