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.
Weakness
The product uses a regular expression with an inefficient, possibly exponential worst-case computational complexity that consumes excessive CPU cycles.
Affected Software
| Name | Vendor | Start Version | End Version |
|---|---|---|---|
| Sqlparse | Sqlparse_project | 0.1.15 (including) | 0.4.4 (excluding) |
| Red Hat Satellite 6.14 for RHEL 8 | RedHat | python-sqlparse-0:0.4.4-1.el8pc | * |
| Red Hat Satellite 6.14 for RHEL 8 | RedHat | python-sqlparse-0:0.4.4-1.el8pc | * |
| RHUI 4 for RHEL 8 | RedHat | python-sqlparse-0:0.4.4-1.0.1.el8ui | * |
| Sqlparse | Ubuntu | bionic | * |
| Sqlparse | Ubuntu | devel | * |
| Sqlparse | Ubuntu | esm-infra/bionic | * |
| Sqlparse | Ubuntu | esm-infra/focal | * |
| Sqlparse | Ubuntu | focal | * |
| Sqlparse | Ubuntu | jammy | * |
| Sqlparse | Ubuntu | kinetic | * |
| Sqlparse | Ubuntu | lunar | * |
| Sqlparse | Ubuntu | trusty | * |
| Sqlparse | Ubuntu | upstream | * |
| Sqlparse | Ubuntu | xenial | * |
Extended Description
Attackers can create crafted inputs that
intentionally cause the regular expression to use
excessive backtracking in a way that causes the CPU
consumption to spike.
Potential Mitigations
Related Attack Patterns
References
- https://github.com/andialbrecht/sqlparse/commit/c457abd5f097dd13fb21543381e7cfafe7d31cfb
- https://github.com/andialbrecht/sqlparse/commit/e75e35869473832a1eb67772b1adfee2db11b85a
- https://github.com/andialbrecht/sqlparse/security/advisories/GHSA-rrm6-wvj7-cwh2
- https://lists.debian.org/debian-lts-announce/2023/05/msg00017.html
- 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://github.com/andialbrecht/sqlparse/security/advisories/GHSA-rrm6-wvj7-cwh2
- https://lists.debian.org/debian-lts-announce/2023/05/msg00017.html
- https://lists.debian.org/debian-lts-announce/2024/12/msg00022.html
- https://owasp.org/www-community/attacks/Regular_expression_Denial_of_Service_-_ReDoS