Vulnerability-Lookup

PYSEC-2026-2341

Vulnerability from pysec - Published: 2026-07-13 14:36 - Updated: 2026-07-13 16:03

Details

Impact

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.

Patches

Fixed in v9.1.0. The Postgres query parser now uses parameterized queries with %(name)s placeholders passed to psycopg2's cursor.execute(), preventing SQL injection through the ?q= parameter. The MongoDB backend was not affected.

Workarounds

Upgrade to v9.1.0 or later. If unable to upgrade, deploy a proxy in front of the Alerta API to sanitize the q= parameter.

Resources

https://github.com/alerta/alerta/pull/712/files https://owasp.org/www-community/attacks/SQL_Injection

Severity

6.9 (Medium)


                  
                    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

Impacted products

Name	purl
alerta-server	pkg:pypi/alerta-server

Aliases

JSON

To clipboard

{
  "affected": [
    {
      "package": {
        "ecosystem": "PyPI",
        "name": "alerta-server",
        "purl": "pkg:pypi/alerta-server"
      },
      "ranges": [
        {
          "events": [
            {
              "introduced": "0"
            },
            {
              "fixed": "9.1.0"
            }
          ],
          "type": "ECOSYSTEM"
        }
      ],
      "versions": [
        "3.1.2",
        "3.2.0",
        "3.2.3",
        "3.2.4",
        "3.2.6",
        "3.2.7",
        "3.2.8",
        "3.2.9",
        "3.3.0",
        "3.3.1",
        "3.3.2",
        "3.3.3",
        "3.3.4",
        "3.3.5",
        "3.3.6",
        "3.3.7",
        "4.0.0",
        "4.0.1",
        "4.0.2",
        "4.0.3",
        "4.0.4",
        "4.0.5",
        "4.0.6",
        "4.0.7",
        "4.0.8",
        "4.0.9",
        "4.1.0",
        "4.1.1",
        "4.1.2",
        "4.1.4",
        "4.1.5",
        "4.1.6",
        "4.1.7",
        "4.1.8",
        "4.10.0",
        "4.10.1",
        "4.10.2",
        "4.10.3",
        "4.10.4",
        "4.10.5",
        "4.2.1",
        "4.2.2",
        "4.2.3",
        "4.2.4",
        "4.2.5",
        "4.2.6",
        "4.3.0",
        "4.3.1",
        "4.3.2",
        "4.4.0",
        "4.4.1",
        "4.4.10",
        "4.4.11",
        "4.4.12",
        "4.4.13",
        "4.4.2",
        "4.4.5",
        "4.4.6",
        "4.4.7",
        "4.4.8",
        "4.4.9",
        "4.5.0",
        "4.5.1",
        "4.5.2",
        "4.5.3",
        "4.5.4",
        "4.5.5",
        "4.6.0",
        "4.6.1",
        "4.6.2",
        "4.6.3",
        "4.6.4",
        "4.6.5",
        "4.6.6",
        "4.6.7",
        "4.6.8",
        "4.6.9",
        "4.7.0",
        "4.7.1",
        "4.7.10",
        "4.7.11",
        "4.7.12",
        "4.7.13",
        "4.7.14",
        "4.7.15",
        "4.7.16",
        "4.7.17",
        "4.7.18",
        "4.7.19",
        "4.7.2",
        "4.7.20",
        "4.7.21",
        "4.7.22",
        "4.7.23",
        "4.7.24",
        "4.7.25",
        "4.7.26",
        "4.7.27",
        "4.7.28",
        "4.7.29",
        "4.7.3",
        "4.7.30",
        "4.7.31",
        "4.7.32",
        "4.7.33",
        "4.7.4",
        "4.7.5",
        "4.7.6",
        "4.7.7",
        "4.7.8",
        "4.7.9",
        "4.8.0",
        "4.8.1",
        "4.8.10",
        "4.8.11",
        "4.8.12",
        "4.8.13",
        "4.8.14",
        "4.8.15",
        "4.8.16",
        "4.8.17",
        "4.8.18",
        "4.8.19",
        "4.8.2",
        "4.8.20",
        "4.8.21",
        "4.8.22",
        "4.8.23",
        "4.8.24",
        "4.8.25",
        "4.8.26",
        "4.8.3",
        "4.8.4",
        "4.8.5",
        "4.8.6",
        "4.8.7",
        "4.8.8",
        "4.8.9",
        "4.9.0",
        "4.9.1",
        "4.9.2",
        "4.9.3",
        "4.9.4",
        "4.9.5",
        "4.9.6",
        "5.0.0",
        "5.0.0rc1",
        "5.0.0rc2",
        "5.0.0rc3",
        "5.0.1",
        "5.0.2",
        "5.0.3",
        "5.0.4",
        "5.0.5",
        "5.0.6",
        "5.0.7",
        "5.0.8",
        "5.0.9",
        "5.1.0",
        "5.1.1",
        "5.2.0",
        "5.2.1",
        "5.2.2",
        "5.2.3",
        "5.2.4",
        "5.2.5",
        "5.2.6",
        "5.2.7",
        "5.2.8",
        "5.2.9",
        "6.0.0",
        "6.0.1",
        "6.1.0",
        "6.2.0",
        "6.2.1",
        "6.3.0",
        "6.3.1",
        "6.3.2",
        "6.4.0",
        "6.5.0",
        "6.6.0",
        "6.6.1",
        "6.7.0",
        "6.7.1",
        "6.7.2",
        "6.7.3",
        "6.7.4",
        "6.7.5",
        "6.8.0",
        "6.8.1",
        "6.8.2",
        "6.8.3",
        "6.8.4",
        "6.8.5",
        "7.0.0",
        "7.0.1",
        "7.1.0",
        "7.1.1",
        "7.1.2",
        "7.2.0",
        "7.2.1",
        "7.2.10",
        "7.2.11",
        "7.2.2",
        "7.2.3",
        "7.2.4",
        "7.2.5",
        "7.2.6",
        "7.2.7",
        "7.2.8",
        "7.2.9",
        "7.3.0",
        "7.3.1",
        "7.3.2",
        "7.4.0",
        "7.4.1",
        "7.4.4",
        "7.4.5",
        "7.4.6",
        "7.5.0",
        "7.5.1",
        "7.5.2",
        "7.5.3",
        "7.5.4",
        "7.5.5",
        "7.5.6",
        "7.5.7",
        "8.0.0",
        "8.0.1",
        "8.0.2",
        "8.0.3",
        "8.1.0",
        "8.2.0",
        "8.3.0",
        "8.3.1",
        "8.3.2",
        "8.3.3",
        "8.4.0",
        "8.4.1",
        "8.5.0",
        "8.6.0",
        "8.6.2",
        "8.6.3",
        "8.6.4",
        "8.6.5",
        "8.7.0",
        "9.0.0",
        "9.0.1",
        "9.0.2",
        "9.0.3",
        "9.0.4"
      ]
    }
  ],
  "aliases": [
    "CVE-2026-34400",
    "GHSA-8prr-286p-4w7j"
  ],
  "details": "### Impact\nThe 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.\n\n### Patches\nFixed in v9.1.0. The Postgres query parser now uses parameterized queries with %(name)s placeholders passed to psycopg2\u0027s cursor.execute(), preventing SQL injection through the ?q= parameter. The MongoDB backend was not affected.\n\n### Workarounds\nUpgrade to v9.1.0 or later. If unable to upgrade, deploy a proxy in front of the Alerta API to sanitize the q= parameter.\n\n### Resources\nhttps://github.com/alerta/alerta/pull/712/files\nhttps://owasp.org/www-community/attacks/SQL_Injection",
  "id": "PYSEC-2026-2341",
  "modified": "2026-07-13T16:03:21.084570Z",
  "published": "2026-07-13T14:36:46.380944Z",
  "references": [
    {
      "type": "WEB",
      "url": "https://github.com/alerta/alerta/security/advisories/GHSA-8prr-286p-4w7j"
    },
    {
      "type": "ADVISORY",
      "url": "https://nvd.nist.gov/vuln/detail/CVE-2026-34400"
    },
    {
      "type": "WEB",
      "url": "https://github.com/alerta/alerta/pull/2040"
    },
    {
      "type": "WEB",
      "url": "https://github.com/alerta/alerta/pull/712"
    },
    {
      "type": "WEB",
      "url": "https://github.com/alerta/alerta/commit/aeba85a37a09e5769a7a2da56481aa979ff99a00"
    },
    {
      "type": "WEB",
      "url": "https://github.com/alerta/alerta/commit/fdd52cd1abad8d02d1dfb8ecdcdbb43b6af3b883"
    },
    {
      "type": "PACKAGE",
      "url": "https://github.com/alerta/alerta"
    },
    {
      "type": "WEB",
      "url": "https://github.com/alerta/alerta/releases/tag/v9.1.0"
    },
    {
      "type": "PACKAGE",
      "url": "https://pypi.org/project/alerta-server"
    },
    {
      "type": "ADVISORY",
      "url": "https://github.com/advisories/GHSA-8prr-286p-4w7j"
    }
  ],
  "severity": [
    {
      "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",
      "type": "CVSS_V4"
    }
  ],
  "summary": "alerta-server has potential SQL Injection vulnerability in Query String Syntax (q=) API"
}

