OpenNMS SQL injection in shipped Asset Management JasperReports via the DATE_FORMAT parameter (ROLE_USER)
Default status is the baseline for the product, each version can override it (e.g. patched versions marked unaffected).
| Vendor | Product | Default status | Versions | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| The OpenNMS Group | Meridian | unaffected |
|
|||||||||
| The OpenNMS Group | Horizon | unaffected |
|
No data.
No data.
| Vendor | Product | Versions | ||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| The Opennms Group | Horizon |
|
||||||||||||
| The Opennms Group | Meridian |
|
Vendor Solution
Upgrade to Meridian 2024.3.13, 2025.0.10 and Horizon 36.0.4 or newer.
No CVSS v4.0
No CVSS v3.0
No CVSS v2
This CVE is not in the KEV list.
Exploit prediction score: < 1% (0.365% probability within 30 days)
| Link | Providers |
|---|---|
| https://github.com/OpenNMS/opennms/pull/8832 |
|
| Type | Values Removed | Values Added |
|---|---|---|
| First Time appeared |
The Opennms Group
The Opennms Group horizon The Opennms Group meridian |
|
| Vendors & Products |
The Opennms Group
The Opennms Group horizon The Opennms Group meridian |
| Type | Values Removed | Values Added |
|---|---|---|
| Metrics |
ssvc
|
| Type | Values Removed | Values Added |
|---|---|---|
| Description | A SQL injection vulnerability exists in the JasperReports-based reporting feature of multiple versions of OpenNMS Meridian and Horizon. A low-privileged authenticated user (ROLE_USER) can run the shipped, default-enabled online reports "Maintenance contracts expired" (AssetManagementMaintExpired) and "Maintenance contracts strategy" (AssetManagementMaintStrategy) via the reporting REST API (POST /rest/reports/{id}) and supply a DATE_FORMAT parameter that the report templates substitute literally, un-escaped, into their SQL queries. This lets an attacker execute arbitrary SQL against the OpenNMS database and read arbitrary data, including database-stored secrets such as provisioning and notification credentials and SNMP community strings. The solution is to upgrade to Meridian 2024.3.13, 2025.0.10 and Horizon 36.0.4 or newer. Meridian and Horizon installation instructions state that they are intended for installation within an organization's private networks and should not be directly accessible from the Internet. | |
| Title | OpenNMS SQL injection in shipped Asset Management JasperReports via the DATE_FORMAT parameter (ROLE_USER) | |
| Weaknesses | CWE-89 | |
| References |
| |
| Metrics |
cvssV3_1
|