CVE-2023-26033: Improper Neutralization of Special Elements used in an SQL Command ('SQL Injection')

Gentoo soko is the code that powers packages.gentoo.org. Versions prior to 1.0.1 is vulnerable to SQL Injection, leading to a Denial of Service. If the user selects (in user preferences) the “Recently Visited Packages” view for the index page, the value of the search_history cookie is used as a base64 encoded comma separated list of atoms. These are string loaded directly into the SQL query with atom = '%s' format string. As a result, any user can modify the browser’s cookie value and inject most SQL queries. A proof of concept malformed cookie was generated that wiped the database or changed it’s content. On the database, only public data is stored, so there is no confidentiality issues to site users. If it is known that the database was modified, a full restoration of data is possible by performing a full database wipe and performing full update of all components. This issue is patched with commit id 5ae9ca83b73. Version 1.0.1 contains the patch. If users are unable to upgrade immediately, the following workarounds may be applied: (1.) Use a proxy to always drop the search_history cookie until upgraded. The impact on user experience is low. (2.) Sanitize to the value of search_history cookie after base64 decoding it.