CVE-2023-22727 - Vulnerability Details - OpenCVE

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.

No CVSS v4.0

Attack Vector Network

Attack Complexity Low

Privileges Required None

Scope Unchanged

Confidentiality Impact High

Integrity Impact High

Availability Impact High

User Interaction None

No CVSS v3.0

No CVSS v2

This CVE is not in the KEV list.

Key SSVC decision points have not yet been added.

Vendors	Products
Cakephp	Cakephp

Configuration 1 [-]

OR	cpe:2.3:a:cakephp:cakephp::::::::
	cpe:2.3:a:cakephp:cakephp::::::::
	cpe:2.3:a:cakephp:cakephp::::::::

No data.

References

Link	Providers
https://bakery.cakephp.org/2023/01/06/cakephp_4211_4311_4410_released.html
https://github.com/cakephp/cakephp/commit/3f463e7084b5a15e67205ced3a622577cca7a239
https://github.com/cakephp/cakephp/security/advisories/GHSA-6g8q-qfpv-57wp

History

No history.

MITRE

Status: PUBLISHED

Assigner: GitHub_M

Published: 2023-01-17T20:41:10.143Z

Updated: 2024-08-02T10:13:50.233Z

Reserved: 2023-01-06T14:21:05.890Z

Link: CVE-2023-22727

Vulnrichment

No data.

NVD

Status : Modified

Published: 2023-01-17T21:15:16.550

Modified: 2024-11-21T07:45:18.273

Link: CVE-2023-22727

Redhat

No data.

{"dataType": "CVE_RECORD", "dataVersion": "5.1", "cveMetadata": {"cveId": "CVE-2023-22727", "assignerOrgId": "a0819718-46f1-4df5-94e2-005712e83aaa", "state": "PUBLISHED", "assignerShortName": "GitHub_M", "dateReserved": "2023-01-06T14:21:05.890Z", "datePublished": "2023-01-17T20:41:10.143Z", "dateUpdated": "2024-08-02T10:13:50.233Z"}, "containers": {"cna": {"title": "Database Query::offset() and limit() vulnerable to SQL injection in cakephp", "problemTypes": [{"descriptions": [{"cweId": "CWE-89", "lang": "en", "description": "CWE-89: Improper Neutralization of Special Elements used in an SQL Command ('SQL Injection')", "type": "CWE"}]}], "metrics": [{"cvssV3_1": {"attackComplexity": "LOW", "attackVector": "NETWORK", "availabilityImpact": "HIGH", "baseScore": 9.8, "baseSeverity": "CRITICAL", "confidentialityImpact": "HIGH", "integrityImpact": "HIGH", "privilegesRequired": "NONE", "scope": "UNCHANGED", "userInteraction": "NONE", "vectorString": "CVSS:3.1/AV:N/AC:L/PR:N/UI:N/S:U/C:H/I:H/A:H", "version": "3.1"}}], "references": [{"name": "https://github.com/cakephp/cakephp/security/advisories/GHSA-6g8q-qfpv-57wp", "tags": ["x_refsource_CONFIRM"], "url": "https://github.com/cakephp/cakephp/security/advisories/GHSA-6g8q-qfpv-57wp"}, {"name": "https://github.com/cakephp/cakephp/commit/3f463e7084b5a15e67205ced3a622577cca7a239", "tags": ["x_refsource_MISC"], "url": "https://github.com/cakephp/cakephp/commit/3f463e7084b5a15e67205ced3a622577cca7a239"}, {"name": "https://bakery.cakephp.org/2023/01/06/cakephp_4211_4311_4410_released.html", "tags": ["x_refsource_MISC"], "url": "https://bakery.cakephp.org/2023/01/06/cakephp_4211_4311_4410_released.html"}], "affected": [{"vendor": "cakephp", "product": "cakephp", "versions": [{"version": ">= 4.2.0, < 4.2.12", "status": "affected"}, {"version": ">= 4.3.0, < 4.3.11", "status": "affected"}, {"version": ">= 4.4.0, < 4.4.10", "status": "affected"}]}], "providerMetadata": {"orgId": "a0819718-46f1-4df5-94e2-005712e83aaa", "shortName": "GitHub_M", "dateUpdated": "2023-01-17T20:41:10.143Z"}, "descriptions": [{"lang": "en", "value": "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."}], "source": {"advisory": "GHSA-6g8q-qfpv-57wp", "discovery": "UNKNOWN"}}, "adp": [{"providerMetadata": {"orgId": "af854a3a-2127-422b-91ae-364da2661108", "shortName": "CVE", "dateUpdated": "2024-08-02T10:13:50.233Z"}, "title": "CVE Program Container", "references": [{"name": "https://github.com/cakephp/cakephp/security/advisories/GHSA-6g8q-qfpv-57wp", "tags": ["x_refsource_CONFIRM", "x_transferred"], "url": "https://github.com/cakephp/cakephp/security/advisories/GHSA-6g8q-qfpv-57wp"}, {"name": "https://github.com/cakephp/cakephp/commit/3f463e7084b5a15e67205ced3a622577cca7a239", "tags": ["x_refsource_MISC", "x_transferred"], "url": "https://github.com/cakephp/cakephp/commit/3f463e7084b5a15e67205ced3a622577cca7a239"}, {"name": "https://bakery.cakephp.org/2023/01/06/cakephp_4211_4311_4410_released.html", "tags": ["x_refsource_MISC", "x_transferred"], "url": "https://bakery.cakephp.org/2023/01/06/cakephp_4211_4311_4410_released.html"}]}]}}

