SQL injection via unescaped JSON keys
Published May 21, 2024 · Updated Nov 21, 2024
SQL injection in PyMySQL through 1.1.0 allows attackers to alter database queries when applications pass untrusted JSON objects as parameters. The escape_dict function escapes each dictionary value but copies each key unchanged, allowing a malicious key to become SQL syntax during query formatting. Reachability requires a consuming application to pass attacker-controlled JSON dictionaries; resulting queries can read or modify data permitted to the database connection.
Summary
What happened
SQL injection in PyMySQL through 1.1.0 allows attackers to alter database queries when applications pass untrusted JSON objects as parameters. The escape_dict function escapes each dictionary value but copies each key unchanged, allowing a malicious key to become SQL syntax during query formatting. Reachability requires a consuming application to pass attacker-controlled JSON dictionaries; resulting queries can read or modify data permitted to the database connection.
The record
- CVE
- CVE-2024-36039
- Published
- May 21, 2024
- Updated
- Nov 21, 2024
- Vendor
- Unknown vendor
- Product
- Unknown product
- Classifications
- CWE-89
- Attack vector
- network
- Privileges
- unauthenticated
Timeline
How it unfolded
- May 21, 2024CVE publishedPublication date reported by the CVE source.
- Nov 21, 2024Record updatedLatest update available in the CVE record.
Exploitability
Present is not the same as exploitable
Compare your product and version with the public record. A matching version still requires validation against your environment.
Is a vulnerable build present?
What conditions does exploitation require?
What is affected?
Affected products and versions are unavailable in this record.
Published CVSS scores
CVSS describes severity. EPSS estimates exploitation probability.
Attacks
What attackers are doing with it
Daily unique IPs observed by Shadowserver honeypots for known exploited vulnerabilities (KEVs). Missing observations do not establish an absence of attacks.
Weakness, pattern, technique
Public exploit references
No public exploit references are available in this record.
Labels summarize the accepted research assessment. They do not indicate a test against your environment.
Technologies
Your stack
See the directory against your own environment.
Your stack
Check the software in your environment
Book a demo to see how Hinoki identifies affected software and validates exploitability in your environment.
Book a demo