中危 sqlparse_project sqlparse 未加控制的资源消耗（资源穷尽）
CVE编号
CVE-2021-32839利用情况
暂无补丁情况
官方补丁披露时间
2021-09-21漏洞描述
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.解决建议
下载相关补丁
参考链接 |
|
|---|---|
| https://github.com/andialbrecht/sqlparse/commit/8238a9e450ed1524e40cb3a8b0b3c... | |
| https://github.com/andialbrecht/sqlparse/security/advisories/GHSA-p5w8-wqhj-9hhf |
受影响软件情况
| # | 类型 | 厂商 | 产品 | 版本 | 影响面 | ||||
| 1 | |||||||||
|---|---|---|---|---|---|---|---|---|---|
| 运行在以下环境 | |||||||||
| 应用 | sqlparse_project | sqlparse | * | From (including) 0.4.0 | Up to (excluding) 0.4.2 | ||||
| 运行在以下环境 | |||||||||
| 系统 | alpine_3.14 | py3-sqlparse | * | Up to (excluding) 0.4.2-r0 | |||||
| 运行在以下环境 | |||||||||
| 系统 | alpine_3.15 | py3-sqlparse | * | Up to (excluding) 0.4.2-r0 | |||||
| 运行在以下环境 | |||||||||
| 系统 | alpine_3.16 | py3-sqlparse | * | Up to (excluding) 0.4.2-r0 | |||||
| 运行在以下环境 | |||||||||
| 系统 | alpine_3.17 | py3-sqlparse | * | Up to (excluding) 0.4.2-r0 | |||||
| 运行在以下环境 | |||||||||
| 系统 | alpine_3.18 | py3-sqlparse | * | Up to (excluding) 0.4.2-r0 | |||||
| 运行在以下环境 | |||||||||
| 系统 | alpine_edge | py3-sqlparse | * | Up to (excluding) 0.4.2-r0 | |||||
| 运行在以下环境 | |||||||||
| 系统 | centos_7 | tfm-rubygem-hammer_cli_foreman_tasks | * | Up to (excluding) 1.1.2-7.el7sat | |||||
| 运行在以下环境 | |||||||||
| 系统 | centos_8 | rubygem-little-plugger | * | Up to (excluding) 1.0.2-5.1.el8sat | |||||
| 运行在以下环境 | |||||||||
| 系统 | debian_10 | sqlparse | * | Up to (excluding) 0.2.4-1 | |||||
| 运行在以下环境 | |||||||||
| 系统 | debian_11 | sqlparse | * | Up to (including) 0.4.1-1 | |||||
| 运行在以下环境 | |||||||||
| 系统 | debian_12 | sqlparse | * | Up to (excluding) 0.4.2-1 | |||||
| 运行在以下环境 | |||||||||
| 系统 | debian_sid | sqlparse | * | Up to (excluding) 0.4.2-1 | |||||
| 运行在以下环境 | |||||||||
| 系统 | opensuse_Leap_15.3 | python3-sqlparse | * | Up to (excluding) 0.4.2-3.3.1 | |||||
| 运行在以下环境 | |||||||||
| 系统 | redhat_7 | tfm-rubygem-hammer_cli_foreman_tasks | * | Up to (excluding) 1.1.2-7.el7sat | |||||
| 运行在以下环境 | |||||||||
| 系统 | redhat_8 | rubygem-little-plugger | * | Up to (excluding) 1.0.2-5.1.el8sat | |||||
| 运行在以下环境 | |||||||||
| 系统 | ubuntu_18.04.5_lts | sqlparse | * | Up to (excluding) 0.2.4-0.1 | |||||
| 运行在以下环境 | |||||||||
| 系统 | ubuntu_21.04 | sqlparse | * | Up to (excluding) 0.4.1-1ubuntu0.1 | |||||
| 运行在以下环境 | |||||||||
| 系统 | ubuntu_21.10 | sqlparse | * | Up to (excluding) 0.4.1-1ubuntu1 | |||||
| 运行在以下环境 | |||||||||
| 系统 | ubuntu_22.04 | sqlparse | * | Up to (excluding) 0.4.1-1ubuntu1 | |||||
- 攻击路径 远程
- 攻击复杂度 容易
- 权限要求 无需权限
- 影响范围 有限影响
- EXP成熟度 未验证
- 补丁情况 官方补丁
- 数据保密性 无影响
- 数据完整性 无影响
- 服务器危害 服务器失陷
- 全网数量 N/A
| CWE-ID | 漏洞类型 |
| CWE-400 | 未加控制的资源消耗（资源穷尽） |
Exp相关链接
版权声明
本站原创文章转载请注明文章出处及链接，谢谢合作！
评论