{
  "id": "CVE-2026-63224",
  "url": "https://poc.griffinguard.io/cve/CVE-2026-63224",
  "published_at": "2026-10-30T22:05:43.581Z",
  "title": "OpenRemote has authenticated SQL injection in crosstab datapoint exports",
  "vendor": "openremote",
  "product": "openremote",
  "cvss": {
    "score": 7.2,
    "source": "cna",
    "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"
  },
  "kev": {
    "in_kev": false,
    "added_at": null,
    "days_after_publication": null
  },
  "first_poc": null,
  "poc_repo_count": 0,
  "exploit_count": 0,
  "suspicious_repo_count": 0,
  "edge_device": null,
  "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.",
  "cwe": "CWE-89",
  "cvss_by_source": {
    "cna": 7.2
  },
  "repos": [],
  "remediation": {
    "affected": [
      {
        "vendor": "openremote",
        "product": "openremote",
        "ranges": [
          "\u003c 1.26.0"
        ],
        "fixed_in": [
          "1.26.0"
        ]
      }
    ],
    "upgrade": [
      "Upgrade openremote to 1.26.0 or later."
    ],
    "references": [
      {
        "kind": "Vendor advisory",
        "url": "https://github.com/openremote/core/security/advisories/GHSA-cgfv-jrfp-2r7v"
      },
      {
        "kind": "Patch",
        "url": "https://github.com/openremote/core/commit/02ac83074b81617add814b2a72d459abdf374147"
      },
      {
        "kind": "Release notes",
        "url": "https://github.com/openremote/core/releases/tag/1.26.0"
      }
    ]
  },
  "exploit_refs": [],
  "hunt_profile": [],
  "rules": []
}
