CVE-2024-4340

一、漏洞信息
漏洞编号：CVE-2024-4340
漏洞归属组件：python-sqlparse
漏洞归属的版本：0.1.18,0.2.4,0.3.1,0.4.1,0.4.2,0.4.3,0.4.4
CVSS V3.0分值：
BaseScore：7.5 High
Vector：CVSS：3.0/AV:N/AC:L/PR:N/UI:N/S:U/C:N/I:N/A:H
漏洞简述：
Passing a heavily nested list to sqlparse.parse() leads to a Denial of Service due to RecursionError.
漏洞公开时间：2024-04-30 23:15:53
漏洞创建时间：2024-05-01 21:47:04
漏洞详情参考链接：
https://nvd.nist.gov/vuln/detail/CVE-2024-4340

更多参考(点击展开)

参考来源	参考链接	来源链接
reefs.jfrog.com	https://github.com/advisories/GHSA-2m57-hf25-phgg
reefs.jfrog.com	https://github.com/andialbrecht/sqlparse/commit/b4a39d9850969b4e1d6940d32094ee0b42a2cf03
reefs.jfrog.com	https://research.jfrog.com/vulnerabilities/sqlparse-stack-exhaustion-dos-jfsa-2024-001031292/
suse_bugzilla	http://web.nvd.nist.gov/view/vuln/detail?vulnId=CVE-2024-4340	https://bugzilla.suse.com/show_bug.cgi?id=1223603
suse_bugzilla	https://www.cve.org/CVERecord?id=CVE-2024-4340	https://bugzilla.suse.com/show_bug.cgi?id=1223603
suse_bugzilla	https://github.com/advisories/GHSA-2m57-hf25-phgg	https://bugzilla.suse.com/show_bug.cgi?id=1223603
suse_bugzilla	https://github.com/andialbrecht/sqlparse/commit/b4a39d9850969b4e1d6940d32094ee0b42a2cf03	https://bugzilla.suse.com/show_bug.cgi?id=1223603
suse_bugzilla	https://research.jfrog.com/vulnerabilities/sqlparse-stack-exhaustion-dos-jfsa-2024-001031292/	https://bugzilla.suse.com/show_bug.cgi?id=1223603
redhat_bugzilla	https://github.com/advisories/GHSA-2m57-hf25-phgg	https://bugzilla.redhat.com/show_bug.cgi?id=2278038
redhat_bugzilla	https://github.com/andialbrecht/sqlparse/commit/b4a39d9850969b4e1d6940d32094ee0b42a2cf03	https://bugzilla.redhat.com/show_bug.cgi?id=2278038
redhat_bugzilla	https://research.jfrog.com/vulnerabilities/sqlparse-stack-exhaustion-dos-jfsa-2024-001031292/	https://bugzilla.redhat.com/show_bug.cgi?id=2278038
ubuntu	https://www.cve.org/CVERecord?id=CVE-2024-4340	https://ubuntu.com/security/CVE-2024-4340
ubuntu	https://research.jfrog.com/vulnerabilities/sqlparse-stack-exhaustion-dos-jfsa-2024-001031292/	https://ubuntu.com/security/CVE-2024-4340
ubuntu	https://github.com/advisories/GHSA-2m57-hf25-phgg	https://ubuntu.com/security/CVE-2024-4340
ubuntu	https://ubuntu.com/security/notices/USN-6771-1	https://ubuntu.com/security/CVE-2024-4340
ubuntu	https://nvd.nist.gov/vuln/detail/CVE-2024-4340	https://ubuntu.com/security/CVE-2024-4340
ubuntu	https://launchpad.net/bugs/cve/CVE-2024-4340	https://ubuntu.com/security/CVE-2024-4340
ubuntu	https://security-tracker.debian.org/tracker/CVE-2024-4340	https://ubuntu.com/security/CVE-2024-4340
ubuntu	https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=1070148	https://ubuntu.com/security/CVE-2024-4340
debian		https://security-tracker.debian.org/tracker/CVE-2024-4340
cve_search		https://research.jfrog.com/vulnerabilities/sqlparse-stack-exhaustion-dos-jfsa-2024-001031292/
cve_search		https://github.com/andialbrecht/sqlparse/commit/b4a39d9850969b4e1d6940d32094ee0b42a2cf03
cve_search		https://github.com/advisories/GHSA-2m57-hf25-phgg
mageia		http://advisories.mageia.org/MGASA-2024-0185.html
osv	https://github.com/advisories/GHSA-2m57-hf25-phgg	https://osv.dev/vulnerability/CVE-2024-4340
osv	https://github.com/andialbrecht/sqlparse/commit/b4a39d9850969b4e1d6940d32094ee0b42a2cf03	https://osv.dev/vulnerability/CVE-2024-4340
osv	https://research.jfrog.com/vulnerabilities/sqlparse-stack-exhaustion-dos-jfsa-2024-001031292/	https://osv.dev/vulnerability/CVE-2024-4340
ubuntu	https://github.com/andialbrecht/sqlparse/commit/b4a39d9850969b4e1d6940d32094ee0b42a2cf03	https://ubuntu.com/security/CVE-2024-4340

