Authenticated arbitrary SQL execution via bypassable keyword filter
Published Aug 28, 2024 · Updated Aug 28, 2024
SQL injection in RuoYi 4.7.9 and earlier allows remote authenticated users to execute arbitrary SQL through the sql parameter. GenController.createTable parses the submitted string as MySQL, reconstructs each CREATE TABLE statement, and passes it to genTableService.createTable after a bypassable keyword filter. An authenticated administrator can use a crafted CREATE TABLE AS SELECT payload for blind data extraction or arbitrary database changes.
Summary
What happened
SQL injection in RuoYi 4.7.9 and earlier allows remote authenticated users to execute arbitrary SQL through the sql parameter. GenController.createTable parses the submitted string as MySQL, reconstructs each CREATE TABLE statement, and passes it to genTableService.createTable after a bypassable keyword filter. An authenticated administrator can use a crafted CREATE TABLE AS SELECT payload for blind data extraction or arbitrary database changes.
The record
- CVE
- CVE-2024-42900
- Published
- Aug 28, 2024
- Updated
- Aug 28, 2024
- Vendor
- yangzongzhuan
- Product
- RuoYi
- Classifications
- CWE-79
- Attack vector
- network
- Privileges
- authenticated
Timeline
How it unfolded
- Aug 28, 2024CVE publishedPublication date reported by the CVE source.
- Aug 28, 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?
Compare these published version ranges with your installed build and any vendor patches.
- Affected versionversion=0 <=4.7.9
What conditions does exploitation require?
What is affected?
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
- Authenticated createTable blind SQL injection proof of conceptproof of concept · demonstrated
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