{"id":"CVE-2026-82028","summary":"Magistrala \u003c 1.0.0 SQL Injection via format Parameter in Reader API","details":"Magistrala before 1.0.0 contains a SQL injection vulnerability in the timescale-reader and postgres-reader HTTP API services that allows authenticated attackers to inject arbitrary SQL by supplying a malicious format query parameter that is interpolated directly into the FROM clause without parameterization or identifier quoting. Attackers with a self-registered account can substitute arbitrary subqueries to achieve cross-tenant database reads, extract pg_shadow password hashes, read and write arbitrary files, and execute arbitrary code as the postgres OS user by loading attacker-supplied shared objects, with all injected SQL executing at superuser privilege due to the default PostgreSQL role configuration.","modified":"2026-09-16T03:47:39.242921497Z","published":"2026-09-14T19:56:59.881Z","database_specific":{"cna_assigner":"VulnCheck","cwe_ids":["CWE-89"],"osv_generated_from":"https://github.com/CVEProject/cvelistV5/tree/main/cves/2026/82xxx/CVE-2026-82028.json"},"references":[{"type":"ADVISORY","url":"https://github.com/CVEProject/cvelistV5/tree/main/cves/2026/82xxx/CVE-2026-82028.json"},{"type":"ADVISORY","url":"https://github.com/absmach/magistrala/releases/tag/v1.0.0"},{"type":"ADVISORY","url":"https://nvd.nist.gov/vuln/detail/CVE-2026-82028"},{"type":"ADVISORY","url":"https://www.vulncheck.com/advisories/magistrala-sql-injection-via-format-parameter-in-reader-api"},{"type":"REPORT","url":"https://github.com/absmach/magistrala/pull/3581"},{"type":"FIX","url":"https://github.com/absmach/magistrala/pull/3581/changes/aac9461aa561c3de7aa9a0dc814ac84c602e0cf9"},{"type":"PACKAGE","url":"https://github.com/absmach/magistrala"}],"affected":[{"ranges":[{"type":"GIT","repo":"https://github.com/absmach/magistrala","events":[{"introduced":"0"},{"fixed":"c446d629455c321a6b4d9e39981a0158659f3da8"}],"database_specific":{"extracted_events":[{"introduced":"0"},{"fixed":"1.0.0"}],"source":["AFFECTED_FIELD","DESCRIPTION","REFERENCES"]}}],"versions":["v0.51.0","v0.50.0","v0.40.0","v0.30.0","v0.20.0","v0.19.1","v0.19.0","v0.18.5","v0.18.4","v0.18.3","v0.18.2","v0.18.1","v0.18.0","v0.17.0","v0.17.0-rc.2","v0.17.0-rc.1","v0.16.0","v0.15.1","v0.15.0","v0.14.0","0.13.0","0.12.1","0.12.0","v0.11.0","0.11.0","0.10.0","0.9.0","0.8.0","0.7.0","0.6.1","0.6.0","0.5.1","0.5.0","0.4.0","0.3.0","0.2.3","0.2.2","0.2.1","0.2.0","0.1.2","0.1.1","0.1.0"],"database_specific":{"source":"https://storage.googleapis.com/cve-osv-conversion/osv-output/CVE-2026-82028.json"}}],"schema_version":"1.9.0","severity":[{"type":"CVSS_V4","score":"CVSS:4.0/AV:N/AC:L/AT:N/PR:L/UI:N/VC:H/VI:H/VA:H/SC:N/SI:N/SA:N"}]}