Description
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.
Affected products
Version statuses are supplied by the assigning organization. Consult the original record for detailed ranges and platform conditions.
absmach magistrala
Default version status: unaffected
0 to < 1.0.0affected
pkg:github/absmach/magistralaReferences
- https://github.com/absmach/magistrala/releases/tag/v1.0.0 ↗
- https://github.com/absmach/magistrala/pull/3581 ↗
- https://github.com/absmach/magistrala/pull/3581/changes/aac9461aa561c3de7aa9a0dc814ac84c602e0cf9 ↗
- https://www.vulncheck.com/advisories/magistrala-sql-injection-via-format-parameter-in-reader-api ↗