CVE-2026-57821

Apache Fineract: Office list: SQL Injection via Subquery in orderBy

Published Jul 15, 2026 CVSS 3.1 · 8.1 High EPSS < 1% KEV · Not listed
Description
A SQL Injection vulnerability exists in Apache Fineract's Office Search API (GET /api/v1/offices) in versions up to and including 1.14.0. The orderBy request parameter is concatenated into a SQL query without sufficient validation, allowing an authenticated user with permission to view offices to inject arbitrary SQL via a crafted orderBy value. This is a bypass of the ColumnValidator fix introduced for CVE-2024-32838, which does not detect bare subqueries in the ORDER BY position. This can be leveraged to perform time-based blind SQL injection for data exfiltration. Because the injected query blocks the database connection for its full duration, concurrent exploitation can exhaust the application's database connection pool, resulting in denial of service for other users. Users are recommended to upgrade to a version containing the fix.

Analysis

AI-generated

Technical impact

The Office Search API in Apache Fineract (GET /api/v1/offices) concatenates the orderBy request parameter directly into an SQL query without sufficient validation, allowing authenticated users with office view permissions to inject a subquery in the ORDER BY clause. This enables blind time-based SQL injection that can exfiltrate data, and because the injected query keeps the database connection occupied for its entire duration, concurrent exploitation can exhaust the application's database connection pool and result in a denial of service for other users.

Affected Systems

Apache Software Foundation: Apache Fineract (up to and including 1.14.0) to inject arbitrary SQL through the orderBy parameter of the Office Search API. The injected query can be time-based, enabling data exfiltration, and it blocks the database connection for its entire duration, which can exhaust the connection pool and cause denial of service for other users.

Risk and Exploitability

The CVSS score of 8.1 indicates high severity but the EPSS score of less than 1% suggests a low likelihood of exploitation. The vulnerability is not listed in the CISA KEV catalog. Exploitation requires access to the Office Search API as a user with office view permissions; the attacker can then craft a malicious orderBy value, perform a time-based blind injection, and saturate database connections to produce a denial of service.

Remediation

No solution or workaround provided in the CVE record.

OpenCVE Recommended Actions

  • Upgrade to a later Apache Fineract release that contains the fix for CVE-2026-57821.
  • Restrict the Office Search API to only trusted users and enforce strict role.
  • Implement request filtering to allow only known column names in the orderBy parameter, rejecting any values that contain parentheses, subqueries, or other SQL syntax patterns until the patch is applied.
  • Monitor database connection usage and configure connection pool limits to mitigate potential denial of service impact.

Generated by OpenCVE AI on July 31, 2026 at 04:05 UTC.

Tracking

Sign in to view the affected projects.

Advisories

No advisories available
History
Type Values Removed Values Added
First Time appeared Apache
Apache fineract
Vendors & Products Apache
Apache fineract
Type Values Removed Values Added
Metrics cvssV3_1

{'score': 8.1, 'vector': 'CVSS:3.1/AV:N/AC:L/PR:L/UI:N/S:U/C:H/I:N/A:H'}

ssvc

{'options': {'Automatable': 'no', 'Exploitation': 'none', 'Technical Impact': 'partial'}, 'version': '2.0.3'}

Type Values Removed Values Added
Description A SQL Injection vulnerability exists in Apache Fineract's Office Search API (GET /api/v1/offices) in versions up to and including 1.14.0. The orderBy request parameter is concatenated into a SQL query without sufficient validation, allowing an authenticated user with permission to view offices to inject arbitrary SQL via a crafted orderBy value. This is a bypass of the ColumnValidator fix introduced for CVE-2024-32838, which does not detect bare subqueries in the ORDER BY position. This can be leveraged to perform time-based blind SQL injection for data exfiltration. Because the injected query blocks the database connection for its full duration, concurrent exploitation can exhaust the application's database connection pool, resulting in denial of service for other users. Users are recommended to upgrade to a version containing the fix.
Title Apache Fineract: Office list: SQL Injection via Subquery in orderBy
Weaknesses CWE-89
References
Weaknesses
  • CWE-89

    Improper Neutralization of Special Elements used in an SQL Command ('SQL Injection')

Sources

Status
PUBLISHED
Assigner
apache
Published
Updated
Jul 15, 2026, 12:26 PM
Reserved
Jun 25, 2026, 11:47 AM
Status
Analyzed
Published
Jul 15, 2026, 10:16 AM
Modified
Oct 24, 2026, 10:10 PM