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