CakePHP through 5.4.3 SQL Injection via StringExpression and IdentifierExpression Collation

Summary

CakePHP through 5.4.3 contains an sql injection vulnerability that allows attackers to inject SQL by supplying unvalidated collation values to StringExpression and IdentifierExpression. Attackers controlling a collation name passed to the constructor or setCollation() can append SQL after the unquoted COLLATE clause, affecting every database driver within the connection's privileges.

Remediation

1. Inventory every cakephp cakephp deployment, including staging.
2. No fixed version appears in the public sources yet. Check the references below and the vendor directly.

References

• Patchhttps://github.com/cakephp/cakephp/commit/21951faea40060dcc5cc1da3159056df66816d3c
• Patchhttps://github.com/cakephp/cakephp/commit/ac07372e6a3045ce2030701a5bc5ed71aa2b4b82
• Patchhttps://github.com/cakephp/cakephp/commit/ae8c354cf825aeb7090ea4b48ce98142446f3ac9
• Patchhttps://github.com/cakephp/cakephp/commit/d04d342c3d1e0bac7ce7661bc098902cc412e595
• Patchhttps://github.com/cakephp/cakephp/pull/19726
• Advisoryhttps://abraxaslabs.tech/research/cakephp-collate-sqli
• Advisoryhttps://www.vulncheck.com/advisories/cakephp-through-5.4.3-sql-injection-via-stringexpression-and-identifierexpression-collation
• Referencehttps://github.com/cakephp/cakephp
• Referencehttps://github.com/cakephp/cakephp/blob/6f3dd91371ac0698b64024ddb21d57def9fbba91/src/Database/Expression/IdentifierExpression.php#L106
• Referencehttps://github.com/cakephp/cakephp/blob/6f3dd91371ac0698b64024ddb21d57def9fbba91/src/Database/Expression/StringExpression.php#L77