漏洞分析指导链接：
https://gitee.com/openeuler/cve-manager/blob/master/cve-vulner-manager/doc/md/manual.md
漏洞数据来源:
openBrain开源漏洞感知系统
漏洞补丁信息：

详情(点击展开)

影响的包	修复补丁	来源
	https://github.com/andialbrecht/sqlparse/commit/b4a39d9850969b4e1d6940d32094ee0b42a2cf03	reefs.jfrog.com
	https://github.com/andialbrecht/sqlparse/commit/b4a39d9850969b4e1d6940d32094ee0b42a2cf03	suse_bugzilla
	https://github.com/andialbrecht/sqlparse/commit/b4a39d9850969b4e1d6940d32094ee0b42a2cf03	redhat_bugzilla
	https://github.com/andialbrecht/sqlparse/commit/b4a39d9850969b4e1d6940d32094ee0b42a2cf03	osv
sqlparse	https://github.com/andialbrecht/sqlparse/commit/b4a39d9850969b4e1d6940d32094ee0b42a2cf03	ubuntu
	https://github.com/andialbrecht/sqlparse/commit/b4a39d9850969b4e1d6940d32094ee0b42a2cf03	debian
	https://github.com/andialbrecht/sqlparse/commit/b4a39d9850969b4e1d6940d32094ee0b42a2cf03	ubuntu

二、漏洞分析结构反馈
影响性分析说明：
Passing a heavily nested list to sqlparse.parse() leads to a Denial of Service due to RecursionError.
openEuler评分：
7.5
Vector：CVSS：3.0/AV:N/AC:L/PR:N/UI:N/S:U/C:N/I:N/A:H
受影响版本排查(受影响/不受影响)：
1.master(0.4.4):受影响
2.openEuler-20.03-LTS-SP1(0.3.1):受影响
3.openEuler-20.03-LTS-SP4(0.3.1):受影响
4.openEuler-22.03-LTS(0.4.1):受影响
5.openEuler-22.03-LTS-Next(0.4.2):受影响
6.openEuler-22.03-LTS-SP1(0.4.2):受影响
7.openEuler-22.03-LTS-SP2(0.4.2):受影响
8.openEuler-22.03-LTS-SP3(0.4.2):受影响
9.openEuler-24.03-LTS:受影响
10.openEuler-24.03-LTS-Next:受影响

修复是否涉及abi变化(是/否)：
1.master(0.4.4):否
2.openEuler-20.03-LTS-SP1(0.3.1):否
3.openEuler-20.03-LTS-SP4(0.3.1):否
4.openEuler-22.03-LTS(0.4.1):否
5.openEuler-22.03-LTS-Next(0.4.2):否
6.openEuler-22.03-LTS-SP1(0.4.2):否
7.openEuler-22.03-LTS-SP2(0.4.2):否
8.openEuler-22.03-LTS-SP3(0.4.2):否
9.openEuler-24.03-LTS:否
10.openEuler-24.03-LTS-Next:否

三、漏洞修复
安全公告链接：https://www.openeuler.org/zh/security/safety-bulletin/detail/?id=openEuler-SA-2024-1646

@shinwell_hu ,@myeuler ,@yangzhao_kl ,@caodongxia ,@cherry530
issue处理注意事项:
1. 当前issue受影响的分支提交pr时, 须在pr描述中填写当前issue编号进行关联, 否则无法关闭当前issue;
2. 模板内容需要填写完整, 无论是受影响或者不受影响都需要填写完整内容,未引入的分支不需要填写, 否则无法关闭当前issue;
3. 以下为模板中需要填写完整的内容, 请复制到评论区回复, 注: 内容的标题名称(影响性分析说明, openEuler评分, 受影响版本排查(受影响/不受影响), 修复是否涉及abi变化(是/否))不能省略,省略后cve-manager将无法正常解析填写内容.

