CVE-2026-63224

Source
https://cve.org/CVERecord?id=CVE-2026-63224
Import Source
https://storage.googleapis.com/cve-osv-conversion/osv-output/CVE-2026-63224.json
JSON Data
https://api.osv.dev/v1/vulns/CVE-2026-63224
Aliases
Published
2026-10-30T22:05:43Z
Modified
2026-11-08T07:11:31Z
Severity
  • 7.2 (High) CVSS_V4 - 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 CVSS Calculator
Summary
OpenRemote has authenticated SQL injection in crosstab datapoint exports
Details

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.

Database specific
{
    "cna_assigner": "GitHub_M",
    "cwe_ids": [
        "CWE-89"
    ],
    "osv_generated_from": "https://github.com/CVEProject/cvelistV5/tree/main/cves/2026/63xxx/CVE-2026-63224.json"
}
References

Affected packages

Git / github.com/openremote/core

Affected ranges

Type
GIT
Repo
https://github.com/openremote/core
Events
Introduced
0 Unknown introduced commit / All previous commits are affected
Fixed
Fixed
Database specific
Show details
{
    "extracted_events": [
        {
            "range": [
                {
                    "introduced": "0"
                },
                {
                    "fixed": "1.26.0"
                }
            ],
            "source": "AFFECTED_FIELD",
            "strategy": "StringRangeExpression"
        },
        {
            "range": [
                {
                    "fixed": "02ac83074b81617add814b2a72d459abdf374147"
                }
            ],
            "source": "REFERENCES_COMMIT"
        },
        {
            "original_tag": "1.26.0",
            "range": [
                {
                    "fixed": "6a1aeda98502618d115aa777b62be57ec16fa59b"
                }
            ],
            "source": "REFERENCES_TAG"
        }
    ]
}

Affected versions

1.*
1.10.0
1.11.0
1.11.1
1.11.2
1.11.3
1.12.0
1.12.1
1.12.2
1.12.3
1.13.0
1.13.1
1.14.0
1.15.0
1.15.1
1.15.2
1.16.0
1.16.1
1.17.0
1.17.1
1.17.2
1.17.3
1.18.0
1.19.0
1.2.0
1.2.1
1.2.2
1.2.3
1.2.4
1.20.0
1.20.1
1.20.2
1.21.0
1.22.0
1.22.1
1.23.0
1.23.1
1.24.0
1.24.1
1.24.2
1.25.0
1.3.0
1.3.1
1.3.2
1.3.3
1.3.4
1.3.5
1.4.0
1.5.0
1.6.0
1.6.1
1.6.2
1.6.3
1.6.4
1.6.5
1.7.0
1.8.0
1.8.1
1.9.0
Other
archive/console_loader

Database specific

