{"id":"GHSA-ph98-v78f-jqrm","aliases":["CVE-2021-43822"],"title":"SQL injection in jackalope/jackalope-doctrine-dbal","description":"### Impact\n\nUsers can provoke SQL injections if they can specify a node name or query.\n\n### Patches\n\nUpgrade to version 1.7.4\n\nIf that is not possible, you can escape all places where `$property` is used to filter `sv:name` in the class `Jackalope\\Transport\\DoctrineDBAL\\Query\\QOMWalker`: `XPath::escape($property)`.\n\n### Workarounds\n\nNode names and xpaths can contain `\"` or `;` according to the JCR specification. The jackalope component that translates the query object model into doctrine dbal queries does not properly escape the names and paths, so that a accordingly crafted node name can lead to an SQL injection.\n\nIf queries are never done from user input, or if you validate the user input to not contain `;`, you are not affected. \n\n### References\n\nNo further references.\n\n### For more information\n\nIf you have any questions or comments about this advisory:\n\n* Open an issue in [jackalope/jackalope-doctrine-dbal repo](https://github.com/jackalope/jackalope-doctrine-dbal/issues)\n","severity":"high","score":8.5,"published":"2021-12-14T21:08:13.000Z","modified":"2026-07-08T06:27:47.086Z","withdrawn":false,"knownExploited":false,"affected":[{"ecosystem":"Packagist","name":"jackalope/jackalope-doctrine-dbal","ranges":[{"events":[{"introduced":"0"},{"fixed":"1.7.4"}],"type":"ECOSYSTEM"}],"versions":["1.0.0","1.0.0-RC1","1.0.0-RC2","1.0.0-RC3","1.0.0-RC4","1.0.0-alpha1","1.0.0-beta1","1.0.0-beta2","1.0.0-beta3","1.0.0-beta4","1.1.0","1.1.0-RC1","1.1.1","1.1.2","1.1.3","1.1.4","1.1.5","1.2.0","1.2.0-RC1","1.2.1","1.2.2","1.2.3","1.2.4","1.2.5","1.2.6","1.2.7","1.2.8","1.3.0","1.3.1","1.3.2","1.3.3","1.3.4","1.3.5","1.3.6","1.4.0","1.4.1","1.5.0","1.5.1","1.6.0","1.6.1","1.7.0","1.7.1","1.7.2","1.7.3"],"fixed":["1.7.4"]}],"references":["https://github.com/jackalope/jackalope-doctrine-dbal/security/advisories/GHSA-ph98-v78f-jqrm","https://nvd.nist.gov/vuln/detail/CVE-2021-43822","https://github.com/jackalope/jackalope-doctrine-dbal/commit/9d179a36d320330ddb303ea3a7c98d3a33d231db","https://github.com/jackalope/jackalope-doctrine-dbal"],"sources":[{"name":"OSV","id":"GHSA-ph98-v78f-jqrm","modified":"2026-07-08T06:27:47.086944679Z","url":"https://osv.dev/vulnerability/GHSA-ph98-v78f-jqrm"}],"assessments":[{"source":"OSV","vector":"CVSS:3.1/AV:N/AC:H/PR:L/UI:N/S:C/C:H/I:H/A:H","score":8.5}]}