CVE-2026-63224
OpenRemote has authenticated SQL injection in crosstab datapoint exports
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
Fuente: CNA
Ciclo de vida de la vulnerabilidad
| Fecha | Fase | Evento | Detalle |
|---|---|---|---|
| Remediación | Parche 1.26.0 | io.openremote:openremote-manager · -122 d desde divulgación | |
| Divulgación | Publicada | CVE-2026-63224 divulgada · CVSS 7.2 (CNA) | |
| Monitoreo | Detectada | Ingresó al índice | |
| Monitoreo | Fuente: NIST NVD | Registro visto por primera vez en NIST NVD | |
| Monitoreo | Fuente: OSV | Registro visto por primera vez en OSV | |
| Divulgación | Evaluación SSVC | CISA-ADP · explotación PoC pública | |
| Divulgación | Modificada | Última actualización del registro | |
| Monitoreo | Verificada | Última verificación contra las fuentes |
OpenRemote, an open-source internet-of-things platform, is affected by an authenticated SQL injection flaw in its datapoint export feature for CSV crosstab exports. A user who can create or rename assets and export datapoints can inject SQL through asset names, potentially reading database contents returned in the export, including other tenants' data in multi-tenant deployments.
Affects OpenRemote before 1.26.0 when the crosstab datapoint export is used on an asset with an exportable datapoint attribute. Fixed in 1.26.0.
Descripción original del registro (GitHub_M)
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.
Condiciones y alcance
Desglose de métricas
Rangos afectados
Estado del parche por paquete
| Paquete / producto | Estado | Corregida en | Desde divulgación | Última versión |
|---|---|---|---|---|
mavenio.openremote:openremote-manager |
Corregida | 1.26.0 | -122 d | 1.34.1 no afectada |
1.26.0Arsenal público
Sin exploits, módulos ni PoC públicos conocidos a la fecha de verificación.
https://github.com/openremote/core/security/advisories/GHSA-cgfv-jrfp-2r7vhttps://github.com/openremote/core/commit/02ac83074b81617add814b2a72d459abdf374147https://github.com/openremote/core/releases/tag/1.26.0Las referencias externas se muestran para copiar: cve.llama.ec no lo redirige a otros sitios.
