Description
Alerta is a monitoring tool. Prior to version 9.1.0, the Query string search API (q=) was vulnerable to SQL injection via the Postgres query parser, which built WHERE clauses by interpolating user-supplied search terms directly into SQL strings via f-strings. This issue has been patched in version 9.1.0.
Affected products
| Vendor | Product | Affected | Fixed |
|---|---|---|---|
| alerta | alerta | < 9.1.0 | — |
Affected packages
| Ecosystem | Package | Affected | Fixed | Record |
|---|---|---|---|---|
| PyPI | alerta-server | < 9.1.0 | 9.1.0 | GHSA-8prr-286p-4w7j |
References
- https://github.com/alerta/alerta/security/advisories/GHSA-8prr-286p-4w7j
- https://github.com/alerta/alerta/pull/2040
- https://github.com/alerta/alerta/pull/712
- https://github.com/alerta/alerta/commit/aeba85a37a09e5769a7a2da56481aa979ff99a00
- https://github.com/alerta/alerta/commit/fdd52cd1abad8d02d1dfb8ecdcdbb43b6af3b883
- https://github.com/alerta/alerta/releases/tag/v9.1.0