Arbitrary file read via SQL injection
The advisory, in context
Impact
It is possible for a user having access to the SQL Manager (Advanced Options -> Database) to arbitrary read any file on the Operating system when using SQL function LOAD_FILE in a SELECT request. So It can access to critical information.
Patches
The patch will be on PS 8.0.4 and PS 1.7.8.9
Affected packages
Start with the recorded fix for your release branch. Check your installed version and test compatibility before upgrading. Fixing this advisory does not rule out other vulnerabilities in the release.
From 8.0.0 before 8.0.4
Fixed in 8.0.4
4 explicitly affected versions
8.0.0, 8.0.1, 8.0.2, 8.0.3
View affected-version evidence
{
"ranges": [
{
"events": [
{
"introduced": "8.0.0"
},
{
"fixed": "8.0.4"
}
],
"type": "ECOSYSTEM"
}
],
"versions": [
"8.0.0",
"8.0.1",
"8.0.2",
"8.0.3"
]
}Earlier releases before 1.7.8.9
Fixed in 1.7.8.9
76 explicitly affected versions
1.7.0.0, 1.7.0.0-beta.1.0, 1.7.0.0-beta.2.0, 1.7.0.0-beta.3.0, 1.7.0.0-beta.4.0, 1.7.0.0-rc.0.0, 1.7.0.0-rc.1.0, 1.7.0.0-rc.2.0, 1.7.0.1, 1.7.0.2, 1.7.0.3, 1.7.0.4, 1.7.0.5, 1.7.0.6, 1.7.1.0, 1.7.1.1, 1.7.1.2, 1.7.2.0, 1.7.2.0-rc.1.0, 1.7.2.1, 1.7.2.2, 1.7.2.3, 1.7.2.4, 1.7.2.5, 1.7.3.0, 1.7.3.1, 1.7.3.2, 1.7.3.3, 1.7.3.4, 1.7.4.0, 1.7.4.0-beta.1, 1.7.4.1, 1.7.4.2, 1.7.4.3, 1.7.4.4, 1.7.5.0, 1.7.5.0-beta.1, 1.7.5.0-rc.1, 1.7.5.1, 1.7.5.2, 1.7.6.0, 1.7.6.0-beta.1, 1.7.6.0-rc.1, 1.7.6.0-rc.2, 1.7.6.1, 1.7.6.2, 1.7.6.3, 1.7.6.4, 1.7.6.5, 1.7.6.6, 1.7.6.7, 1.7.6.8, 1.7.6.9, 1.7.7.0, 1.7.7.0-beta.1, 1.7.7.0-beta.2, 1.7.7.0-rc.1, 1.7.7.1, 1.7.7.2, 1.7.7.3, 1.7.7.4, 1.7.7.5, 1.7.7.6, 1.7.7.7, 1.7.7.8, 1.7.8.0, 1.7.8.0-beta.1, 1.7.8.0-rc.1, 1.7.8.1, 1.7.8.2, 1.7.8.3, 1.7.8.4, 1.7.8.5, 1.7.8.6, 1.7.8.7, 1.7.8.8
View affected-version evidence
{
"ranges": [
{
"events": [
{
"introduced": "0"
},
{
"fixed": "1.7.8.9"
}
],
"type": "ECOSYSTEM"
}
],
"versions": [
"1.7.0.0",
"1.7.0.0-beta.1.0",
"1.7.0.0-beta.2.0",
"1.7.0.0-beta.3.0",
"1.7.0.0-beta.4.0",
"1.7.0.0-rc.0.0",
"1.7.0.0-rc.1.0",
"1.7.0.0-rc.2.0",
"1.7.0.1",
"1.7.0.2",
"1.7.0.3",
"1.7.0.4",
"1.7.0.5",
"1.7.0.6",
"1.7.1.0",
"1.7.1.1",
"1.7.1.2",
"1.7.2.0",
"1.7.2.0-rc.1.0",
"1.7.2.1",
"1.7.2.2",
"1.7.2.3",
"1.7.2.4",
"1.7.2.5",
"1.7.3.0",
"1.7.3.1",
"1.7.3.2",
"1.7.3.3",
"1.7.3.4",
"1.7.4.0",
"1.7.4.0-beta.1",
"1.7.4.1",
"1.7.4.2",
"1.7.4.3",
"1.7.4.4",
"1.7.5.0",
"1.7.5.0-beta.1",
"1.7.5.0-rc.1",
"1.7.5.1",
"1.7.5.2",
"1.7.6.0",
"1.7.6.0-beta.1",
"1.7.6.0-rc.1",
"1.7.6.0-rc.2",
"1.7.6.1",
"1.7.6.2",
"1.7.6.3",
"1.7.6.4",
"1.7.6.5",
"1.7.6.6",
"1.7.6.7",
"1.7.6.8",
"1.7.6.9",
"1.7.7.0",
"1.7.7.0-beta.1",
"1.7.7.0-beta.2",
"1.7.7.0-rc.1",
"1.7.7.1",
"1.7.7.2",
"1.7.7.3",
"1.7.7.4",
"1.7.7.5",
"1.7.7.6",
"1.7.7.7",
"1.7.7.8",
"1.7.8.0",
"1.7.8.0-beta.1",
"1.7.8.0-rc.1",
"1.7.8.1",
"1.7.8.2",
"1.7.8.3",
"1.7.8.4",
"1.7.8.5",
"1.7.8.6",
"1.7.8.7",
"1.7.8.8"
]
}References
- https://github.com/PrestaShop/PrestaShop/security/advisories/GHSA-8r4m-5p6p-52rp
- https://nvd.nist.gov/vuln/detail/CVE-2023-30545
- https://github.com/PrestaShop/PrestaShop/commit/cddac4198a47c602878a787280d813f60c6c0630
- https://github.com/PrestaShop/PrestaShop/commit/d900806e1841a31f26ff0a1843a6888fc1bb7f81
- https://github.com/PrestaShop/PrestaShop