影响性分析说明:

openEuler评分: (评分和向量)

受影响版本排查(受影响/不受影响):
1.master(0.4.4):
2.openEuler-20.03-LTS-SP1(0.3.1):
3.openEuler-20.03-LTS-SP4(0.3.1):
4.openEuler-22.03-LTS(0.4.1):
5.openEuler-22.03-LTS-Next(0.4.2):
6.openEuler-22.03-LTS-SP1(0.4.2):
7.openEuler-22.03-LTS-SP2(0.4.2):
8.openEuler-22.03-LTS-SP3(0.4.2):
9.openEuler-24.03-LTS:
10.openEuler-24.03-LTS-Next:

修复是否涉及abi变化(是/否)：
1.master(0.4.4):
2.openEuler-20.03-LTS-SP1(0.3.1):
3.openEuler-20.03-LTS-SP4(0.3.1):
4.openEuler-22.03-LTS(0.4.1):
5.openEuler-22.03-LTS-Next(0.4.2):
6.openEuler-22.03-LTS-SP1(0.4.2):
7.openEuler-22.03-LTS-SP2(0.4.2):
8.openEuler-22.03-LTS-SP3(0.4.2):
9.openEuler-24.03-LTS:
10.openEuler-24.03-LTS-Next:

issue处理具体操作请参考:
https://gitee.com/openeuler/cve-manager/blob/master/cve-vulner-manager/doc/md/manual.md
pr关联issue具体操作请参考:
https://gitee.com/help/articles/4142

Hi openeuler-ci-bot, welcome to the openEuler Community.
I'm the Bot here serving you. You can find the instructions on how to interact with me at Here.
If you have any questions, please contact the SIG: sig-python-modules, and any of the maintainers: @shinwell_hu , @myeuler , @yangzhao_kl , @caodongxia , @cherry530

参考网址	关联pr	状态	补丁链接
https://nvd.nist.gov/vuln/detail/CVE-2024-4340	None	None	https://github.com/andialbrecht/sqlparse/commit/b4a39d9850969b4e1d6940d32094ee0b42a2cf03
https://www.opencve.io/cve/CVE-2024-4340	None	None	https://github.com/andialbrecht/sqlparse/commit/b4a39d9850969b4e1d6940d32094ee0b42a2cf03
https://bugzilla.redhat.com/show_bug.cgi?id=CVE-2024-4340	None	None	https://github.com/andialbrecht/sqlparse/commit/b4a39d9850969b4e1d6940d32094ee0b42a2cf03
https://security-tracker.debian.org/tracker/CVE-2024-4340	None	None	https://github.com/andialbrecht/sqlparse/commit/b4a39d9850969b4e1d6940d32094ee0b42a2cf03

说明：补丁链接仅供初步排查参考，实际可用性请人工再次确认，补丁下载验证可使用CVE补丁工具。
若补丁不准确，烦请在此issue下评论 '/report-patch 参考网址补丁链接1,补丁链接2' 反馈正确信息，便于我们不断优化工具，不胜感激。
如 /report-patch https://security-tracker.debian.org/tracker/CVE-2021-3997 https://github.com/systemd/systemd/commit/5b1cf7a9be37e20133c0208005274ce4a5b5c6a1

影响性分析说明：
Passing a heavily nested list to sqlparse.parse() leads to a Denial of Service due to RecursionError.

openEuler评分：
7.5
Vector：CVSS：3.0/AV:N/AC:L/PR:N/UI:N/S:U/C:N/I:N/A:H

受影响版本排查(受影响/不受影响)：
1.master:受影响
2.openEuler-20.03-LTS-SP1:受影响
3.openEuler-20.03-LTS-SP4:受影响
4.openEuler-22.03-LTS:受影响
5.openEuler-22.03-LTS-Next:受影响
6.openEuler-22.03-LTS-SP1:受影响
7.openEuler-22.03-LTS-SP2:受影响
8.openEuler-22.03-LTS-SP3:受影响
9.openEuler-24.03-LTS:受影响
10.openEuler-24.03-LTS-Next:受影响

