{"id":"GHSA-5grx-v727-qmq6","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\u003cimg width=\"697\" alt=\"image\" src=\"https://github.com/1Panel-dev/1Panel/assets/129351704/895b7b43-9bc0-44b3-9c84-24c2dcc962da\"\u003e\n\u003cimg width=\"936\" alt=\"image\" src=\"https://github.com/1Panel-dev/1Panel/assets/129351704/1b8eb866-9865-4bef-a359-53335d709157\"\u003e\n\u003cimg width=\"684\" alt=\"image\" src=\"https://github.com/1Panel-dev/1Panel/assets/129351704/e865d6d0-7ecb-49f7-b4a2-f1b0bc407986\"\u003e\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\u003cimg width=\"664\" alt=\"image\" src=\"https://github.com/1Panel-dev/1Panel/assets/129351704/250d5a2a-cb32-44dc-9831-86dbc2f2b43f\"\u003e\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","aliases":["CVE-2024-39907","GO-2024-2990"],"modified":"2024-07-24T13:49:36Z","published":"2024-07-18T14:25:00Z","database_specific":{"github_reviewed_at":"2024-07-18T14:25:00Z","nvd_published_at":"2024-07-18T16:15:07Z","cwe_ids":["CWE-89"],"severity":"CRITICAL","github_reviewed":true},"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"}],"affected":[{"package":{"name":"github.com/1Panel-dev/1Panel","ecosystem":"Go","purl":"pkg:golang/github.com/1Panel-dev/1Panel"},"ranges":[{"type":"SEMVER","events":[{"introduced":"0"},{"fixed":"1.10.12-tls"}]}],"database_specific":{"source":"https://github.com/github/advisory-database/blob/main/advisories/github-reviewed/2024/07/GHSA-5grx-v727-qmq6/GHSA-5grx-v727-qmq6.json"}}],"schema_version":"1.9.0","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"}]}