nday
CVE-2024-24811 GHSA-r3jc-3qmm-w3pw

Products.SQLAlchemyDA vulnerable to unauthenticated arbitrary SQL query execution

zopefoundation / Products.SQLAlchemyDA

Correctif recensé 1 013 jours après la divulgation. Version corrigée : Products.SQLAlchemyDA 2.2. Cette vulnérabilité ne figure dans aucune des quatre sources de PoC. Aucune inscription au catalogue KEV de la CISA à ce jour.

why these tags

nday derives these tags by fixed rules from the facts below; NVD, the CNA and other sources do not assign them. Vocabulary and rules: ~/tags.

SQL injection
CWE-89, stated by the CNA GitHub_M, NVD, republishing [email protected] et GitHub advisory GHSA-r3jc-3qmm-w3pw
remote, unauthenticated
AV:N, PR:N, UI:N in CVSS:3.1/AV:N/AC:L/PR:N/UI:N/S:U/C:H/I:H/A:H (CVSS 3.1) from the CNA GitHub_M
network
AV:N in CVSS:3.1/AV:N/AC:L/PR:N/UI:N/S:U/C:H/I:H/A:H (CVSS 3.1) from the CNA GitHub_M
no authentication required
PR:N in CVSS:3.1/AV:N/AC:L/PR:N/UI:N/S:U/C:H/I:H/A:H (CVSS 3.1) from the CNA GitHub_M
no user interaction
UI:N in CVSS:3.1/AV:N/AC:L/PR:N/UI:N/S:U/C:H/I:H/A:H (CVSS 3.1) from the CNA GitHub_M
PyPI
GHSA-r3jc-3qmm-w3pw: pip packages Products.SQLAlchemyDA
étape actuelle
PAT
divulgation
délai avant correctif
T+1013d
CVSS
9.8 CRITICAL v3.1

Cycle de vie

Axe en UTC ; point = minute exacte, barre large = date seule, creux = inconnue ou déduite.
date inconnue
DISdivulguée
2024-02-07T14:54Z
PATcorrectif
2026-11-16T17:01Z
ANAanalyse
aucune donnée
POCPoC
aucune donnée
ITWexploitée
aucune donnée
KEVKEV
aucune donnée

Résumé

SQLAlchemyDA is a generic database adapter for ZSQL methods. A vulnerability found in versions prior to 2.2 allows unauthenticated execution of arbitrary SQL statements on the database to which the SQLAlchemyDA instance is connected. All users are affected. The problem has been patched in version 2.2. There is no workaround for the problem.

Original text of the CVE record (cvelist), shown as published.

Exploit conditions

What an attack needs, read from the CVSS vector.
Attack vector AV:N
Network: the attacker only needs to reach it over the network
Attack complexity AC:L
Low: no special conditions; the attacker can expect repeatable success
Privileges required PR:N
None: no account or authorization needed
User interaction UI:N
None: no action by anyone other than the attacker

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

CVSS 3.1 vector from the CVE record, scored by the CNA GitHub_M.

Journal des événements

+DISdivulgation

Fiche CVE publiée par GitHub_M. CVSS 9.8, gravité critique.

source cvelist · importé en masse par nday le · brut
{
  "id": 326695,
  "type": "disclosed",
  "source": "cvelist",
  "url": "https://www.cve.org/CVERecord?id=CVE-2024-24811",
  "occurred_at": "2024-02-07T14:54:41.601Z",
  "observed_at": "2026-11-13T05:38:29.055618Z",
  "is_backfill": true,
  "dedupe_key": "",
  "detail": {
    "cvss": {
      "source": "cna",
      "vector": "CVSS:3.1/AV:N/AC:L/PR:N/UI:N/S:U/C:H/I:H/A:H",
      "version": "3.1",
      "base_score": 9.8,
      "base_severity": "CRITICAL"
    },
    "ssvc": {
      "timestamp": "2025-05-08T15:40:51.292776Z",
      "automatable": "yes",
      "exploitation": "none",
      "technical_impact": "total"
    },
    "state": "PUBLISHED",
    "date_published": "2024-02-07T14:54:41.601Z",
    "assigner_short_name": "GitHub_M"
  }
}
source non datée ; vu en direct par nday
+PATcorrectif disponible

L’avis indique la version corrigée Products.SQLAlchemyDA 2.2. L’avis renvoie vers les commits de correction. Avis publié le  ; la date de publication du correctif lui-même n’est pas renseignée.

source ghsa GHSA-r3jc-3qmm-w3pw · observé en direct par nday le · brut
{
  "id": 473089,
  "type": "patch_released",
  "source": "ghsa",
  "url": "https://github.com/advisories/GHSA-r3jc-3qmm-w3pw",
  "occurred_at": null,
  "observed_at": "2026-11-16T17:01:02.573287Z",
  "is_backfill": false,
  "dedupe_key": "GHSA-r3jc-3qmm-w3pw",
  "detail": {
    "cvss": {
      "cvss_v3": {
        "score": 9.8,
        "vector_string": "CVSS:3.1/AV:N/AC:L/PR:N/UI:N/S:U/C:H/I:H/A:H"
      },
      "cvss_v4": {
        "score": 0.0,
        "vector_string": null
      }
    },
    "cwes": [
      {
        "name": "Improper Neutralization of Special Elements used in an SQL Command",
        "cwe_id": "CWE-89"
      }
    ],
    "ghsa_id": "GHSA-r3jc-3qmm-w3pw",
    "packages": [
      {
        "name": "Products.SQLAlchemyDA",
        "ecosystem": "pip",
        "first_patched_version": "2.2",
        "vulnerable_version_range": "< 2.2"
      }
    ],
    "severity": "critical",
    "references": [
      "https://github.com/zopefoundation/Products.SQLAlchemyDA/security/advisories/GHSA-r3jc-3qmm-w3pw",
      "https://nvd.nist.gov/vuln/detail/CVE-2024-24811",
      "https://github.com/zopefoundation/Products.SQLAlchemyDA/commit/e682b99f8406f20bc3f0f2c77153ed7345fd215a",
      "https://github.com/pypa/advisory-database/tree/main/vulns/products-sqlalchemyda/PYSEC-2026-489.yaml",
      "https://pypi.org/project/products-sqlalchemyda",
      "https://github.com/advisories/GHSA-r3jc-3qmm-w3pw"
    ],
    "fix_commit_urls": [
      "https://github.com/zopefoundation/Products.SQLAlchemyDA/commit/e682b99f8406f20bc3f0f2c77153ed7345fd215a"
    ],
    "github_reviewed_at": "2024-02-07T17:28:26Z",
    "advisory_updated_at": "2026-11-16T16:02:31Z",
    "source_code_location": "https://github.com/zopefoundation/Products.SQLAlchemyDA",
    "advisory_published_at": "2024-02-07T17:28:26Z"
  }
}

Report an error

report an error or omission

Something on this page wrong or missing? Tell the editors; if they accept it, this page's revision log says so publicly. Upstream data is not changed.

Échanges entre chercheurs

0 chercheur en a parlé ces 7 derniers jours

Publications sur X de chercheurs suivis par nday citant cette CVE, telles que publiées. nday ne les vérifie pas.

nday n’a encore recueilli aucune publication sur X d’un chercheur de sa liste citant cette CVE.

Discussion

0 comments

No comments yet.