修复是否涉及abi变化(是/否)：
1.master:否
2.openEuler-20.03-LTS-SP1:否
3.openEuler-20.03-LTS-SP4:否
4.openEuler-22.03-LTS:否
5.openEuler-22.03-LTS-Next:否
6.openEuler-22.03-LTS-SP1:否
7.openEuler-22.03-LTS-SP2:否
8.openEuler-22.03-LTS-SP3:否
9.openEuler-24.03-LTS:否
10.openEuler-24.03-LTS-Next:否

@ 经过 cve-manager 解析, 已分析的内容如下表所示:

状态	需分析	内容
已分析	1.影响性分析说明	Passing a heavily nested list to sqlparse.parse() leads to a Denial of Service due to RecursionError.
已分析	2.openEulerScore	7.5
已分析	3.openEulerVector	AV:N/AC:L/PR:N/UI:N/S:U/C:N/I:N/A:H
已分析	4.受影响版本排查	master:受影响,openEuler-20.03-LTS-SP1:受影响,openEuler-20.03-LTS-SP4:受影响,openEuler-22.03-LTS:受影响,openEuler-22.03-LTS-Next:受影响,openEuler-22.03-LTS-SP1:受影响,openEuler-22.03-LTS-SP2:受影响,openEuler-22.03-LTS-SP3:受影响,openEuler-24.03-LTS:受影响,openEuler-24.03-LTS-Next:受影响
已分析	5.修复是否涉及abi变化	master:否,openEuler-20.03-LTS-SP1:否,openEuler-20.03-LTS-SP4:否,openEuler-22.03-LTS:否,openEuler-22.03-LTS-Next:否,openEuler-22.03-LTS-SP1:否,openEuler-22.03-LTS-SP2:否,openEuler-22.03-LTS-SP3:否,openEuler-24.03-LTS:否,openEuler-24.03-LTS-Next:否

请确认分析内容的准确性, 确认无误后, 您可以进行后续步骤, 否则您可以继续分析.

@myeuler ,@Shinwell_Hu ,@yangzhao_kl ,@openeuler-sync-bot
关闭issue前,需要将受影响的分支在合并pr时关联上当前issue编号: #I9L9FT
受影响分支: openEuler-24.03-LTS/openEuler-22.03-LTS-SP1/openEuler-22.03-LTS-SP2/openEuler-22.03-LTS-SP3/openEuler-20.03-LTS-SP1
具体操作参考: https://gitee.com/help/articles/4142

@myeuler ,@Shinwell_Hu ,@yangzhao_kl ,@openeuler-sync-bot
关闭issue前,需要将受影响的分支在合并pr时关联上当前issue编号: #I9L9FT
受影响分支: openEuler-22.03-LTS-SP1/openEuler-22.03-LTS-SP3/openEuler-22.03-LTS-SP2/openEuler-20.03-LTS-SP1
具体操作参考: https://gitee.com/help/articles/4142

@myeuler ,@Shinwell_Hu ,@yangzhao_kl ,@openeuler-sync-bot
关闭issue前,需要将受影响的分支在合并pr时关联上当前issue编号: #I9L9FT
受影响分支: openEuler-20.03-LTS-SP1/openEuler-22.03-LTS-SP2/openEuler-22.03-LTS-SP3
具体操作参考: https://gitee.com/help/articles/4142

@myeuler ,@Shinwell_Hu ,@yangzhao_kl ,@openeuler-sync-bot
关闭issue前,需要将受影响的分支在合并pr时关联上当前issue编号: #I9L9FT
受影响分支: openEuler-22.03-LTS-SP3/openEuler-20.03-LTS-SP1
具体操作参考: https://gitee.com/help/articles/4142

@myeuler ,@Shinwell_Hu ,@yangzhao_kl ,@openeuler-sync-bot
关闭issue前,需要将受影响的分支在合并pr时关联上当前issue编号: #I9L9FT
受影响分支: openEuler-20.03-LTS-SP1
具体操作参考: https://gitee.com/help/articles/4142

src-openEuler/python-sqlparse

内容风险标识

评论 (10)

src-openEuler/python-sqlparse .gitee-modal { width: 500px !important; }

内容风险标识

CVE-2024-4340

评论 (10)

搜索帮助

src-openEuler/python-sqlparse