{"id":"CVE-2026-63224","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.","aliases":["CVE-2026-62238","GHSA-cgfv-jrfp-2r7v"],"modified":"2026-11-08T07:11:31.302162217Z","published":"2026-10-30T22:05:43.581Z","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":[{"type":"WEB","url":"https://github.com/openremote/core/releases/tag/1.26.0"},{"type":"ADVISORY","url":"https://github.com/CVEProject/cvelistV5/tree/main/cves/2026/63xxx/CVE-2026-63224.json"},{"type":"ADVISORY","url":"https://github.com/openremote/core/security/advisories/GHSA-cgfv-jrfp-2r7v"},{"type":"ADVISORY","url":"https://nvd.nist.gov/vuln/detail/CVE-2026-63224"},{"type":"FIX","url":"https://github.com/openremote/core/commit/02ac83074b81617add814b2a72d459abdf374147"}],"affected":[{"ranges":[{"type":"GIT","repo":"https://github.com/openremote/core","events":[{"introduced":"0"},{"fixed":"6a1aeda98502618d115aa777b62be57ec16fa59b"},{"fixed":"02ac83074b81617add814b2a72d459abdf374147"}],"database_specific":{"extracted_events":[{"range":[{"introduced":"0"},{"fixed":"1.26.0"}],"source":"AFFECTED_FIELD","strategy":"StringRangeExpression"},{"source":"REFERENCES_COMMIT","range":[{"fixed":"02ac83074b81617add814b2a72d459abdf374147"}]},{"range":[{"fixed":"6a1aeda98502618d115aa777b62be57ec16fa59b"}],"source":"REFERENCES_TAG","original_tag":"1.26.0"}]}}],"versions":["1.25.0","1.24.2","1.24.1","1.24.0","1.23.1","1.23.0","1.22.1","1.22.0","1.21.0","1.20.2","1.20.1","1.20.0","1.19.0","1.18.0","1.17.3","1.17.2","1.17.1","1.17.0","1.16.1","1.16.0","1.15.2","1.15.1","1.15.0","1.14.0","1.13.1","1.13.0","1.12.3","1.12.2","1.12.1","1.12.0","1.11.3","1.11.2","1.11.1","1.11.0","1.10.0","1.9.0","1.8.1","1.8.0","archive/console_loader","1.7.0","1.6.5","1.6.4","1.6.3","1.6.2","1.6.1","1.6.0","1.5.0","1.4.0","1.3.5","1.3.4","1.3.3","1.3.2","1.3.1","1.3.0","1.2.4","1.2.3","1.2.2","1.2.1","1.2.0"],"database_specific":{"vanir_signatures":[{"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":{"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"},{"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":{"length":311,"function_hash":"294341342121804594752264208050656430025"}},{"target":{"file":"manager/src/main/java/org/openremote/manager/datapoint/AssetDatapointService.java","function":"buildCopyToStdoutQuery"},"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"},{"source":"https://github.com/openremote/core/commit/02ac83074b81617add814b2a72d459abdf374147","target":{"file":"manager/src/main/java/org/openremote/manager/datapoint/AssetDatapointService.java","function":"doExportDatapoints"},"deprecated":false,"digest":{"function_hash":"270098285885174403942450501813169614826","length":2178},"id":"CVE-2026-63224-8c284691","signature_type":"Function","signature_version":"v1"}],"vanir_signatures_modified":"2026-11-08T07:11:31Z","source":"https://storage.googleapis.com/cve-osv-conversion/osv-output/CVE-2026-63224.json"}}],"schema_version":"1.9.2","severity":[{"type":"CVSS_V4","score":"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"}]}