CVE-2023-22727 Database Query::offset() and limit() vulnerable to SQL injection in cakephp
CriticalCVSS 9.8
EPSS 0.93%
- Published
- Updated
- Exploit status
- No public exploit known
- CISA SSVC
- No known exploitation · automatable: yes · technical impact: total
- Technology
- PHPUbuntuDebian
Description
CakePHP is a development framework for PHP web apps. In affected versions the Cake\Database\Query::limit() and Cake\Database\Query::offset() methods are vulnerable to SQL injection if passed un-sanitized user request data. This issue has been fixed in 4.2.12, 4.3.11, 4.4.10. Users are advised to upgrade. Users unable to upgrade may mitigate this issue by using CakePHP's Pagination library. Manually validating or casting parameters to these methods will also mitigate the issue.
Upgrade path
7 packages: 3 fixed, 4 with no fix yet.
| Package | Affected | Fixed in | Status |
|---|---|---|---|
| debian/cakephp(Debian 11) | = 2.10.11-2.1; = 2.10.24-1; = 2.10.24-2; All versions | No fix listed | No fix yet |
| ubuntu/cakephp(Ubuntu 20.04) | = 2.10.11-2; All versions | No fix listed | No fix yet |
| ubuntu/cakephp(Ubuntu 22.04) | = 2.10.11-2.1; = 2.10.24-1; All versions | No fix listed | No fix yet |
| ubuntu/cakephp(Ubuntu Pro 16.04) | = 2.7.2-1; = 2.8.0-1; = 2.8.0-1ubuntu0.1~esm1; All versions | No fix listed | No fix yet |
| cakephp/cakephp | = >= 4.2.0, < 4.2.12; = >= 4.3.0, < 4.3.11; = >= 4.4.0, < 4.4.10; >= 4.2.0, < 4.2.12 +2 more | 4.2.12, 4.3.11, 4.4.10 | Fixed |
| cakephp/cakephp(Packagist) | = 4.2.0; = 4.2.1; = 4.2.2; = 4.2.3 +32 more | 4.2.12, 4.3.11, 4.4.10 | Fixed |
| cakephp/database(Packagist) | = 4.2.0; = 4.2.1; = 4.2.2; = 4.2.3 +32 more | 4.2.12, 4.3.11, 4.4.10 | Fixed |
Affected products
| Product | Affected versions | Fixed in |
|---|---|---|
| cakephp/cakephp(Packagist) | >= 4.2.0, < 4.2.12 | 4.2.12 |
| cakephp/cakephp(Packagist) | = 4.2.0 | No fix listed |
| cakephp/cakephp(Packagist) | = 4.2.1 | No fix listed |
| cakephp/cakephp(Packagist) | = 4.2.10 | No fix listed |
| cakephp/cakephp(Packagist) | = 4.2.11 | No fix listed |
| cakephp/cakephp(Packagist) | = 4.2.2 | No fix listed |
| cakephp/cakephp(Packagist) | = 4.2.3 | No fix listed |
| cakephp/cakephp(Packagist) | = 4.2.4 | No fix listed |
| cakephp/cakephp(Packagist) | = 4.2.5 | No fix listed |
| cakephp/cakephp(Packagist) | = 4.2.6 | No fix listed |
| cakephp/cakephp(Packagist) | = 4.2.7 | No fix listed |
| cakephp/cakephp(Packagist) | = 4.2.8 | No fix listed |
| cakephp/cakephp(Packagist) | = 4.2.9 | No fix listed |
| cakephp/cakephp(Packagist) | >= 4.3.0, < 4.3.11 | 4.3.11 |
| cakephp/cakephp(Packagist) | = 4.3.0 | No fix listed |
| cakephp/cakephp(Packagist) | = 4.3.1 | No fix listed |
| cakephp/cakephp(Packagist) | = 4.3.10 | No fix listed |
| cakephp/cakephp(Packagist) | = 4.3.2 | No fix listed |
| cakephp/cakephp(Packagist) | = 4.3.3 | No fix listed |
| cakephp/cakephp(Packagist) | = 4.3.4 | No fix listed |
| cakephp/cakephp(Packagist) | = 4.3.5 | No fix listed |
| cakephp/cakephp(Packagist) | = 4.3.6 | No fix listed |
| cakephp/cakephp(Packagist) | = 4.3.7 | No fix listed |
| cakephp/cakephp(Packagist) | = 4.3.8 | No fix listed |
| cakephp/cakephp(Packagist) | = 4.3.9 | No fix listed |
Show 66 more
| Product | Affected versions | Fixed in |
|---|---|---|
| cakephp/cakephp(Packagist) | >= 4.4.0, < 4.4.10 | 4.4.10 |
| cakephp/cakephp(Packagist) | = 4.4.0 | No fix listed |
| cakephp/cakephp(Packagist) | = 4.4.1 | No fix listed |
| cakephp/cakephp(Packagist) | = 4.4.2 | No fix listed |
| cakephp/cakephp(Packagist) | = 4.4.3 | No fix listed |
| cakephp/cakephp(Packagist) | = 4.4.4 | No fix listed |
| cakephp/cakephp(Packagist) | = 4.4.5 | No fix listed |
| cakephp/cakephp(Packagist) | = 4.4.6 | No fix listed |
| cakephp/cakephp(Packagist) | = 4.4.7 | No fix listed |
| cakephp/cakephp(Packagist) | = 4.4.8 | No fix listed |
| cakephp/cakephp(Packagist) | = 4.4.9 | No fix listed |
| cakephp/database(Packagist) | >= 4.2.0, < 4.2.12 | 4.2.12 |
| cakephp/database(Packagist) | = 4.2.0 | No fix listed |
| cakephp/database(Packagist) | = 4.2.1 | No fix listed |
| cakephp/database(Packagist) | = 4.2.10 | No fix listed |
| cakephp/database(Packagist) | = 4.2.11 | No fix listed |
| cakephp/database(Packagist) | = 4.2.2 | No fix listed |
| cakephp/database(Packagist) | = 4.2.3 | No fix listed |
| cakephp/database(Packagist) | = 4.2.4 | No fix listed |
| cakephp/database(Packagist) | = 4.2.5 | No fix listed |
| cakephp/database(Packagist) | = 4.2.6 | No fix listed |
| cakephp/database(Packagist) | = 4.2.7 | No fix listed |
| cakephp/database(Packagist) | = 4.2.8 | No fix listed |
| cakephp/database(Packagist) | = 4.2.9 | No fix listed |
| cakephp/database(Packagist) | >= 4.3.0, < 4.3.11 | 4.3.11 |
| cakephp/database(Packagist) | = 4.3.0 | No fix listed |
| cakephp/database(Packagist) | = 4.3.1 | No fix listed |
| cakephp/database(Packagist) | = 4.3.10 | No fix listed |
| cakephp/database(Packagist) | = 4.3.2 | No fix listed |
| cakephp/database(Packagist) | = 4.3.3 | No fix listed |
| cakephp/database(Packagist) | = 4.3.4 | No fix listed |
| cakephp/database(Packagist) | = 4.3.5 | No fix listed |
| cakephp/database(Packagist) | = 4.3.6 | No fix listed |
| cakephp/database(Packagist) | = 4.3.7 | No fix listed |
| cakephp/database(Packagist) | = 4.3.8 | No fix listed |
| cakephp/database(Packagist) | = 4.3.9 | No fix listed |
| cakephp/database(Packagist) | >= 4.4.0, < 4.4.10 | 4.4.10 |
| cakephp/database(Packagist) | = 4.4.0 | No fix listed |
| cakephp/database(Packagist) | = 4.4.1 | No fix listed |
| cakephp/database(Packagist) | = 4.4.2 | No fix listed |
| cakephp/database(Packagist) | = 4.4.3 | No fix listed |
| cakephp/database(Packagist) | = 4.4.4 | No fix listed |
| cakephp/database(Packagist) | = 4.4.5 | No fix listed |
| cakephp/database(Packagist) | = 4.4.6 | No fix listed |
| cakephp/database(Packagist) | = 4.4.7 | No fix listed |
| cakephp/database(Packagist) | = 4.4.8 | No fix listed |
| cakephp/database(Packagist) | = 4.4.9 | No fix listed |
| debian/cakephp(Debian:11) | All versions | No fix listed |
| debian/cakephp(Debian:11) | = 2.10.11-2.1 | No fix listed |
| debian/cakephp(Debian:11) | = 2.10.24-1 | No fix listed |
| debian/cakephp(Debian:11) | = 2.10.24-2 | No fix listed |
| cakephp/cakephp | = >= 4.2.0, < 4.2.12 | No fix listed |
| cakephp/cakephp | = >= 4.3.0, < 4.3.11 | No fix listed |
| cakephp/cakephp | = >= 4.4.0, < 4.4.10 | No fix listed |
| ubuntu/cakephp(Ubuntu:22.04) | All versions | No fix listed |
| cakephp/cakephp | >= 4.2.0, < 4.2.12 | 4.2.12 |
| cakephp/cakephp | >= 4.3.0, < 4.3.11 | 4.3.11 |
| cakephp/cakephp | >= 4.4.0, < 4.4.10 | 4.4.10 |
| ubuntu/cakephp(Ubuntu:Pro:16.04) | All versions | No fix listed |
| ubuntu/cakephp(Ubuntu:Pro:16.04) | = 2.7.2-1 | No fix listed |
| ubuntu/cakephp(Ubuntu:Pro:16.04) | = 2.8.0-1 | No fix listed |
| ubuntu/cakephp(Ubuntu:Pro:16.04) | = 2.8.0-1ubuntu0.1~esm1 | No fix listed |
| ubuntu/cakephp(Ubuntu:20.04) | All versions | No fix listed |
| ubuntu/cakephp(Ubuntu:20.04) | = 2.10.11-2 | No fix listed |
| ubuntu/cakephp(Ubuntu:22.04) | = 2.10.11-2.1 | No fix listed |
| ubuntu/cakephp(Ubuntu:22.04) | = 2.10.24-1 | No fix listed |
References
- https://github.com/cakephp/cakephp/security/advisories/GHSA-6g8q-qfpv-57wp issue-tracking third-party-advisory vendor-advisory
- nvd.nist.gov third-party-advisory vendor-advisory
- https://github.com/cakephp/cakephp/commit/3f463e7084b5a15e67205ced3a622577cca7a239 issue-tracking patch third-party-advisory
- https://bakery.cakephp.org/2023/01/06/cakephp_4211_4311_4410_released.html issue-tracking release-notes vendor-advisory
- github.com product
- github.com
- security-tracker.debian.org vendor-advisory
- Ubuntu CVE tracker issue-tracking vendor-advisory
- www.cve.org issue-tracking