alerta-server has potential SQL Injection vulnerability in Query String Syntax (q=) API

{
  "id": "d1b3470b657710d4a979d7ba8ec0dd8f73a7068e59fb970f7bdc2d72b6cce26c",
  "url": "https://osv.dev/vulnerability/CVE-2026-34400",
  "method": "structured",
  "payload": {
    "kind": "advisory",
    "title": "alerta-server has potential SQL Injection vulnerability in Query String Syntax (q=) API",
    "summary": "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.",
    "evidence": "osv:CVE-2026-34400",
    "products": [],
    "severity": "medium",
    "structured": {
      "id": "CVE-2026-34400",
      "aliases": [
        "CVE-2026-34400",
        "GHSA-8prr-286p-4w7j",
        "PYSEC-2026-2341"
      ],
      "metrics": [
        {
          "type": "CVSS_V4",
          "score": "CVSS:4.0/AV:N/AC:L/AT:N/PR:N/UI:N/VC:N/VI:L/VA:N/SC:N/SI:N/SA:N"
        }
      ],
      "affected": [
        {
          "ranges": [
            {
              "repo": "https://github.com/alerta/alerta",
              "type": "GIT",
              "events": [
                {
                  "introduced": "0"
                },
                {
                  "fixed": "f4312727783dad64198b62ed778bbca98a5144a3"
                },
                {
                  "fixed": "aeba85a37a09e5769a7a2da56481aa979ff99a00"
                },
                {
                  "fixed": "fdd52cd1abad8d02d1dfb8ecdcdbb43b6af3b883"
                }
              ],
              "database_specific": {
                "extracted_events": [
                  {
                    "cpe": "cpe:2.3:a:alerta_project:alerta:*:*:*:*:*:*:*:*",
                    "range": [
                      {
                        "introduced": "0"
                      },
                      {
                        "fixed": "9.1.0"
                      }
                    ],
                    "source": "CPE_RANGE"
                  },
                  {
                    "range": [
                      {
                        "fixed": "aeba85a37a09e5769a7a2da56481aa979ff99a00"
                      }
                    ],
                    "source": "REFERENCES_COMMIT"
                  },
                  {
                    "range": [
                      {
                        "fixed": "fdd52cd1abad8d02d1dfb8ecdcdbb43b6af3b883"
                      }
                    ],
                    "source": "REFERENCES_COMMIT"
                  },
                  {
                    "range": [
                      {
                        "fixed": "f4312727783dad64198b62ed778bbca98a5144a3"
                      }
                    ],
                    "source": "REFERENCES_TAG",
                    "original_tag": "v9.1.0"
                  }
                ]
              }
            }
          ],
          "versions": [
            "v6.2.1",
            "v6.2.0",
            "v6.1.0",
            "v6.0.1",
            "v6.0.0",
            "v5.2.9",
            "v5.2.8",
            "v5.2.7",
            "v5.2.6",
            "v5.2.5",
            "v5.2.4",
            "v5.2.3",
            "v5.2.2",
            "v5.2.1",
            "v5.2.0",
            "v5.1.1",
            "v5.1.0",
            "v5.0.9",
            "v5.0.8",
            "v5.0.7",
            "v5.0.6",
            "v5.0.5",
            "v5.0.4",
            "v5.0.3",
            "v5.0.2",
            "v5.0.1",
            "v5.0.0",
            "v4.10.2",
            "v5.0.0-rc1",
            "v5.0.0-beta1",
            "v5.0.0-alpha3",
            "v5.0.0-alpha2",
            "v5.0.0-alpha1",
            "v4.5.5"
          ],
          "database_specific": {
            "source": "https://storage.googleapis.com/cve-osv-conversion/osv-output/CVE-2026-34400.json"
          }
        }
      ],
      "modified": "2026-10-28T02:30:33.250328979Z",
      "provider": "osv",
      "references": [
        "https://github.com/alerta/alerta/releases/tag/v9.1.0",
        "https://github.com/CVEProject/cvelistV5/tree/main/cves/2026/34xxx/CVE-2026-34400.json",
        "https://github.com/alerta/alerta/security/advisories/GHSA-8prr-286p-4w7j",
        "https://nvd.nist.gov/vuln/detail/CVE-2026-34400",
        "https://github.com/alerta/alerta/commit/aeba85a37a09e5769a7a2da56481aa979ff99a00",
        "https://github.com/alerta/alerta/commit/fdd52cd1abad8d02d1dfb8ecdcdbb43b6af3b883",
        "https://github.com/alerta/alerta/pull/2040",
        "https://github.com/alerta/alerta/pull/712"
      ],
      "provider_metadata": {
        "cwe_ids": [
          "CWE-89"
        ],
        "cna_assigner": "GitHub_M",
        "osv_generated_from": "https://github.com/CVEProject/cvelistV5/tree/main/cves/2026/34xxx/CVE-2026-34400.json"
      }
    },
    "related_cves": [
      {
        "value": "CVE-2026-34400",
        "evidence": "/id"
      }
    ],
    "security_relevant": true,
    "severity_evidence": "/severity/0/score"
  },
  "source_id": "core-osv",
  "document_id": 500354,
  "published_at": "2026-03-31T21:00:59.824+00:00"
}