CVE-2024-39907: Github.com/1Panel dev/1Panel SQL Injection Vulnerability
CRITICALCVE-2024-39907 is a CRITICAL (CVSS 9.8) sql injection vulnerability (CWE-89: Improper Neutralization of Special Elements used in an SQL Command ('SQL Injection')) affecting Github.com/1Panel dev/1Panel libraries in the Go ecosystem. The issue involves 1panel has an sql injection issue related to the orderby clause. Remediation is available by upgrading affected packages to version 1.10.12-tls.
CVE-2024-39907 at a Glance
Security Impact
CVSS: 9.8
The security impact metrics below are parsed directly from the CVSS v3.1 vector string (CVSS:3.1/AV:N/AC:L/PR:N/UI:N/S:U/C:H/I:H/A:H).
How to Fix CVE-2024-39907
To remediate this vulnerability, upgrade all affected Github.com/1Panel dev/1Panel dependencies to a patched release. Both direct and transitive dependencies should be checked, as frameworks or security libraries may pull in vulnerable versions transitively.
Upgrade github.com/1Panel-dev/1Panel to 1.10.12-tlsRun the following command in your project directory to verify that all resolved dependencies use the patched release:
inspect dependencies for github.com/1Panel-dev/1PanelHow to Check if You Are Affected
To determine whether your application is affected by CVE-2024-39907, inspect your project dependencies for Github.com/1Panel dev/1Panel:
inspect dependencies for github.com/1Panel-dev/1PanelAnalyze the terminal output to locate any version of Github.com/1Panel dev/1Panel in your dependency tree. If any resolved version matches the vulnerable ranges listed in the table below (for example, versions earlier than 1.10.12-tls), your application is affected.
Note: Verify declared build manifests and deployed runtime container environments.
Technical Details
Vulnerability Mechanism & Technical Analysis
This vulnerability is classified under CWE-89: Improper Neutralization of Special Elements used in an SQL Command ('SQL Injection'), where the product constructs all or part of an sql command using externally-influenced input from an upstream component, but it does not neutralize or incorrectly neutralizes special elements that could modify the intended sql command when it is sent to a downstream component. without sufficient removal or quoting of sql syntax in user-controllable inputs, the generated sql query can cause those inputs to be interpreted as sql instead of ordinary user data. In Github.com/1Panel dev/1Panel, software state validation or input boundaries are circumvented during processing. Review the official source advisory statement below for specific affected components, classes, and reproduction details.
Source Advisory Statement
CVE-2024-39907 Affected Github.com/1Panel dev/1Panel Versions
1 component(s)| Product / Package | Ecosystem | Affected Versions | Fixed Version |
|---|---|---|---|
|
github.com/1Panel-dev/1Panel
|
Go |
< 1.10.12-tls
|
1.10.12-tls
|
References
Frequently Asked Questions
What is CVE-2024-39907?
Which Github.com/1Panel dev/1Panel versions are affected?
What version fixes CVE-2024-39907?
Is github.com/1Panel-dev/1Panel affected?
What is the CVSS score of CVE-2024-39907?
What CWE is associated with CVE-2024-39907?
How can I check Go dependencies for CVE-2024-39907?
Machine-readable OSV JSON
OSV v1.5 Schema
{
"schema_version" : "1.4.0",
"id" : "GHSA-5grx-v727-qmq6",
"modified" : "2024-07-24T13:49:36Z",
"published" : "2024-07-18T14:25:00Z",
"aliases" : [ "CVE-2024-39907" ],
"summary" : "1Panel has an SQL injection issue related to the orderBy clause",
"details" : "### Summary\nThere are many sql injections in the project, and some of them are not well filtered, leading to arbitrary file writes, and ultimately leading to RCEs.\nThe proof is as follows\n\n### Details （one of them ）\n<img width=\"697\" alt=\"image\" src=\"https://github.com/1Panel-dev/1Panel/assets/129351704/895b7b43-9bc0-44b3-9c84-24c2dcc962da\">\n<img width=\"936\" alt=\"image\" src=\"https://github.com/1Panel-dev/1Panel/assets/129351704/1b8eb866-9865-4bef-a359-53335d709157\">\n<img width=\"684\" alt=\"image\" src=\"https://github.com/1Panel-dev/1Panel/assets/129351704/e865d6d0-7ecb-49f7-b4a2-f1b0bc407986\">\n\n\n### PoC\ncurl 'http://api:30455/api/v1/hosts/command/search' {\"page\":1,\"pageSize\":10,\"groupID\":0,\"orderBy\":\"**3**\",\"order\":\"ascending\",\"name\":\"a\"}\n<img width=\"664\" alt=\"image\" src=\"https://github.com/1Panel-dev/1Panel/assets/129351704/250d5a2a-cb32-44dc-9831-86dbc2f2b43f\">\nfor example as picture . just change orderby‘s num we can know How many columns does the data table have.Parameters require strict whitelist filtering\n\n### Impact\nRCE、data leak.\n",
"severity" : [ {
"type" : "CVSS_V3",
"score" : "CVSS:3.1/AV:N/AC:L/PR:N/UI:N/S:U/C:H/I:H/A:H"
}, {
"type" : "CVSS_V4",
"score" : "CVSS:4.0/AV:N/AC:L/AT:N/PR:N/UI:N/VC:H/VI:H/VA:H/SC:N/SI:N/SA:N"
} ],
"affected" : [ {
"package" : {
"ecosystem" : "Go",
"name" : "github.com/1Panel-dev/1Panel"
},
"ranges" : [ {
"type" : "ECOSYSTEM",
"events" : [ {
"introduced" : "0"
}, {
"fixed" : "1.10.12-tls"
} ]
} ]
} ],
"references" : [ {
"type" : "WEB",
"url" : "https://github.com/1Panel-dev/1Panel/security/advisories/GHSA-5grx-v727-qmq6"
}, {
"type" : "ADVISORY",
"url" : "https://nvd.nist.gov/vuln/detail/CVE-2024-39907"
}, {
"type" : "WEB",
"url" : "https://github.com/1Panel-dev/1Panel/commit/ff549a47937c1314e6ee08453a1d2128242440cd"
}, {
"type" : "PACKAGE",
"url" : "https://github.com/1Panel-dev/1Panel"
} ],
"database_specific" : {
"cwe_ids" : [ "CWE-89" ],
"severity" : "CRITICAL",
"github_reviewed" : true,
"github_reviewed_at" : "2024-07-18T14:25:00Z",
"nvd_published_at" : "2024-07-18T16:15:07Z"
}
}