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.
Published: 2026-10-30
Score: 7.2 High
EPSS: n/a
KEV: No
Impact: Database data exfiltration via authenticated SQL injection
Action: Patch
AI Analysis

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.

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

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

History

Fri, 30 Oct 2026 23:45:00 +0000

Type Values Removed Values Added
First Time appeared Openremote
Openremote openremote
Vendors & Products Openremote
Openremote openremote

Fri, 30 Oct 2026 22:15:00 +0000

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


Subscriptions

Openremote Openremote
cve-icon MITRE

Status: PUBLISHED

Assigner: GitHub_M

Published:

Updated: 2026-10-30T22:05:43.581Z

Reserved: 2026-07-15T22:19:06.907Z

Link: CVE-2026-63224

cve-icon Vulnrichment

No data.

cve-icon NVD

Status : Deferred

Published: 2026-10-30T22:16:58.837

Modified: 2026-10-30T22:16:58.987

Link: CVE-2026-63224

cve-icon Redhat

No data.

cve-icon OpenCVE Enrichment

Updated: 2026-10-30T23:30:15Z

Weaknesses
  • CWE-89

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