{"configurations": [{"nodes": [{"cpeMatch": [{"criteria": "cpe:2.3:a:cakephp:cakephp:*:*:*:*:*:*:*:*", "matchCriteriaId": "54CC7CDF-D3A7-427B-B734-89E0E47778C7", "versionEndExcluding": "4.2.12", "versionStartIncluding": "4.2.0", "vulnerable": true}, {"criteria": "cpe:2.3:a:cakephp:cakephp:*:*:*:*:*:*:*:*", "matchCriteriaId": "09F4E6E5-91F9-4496-88A1-2B9DCC6D9656", "versionEndExcluding": "4.3.11", "versionStartIncluding": "4.3.0", "vulnerable": true}, {"criteria": "cpe:2.3:a:cakephp:cakephp:*:*:*:*:*:*:*:*", "matchCriteriaId": "45326B61-AA4E-4D7C-8B29-ACE4AA9951E5", "versionEndExcluding": "4.4.10", "versionStartIncluding": "4.4.0", "vulnerable": true}], "negate": false, "operator": "OR"}]}], "descriptions": [{"lang": "en", "value": "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."}, {"lang": "es", "value": "CakePHP es un framework de desarrollo para aplicaciones web PHP. En las versiones afectadas, los m\u00e9todos `Cake\\Database\\Query::limit()` y `Cake\\Database\\Query::offset()` son vulnerables a la inyecci\u00f3n SQL si se pasan datos de solicitud de usuario sin desinfectar. Este problema se solucion\u00f3 en 4.2.12, 4.3.11, 4.4.10. Se recomienda a los usuarios que actualicen. Los usuarios que no puedan actualizar pueden mitigar este problema utilizando la librer\u00eda de paginaci\u00f3n de CakePHP. La validaci\u00f3n manual o la conversi\u00f3n de par\u00e1metros a estos m\u00e9todos tambi\u00e9n mitigar\u00e1 el problema."}], "id": "CVE-2023-22727", "lastModified": "2024-11-21T07:45:18.273", "metrics": {"cvssMetricV31": [{"cvssData": {"attackComplexity": "LOW", "attackVector": "NETWORK", "availabilityImpact": "HIGH", "baseScore": 9.8, "baseSeverity": "CRITICAL", "confidentialityImpact": "HIGH", "integrityImpact": "HIGH", "privilegesRequired": "NONE", "scope": "UNCHANGED", "userInteraction": "NONE", "vectorString": "CVSS:3.1/AV:N/AC:L/PR:N/UI:N/S:U/C:H/I:H/A:H", "version": "3.1"}, "exploitabilityScore": 3.9, "impactScore": 5.9, "source": "security-advisories@github.com", "type": "Secondary"}, {"cvssData": {"attackComplexity": "LOW", "attackVector": "NETWORK", "availabilityImpact": "HIGH", "baseScore": 9.8, "baseSeverity": "CRITICAL", "confidentialityImpact": "HIGH", "integrityImpact": "HIGH", "privilegesRequired": "NONE", "scope": "UNCHANGED", "userInteraction": "NONE", "vectorString": "CVSS:3.1/AV:N/AC:L/PR:N/UI:N/S:U/C:H/I:H/A:H", "version": "3.1"}, "exploitabilityScore": 3.9, "impactScore": 5.9, "source": "nvd@nist.gov", "type": "Primary"}]}, "published": "2023-01-17T21:15:16.550", "references": [{"source": "security-advisories@github.com", "tags": ["Release Notes", "Vendor Advisory"], "url": "https://bakery.cakephp.org/2023/01/06/cakephp_4211_4311_4410_released.html"}, {"source": "security-advisories@github.com", "tags": ["Patch", "Third Party Advisory"], "url": "https://github.com/cakephp/cakephp/commit/3f463e7084b5a15e67205ced3a622577cca7a239"}, {"source": "security-advisories@github.com", "tags": ["Third Party Advisory"], "url": "https://github.com/cakephp/cakephp/security/advisories/GHSA-6g8q-qfpv-57wp"}, {"source": "af854a3a-2127-422b-91ae-364da2661108", "tags": ["Release Notes", "Vendor Advisory"], "url": "https://bakery.cakephp.org/2023/01/06/cakephp_4211_4311_4410_released.html"}, {"source": "af854a3a-2127-422b-91ae-364da2661108", "tags": ["Patch", "Third Party Advisory"], "url": "https://github.com/cakephp/cakephp/commit/3f463e7084b5a15e67205ced3a622577cca7a239"}, {"source": "af854a3a-2127-422b-91ae-364da2661108", "tags": ["Third Party Advisory"], "url": "https://github.com/cakephp/cakephp/security/advisories/GHSA-6g8q-qfpv-57wp"}], "sourceIdentifier": "security-advisories@github.com", "vulnStatus": "Modified", "weaknesses": [{"description": [{"lang": "en", "value": "CWE-89"}], "source": "security-advisories@github.com", "type": "Secondary"}]}