CVE-2026-34400 (GCVE-0-2026-34400)

Vulnerability from cvelistv5 – Published: 2026-03-31 21:00 – Updated: 2026-04-03 16:36

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.

Severity

6.9 (Medium)


                        
                          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

9.8 (Critical)


                        
                          CVSS:3.1/AV:N/AC:L/PR:N/UI:N/S:U/C:H/I:H/A:H

SSVC

Exploitation: none Automatable: yes Technical Impact: total

CISA Coordinator (v2.0.3)

CWE

CWE-89 - Improper Neutralization of Special Elements used in an SQL Command ('SQL Injection')

Assigner

GitHub_M

References

6 references

URL	Tags
https://github.com/alerta/alerta/security/advisor…	x_refsource_CONFIRM
https://github.com/alerta/alerta/pull/2040	x_refsource_MISC
https://github.com/alerta/alerta/pull/712	x_refsource_MISC
https://github.com/alerta/alerta/commit/aeba85a37…	x_refsource_MISC
https://github.com/alerta/alerta/commit/fdd52cd1a…	x_refsource_MISC
https://github.com/alerta/alerta/releases/tag/v9.1.0	x_refsource_MISC

Impacted products

1 product

Vendor	Product	Version
alerta	alerta	Affected: < 9.1.0

