Upstream information
Description
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.SUSE information
Overall state of this security issue: Resolved
This issue is currently rated as having moderate severity.
| National Vulnerability Database | SUSE | |
|---|---|---|
| Base Score | 7.5 | 6.5 |
| Vector | CVSS:3.1/AV:N/AC:L/PR:N/UI:N/S:U/C:N/I:N/A:H | CVSS:3.1/AV:N/AC:L/PR:L/UI:N/S:U/C:N/I:N/A:H |
| Attack Vector | Network | Network |
| Attack Complexity | Low | Low |
| Privileges Required | None | Low |
| User Interaction | None | None |
| Scope | Unchanged | Unchanged |
| Confidentiality Impact | None | None |
| Integrity Impact | None | None |
| Availability Impact | High | High |
| CVSSv3 Version | 3.1 | 3.1 |
SUSE Security Advisories:
- SUSE-SU-2021:3857-1, published Wed Dec 1 21:03:11 UTC 2021
- openSUSE-SU-2021:3857-1, published Thu Dec 2 00:42:13 2021
List of released packages
| Product(s) | Fixed package version(s) | References |
|---|---|---|
| SUSE Enterprise Storage 7.1 SUSE Linux Enterprise Desktop 15 SP3 SUSE Linux Enterprise High Performance Computing 15 SP3 SUSE Linux Enterprise Module for Basesystem 15 SP3 SUSE Linux Enterprise Server 15 SP3 SUSE Linux Enterprise Server for SAP Applications 15 SP3 SUSE Manager Proxy 4.2 SUSE Manager Retail Branch Server 4.2 SUSE Manager Server 4.2 |
| Patchnames: SUSE-SLE-Module-Basesystem-15-SP3-2021-3857 |
| SUSE Linux Enterprise Desktop 15 SP4 SUSE Linux Enterprise High Performance Computing 15 SP4 SUSE Linux Enterprise Module for Basesystem 15 SP4 SUSE Linux Enterprise Server 15 SP4 SUSE Linux Enterprise Server for SAP Applications 15 SP4 SUSE Manager Proxy 4.3 SUSE Manager Retail Branch Server 4.3 SUSE Manager Server 4.3 |
| Patchnames: SUSE Linux Enterprise Module for Basesystem 15 SP4 GA python-sqlparse-0.4.2-3.3.1 SUSE Linux Enterprise Module for Basesystem 15 SP4 GA python3-sqlparse-0.4.2-3.3.1 |
| SUSE Linux Enterprise Desktop 15 SP5 SUSE Linux Enterprise High Performance Computing 15 SP5 SUSE Linux Enterprise Module for Basesystem 15 SP5 SUSE Linux Enterprise Server 15 SP5 SUSE Linux Enterprise Server for SAP Applications 15 SP5 |
| Patchnames: SUSE Linux Enterprise Module for Basesystem 15 SP5 GA python-sqlparse-0.4.2-3.3.1 SUSE Linux Enterprise Module for Basesystem 15 SP5 GA python3-sqlparse-0.4.2-3.3.1 |
| SUSE Linux Enterprise Desktop 15 SP6 SUSE Linux Enterprise High Performance Computing 15 SP6 SUSE Linux Enterprise Server 15 SP6 SUSE Linux Enterprise Server for SAP Applications 15 SP6 |
| Patchnames: SUSE Linux Enterprise Module for Basesystem 15 SP6 GA python3-sqlparse-0.4.2-150300.9.1 SUSE Linux Enterprise Module for Python 3 15 SP6 GA python311-sqlparse-0.4.4-150600.1.2 |
| SUSE Linux Enterprise Module for Basesystem 15 SP6 |
| Patchnames: SUSE Linux Enterprise Module for Basesystem 15 SP6 GA python3-sqlparse-0.4.2-150300.9.1 |
| SUSE Linux Enterprise Module for Python 3 15 SP6 |
| Patchnames: SUSE Linux Enterprise Module for Python 3 15 SP6 GA python311-sqlparse-0.4.4-150600.1.2 |
| openSUSE Leap 15.3 |
| Patchnames: openSUSE-SLE-15.3-2021-3857 |
| openSUSE Tumbleweed |
| Patchnames: openSUSE-Tumbleweed-2024-11581 openSUSE-Tumbleweed-2024-13938 |
Status of this issue by product and package
Please note that this evaluation state might be work in progress, incomplete or outdated. Also information for service packs in the LTSS phase is only included for issues meeting the LTSS criteria. If in doubt, feel free to contact us for clarification. The updates are grouped by state of their lifecycle. SUSE product lifecycles are documented on the lifecycle page.
| Product(s) | Source package | State |
|---|---|---|
| Products under general support and receiving all security fixes. | ||
| SUSE Linux Enterprise Desktop 15 SP5 | python-sqlparse | Released |
| SUSE Linux Enterprise Desktop 15 SP6 | python3-sqlparse | Released |
| SUSE Linux Enterprise High Performance Computing 15 SP5 | python-sqlparse | Released |
| SUSE Linux Enterprise High Performance Computing 15 SP6 | python3-sqlparse | Released |
| SUSE Linux Enterprise Module for Basesystem 15 SP5 | python-sqlparse | Released |
| SUSE Linux Enterprise Module for Basesystem 15 SP6 | python3-sqlparse | Released |
| SUSE Linux Enterprise Module for Package Hub 15 SP5 | python-sqlparse | Not affected |
| SUSE Linux Enterprise Module for Package Hub 15 SP6 | python-sqlparse | Not affected |
| SUSE Linux Enterprise Server 15 SP5 | python-sqlparse | Released |
| SUSE Linux Enterprise Server 15 SP6 | python3-sqlparse | Released |
| SUSE Linux Enterprise Server for SAP Applications 15 SP5 | python-sqlparse | Released |
| SUSE Linux Enterprise Server for SAP Applications 15 SP6 | python3-sqlparse | Released |
| SUSE Manager Proxy 4.3 | python-sqlparse | Released |
| SUSE Manager Retail Branch Server 4.3 | python-sqlparse | Released |
| SUSE Manager Server 4.3 | python-sqlparse | Released |
| Products under Long Term Service Pack support and receiving important and critical security fixes. | ||
| SUSE Linux Enterprise Desktop 15 SP4 | python-sqlparse | Released |
| SUSE Linux Enterprise High Performance Computing 15 SP2 | python-sqlparse | Not affected |
| SUSE Linux Enterprise High Performance Computing 15 SP2-ESPOS | python-sqlparse | Not affected |
| SUSE Linux Enterprise High Performance Computing 15 SP2-LTSS | python-sqlparse | Not affected |
| SUSE Linux Enterprise High Performance Computing 15 SP3 | python-sqlparse | Released |
| SUSE Linux Enterprise High Performance Computing 15 SP4 | python-sqlparse | Released |
| SUSE Linux Enterprise Module for Basesystem 15 SP2 | python-sqlparse | Not affected |
| SUSE Linux Enterprise Module for Basesystem 15 SP3 | python-sqlparse | Released |
| SUSE Linux Enterprise Module for Basesystem 15 SP4 | python-sqlparse | Released |
| SUSE Linux Enterprise Server 15 SP2 | python-sqlparse | Not affected |
| SUSE Linux Enterprise Server 15 SP2-LTSS | python-sqlparse | Not affected |
| SUSE Linux Enterprise Server 15 SP3 | python-sqlparse | Released |
| SUSE Linux Enterprise Server 15 SP4 | python-sqlparse | Released |
| SUSE Linux Enterprise Server Business Critical Linux 15 SP1 | python-sqlparse | Not affected |
| SUSE Linux Enterprise Server for SAP Applications 15 SP2 | python-sqlparse | Not affected |
| SUSE Linux Enterprise Server for SAP Applications 15 SP3 | python-sqlparse | Released |
| SUSE Linux Enterprise Server for SAP Applications 15 SP4 | python-sqlparse | Released |
| Products past their end of life and not receiving proactive updates anymore. | ||
| HPE Helion OpenStack 8 | python-sqlparse | Not affected |
| SUSE CaaS Platform 4.0 | python-sqlparse | Not affected |
| SUSE Enterprise Storage 6 | python-sqlparse | Not affected |
| SUSE Enterprise Storage 7 | python-sqlparse | Not affected |
| SUSE Enterprise Storage 7.1 | python-sqlparse | Released |
| SUSE Linux Enterprise Desktop 15 SP1 | python-sqlparse | Not affected |
| SUSE Linux Enterprise Desktop 15 SP2 | python-sqlparse | Not affected |
| SUSE Linux Enterprise Desktop 15 SP3 | python-sqlparse | Released |
| SUSE Linux Enterprise High Performance Computing 15 SP1 | python-sqlparse | Not affected |
| SUSE Linux Enterprise High Performance Computing 15 SP1-ESPOS | python-sqlparse | Not affected |
| SUSE Linux Enterprise High Performance Computing 15 SP1-LTSS | python-sqlparse | Not affected |
| SUSE Linux Enterprise Module for Basesystem 15 SP1 | python-sqlparse | Not affected |
| SUSE Linux Enterprise Module for Package Hub 15 SP1 | python-sqlparse | Not affected |
| SUSE Linux Enterprise Module for Package Hub 15 SP2 | python-sqlparse | Not affected |
| SUSE Linux Enterprise Module for Package Hub 15 SP3 | python-sqlparse | Not affected |
| SUSE Linux Enterprise Module for Package Hub 15 SP4 | python-sqlparse | Not affected |
| SUSE Linux Enterprise Real Time 15 SP2 | python-sqlparse | Not affected |
| SUSE Linux Enterprise Server 15 SP1 | python-sqlparse | Not affected |
| SUSE Linux Enterprise Server 15 SP1-BCL | python-sqlparse | Not affected |
| SUSE Linux Enterprise Server 15 SP1-LTSS | python-sqlparse | Not affected |
| SUSE Linux Enterprise Server 15 SP2-BCL | python-sqlparse | Not affected |
| SUSE Linux Enterprise Server 15 SP3-BCL | python-sqlparse | Affected |
| SUSE Linux Enterprise Server for SAP Applications 15 SP1 | python-sqlparse | Not affected |
| SUSE Manager Proxy 4.0 | python-sqlparse | Not affected |
| SUSE Manager Proxy 4.1 | python-sqlparse | Not affected |
| SUSE Manager Proxy 4.2 | python-sqlparse | Released |
| SUSE Manager Retail Branch Server 4.0 | python-sqlparse | Not affected |
| SUSE Manager Retail Branch Server 4.1 | python-sqlparse | Not affected |
| SUSE Manager Retail Branch Server 4.2 | python-sqlparse | Released |
| SUSE Manager Server 4.0 | python-sqlparse | Not affected |
| SUSE Manager Server 4.1 | python-sqlparse | Not affected |
| SUSE Manager Server 4.2 | python-sqlparse | Released |
| SUSE OpenStack Cloud 8 | python-sqlparse | Not affected |
| SUSE OpenStack Cloud 9 | python-sqlparse | Not affected |
| SUSE OpenStack Cloud Crowbar 8 | python-sqlparse | Not affected |
| SUSE OpenStack Cloud Crowbar 9 | python-sqlparse | Not affected |
| openSUSE Leap 15.3 | python-sqlparse | Not affected |
SUSE Timeline for this CVE
CVE page created: Mon Sep 20 22:00:14 2021CVE page last modified: Wed Oct 30 11:43:17 2024