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.
Published: 2026-07-15
Score: 8.1 High
EPSS: < 1% Very Low
KEV: No
Impact: n/a
Action: n/a
AI Analysis

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.

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

Remediation

No vendor fix or workaround currently provided.

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 yet.

History

Wed, 15 Jul 2026 23:00:00 +0000

Type Values Removed Values Added
First Time appeared Apache
Apache fineract
Vendors & Products Apache
Apache fineract

Wed, 15 Jul 2026 13:30:00 +0000

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'}


Wed, 15 Jul 2026 10:15:00 +0000

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

cve-icon MITRE

Status: PUBLISHED

Assigner: apache

Published:

Updated: 2026-07-15T12:26:10.244Z

Reserved: 2026-06-25T11:47:18.920Z

Link: CVE-2026-57821

cve-icon Vulnrichment

Updated: 2026-07-15T12:25:50.656Z

cve-icon NVD

No data.

cve-icon Redhat

No data.

cve-icon OpenCVE Enrichment

Updated: 2026-07-31T04:15:04Z

Weaknesses
  • CWE-89

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