CVE-2026-105107
7.6HighPublished 14 Oct 2026 · NVD status: Deferred · AI triage by gemini-3.8-flash
- Attack vector
- Network
- Complexity
- Low
- Privileges needed
- Low
- User interaction
- None
- Impact
- High impact on confidentiality
- Weakness
- CWE-89
Impact
Authenticated staff members with reports permissions can dump the entire database via SQL injection, exposing bcrypt password hashes, 2FA secrets, API keys, and active sessions. Attackers only need valid staff credentials with access to the reports module.
Root cause
The script reports/cat_issues_top.pl concatenates user-controlled Criteria, Filter, and Limit parameters directly into dynamic SQL queries without validation or parameterization.
Affected systems
Koha versions prior to 24.11.19, 25.05.14, 25.11.08, and 26.05.03.
CVSS v3.1 · CVSS:3.1/AV:N/AC:L/PR:L/UI:N/S:U/C:H/I:L/A:L
Fix & remediation
Upgrade Koha to 24.11.19, 25.05.14, 25.11.08, 26.05.03, or 26.11 development branch. As an interim mitigation, restrict access to the reports module or block HTTP requests to /cgi-bin/koha/reports/cat_issues_top.pl at your reverse proxy.
$ sudo apt-get update && sudo apt-get install --only-upgrade koha-commonAI-suggested. Run it in staging first and check it against the vendor advisory. Why?
NVD description
Koha is vulnerable to SQL injection in the Most-circulated items report. The reports/cat_issues_top.pl script (sub calculate) concatenates the user-controlled Criteria, Filter, and Limit request parameters directly into dynamic SQL. Criteria is only prefix-normalized and never validated against an allow-list, so it is inserted verbatim into identifier positions (SELECT DISTINCTROW, GROUP BY, ORDER BY, and the main calculation query). Filter values are concatenated raw into single-quoted LIKE, BETWEEN, and comparison fragments. Limit is appended raw to a LIMIT clause. An authenticated staff user with the reports module permission (not requiring superlibrarian) can inject arbitrary SQL and read any table reachable by the Koha database user, including borrowers (userid and bcrypt password hashes, two-factor secrets, personal data), api_keys, and sessions. The issue is fixed in Koha 24.11.19, 25.05.14, 25.11.08, and 26.05.03, and in the 26.11 development branch. This is the unpatched twin of reports/bor_issues_top.pl (CVE-2026-70372).