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.
CVSS Details
- CVSS 3.1 Base Score: 7.5
- CVSS 3.1 Vector: (CVSS:3.1/AV:N/AC:L/PR:N/UI:N/S:U/C:N/I:N/A:H)
Covered by Rapid7
| Product | Vendor Advisory | Solution File | Added | Published |
|---|---|---|---|---|
| Alpine Linux | — | Upgrade py3-sqlparse | Aug 22, 2024 | Sep 20, 2021 |
| Centos_linux | — | Upgrade satellite-cloneUpgrade tfm-rubygem-hammer_cli_foreman_adminUpgrade rubygem-hammer_cli_foreman_openscapUpgrade rubygem-unicode-debugsourceUpgrade rubygem-hammer_cli_foreman_webhooksUpgrade tfm-rubygem-fast_gettextUpgrade rubygem-multi_jsonUpgrade rubygem-hammer_cli_foreman_remote_executionUpgrade rubygem-unicodeUpgrade tfm-runtimeUpgrade rubygem-apipie-bindingsUpgrade rubygem-hammer_cli_foreman_virt_who_configureUpgrade tfm-rubygem-http-cookieUpgrade rubygem-localeUpgrade rubygem-mime-typesUpgrade tfm-rubygem-hammer_cli_foreman_bootdiskUpgrade tfm-rubygem-hammer_cli_foreman_virt_who_configureUpgrade rubygem-unicode-display_widthUpgrade rubygem-hammer_cli_foreman_azure_rmUpgrade rubygem-http-cookieUpgrade rubygem-hammer_cli_foreman_adminUpgrade rubygem-powerbarUpgrade tfm-rubygem-unfUpgrade tfm-rubygem-hammer_cli_foreman_ansibleUpgrade tfm-rubygem-powerbarUpgrade rubygem-mime-types-dataUpgrade tfm-rubygem-rest-clientUpgrade tfm-rubygem-little-pluggerUpgrade rubygem-netrcUpgrade tfm-rubygem-loggingUpgrade tfm-rubygem-mime-typesUpgrade tfm-rubygem-hammer_cli_foreman_remote_executionUpgrade tfm-rubygem-hammer_cli_foreman_templatesUpgrade tfm-rubygem-oauthUpgrade tfm-rubygem-hammer_cli_foreman_tasksUpgrade tfm-rubygem-unf_extUpgrade tfm-rubygem-amazing_printUpgrade tfm-rubygem-hammer_cli_foreman_azure_rmUpgrade rubygem-unfUpgrade tfm-rubygem-apipie-bindingsUpgrade rubygem-hammer_cli_katelloUpgrade rubygem-unf_extUpgrade rubygem-hammer_cli_foreman_ansibleUpgrade tfm-rubygem-clampUpgrade tfm-rubygem-hammer_cliUpgrade rubygem-unf_ext-debuginfoUpgrade satellite-cliUpgrade tfm-rubygem-hammer_cli_katelloUpgrade rubygem-domain_nameUpgrade rubygem-hammer_cli_foreman_bootdiskUpgrade tfm-rubygem-hammer_cli_foreman_openscapUpgrade foreman-cliUpgrade rubygem-highlineUpgrade tfm-rubygem-hashieUpgrade tfm-rubygem-unf_ext-debuginfoUpgrade rubygem-jwtUpgrade rubygem-hammer_cliUpgrade rubygem-unicode-debuginfoUpgrade rubygem-rest-clientUpgrade rubygem-foreman_maintainUpgrade tfm-rubygem-hammer_cli_foreman_webhooksUpgrade tfm-rubygem-mime-types-dataUpgrade rubygem-little-pluggerUpgrade tfm-rubygem-jwtUpgrade rubygem-hashieUpgrade rubygem-unf_ext-debugsourceUpgrade rubygem-hammer_cli_foreman_templatesUpgrade rubygem-hammer_cli_foreman_tasksUpgrade tfm-rubygem-netrcUpgrade tfm-rubygem-localeUpgrade tfm-rubygem-highlineUpgrade rubygem-oauthUpgrade rubygem-hammer_cli_foreman_discoveryUpgrade rubygem-fast_gettextUpgrade rubygem-amazing_printUpgrade tfm-rubygem-hammer_cli_foreman_discoveryUpgrade tfm-rubygem-unicodeUpgrade tfm-rubygem-multi_jsonUpgrade rubygem-hammer_cli_foremanUpgrade tfm-rubygem-unicode-display_widthUpgrade rubygem-clampUpgrade tfm-rubygem-unicode-debuginfoUpgrade satellite-maintainUpgrade rubygem-loggingUpgrade tfm-rubygem-hammer_cli_foremanUpgrade tfm-rubygem-domain_name | Jul 14, 2022 | Sep 20, 2021 |
| Debian | — | Upgrade sqlparse | Jul 30, 2024 | Sep 20, 2021 |
| Redhat_linux | — | Upgrade tfm-runtimeUpgrade rubygem-hammer_cli_foreman_webhooksUpgrade rubygem-unicode-display_widthUpgrade tfm-rubygem-hammer_cli_foreman_bootdiskUpgrade rubygem-multi_jsonUpgrade tfm-rubygem-domain_nameUpgrade rubygem-hammer_cli_foreman_openscapUpgrade rubygem-unicode-debugsourceUpgrade tfm-rubygem-highlineUpgrade tfm-rubygem-hammer_cli_foreman_discoveryUpgrade tfm-rubygem-apipie-bindingsUpgrade rubygem-unf_ext-debugsourceUpgrade satellite-cliUpgrade rubygem-hammer_cli_foreman_templatesUpgrade tfm-rubygem-hammer_cli_foreman_remote_executionUpgrade rubygem-mime-typesUpgrade tfm-rubygem-unf_ext-debuginfoUpgrade satellite-maintainUpgrade tfm-rubygem-hammer_cli_foreman_openscapUpgrade rubygem-hammer_cli_foreman_tasksUpgrade tfm-rubygem-unf_extUpgrade tfm-rubygem-unicodeUpgrade tfm-rubygem-http-cookieUpgrade tfm-rubygem-hammer_cli_foreman_azure_rmUpgrade tfm-rubygem-rest-clientUpgrade tfm-rubygem-hammer_cli_foreman_templatesUpgrade tfm-rubygem-jwtUpgrade tfm-rubygem-hammer_cli_foreman_adminUpgrade tfm-rubygem-localeUpgrade tfm-rubygem-hammer_cliUpgrade tfm-rubygem-oauthUpgrade rubygem-hammer_cli_katelloUpgrade rubygem-hammer_cli_foreman_adminUpgrade tfm-rubygem-hashieUpgrade rubygem-netrcUpgrade rubygem-little-pluggerUpgrade rubygem-hammer_cli_foremanUpgrade tfm-rubygem-clampUpgrade tfm-rubygem-multi_jsonUpgrade rubygem-hammer_cliUpgrade rubygem-rest-clientUpgrade tfm-rubygem-hammer_cli_foreman_webhooksUpgrade rubygem-hammer_cli_foreman_ansibleUpgrade tfm-rubygem-fast_gettextUpgrade tfm-rubygem-hammer_cli_foreman_virt_who_configureUpgrade rubygem-http-cookieUpgrade rubygem-localeUpgrade rubygem-unicodeUpgrade rubygem-hammer_cli_foreman_azure_rmUpgrade tfm-rubygem-mime-typesUpgrade rubygem-amazing_printUpgrade rubygem-hammer_cli_foreman_bootdiskUpgrade tfm-rubygem-unfUpgrade foreman-cliUpgrade tfm-rubygem-amazing_printUpgrade rubygem-unfUpgrade rubygem-hammer_cli_foreman_discoveryUpgrade tfm-rubygem-hammer_cli_foreman_ansibleUpgrade rubygem-clampUpgrade tfm-rubygem-hammer_cli_foreman_tasksUpgrade rubygem-unf_ext-debuginfoUpgrade rubygem-mime-types-dataUpgrade tfm-rubygem-little-pluggerUpgrade tfm-rubygem-loggingUpgrade rubygem-hammer_cli_foreman_virt_who_configureUpgrade rubygem-hashieUpgrade tfm-rubygem-mime-types-dataUpgrade rubygem-foreman_maintainUpgrade rubygem-domain_nameUpgrade rubygem-oauthUpgrade tfm-rubygem-powerbarUpgrade rubygem-jwtUpgrade tfm-rubygem-unicode-debuginfoUpgrade rubygem-fast_gettextUpgrade tfm-rubygem-hammer_cli_foremanUpgrade rubygem-apipie-bindingsUpgrade satellite-cloneUpgrade rubygem-hammer_cli_foreman_remote_executionUpgrade rubygem-unf_extUpgrade tfm-rubygem-unicode-display_widthUpgrade tfm-rubygem-hammer_cli_katelloUpgrade rubygem-highlineUpgrade rubygem-unicode-debuginfoUpgrade rubygem-loggingUpgrade rubygem-powerbarUpgrade tfm-rubygem-netrc | Jul 14, 2022 | Sep 20, 2021 |
| Rocky_linux | — | Upgrade libdb-cxx-debuginfoUpgrade libdb-debuginfoUpgrade libdb-cxxUpgrade libdb-sql-debuginfoUpgrade libdb-debugsourceUpgrade libdb-utils-debuginfoUpgrade libdb-sql-devel-debuginfo | Mar 12, 2024 | Sep 20, 2021 |
| Suse | — | Upgrade python3-sqlparse | Dec 2, 2021 | Sep 20, 2021 |
| Ubuntu | — | Upgrade python3-sqlparse | Sep 23, 2021 | Sep 20, 2021 |
Prioritize with Active Threat Intelligence
With curated Threat Intelligence, you can see which vulnerabilities truly put you at risk, prioritize what matters most, and act before attackers do.
Explore Intelligence Hub