source
"https://storage.googleapis.com/cve-osv-conversion/osv-output/CVE-2026-63224.json"
vanir_signatures
[
    {
        "deprecated": false,
        "digest": {
            "line_hashes": [
                "212501404792636599223332457331805613668",
                "313339606263722002939400328055180180588",
                "157210917634600877815562164476672736501",
                "203166221761430739976194548764479757846",
                "306306602659483446891119661376431275307",
                "49351688903985390062485056071603403903",
                "210735325278228370527359625833568322049",
                "304952122038959790624055050114385544639",
                "108024607928483481519178750996724874370",
                "313628705955544973756648417978469044098",
                "115387842214082388183928002752554647769",
                "254063251152503890587135672118611189139",
                "170521412059205717101249466011133830174",
                "93218676147775661913936600707659411075",
                "97863413001532739529133720183432925370",
                "130516563501011382672278713829692685888",
                "146640122189386287004716131847074597070",
                "160999688151373772011048825526268359090",
                "329443258312426821594092181304437851298",
                "259060164761554657103866746848817354182",
                "97210697748667358659898047179520344640",
                "173507131390620303746875495035853859329",
                "105757634820126479633773846189691384887",
                "194806195633172645110072028838379063168",
                "177315868725279934835138127795472389057",
                "313462284584645050061526401549663188164",
                "106054946728934550241448916524898146714",
                "174612313107821077829234721216166346944",
                "118849142690185852896382920094849923667",
                "271875736556317251552911676306178836171",
                "339781807464613009066133924490486089209",
                "291237632404291035719027426333279134457",
                "80917800881704685278906873343982484430",
                "19858305167260609148808805728602981322",
                "120171360265885119729904429201193667778",
                "314253353305816130357368640722102788944",
                "68497816619302028146488561810074880039",
                "274989533421672019060347583809806765721",
                "3264916515731374166676438983833828333",
                "130191346655409596075914213159505020027",
                "227009972323556492128309966709296412882",
                "66614326645329907384381929233595647256",
                "36476790144109711153185313766274767692",
                "34467124005217408601166317192034588166",
                "179389150532849984890026567686429270316",
                "23885980460053085125794841250538212068",
                "181976967496852688035050388013590281154",
                "6683312695770242629580566584943322860",
                "36627285792829038259363632698627245492",
                "155542750984388247755047609518789304517",
                "196685133131627086182054480692821774729",
                "291957179569517575866671409188935138940",
                "12596490201229628450556540194689111043",
                "107007393114579796305597960727649334575",
                "58424399173576309264938219244467528086",
                "237635864060013953187125739690485053474",
                "171199487685265555705895286750434322934",
                "49346799341987701703334397995499041847",
                "182560588199803752241220526128169346209",
                "36627285792829038259363632698627245492",
                "155542750984388247755047609518789304517",
                "265376577521866205503936631376520574045",
                "197788504450738084718918491325132990557",
                "225499622955679116740915106531492840149",
                "111116713182851269201988242130926655904",
                "136980522410413111575444341796761601341",
                "49601596653088048136636573524832242822",
                "250052801845061798677621419320125276925",
                "335337581901555406121933036410322333920",
                "36627285792829038259363632698627245492",
                "155542750984388247755047609518789304517",
                "6803750458691736721598321053683418320",
                "202473041577143841096204983028903978046",
                "224336776251365837935340433555656804871",
                "84557961046360289015714754162933132581",
                "93483898487853255679818070341200076731",
                "114972995913947315074591808158396733759",
                "90813696584429767557810103485332142701",
                "189167829345173138718129645054724125833",
                "198422650904889137422691097036296744239",
                "8020751504207976786859644073380774055",
                "92080823816438845294803581671851225940",
                "211527415429011005371445358142094362813",
                "23338934782814398953951163262878521543",
                "313547085278014574006364564532733154766",
                "24466442137252810892517523471756466776",
                "47059852105437304538649951549840692640",
                "199422109683362095764963986833334697211",
                "65807389507230059846536374392217354538"
            ],
            "threshold": 0.9
        },
        "id": "CVE-2026-63224-2bc47dab",
        "signature_type": "Line",
        "signature_version": "v1",
        "source": "https://github.com/openremote/core/commit/02ac83074b81617add814b2a72d459abdf374147",
        "target": {
            "file": "manager/src/main/java/org/openremote/manager/datapoint/AssetDatapointService.java"
        }
    },
    {
        "deprecated": false,
        "digest": {
            "function_hash": "294341342121804594752264208050656430025",
            "length": 311
        },
        "id": "CVE-2026-63224-7f8486ee",
        "signature_type": "Function",
        "signature_version": "v1",
        "source": "https://github.com/openremote/core/commit/02ac83074b81617add814b2a72d459abdf374147",
        "target": {
            "file": "manager/src/main/java/org/openremote/manager/datapoint/AssetDatapointService.java",
            "function": "getAttributeHeaders"
        }
    },
    {
        "deprecated": false,
        "digest": {
            "function_hash": "24234756360999720261281830038092480581",
            "length": 2529
        },
        "id": "CVE-2026-63224-824bdfbf",
        "signature_type": "Function",
        "signature_version": "v1",
        "source": "https://github.com/openremote/core/commit/02ac83074b81617add814b2a72d459abdf374147",
        "target": {
            "file": "manager/src/main/java/org/openremote/manager/datapoint/AssetDatapointService.java",
            "function": "buildCopyToStdoutQuery"
        }
    },
    {
        "deprecated": false,
        "digest": {
            "function_hash": "270098285885174403942450501813169614826",
            "length": 2178
        },
        "id": "CVE-2026-63224-8c284691",
        "signature_type": "Function",
        "signature_version": "v1",
        "source": "https://github.com/openremote/core/commit/02ac83074b81617add814b2a72d459abdf374147",
        "target": {
            "file": "manager/src/main/java/org/openremote/manager/datapoint/AssetDatapointService.java",
            "function": "doExportDatapoints"
        }
    }
]
vanir_signatures_modified
"2026-11-08T07:11:31Z"