CVE-2026-63224

OpenRemote has authenticated SQL injection in crosstab datapoint exports

Published Oct 30, 2026 CVSS 4.0 · 7.2 High EPSS < 1% KEV · Not listed
Description
OpenRemote is an open-source internet-of-things platform. Prior to 1.26.0, the `datapoint export` API constructs `CSV crosstab` SQL by concatenating an `asset name` and `attribute name` into a `COPY` query that uses `crosstab` and streams `TO STDOUT`. The `asset name` enters both a double-quoted column identifier and a category query enclosed by the fixed `$cat$` delimiter. Escaping single quotes in one string context does not escape embedded double quotes in identifiers or protect that dollar-quote boundary. An authenticated user permitted to create or rename an asset and read/export datapoints for one of its attributes can store SQL metacharacters in the name and request a `crosstab` export, causing injected SELECT output to be returned in the normal ZIP/CSV response. This enables database exfiltration without direct database or filesystem access or token forgery. In a multi-tenant deployment it can expose other tenants' data if the manager's database role can read shared tables; integrity and availability effects are not established by the demonstrated read primitive. This issue is fixed in version 1.26.0.

Analysis

AI-generated

Technical impact

Authenticated users who can create or rename assets can inject SQL metacharacters into asset names. The application concatenates these names into a crosstab SQL statement, causing the injected SELECT statements to execute and return data in the standard ZIP/CSV response. This allows targeted database exfiltration without direct database or filesystem access or token forgery.

Affected Systems

OpenRemote platforms running any 1.x release prior to 1.26.0 are affected. The vulnerability impacts all deployments that rely on the datapoint export API, including multi‑tenant installations where the database role of the manager has read access to shared tables. The platform is distributed under the openremote:openremote suite.

Risk and Exploitability

The CVSS score of 7.2 indicates a significant risk, while the EPSS score is not available and the vulnerability is not listed in the CISA KEV catalog. Exploitation requires an authenticated session with permissions to create or rename assets; the attacker can then request a crosstab export to receive arbitrary data exported from the database. The vulnerability is only a read‑only data exfiltration under the currently demonstrated technique, but it could expand if additional privileges are granted.

Remediation

No solution or workaround provided in the CVE record.

OpenCVE Recommended Actions

  • Upgrade to OpenRemote 1.26.0 or later, which contains the fix to correctly parameterize the crosstab query.
  • Restrict asset creation and renaming privileges to trusted users only.
  • Review database permissions to limit manager role read access to shared tables in multi‑tenant deployments.
  • Consider disabling or hardening the datapoint export API if it is not required.

Generated by OpenCVE AI on October 30, 2026 at 23:26 UTC.

Tracking

Sign in to view the affected projects.

Advisories

No advisories available
History
Type Values Removed Values Added
Metrics ssvc

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

Type Values Removed Values Added
First Time appeared Openremote
Openremote openremote
Vendors & Products Openremote
Openremote openremote
Type Values Removed Values Added
Description OpenRemote is an open-source internet-of-things platform. Prior to 1.26.0, the `datapoint export` API constructs `CSV crosstab` SQL by concatenating an `asset name` and `attribute name` into a `COPY` query that uses `crosstab` and streams `TO STDOUT`. The `asset name` enters both a double-quoted column identifier and a category query enclosed by the fixed `$cat$` delimiter. Escaping single quotes in one string context does not escape embedded double quotes in identifiers or protect that dollar-quote boundary. An authenticated user permitted to create or rename an asset and read/export datapoints for one of its attributes can store SQL metacharacters in the name and request a `crosstab` export, causing injected SELECT output to be returned in the normal ZIP/CSV response. This enables database exfiltration without direct database or filesystem access or token forgery. In a multi-tenant deployment it can expose other tenants' data if the manager's database role can read shared tables; integrity and availability effects are not established by the demonstrated read primitive. This issue is fixed in version 1.26.0.
Title OpenRemote has authenticated SQL injection in crosstab datapoint exports
Weaknesses CWE-89
References
Metrics cvssV4_0

{'score': 7.2, 'vector': 'CVSS:4.0/AV:N/AC:L/AT:N/PR:L/UI:N/VC:H/VI:L/VA:L/SC:N/SI:N/SA:N'}

Weaknesses
  • CWE-89

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

Sources

Status
PUBLISHED
Assigner
GitHub_M
Published
Updated
Nov 6, 2026, 6:32 PM
Reserved
Jul 15, 2026, 10:19 PM
Status
Deferred
Published
Oct 30, 2026, 10:16 PM
Modified
Nov 6, 2026, 7:17 PM