SQL Injection in Translation Export API
Published 27 Apr 2023 · Updated 16 Feb 2024
Affected package
- Affected
- <10.5.21
- Fixed in
- 10.5.21
composer require pimcore/pimcore:^10.5.21Details
Impact
SQL injection is a web security vulnerability that allows an attacker to interfere with the queries that an application makes to its database. It generally allows an attacker to view data that they are not normally able to retrieve. This might include data belonging to other users, or any other data that the application itself is able to access.
In many cases, an attacker can modify or delete this data, causing persistent changes to the application's content or behavior. In some situations, an attacker can escalate an SQL injection attack to compromise the underlying server or other back-end infrastructure, or perform a denial-of-service attack. It was observed that the reported API endpoint accessible by an authenticated administrator user and is vulnerable to SQL injection via the "filter" GET parameter. The parameter accepts JSON formatted data. The value of JSON key "property" inside "filter" is not sanitized properly and is used in a SQL statement in an unsafe manner, resulting in SQL injection
Patches
Update to version 10.5.21 or apply this patch manually https://github.com/pimcore/pimcore/commit/c6c80905e58c7724c776f980570a56df7016c6d1.patch
Workarounds
Apply patch https://github.com/pimcore/pimcore/commit/c6c80905e58c7724c776f980570a56df7016c6d1.patch manually.
References
#14968
Is GHSA-xmg8-w465-mr56 in any of your client repos?
Checking one package by hand is fine. Checking it across forty client projects is not. NPMscan reads the lockfiles in every GitHub repo you pick, finds each project with an affected pimcore/pimcore, and gives you the command that fixes it.
References
- Linkgithub.com/pimcore/pimcore/security/advisories/GHSA-xmg8-w465-mr56
- Advisorynvd.nist.gov/vuln/detail/CVE-2023-30849
- Linkgithub.com/pimcore/pimcore/pull/14968
- Linkgithub.com/pimcore/pimcore/commit/c6c80905e58c7724c776f980570a56df7016c6d1
- Linkgithub.com/pimcore/pimcore/commit/c6c80905e58c7724c776f980570a56df7016c6d1.patch
- Packagegithub.com/pimcore/pimcore
Advisory data from OSV.dev (opens OSV.dev in a new tab), refreshed daily.