GHSA-h7j7-3rx6-xvcg CKAN has Unauthenticated SQL Injection and Authorization Bypass in `datastore_search_sql`

• PyPI ckan: < 2.10.10 → fixed in 2.10.10 • PyPI ckan: >= 2.11.0, < 2.11.5 → fixed in 2.11.5

Impact A vulnerability in `datastore_search_sql` allowed attackers to inject SQL in order to gain access to private resources and PostgreSQL system information. Patches The issue has been patched in CKAN 2.10.10 and CKAN 2.11.5 Workarounds Disable the DataStore SQL search (`ckan.datastore.sqlsearch.enabled = false`). Note that the SQL search is disabled by default. More information As stated in the documentation, this action function has protections that offer some safety but are not designed to prevent all types of abuse. Depending on the sensitivity of private data in a project's DataStore and the likelihood of abuse of a consuming site, a developer may choose to disable this action function or restrict its use with a `IAuthFunctions` plugin. Credits • Reported by Arvin Shivram of Brutecat Security