Bug 1225070 (CVE-2024-36039)

Summary:	VUL-0: CVE-2024-36039: python-PyMySQL: SQL injection if used with untrusted JSON input
Product:	[Novell Products] SUSE Security Incidents	Reporter:	SMASH SMASH <smash_bz>
Component:	Incidents	Assignee:	Security Team bot <security-team>
Status:	IN_PROGRESS ---	QA Contact:	Security Team bot <security-team>
Severity:	Major
Priority:	P3 - Medium	CC:	abergmann, daniel.garcia, stoyan.manolov
Version:	unspecified
Target Milestone:	---
Hardware:	Other
OS:	Other
URL:	https://smash.suse.de/issue/407236/
Whiteboard:	CVSSv3.1:SUSE:CVE-2024-36039:8.1:(AV:N/AC:H/PR:N/UI:N/S:U/C:H/I:H/A:H)
Found By:	Security Response Team	Services Priority:
Business Priority:		Blocker:	---
Marketing QA Status:	---	IT Deployment:	---

Description SMASH SMASH 2024-05-23 06:10:54 UTC

PyMySQL through 1.1.0 allows SQL injection if used with untrusted JSON input because keys are not escaped by escape_dict.

References:
http://web.nvd.nist.gov/view/vuln/detail?vulnId=CVE-2024-36039
https://www.cve.org/CVERecord?id=CVE-2024-36039
https://github.com/PyMySQL/PyMySQL/releases/tag/v1.1.1
https://bugzilla.redhat.com/show_bug.cgi?id=2282821

Comment 2 OBSbugzilla Bot 2024-05-23 12:15:05 UTC

This is an autogenerated message for OBS integration:
This bug (1225070) was mentioned in
https://build.opensuse.org/request/show/1176449 Factory / python-PyMySQL

Comment 6 Maintenance Automation 2024-06-05 12:30:02 UTC

SUSE-SU-2024:1925-1: An update that solves one vulnerability can now be installed.

Category: security (important)
Bug References: 1225070
CVE References: CVE-2024-36039
Maintenance Incident: [SUSE:Maintenance:34030](https://smelt.suse.de/incident/34030/)
Sources used:
openSUSE Leap 15.6 (src):
 python-PyMySQL-1.1.0-150600.3.3.1

NOTE: This line indicates an update has been released for the listed product(s). At times this might be only a partial fix. If you have questions please reach out to maintenance coordination.