{"id":"CVE-2026-47720","aliases":["EUVD-2026-61207","GHSA-h9fj-c2qr-76g2"],"status":"published","title":"FUXA: SQL injection in TDengine DAQ connector via backslash bypass of escapeTdString","description":"FUXA is a web-based Process Visualization (SCADA/HMI/Dashboard) software. Prior to 1.3.2, the TDengine DAQ storage connector's escapeTdString function in server/runtime/storage/tdengine/index.js doubles single quotes but does not escape backslashes. A remote unauthenticated attacker can submit a crafted sids tag identifier through GET /api/daq or the Socket.IO DAQ_QUERY event so TDengine interprets the backslash and quote sequence as SQL syntax. The injected query can return every row from fuxa.meters, exposing historical PLC tag values, device identifiers, and device names even when FUXA authentication is enabled. This issue is fixed in version 1.3.2.","severity":{"version":"3.1","score":5.3,"vector":"CVSS:3.1/AV:N/AC:L/PR:N/UI:N/S:U/C:L/I:N/A:N","level":"medium","assessor":"cna","from":"cve"},"epss":{"day":"2026-11-09","score":0.00641,"percentile":0.51016,"model":"v2026.06.15"},"facts":{"in_kev":false,"known_exploited":false,"public_exploit":false,"fix_available":false},"cwes":["CWE-89"],"published":"2026-06-08T23:06:43Z","modified":"2026-11-09T20:10:00Z","affected":[{"source":"ghsa","ecosystem":"npm","package":"fuxa-server","ranges":[{"type":"ECOSYSTEM","events":[{"introduced":"0"},{"last_affected":"1.1.14-1243"}]}]},{"source":"osv","ecosystem":"npm","package":"fuxa-server","ranges":[{"type":"SEMVER","events":[{"introduced":"0"},{"last_affected":"1.1.14-1243"}]}]}],"products":[{"vendor":"frangoteam","product":"fuxa"}],"references":[{"url":"https://github.com/frangoteam/FUXA/security/advisories/GHSA-h9fj-c2qr-76g2","tags":["x_refsource_CONFIRM","advisory","web"]},{"url":"https://github.com/frangoteam/FUXA/pull/2343","tags":["x_refsource_MISC","fix"]},{"url":"https://github.com/frangoteam/FUXA/commit/b78f6159d02a56ce5ff48207feb936afb3534fc8","tags":["x_refsource_MISC","fix"]},{"url":"https://github.com/frangoteam/FUXA/releases/tag/v1.3.2","tags":["x_refsource_MISC","web"]},{"url":"https://github.com/advisories/GHSA-h9fj-c2qr-76g2"},{"url":"https://github.com/CVEProject/cvelistV5/tree/main/cves/2026/47xxx/CVE-2026-47720.json","tags":["advisory"]},{"url":"https://nvd.nist.gov/vuln/detail/CVE-2026-47720","tags":["advisory"]},{"url":"https://github.com/frangoteam/FUXA","tags":["package"]}],"sources":{"cve":[{"id":"CVE-2026-47720","title":"FUXA: SQL injection in TDengine DAQ connector via backslash bypass of escapeTdString","description":"FUXA is a web-based Process Visualization (SCADA/HMI/Dashboard) software. Prior to 1.3.2, the TDengine DAQ storage connector's escapeTdString function in server/runtime/storage/tdengine/index.js doubles single quotes but does not escape backslashes. A remote unauthenticated attacker can submit a crafted sids tag identifier through GET /api/daq or the Socket.IO DAQ_QUERY event so TDengine interprets the backslash and quote sequence as SQL syntax. The injected query can return every row from fuxa.meters, exposing historical PLC tag values, device identifiers, and device names even when FUXA authentication is enabled. This issue is fixed in version 1.3.2.","status":"published","published":"2026-08-18T19:58:26.111Z","modified":"2026-08-19T13:10:57.66Z","cvss":[{"version":"3.1","score":5.3,"vector":"CVSS:3.1/AV:N/AC:L/PR:N/UI:N/S:U/C:L/I:N/A:N","level":"medium","assessor":"cna"}],"cwes":["CWE-89"],"updated_at":"2026-11-02T13:36:40.478484Z"}],"euvd":[{"id":"EUVD-2026-61207","description":"FUXA is a web-based Process Visualization (SCADA/HMI/Dashboard) software. Prior to 1.3.2, the TDengine DAQ storage connector's escapeTdString function in server/runtime/storage/tdengine/index.js doubles single quotes but does not escape backslashes. A remote unauthenticated attacker can submit a crafted sids tag identifier through GET /api/daq or the Socket.IO DAQ_QUERY event so TDengine interprets the backslash and quote sequence as SQL syntax. The injected query can return every row from fuxa.meters, exposing historical PLC tag values, device identifiers, and device names even when FUXA authentication is enabled. This issue is fixed in version 1.3.2.","status":"published","published":"2026-08-18T19:58:26Z","modified":"2026-08-19T13:10:57Z","cvss":[{"version":"3.1","score":5.3,"vector":"CVSS:3.1/AV:N/AC:L/PR:N/UI:N/S:U/C:L/I:N/A:N","level":"medium"}],"updated_at":"2026-11-02T18:01:45.260244Z"}],"ghsa":[{"id":"GHSA-h9fj-c2qr-76g2","title":"FUXA has SQL Injection in its TDengine DAQ connector via backslash bypass of escapeTdString","description":"## Summary\n\nThe TDengine DAQ storage connector's `escapeTdString` at `server/runtime/storage/tdengine/index.js:10` doubles single quotes but does not escape backslashes. TDengine's SQL parser treats `\\'` as a literal single quote inside a string, so a tag id of the form `x\\' OR 1=1--` escapes the first single quote, lets the doubled quote close the string, and appends an injected clause that runs on the TDengine server. An attacker (Alice) sends the crafted `sids` value through `GET /api/daq` or the Socket.IO `DAQ_QUERY` event and reads every row in `fuxa.meters`, which holds the historical tag values of every PLC the FUXA instance records.\n\n## Details\n\nThe TDengine DAQ storage connector did not correctly sanitize user-controlled values before including them in SQL queries.\n\nA specially crafted tag identifier could bypass the intended escaping logic and alter the query executed against the TDengine database.\n\nThis could allow unauthorized access to historical DAQ data stored in TDengine, including recorded tag values and related metadata.\n\nThe issue has been fixed in version 1.3.2 by improving input escaping in the TDengine connector.\n\n## Impact\n\nAn attacker with network access to a FUXA instance configured with TDengine as the DAQ backend reads the entire historical tag-value archive: every PLC tag the instance has recorded, plus the associated device ids and device names. Turning on authentication does not close the gap: the Socket.IO `DAQ_QUERY` handler has no authorization check, and `/api/daq` accepts guest-level requests. No login is needed in the default configuration.\n\n**CVSS 3.1**: `AV:N/AC:L/PR:N/UI:N/S:U/C:L/I:N/A:N` (Medium, 5.3). CWE-89.\n---\nA fix is available at https://github.com/frangoteam/FUXA/releases/tag/v1.3.2.\n\n---\n*Found by [aisafe.io](https://aisafe.io)*","status":"published","published":"2026-06-08T23:06:43Z","modified":"2026-06-08T23:06:45Z","cvss":[{"version":"3.1","score":5.3,"vector":"CVSS:3.1/AV:N/AC:L/PR:N/UI:N/S:U/C:L/I:N/A:N","level":"medium"}],"cwes":["CWE-89"],"updated_at":"2026-11-02T14:40:20.187636Z"}],"nvd":[{"id":"CVE-2026-47720","description":"FUXA is a web-based Process Visualization (SCADA/HMI/Dashboard) software. Prior to 1.3.2, the TDengine DAQ storage connector's escapeTdString function in server/runtime/storage/tdengine/index.js doubles single quotes but does not escape backslashes. A remote unauthenticated attacker can submit a crafted sids tag identifier through GET /api/daq or the Socket.IO DAQ_QUERY event so TDengine interprets the backslash and quote sequence as SQL syntax. The injected query can return every row from fuxa.meters, exposing historical PLC tag values, device identifiers, and device names even when FUXA authentication is enabled. This issue is fixed in version 1.3.2.","status":"published","published":"2026-08-18T20:17:15.25Z","modified":"2026-11-09T20:10:00.2Z","cvss":[{"version":"3.1","score":5.3,"vector":"CVSS:3.1/AV:N/AC:L/PR:N/UI:N/S:U/C:L/I:N/A:N","level":"medium","assessor":"secondary"}],"cwes":["CWE-89"],"updated_at":"2026-11-09T22:15:51.558963Z"}],"osv":[{"id":"CVE-2026-47720","title":"FUXA: SQL injection in TDengine DAQ connector via backslash bypass of escapeTdString","description":"FUXA is a web-based Process Visualization (SCADA/HMI/Dashboard) software. Prior to 1.3.2, the TDengine DAQ storage connector's escapeTdString function in server/runtime/storage/tdengine/index.js doubles single quotes but does not escape backslashes. A remote unauthenticated attacker can submit a crafted sids tag identifier through GET /api/daq or the Socket.IO DAQ_QUERY event so TDengine interprets the backslash and quote sequence as SQL syntax. The injected query can return every row from fuxa.meters, exposing historical PLC tag values, device identifiers, and device names even when FUXA authentication is enabled. This issue is fixed in version 1.3.2.","status":"published","published":"2026-08-18T19:58:26.111Z","modified":"2026-10-28T02:31:13.651290219Z","cvss":[{"version":"3.1","score":5.3,"vector":"CVSS:3.1/AV:N/AC:L/PR:N/UI:N/S:U/C:L/I:N/A:N","level":"medium"}],"cwes":["CWE-89"],"updated_at":"2026-11-02T15:45:06.231145Z"},{"id":"GHSA-h9fj-c2qr-76g2","title":"FUXA has SQL Injection in its TDengine DAQ connector via backslash bypass of escapeTdString","description":"## Summary\n\nThe TDengine DAQ storage connector's `escapeTdString` at `server/runtime/storage/tdengine/index.js:10` doubles single quotes but does not escape backslashes. TDengine's SQL parser treats `\\'` as a literal single quote inside a string, so a tag id of the form `x\\' OR 1=1--` escapes the first single quote, lets the doubled quote close the string, and appends an injected clause that runs on the TDengine server. An attacker (Alice) sends the crafted `sids` value through `GET /api/daq` or the Socket.IO `DAQ_QUERY` event and reads every row in `fuxa.meters`, which holds the historical tag values of every PLC the FUXA instance records.\n\n## Details\n\nThe TDengine DAQ storage connector did not correctly sanitize user-controlled values before including them in SQL queries.\n\nA specially crafted tag identifier could bypass the intended escaping logic and alter the query executed against the TDengine database.\n\nThis could allow unauthorized access to historical DAQ data stored in TDengine, including recorded tag values and related metadata.\n\nThe issue has been fixed in version 1.3.2 by improving input escaping in the TDengine connector.\n\n## Impact\n\nAn attacker with network access to a FUXA instance configured with TDengine as the DAQ backend reads the entire historical tag-value archive: every PLC tag the instance has recorded, plus the associated device ids and device names. Turning on authentication does not close the gap: the Socket.IO `DAQ_QUERY` handler has no authorization check, and `/api/daq` accepts guest-level requests. No login is needed in the default configuration.\n\n**CVSS 3.1**: `AV:N/AC:L/PR:N/UI:N/S:U/C:L/I:N/A:N` (Medium, 5.3). CWE-89.\n---\nA fix is available at https://github.com/frangoteam/FUXA/releases/tag/v1.3.2.\n\n---\n*Found by [aisafe.io](https://aisafe.io)*","status":"published","published":"2026-06-08T23:06:43Z","modified":"2026-06-08T23:26:36.280906Z","cvss":[{"version":"3.1","score":5.3,"vector":"CVSS:3.1/AV:N/AC:L/PR:N/UI:N/S:U/C:L/I:N/A:N","level":"medium"}],"cwes":["CWE-89"],"updated_at":"2026-11-02T15:46:48.920784Z"}]}}