CVE-2021-32839: Regular Expression Denial of Service in sqlparse
First published: Fri Sep 10 2021(Updated: )
### Impact The formatter function that strips comments from a SQL contains a regular expression that is vulnerable to [ReDoS](https://owasp.org/www-community/attacks/Regular_expression_Denial_of_Service_-_ReDoS) (Regular Expression Denial of Service). The regular expression may cause exponential backtracking on strings containing many repetitions of '\r\n' in SQL comments. ### Patches The issues has been fixed in sqlparse 0.4.2. ### Workarounds 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. ### References This issue was discovered by GitHub team members @erik-krogh and @yoff. It was found using a [CodeQL](https://codeql.github.com/) query which identifies inefficient regular expressions. You can see the results of the query on python-sqlparse by following [this link](https://lgtm.com/query/2223658096471222354/). ### For more information If you have any questions or comments about this advisory: * Open an issue in [sqlparse issue tracker](https://github.com/andialbrecht/sqlparse/issues) * Email us at [albrecht.andi@gmail.com](mailto:albrecht.andi@gmail.com)
Credit: security-advisories@github.com security-advisories@github.com
| Affected Software | Affected Version | How to fix |
|---|---|---|
| redhat/sqlparse | <0.4.2 | 0.4.2 |
| pip/sqlparse | >=0.4.0<0.4.2 | 0.4.2 |
| sqlparse | >=0.4.0<0.4.2 |
Never miss a vulnerability like this again
Sign up to SecAlerts for real-time vulnerability data matched to your software, aggregated from hundreds of sources.
Reference Links
- https://github.com/andialbrecht/sqlparse/commit/8238a9e450ed1524e40cb3a8b0b3c00606903aeb
- https://github.com/andialbrecht/sqlparse/security/advisories/GHSA-p5w8-wqhj-9hhf
- https://bugzilla.redhat.com/show_bug.cgi/show_bug.cgi?id=2005074
- https://bugzilla.redhat.com/show_bug.cgi/show_bug.cgi?id=2005178
- https://access.redhat.com/errata/RHSA-2022:5498
- https://bugzilla.redhat.com/show_bug.cgi?id=2005072
- https://nvd.nist.gov/vuln/detail/CVE-2021-32839
- https://github.com/pypa/advisory-database/tree/main/vulns/sqlparse/PYSEC-2021-333.yaml
- https://securitylab.github.com/advisories/GHSL-2021-107-andialbrecht-sqlparse
- https://github.com/advisories/GHSA-p5w8-wqhj-9hhf (Advisory)
- agent/type
- agent/weakness
- agent/remedy
- collector/redhat-bugzilla
- source/Red Hat
- alias/CVE-2021-32839
- agent/software-canonical-lookup
- collector/mitre-cve
- source/MITRE
- agent/severity
- agent/title
- collector/github-advisory-latest
- source/GitHub
- alias/GHSA-p5w8-wqhj-9hhf
- agent/last-modified-date
- agent/references
- agent/first-publish-date
- agent/description
- agent/event
- agent/softwarecombine
- agent/author
- collector/github-advisory
- agent/trending
- agent/source
- agent/tags
- collector/nvd-cve
- source/NVD
- agent/software-canonical-lookup-request
- collector/nvd-index
- package-manager/redhat
- package-manager/pip
- vendor/sqlparse project
- canonical/sqlparse
- version/sqlparse/0.4.0