Show details on NVD website

JSON

To clipboard

{
  "containers": {
    "adp": [
      {
        "metrics": [
          {
            "cvssV3_1": {
              "attackComplexity": "LOW",
              "attackVector": "NETWORK",
              "availabilityImpact": "HIGH",
              "baseScore": 9.8,
              "baseSeverity": "CRITICAL",
              "confidentialityImpact": "HIGH",
              "integrityImpact": "HIGH",
              "privilegesRequired": "NONE",
              "scope": "UNCHANGED",
              "userInteraction": "NONE",
              "vectorString": "CVSS:3.1/AV:N/AC:L/PR:N/UI:N/S:U/C:H/I:H/A:H",
              "version": "3.1"
            }
          },
          {
            "other": {
              "content": {
                "id": "CVE-2026-34400",
                "options": [
                  {
                    "Exploitation": "none"
                  },
                  {
                    "Automatable": "yes"
                  },
                  {
                    "Technical Impact": "total"
                  }
                ],
                "role": "CISA Coordinator",
                "timestamp": "2026-04-03T16:36:18.411062Z",
                "version": "2.0.3"
              },
              "type": "ssvc"
            }
          }
        ],
        "providerMetadata": {
          "dateUpdated": "2026-04-03T16:36:42.053Z",
          "orgId": "134c704f-9b21-4f2e-91b3-4a467353bcc0",
          "shortName": "CISA-ADP"
        },
        "title": "CISA ADP Vulnrichment"
      }
    ],
    "cna": {
      "affected": [
        {
          "product": "alerta",
          "vendor": "alerta",
          "versions": [
            {
              "status": "affected",
              "version": "\u003c 9.1.0"
            }
          ]
        }
      ],
      "descriptions": [
        {
          "lang": "en",
          "value": "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."
        }
      ],
      "metrics": [
        {
          "cvssV4_0": {
            "attackComplexity": "LOW",
            "attackRequirements": "NONE",
            "attackVector": "NETWORK",
            "baseScore": 6.9,
            "baseSeverity": "MEDIUM",
            "privilegesRequired": "NONE",
            "subAvailabilityImpact": "NONE",
            "subConfidentialityImpact": "NONE",
            "subIntegrityImpact": "NONE",
            "userInteraction": "NONE",
            "vectorString": "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",
            "version": "4.0",
            "vulnAvailabilityImpact": "NONE",
            "vulnConfidentialityImpact": "NONE",
            "vulnIntegrityImpact": "LOW"
          }
        }
      ],
      "problemTypes": [
        {
          "descriptions": [
            {
              "cweId": "CWE-89",
              "description": "CWE-89: Improper Neutralization of Special Elements used in an SQL Command (\u0027SQL Injection\u0027)",
              "lang": "en",
              "type": "CWE"
            }
          ]
        }
      ],
      "providerMetadata": {
        "dateUpdated": "2026-03-31T21:00:59.824Z",
        "orgId": "a0819718-46f1-4df5-94e2-005712e83aaa",
        "shortName": "GitHub_M"
      },
      "references": [
        {
          "name": "https://github.com/alerta/alerta/security/advisories/GHSA-8prr-286p-4w7j",
          "tags": [
            "x_refsource_CONFIRM"
          ],
          "url": "https://github.com/alerta/alerta/security/advisories/GHSA-8prr-286p-4w7j"
        },
        {
          "name": "https://github.com/alerta/alerta/pull/2040",
          "tags": [
            "x_refsource_MISC"
          ],
          "url": "https://github.com/alerta/alerta/pull/2040"
        },
        {
          "name": "https://github.com/alerta/alerta/pull/712",
          "tags": [
            "x_refsource_MISC"
          ],
          "url": "https://github.com/alerta/alerta/pull/712"
        },
        {
          "name": "https://github.com/alerta/alerta/commit/aeba85a37a09e5769a7a2da56481aa979ff99a00",
          "tags": [
            "x_refsource_MISC"
          ],
          "url": "https://github.com/alerta/alerta/commit/aeba85a37a09e5769a7a2da56481aa979ff99a00"
        },
        {
          "name": "https://github.com/alerta/alerta/commit/fdd52cd1abad8d02d1dfb8ecdcdbb43b6af3b883",
          "tags": [
            "x_refsource_MISC"
          ],
          "url": "https://github.com/alerta/alerta/commit/fdd52cd1abad8d02d1dfb8ecdcdbb43b6af3b883"
        },
        {
          "name": "https://github.com/alerta/alerta/releases/tag/v9.1.0",
          "tags": [
            "x_refsource_MISC"
          ],
          "url": "https://github.com/alerta/alerta/releases/tag/v9.1.0"
        }
      ],
      "source": {
        "advisory": "GHSA-8prr-286p-4w7j",
        "discovery": "UNKNOWN"
      },
      "title": "alerta-server has potential SQL Injection vulnerability in Query String Syntax (q=) API"
    }
  },
  "cveMetadata": {
    "assignerOrgId": "a0819718-46f1-4df5-94e2-005712e83aaa",
    "assignerShortName": "GitHub_M",
    "cveId": "CVE-2026-34400",
    "datePublished": "2026-03-31T21:00:59.824Z",
    "dateReserved": "2026-03-27T13:45:29.620Z",
    "dateUpdated": "2026-04-03T16:36:42.053Z",
    "state": "PUBLISHED"
  },
  "dataType": "CVE_RECORD",
  "dataVersion": "5.2"
}

