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