جزئیات آسیب‌پذیری

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.

• https://github.com/absmach/magistrala/releases/tag/v1.0.0 release-notes
• https://github.com/absmach/magistrala/pull/3581 issue-trackingpatch
• https://github.com/absmach/magistrala/pull/3581/changes/aac9461aa561c3de7aa9a0dc814ac84c602e0cf9 patch
• https://www.vulncheck.com/advisories/magistrala-sql-injection-via-format-parameter-in-reader-api third-party-advisory