GHSA-8PRR-286P-4W7J

Vulnerability from github – Published: 2026-03-31 23:23 – Updated: 2026-04-06 17:37

Summary

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

Details

Impact

Patches

Workarounds

Upgrade to v9.1.0 or later. If unable to upgrade, deploy a proxy in front of the Alerta API to sanitize the q= parameter.

Resources

https://github.com/alerta/alerta/pull/712/files https://owasp.org/www-community/attacks/SQL_Injection

Severity

6.9 (Medium)


                  
                    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

Show details on source website

JSON

To clipboard

{
  "affected": [
    {
      "package": {
        "ecosystem": "PyPI",
        "name": "alerta-server"
      },
      "ranges": [
        {
          "events": [
            {
              "introduced": "0"
            },
            {
              "fixed": "9.1.0"
            }
          ],
          "type": "ECOSYSTEM"
        }
      ]
    }
  ],
  "aliases": [
    "CVE-2026-34400"
  ],
  "database_specific": {
    "cwe_ids": [
      "CWE-89"
    ],
    "github_reviewed": true,
    "github_reviewed_at": "2026-03-31T23:23:21Z",
    "nvd_published_at": "2026-03-31T22:16:18Z",
    "severity": "MODERATE"
  },
  "details": "### Impact\nThe 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.\n\n### Patches\nFixed in v9.1.0. The Postgres query parser now uses parameterized queries with %(name)s placeholders passed to psycopg2\u0027s cursor.execute(), preventing SQL injection through the ?q= parameter. The MongoDB backend was not affected.\n\n### Workarounds\nUpgrade to v9.1.0 or later. If unable to upgrade, deploy a proxy in front of the Alerta API to sanitize the q= parameter.\n\n### Resources\nhttps://github.com/alerta/alerta/pull/712/files\nhttps://owasp.org/www-community/attacks/SQL_Injection",
  "id": "GHSA-8prr-286p-4w7j",
  "modified": "2026-04-06T17:37:22Z",
  "published": "2026-03-31T23:23:21Z",
  "references": [
    {
      "type": "WEB",
      "url": "https://github.com/alerta/alerta/security/advisories/GHSA-8prr-286p-4w7j"
    },
    {
      "type": "ADVISORY",
      "url": "https://nvd.nist.gov/vuln/detail/CVE-2026-34400"
    },
    {
      "type": "WEB",
      "url": "https://github.com/alerta/alerta/pull/2040"
    },
    {
      "type": "WEB",
      "url": "https://github.com/alerta/alerta/pull/712"
    },
    {
      "type": "WEB",
      "url": "https://github.com/alerta/alerta/commit/aeba85a37a09e5769a7a2da56481aa979ff99a00"
    },
    {
      "type": "WEB",
      "url": "https://github.com/alerta/alerta/commit/fdd52cd1abad8d02d1dfb8ecdcdbb43b6af3b883"
    },
    {
      "type": "PACKAGE",
      "url": "https://github.com/alerta/alerta"
    },
    {
      "type": "WEB",
      "url": "https://github.com/alerta/alerta/releases/tag/v9.1.0"
    }
  ],
  "schema_version": "1.4.0",
  "severity": [
    {
      "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",
      "type": "CVSS_V4"
    }
  ],
  "summary": "alerta-server has potential SQL Injection vulnerability in Query String Syntax (q=) API"
}

Sightings

Author	Source	Type	Date	Other

Nomenclature

Seen: The vulnerability was mentioned, discussed, or observed by the user.
Confirmed: The vulnerability has been validated from an analyst's perspective.
Published Proof of Concept: A public proof of concept is available for this vulnerability.
Exploited: The vulnerability was observed as exploited by the user who reported the sighting.
Patched: The vulnerability was observed as successfully patched by the user who reported the sighting.
Not exploited: The vulnerability was not observed as exploited by the user who reported the sighting.
Not confirmed: The user expressed doubt about the validity of the vulnerability.
Not patched: The vulnerability was not observed as successfully patched by the user who reported the sighting.

Detection rules are retrieved from Rulezet.

Action not permitted

PYSEC-2026-2341

Impact

Patches

Workarounds

Resources

CVE-2026-34400 (GCVE-0-2026-34400)

GHSA-8PRR-286P-4W7J

Impact

Patches

Workarounds

Resources

Tags

Sightings

Nomenclature