Sulu: JCR-SQL2 injection via `categories` query parameter (unauthenticated)

[ Description ]Official description

Sulu is an open-source PHP content management system based on the Symfony framework. Prior to 2.6.25 and 3.0.8, the affected Sulu 2.6 and 3.0 release lines have a Smart Content QueryBuilder in src/Sulu/Component/Content/SmartContent/QueryBuilder.php that concatenates category identifiers from the public categories query parameter into a JCR-SQL2 WHERE clause without numeric validation. On a public page containing a category-filtered Smart Content block, an unauthenticated attacker can alter query conditions to infer or enumerate content-repository nodes, including unpublished content, or submit malformed and expensive query fragments that degrade availability; this path does not modify repository data. This issue is fixed in versions 2.6.25 and 3.0.8.

[ Fixes ]Fixes and patches

• sulu/sulu 2.6.25Fixed version · GitHub Advisories · composer package sulu/sulu: upgrade to 2.6.25 or later (affected < 2.6.25)
• sulu/sulu 3.0.8Fixed version · GitHub Advisories · composer package sulu/sulu: upgrade to 3.0.8 or later (affected >= 3.0.0, < 3.0.8)

[ Packages ]Affected open-source packages

• sulu/sulu composerAffected < 2.6.25 · fixed in 2.6.25 · GHSA-jg26-q8hg-3pq4
• sulu/sulu composerAffected >= 3.0.0, < 3.0.8 · fixed in 3.0.8 · GHSA-jg26-q8hg-3pq4

[ References ]References

• github.com/sulu/sulu/commit/d19c01487af8c3de2fb3aa145856707a6367392c
• github.com/sulu/sulu/releases/tag/2.6.25
• github.com/sulu/sulu/releases/tag/3.0.8
• github.com/sulu/sulu/security/advisories/GHSA-jg26-q8hg-3pq4