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 tfm-rubygem-unf_ext-debuginfoUpgrade tfm-rubygem-domain_nameUpgrade satellite-maintainUpgrade rubygem-jwtUpgrade rubygem-hammer_cliUpgrade tfm-rubygem-hashieUpgrade tfm-rubygem-hammer_cli_foremanUpgrade rubygem-rest-clientUpgrade tfm-rubygem-unicode-debuginfoUpgrade rubygem-unicode-debuginfoUpgrade tfm-rubygem-unicodeUpgrade tfm-rubygem-hammer_cli_foreman_discoveryUpgrade rubygem-highlineUpgrade rubygem-loggingUpgrade tfm-rubygem-hammer_cli_foreman_webhooksUpgrade foreman-cliUpgrade rubygem-little-pluggerUpgrade tfm-rubygem-jwtUpgrade rubygem-hashieUpgrade tfm-rubygem-mime-types-dataUpgrade rubygem-foreman_maintainUpgrade rubygem-oauthUpgrade tfm-rubygem-highlineUpgrade tfm-rubygem-localeUpgrade rubygem-amazing_printUpgrade rubygem-fast_gettextUpgrade rubygem-hammer_cli_foreman_templatesUpgrade rubygem-hammer_cli_foreman_discoveryUpgrade rubygem-hammer_cli_foreman_tasksUpgrade rubygem-unf_ext-debugsourceUpgrade tfm-rubygem-netrcUpgrade rubygem-hammer_cli_foremanUpgrade tfm-rubygem-multi_jsonUpgrade rubygem-clampUpgrade tfm-rubygem-unicode-display_widthUpgrade tfm-rubygem-hammer_cli_foreman_templatesUpgrade satellite-cliUpgrade rubygem-apipie-bindingsUpgrade tfm-rubygem-apipie-bindingsUpgrade tfm-rubygem-hammer_cli_foreman_tasksUpgrade tfm-rubygem-clampUpgrade tfm-rubygem-amazing_printUpgrade rubygem-hammer_cli_foreman_bootdiskUpgrade tfm-rubygem-rest-clientUpgrade rubygem-unf_ext-debuginfoUpgrade rubygem-unfUpgrade tfm-rubygem-hammer_cli_katelloUpgrade tfm-rubygem-fast_gettextUpgrade rubygem-http-cookieUpgrade rubygem-hammer_cli_foreman_remote_executionUpgrade rubygem-unicodeUpgrade tfm-rubygem-hammer_cli_foreman_ansibleUpgrade rubygem-domain_nameUpgrade rubygem-mime-types-dataUpgrade tfm-runtimeUpgrade rubygem-multi_jsonUpgrade rubygem-hammer_cli_foreman_webhooksUpgrade rubygem-hammer_cli_foreman_openscapUpgrade tfm-rubygem-hammer_cli_foreman_adminUpgrade satellite-cloneUpgrade rubygem-unicode-debugsourceUpgrade rubygem-hammer_cli_foreman_virt_who_configureUpgrade tfm-rubygem-powerbarUpgrade tfm-rubygem-little-pluggerUpgrade tfm-rubygem-http-cookieUpgrade tfm-rubygem-hammer_cli_foreman_bootdiskUpgrade rubygem-powerbarUpgrade rubygem-mime-typesUpgrade rubygem-hammer_cli_foreman_ansibleUpgrade rubygem-netrcUpgrade rubygem-unicode-display_widthUpgrade rubygem-localeUpgrade tfm-rubygem-hammer_cli_foreman_remote_executionUpgrade tfm-rubygem-mime-typesUpgrade tfm-rubygem-loggingUpgrade rubygem-unf_extUpgrade rubygem-hammer_cli_katelloUpgrade tfm-rubygem-unfUpgrade tfm-rubygem-hammer_cli_foreman_virt_who_configureUpgrade tfm-rubygem-hammer_cli_foreman_azure_rmUpgrade rubygem-hammer_cli_foreman_azure_rmUpgrade rubygem-hammer_cli_foreman_adminUpgrade tfm-rubygem-hammer_cli_foreman_openscapUpgrade tfm-rubygem-hammer_cliUpgrade tfm-rubygem-unf_extUpgrade tfm-rubygem-oauth | Jul 14, 2022 | Sep 20, 2021 |
| Debian | — | Upgrade sqlparse | Jul 30, 2024 | Sep 20, 2021 |
| Redhat_linux | — | Upgrade rubygem-unf_ext-debuginfoUpgrade tfm-rubygem-multi_jsonUpgrade foreman-cliUpgrade rubygem-hammer_cli_foreman_azure_rmUpgrade tfm-rubygem-hammer_cli_foreman_ansibleUpgrade rubygem-hammer_cli_foreman_bootdiskUpgrade tfm-rubygem-mime-typesUpgrade rubygem-localeUpgrade tfm-rubygem-fast_gettextUpgrade rubygem-oauthUpgrade rubygem-rest-clientUpgrade rubygem-hammer_cli_foreman_discoveryUpgrade rubygem-powerbarUpgrade rubygem-apipie-bindingsUpgrade rubygem-unf_extUpgrade rubygem-foreman_maintainUpgrade rubygem-hammer_cli_foreman_virt_who_configureUpgrade rubygem-domain_nameUpgrade tfm-rubygem-little-pluggerUpgrade rubygem-mime-types-dataUpgrade tfm-rubygem-unfUpgrade rubygem-hammer_cli_foreman_ansibleUpgrade tfm-rubygem-netrcUpgrade tfm-rubygem-unicode-debuginfoUpgrade tfm-rubygem-amazing_printUpgrade tfm-rubygem-powerbarUpgrade tfm-rubygem-hammer_cli_katelloUpgrade rubygem-loggingUpgrade rubygem-hammer_cliUpgrade rubygem-highlineUpgrade rubygem-jwtUpgrade rubygem-http-cookieUpgrade rubygem-unicode-debuginfoUpgrade tfm-rubygem-hammer_cli_foreman_virt_who_configureUpgrade tfm-rubygem-hammer_cli_foreman_tasksUpgrade tfm-rubygem-unicode-display_widthUpgrade rubygem-hashieUpgrade rubygem-unicodeUpgrade tfm-rubygem-clampUpgrade tfm-rubygem-hammer_cli_foremanUpgrade tfm-rubygem-loggingUpgrade rubygem-hammer_cli_foreman_remote_executionUpgrade satellite-cloneUpgrade rubygem-fast_gettextUpgrade rubygem-unfUpgrade rubygem-clampUpgrade tfm-rubygem-mime-types-dataUpgrade tfm-rubygem-hammer_cli_foreman_webhooksUpgrade rubygem-amazing_printUpgrade tfm-runtimeUpgrade rubygem-mime-typesUpgrade tfm-rubygem-hammer_cli_foreman_adminUpgrade tfm-rubygem-hammer_cliUpgrade rubygem-netrcUpgrade tfm-rubygem-hammer_cli_foreman_openscapUpgrade tfm-rubygem-unf_ext-debuginfoUpgrade tfm-rubygem-hammer_cli_foreman_remote_executionUpgrade rubygem-hammer_cli_foreman_tasksUpgrade tfm-rubygem-hashieUpgrade tfm-rubygem-apipie-bindingsUpgrade rubygem-hammer_cli_katelloUpgrade tfm-rubygem-unicodeUpgrade rubygem-hammer_cli_foremanUpgrade rubygem-unicode-debugsourceUpgrade tfm-rubygem-domain_nameUpgrade satellite-maintainUpgrade rubygem-unicode-display_widthUpgrade tfm-rubygem-hammer_cli_foreman_bootdiskUpgrade rubygem-multi_jsonUpgrade rubygem-little-pluggerUpgrade satellite-cliUpgrade rubygem-hammer_cli_foreman_adminUpgrade tfm-rubygem-unf_extUpgrade tfm-rubygem-http-cookieUpgrade tfm-rubygem-hammer_cli_foreman_templatesUpgrade tfm-rubygem-rest-clientUpgrade tfm-rubygem-localeUpgrade rubygem-hammer_cli_foreman_openscapUpgrade tfm-rubygem-hammer_cli_foreman_azure_rmUpgrade tfm-rubygem-jwtUpgrade tfm-rubygem-highlineUpgrade tfm-rubygem-hammer_cli_foreman_discoveryUpgrade rubygem-unf_ext-debugsourceUpgrade rubygem-hammer_cli_foreman_webhooksUpgrade tfm-rubygem-oauthUpgrade rubygem-hammer_cli_foreman_templates | Jul 14, 2022 | Sep 20, 2021 |
| Rocky_linux | — | Upgrade libdb-utils-debuginfoUpgrade libdb-debugsourceUpgrade libdb-sql-devel-debuginfoUpgrade libdb-sql-debuginfoUpgrade libdb-cxx-debuginfoUpgrade libdb-cxxUpgrade libdb-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 |
Prioritise 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