Skip to content

CakePHP Database\\Query::offset() and limit() methods are vulnerable to SQL injection

Critical severity GitHub Reviewed Published Jan 17, 2023 in cakephp/cakephp • Updated Jan 25, 2023

Package

composer cakephp/cakephp (Composer)

Affected versions

>= 4.2.0, < 4.2.12
>= 4.3.0, < 4.3.11
>= 4.4.0, < 4.4.10

Patched versions

4.2.12
4.3.11
4.4.10
composer cakephp/database (Composer)
>= 4.2.0, < 4.2.12
>= 4.3.0, < 4.3.11
>= 4.4.0, < 4.4.10
4.2.12
4.3.11
4.4.10

Description

Impact

The Cake\Database\Query::limit() and Cake\Database\Query::offset() methods are vulnerable to SQL injection if passed un-sanitized user request data.

Patches

This issue has been fixed in 4.2.12, 4.3.11, 4.4.10

Workarounds

Using CakePHP's Pagination library will mitigate this issue, as will validating or casting parameters to these methods.

References

https://bakery.cakephp.org/2023/01/06/cakephp_4211_4311_4410_released.html

References

@markstory markstory published to cakephp/cakephp Jan 17, 2023
Published by the National Vulnerability Database Jan 17, 2023
Published to the GitHub Advisory Database Jan 20, 2023
Reviewed Jan 20, 2023
Last updated Jan 25, 2023

Severity

Critical

CVSS overall score

This score calculates overall vulnerability severity from 0 to 10 and is based on the Common Vulnerability Scoring System (CVSS).
/ 10

CVSS v3 base metrics

Attack vector
Network
Attack complexity
Low
Privileges required
None
User interaction
None
Scope
Unchanged
Confidentiality
High
Integrity
High
Availability
High

CVSS v3 base metrics

Attack vector: More severe the more the remote (logically and physically) an attacker can be in order to exploit the vulnerability.
Attack complexity: More severe for the least complex attacks.
Privileges required: More severe if no privileges are required.
User interaction: More severe when no user interaction is required.
Scope: More severe when a scope change occurs, e.g. one vulnerable component impacts resources in components beyond its security scope.
Confidentiality: More severe when loss of data confidentiality is highest, measuring the level of data access available to an unauthorized user.
Integrity: More severe when loss of data integrity is the highest, measuring the consequence of data modification possible by an unauthorized user.
Availability: More severe when the loss of impacted component availability is highest.
CVSS:3.1/AV:N/AC:L/PR:N/UI:N/S:U/C:H/I:H/A:H

EPSS score

0.186%
(57th percentile)

Weaknesses

CVE ID

CVE-2023-22727

GHSA ID

GHSA-6g8q-qfpv-57wp

Source code

Credits

Loading Checking history
See something to contribute? Suggest improvements for this vulnerability.