CVE-2021-32839

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.

Impact

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.

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 query which identifies inefficient regular expressions. You can see the results of the query on python-sqlparse by following this link.

For more information

If you have any questions or comments about this advisory:

• Open an issue in sqlparse issue tracker
• Email us at [email protected]

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.

This update for python-sqlparse fixes the following issues:

• CVE-2021-32839: Fixed ReDoS via regular expression in StripComments filter (bsc#1190741).

These are all security issues fixed in the python36-sqlparse-0.4.2-1.1 package on the GA media of openSUSE Tumbleweed.

These are all security issues fixed in the python310-sqlparse-0.5.0-1.1 package on the GA media of openSUSE Tumbleweed.

These are all security issues fixed in the python313-sqlparse-0.5.5-2.1 package on the GA media of openSUSE Tumbleweed.

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.

Rocky Enterprise Software Foundation Satellite is a systems management tool for Linux-based infrastructure. It allows for provisioning, remote management, and monitoring of multiple Linux deployments with a single centralized tool.

Security Fix(es):

• libsolv: Heap-based buffer overflow in testcase_read() in src/testcase.c (CVE-2021-3200)
• satellite: foreman: Authenticate remote code execution through Sendmail configuration (CVE-2021-3584)
• candlepin: Allow unintended SCA certificate to authenticate Candlepin (CVE-2021-4142)
• candlepin: netty: Information disclosure via the local system temporary directory (CVE-2021-21290)
• candlepin: netty: Possible request smuggling in HTTP/2 due missing validation (CVE-2021-21295)
• candlepin: netty: Request smuggling via content-length header (CVE-2021-21409)
• tfm-rubygem-sidekiq: XSS via the queue name of the live-poll feature (CVE-2021-30151)
• python-sqlparse: ReDoS via regular expression in StripComments filter (CVE-2021-32839)
• libsolv: various flaws (CVE-2021-33928 CVE-2021-33929 CVE-2021-33930 CVE-2021-33938)
• tfm-rubygem-puma: Inconsistent Interpretation of HTTP Requests in puma (CVE-2021-41136)
• logback-classic: Remote code execution through JNDI call from within its configuration file (CVE-2021-42550)
• candlepin: netty: Control chars in header names may lead to HTTP request smuggling (CVE-2021-43797)
• python-lxml: HTML Cleaner allows crafted and SVG embedded scripts to pass through (CVE-2021-43818)
• python3-django: Potential bypass of an upstream access control based on URL paths (CVE-2021-44420)
• libsolv: Heap overflow (CVE-2021-44568)
• python3-django: Various flaws (CVE-2021-45115 CVE-2021-45116 CVE-2021-45452 CVE-2022-22818)
• tfm-rubygem-actionpack: Information leak between requests (CVE-2022-23633)
• tfm-rubygem-puma: rubygem-rails: Information leak between requests (CVE-2022-23634)
• python3-django: Denial-of-service possibility in file uploads (CVE-2022-23833)
• tfm-rubygem-sidekiq: WebUI Denial of Service caused by number of days on graph (CVE-2022-23837)
• python3-django: Various flaws (CVE-2022-28346 CVE-2022-28347)

For more details about the security issue(s), including the impact, a CVSS score, acknowledgments, and other related information, refer to the CVE page(s) listed in the References section.

Additional Changes:

• New repo layout for Satellite, Utils, Maintenance, and Client repos.
• Support for Rocky Linux 9 clients
• Module-based installation on Rocky Linux 8
• Upgrading Satellite Server and Capsule Server installations from Rocky Linux 7 to Rocky Linux 8
• Connected and Disconnected servers supported on Rocky Linux 7 and Rocky Linux 8
• Inter-Server Synchronization improvements
• Puppet integration optional and disabled by default
• Pulp 3 updated to Python 3.8
• Change to Capsule certificate archive
• New default port for communication with Rocky Enterprise Software Foundation Subscription Management * (RHSM) API on Capsule servers
• New Content Views Page (Content Publication workflow simplification)
• New Hosts Page (Technology Preview)
• Registration and preview templates
• Simplified host content source changing
• Improved behavior for configuring and running remote jobs
• Provisioning improvements
• New error signaling unsupported options in TASK-Filter
• Virt-who configuration enhanced to support Nutanix AHV
• Cloud Connector configuration updated
• Improved Insights adoption

The items above are not a complete list of changes. This update also fixes several bugs and adds various enhancements. Documentation for these changes is available from the Release Notes document linked to in the References section.

This update for python-sqlparse fixes the following issues:

• CVE-2021-32839: Fixed ReDoS via regular expression in StripComments filter (bsc#1190741).