{
  "document": {
    "aggregate_severity": {
      "namespace": "https://access.redhat.com/security/updates/classification/",
      "text": "Moderate"
    },
    "category": "csaf_security_advisory",
    "csaf_version": "2.0",
    "distribution": {
      "text": "Copyright \u00a9 Red Hat, Inc. All rights reserved.",
      "tlp": {
        "label": "WHITE",
        "url": "https://www.first.org/tlp/"
      }
    },
    "lang": "en",
    "notes": [
      {
        "category": "summary",
        "text": "An update for python3 is now available for Red Hat Enterprise Linux 8.\n\nRed Hat Product Security has rated this update as having a security impact of Moderate. A Common Vulnerability Scoring System (CVSS) base score, which gives a detailed severity rating, is available for each vulnerability from the CVE link(s) in the References section.",
        "title": "Topic"
      },
      {
        "category": "general",
        "text": "Python is an interpreted, interactive, object-oriented programming language, which includes modules, classes, exceptions, very high level dynamic data types and dynamic typing. Python supports interfaces to many system calls and libraries, as well as to various windowing systems.\n\nSecurity Fix(es):\n\n* python-pymysql: SQL injection if used with untrusted JSON input (CVE-2024-36039)\n\nFor more details about the security issue(s), including the impact, a CVSS score, acknowledgments, and other related information, refer to the CVE page(s) listed in the References section.",
        "title": "Details"
      },
      {
        "category": "legal_disclaimer",
        "text": "This content is licensed under the Creative Commons Attribution 4.0 International License (https://creativecommons.org/licenses/by/4.0/). If you distribute this content, or a modified version of it, you must provide attribution to Red Hat Inc. and provide a link to the original.",
        "title": "Terms of Use"
      }
    ],
    "publisher": {
      "category": "vendor",
      "contact_details": "https://access.redhat.com/security/team/contact/",
      "issuing_authority": "Red Hat Product Security is responsible for vulnerability handling across all Red Hat products and services.",
      "name": "Red Hat Product Security",
      "namespace": "https://www.redhat.com"
    },
    "references": [
      {
        "category": "self",
        "summary": "https://access.redhat.com/errata/RHSA-2024:4245",
        "url": "https://access.redhat.com/errata/RHSA-2024:4245"
      },
      {
        "category": "external",
        "summary": "https://access.redhat.com/security/updates/classification/#moderate",
        "url": "https://access.redhat.com/security/updates/classification/#moderate"
      },
      {
        "category": "external",
        "summary": "2282821",
        "url": "https://bugzilla.redhat.com/show_bug.cgi?id=2282821"
      },
      {
        "category": "self",
        "summary": "Canonical URL",
        "url": "https://security.access.redhat.com/data/csaf/v2/advisories/2024/rhsa-2024_4245.json"
      }
    ],
    "title": "Red Hat Security Advisory: python3 security update",
    "tracking": {
      "current_release_date": "2026-03-18T02:40:19+00:00",
      "generator": {
        "date": "2026-03-18T02:40:19+00:00",
        "engine": {
          "name": "Red Hat SDEngine",
          "version": "4.7.3"
        }
      },
      "id": "RHSA-2024:4245",
      "initial_release_date": "2024-07-02T15:24:34+00:00",
      "revision_history": [
        {
          "date": "2024-07-02T15:24:34+00:00",
          "number": "1",
          "summary": "Initial version"
        },
        {
          "date": "2024-07-02T15:24:35+00:00",
          "number": "2",
          "summary": "Last updated version"
        },
        {
          "date": "2026-03-18T02:40:19+00:00",
          "number": "3",
          "summary": "Last generated version"
        }
      ],
      "status": "final",
      "version": "3"
    }
  },
  "product_tree": {
    "branches": [
      {
        "branches": [
          {
            "branches": [
              {
                "category": "product_name",
                "name": "Red Hat Enterprise Linux AppStream (v. 8)",
                "product": {
                  "name": "Red Hat Enterprise Linux AppStream (v. 8)",
                  "product_id": "AppStream-8.10.0.Z.MAIN.EUS",
                  "product_identification_helper": {
                    "cpe": "cpe:/a:redhat:enterprise_linux:8::appstream"
                  }
                }
              }
            ],
            "category": "product_family",
            "name": "Red Hat Enterprise Linux"
          },
          {
            "branches": [
              {
                "category": "product_version",
                "name": "python3.12-PyMySQL-0:1.1.0-3.el8_10.src",
                "product": {
                  "name": "python3.12-PyMySQL-0:1.1.0-3.el8_10.src",
                  "product_id": "python3.12-PyMySQL-0:1.1.0-3.el8_10.src",
                  "product_identification_helper": {
                    "purl": "pkg:rpm/redhat/python3.12-PyMySQL@1.1.0-3.el8_10?arch=src"
                  }
                }
              }
            ],
            "category": "architecture",
            "name": "src"
          },
          {
            "branches": [
              {
                "category": "product_version",
                "name": "python3.12-PyMySQL-0:1.1.0-3.el8_10.noarch",
                "product": {
                  "name": "python3.12-PyMySQL-0:1.1.0-3.el8_10.noarch",
                  "product_id": "python3.12-PyMySQL-0:1.1.0-3.el8_10.noarch",
                  "product_identification_helper": {
                    "purl": "pkg:rpm/redhat/python3.12-PyMySQL@1.1.0-3.el8_10?arch=noarch"
                  }
                }
              }
            ],
            "category": "architecture",
            "name": "noarch"
          }
        ],
        "category": "vendor",
        "name": "Red Hat"
      }
    ],
    "relationships": [
      {
        "category": "default_component_of",
        "full_product_name": {
          "name": "python3.12-PyMySQL-0:1.1.0-3.el8_10.noarch as a component of Red Hat Enterprise Linux AppStream (v. 8)",
          "product_id": "AppStream-8.10.0.Z.MAIN.EUS:python3.12-PyMySQL-0:1.1.0-3.el8_10.noarch"
        },
        "product_reference": "python3.12-PyMySQL-0:1.1.0-3.el8_10.noarch",
        "relates_to_product_reference": "AppStream-8.10.0.Z.MAIN.EUS"
      },
      {
        "category": "default_component_of",
        "full_product_name": {
          "name": "python3.12-PyMySQL-0:1.1.0-3.el8_10.src as a component of Red Hat Enterprise Linux AppStream (v. 8)",
          "product_id": "AppStream-8.10.0.Z.MAIN.EUS:python3.12-PyMySQL-0:1.1.0-3.el8_10.src"
        },
        "product_reference": "python3.12-PyMySQL-0:1.1.0-3.el8_10.src",
        "relates_to_product_reference": "AppStream-8.10.0.Z.MAIN.EUS"
      }
    ]
  },
  "vulnerabilities": [
    {
      "cve": "CVE-2024-36039",
      "cwe": {
        "id": "CWE-89",
        "name": "Improper Neutralization of Special Elements used in an SQL Command (\u0027SQL Injection\u0027)"
      },
      "discovery_date": "2024-05-21T00:00:00+00:00",
      "ids": [
        {
          "system_name": "Red Hat Bugzilla ID",
          "text": "2282821"
        }
      ],
      "notes": [
        {
          "category": "description",
          "text": "A flaw was found in PyMySQL. When processing untrusted JSON input, keys are not escaped by the escape_dict function due to insufficient input sanitization, allowing an attacker to inject malicious SQL queries.",
          "title": "Vulnerability description"
        },
        {
          "category": "summary",
          "text": "python-pymysql: SQL injection if used with untrusted JSON input",
          "title": "Vulnerability summary"
        },
        {
          "category": "other",
          "text": "Applications not exposed to untrusted JSON input are not vulnerable to this issue. Additionally, exploitation of this vulnerability depends on the permissions granted to the database user, limiting the security impact. For this reason, this flaw was rated with a Moderate severity.",
          "title": "Statement"
        },
        {
          "category": "general",
          "text": "The CVSS score(s) listed for this vulnerability do not reflect the associated product\u0027s status, and are included for informational purposes to better understand the severity of this vulnerability.",
          "title": "CVSS score applicability"
        }
      ],
      "product_status": {
        "fixed": [
          "AppStream-8.10.0.Z.MAIN.EUS:python3.12-PyMySQL-0:1.1.0-3.el8_10.noarch",
          "AppStream-8.10.0.Z.MAIN.EUS:python3.12-PyMySQL-0:1.1.0-3.el8_10.src"
        ]
      },
      "references": [
        {
          "category": "self",
          "summary": "Canonical URL",
          "url": "https://access.redhat.com/security/cve/CVE-2024-36039"
        },
        {
          "category": "external",
          "summary": "RHBZ#2282821",
          "url": "https://bugzilla.redhat.com/show_bug.cgi?id=2282821"
        },
        {
          "category": "external",
          "summary": "https://www.cve.org/CVERecord?id=CVE-2024-36039",
          "url": "https://www.cve.org/CVERecord?id=CVE-2024-36039"
        },
        {
          "category": "external",
          "summary": "https://nvd.nist.gov/vuln/detail/CVE-2024-36039",
          "url": "https://nvd.nist.gov/vuln/detail/CVE-2024-36039"
        }
      ],
      "release_date": "2024-05-21T00:00:00+00:00",
      "remediations": [
        {
          "category": "vendor_fix",
          "date": "2024-07-02T15:24:34+00:00",
          "details": "For details on how to apply this update, which includes the changes described in this advisory, refer to:\n\nhttps://access.redhat.com/articles/11258",
          "product_ids": [
            "AppStream-8.10.0.Z.MAIN.EUS:python3.12-PyMySQL-0:1.1.0-3.el8_10.noarch",
            "AppStream-8.10.0.Z.MAIN.EUS:python3.12-PyMySQL-0:1.1.0-3.el8_10.src"
          ],
          "restart_required": {
            "category": "none"
          },
          "url": "https://access.redhat.com/errata/RHSA-2024:4245"
        },
        {
          "category": "workaround",
          "details": "Make sure the permissions are set correctly for each user, database, table, operation, etc. Do not expose the PyMySQL library to untrusted JSON input.",
          "product_ids": [
            "AppStream-8.10.0.Z.MAIN.EUS:python3.12-PyMySQL-0:1.1.0-3.el8_10.noarch",
            "AppStream-8.10.0.Z.MAIN.EUS:python3.12-PyMySQL-0:1.1.0-3.el8_10.src"
          ]
        }
      ],
      "scores": [
        {
          "cvss_v3": {
            "attackComplexity": "LOW",
            "attackVector": "NETWORK",
            "availabilityImpact": "LOW",
            "baseScore": 6.3,
            "baseSeverity": "MEDIUM",
            "confidentialityImpact": "LOW",
            "integrityImpact": "LOW",
            "privilegesRequired": "LOW",
            "scope": "UNCHANGED",
            "userInteraction": "NONE",
            "vectorString": "CVSS:3.1/AV:N/AC:L/PR:L/UI:N/S:U/C:L/I:L/A:L",
            "version": "3.1"
          },
          "products": [
            "AppStream-8.10.0.Z.MAIN.EUS:python3.12-PyMySQL-0:1.1.0-3.el8_10.noarch",
            "AppStream-8.10.0.Z.MAIN.EUS:python3.12-PyMySQL-0:1.1.0-3.el8_10.src"
          ]
        }
      ],
      "threats": [
        {
          "category": "impact",
          "details": "Moderate"
        }
      ],
      "title": "python-pymysql: SQL injection if used with untrusted JSON input"
    }
  ]
}

{
  "document": {
    "aggregate_severity": {
      "namespace": "https://access.redhat.com/security/updates/classification/",
      "text": "Moderate"
    },
    "category": "csaf_security_advisory",
    "csaf_version": "2.0",
    "distribution": {
      "text": "Copyright \u00a9 Red Hat, Inc. All rights reserved.",
      "tlp": {
        "label": "WHITE",
        "url": "https://www.first.org/tlp/"
      }
    },
    "lang": "en",
    "notes": [
      {
        "category": "summary",
        "text": "An update for python3.12-PyMySQL is now available for Red Hat Enterprise Linux 9.\n\nRed Hat Product Security has rated this update as having a security impact of Moderate. A Common Vulnerability Scoring System (CVSS) base score, which gives a detailed severity rating, is available for each vulnerability from the CVE link(s) in the References section.",
        "title": "Topic"
      },
      {
        "category": "general",
        "text": "This package contains a pure-Python MySQL client library. The goal of PyMySQL is to be a drop-in replacement for MySQLdb and work on CPython, PyPy, IronPython and Jython.\n\nSecurity Fix(es):\n\n* python-pymysql: SQL injection if used with untrusted JSON input (CVE-2024-36039)\n\nFor more details about the security issue(s), including the impact, a CVSS score, acknowledgments, and other related information, refer to the CVE page(s) listed in the References section.\n\nAdditional Changes:\n\nFor detailed information on changes in this release, see the Red Hat Enterprise Linux 9.5 Release Notes linked from the References section.",
        "title": "Details"
      },
      {
        "category": "legal_disclaimer",
        "text": "This content is licensed under the Creative Commons Attribution 4.0 International License (https://creativecommons.org/licenses/by/4.0/). If you distribute this content, or a modified version of it, you must provide attribution to Red Hat Inc. and provide a link to the original.",
        "title": "Terms of Use"
      }
    ],
    "publisher": {
      "category": "vendor",
      "contact_details": "https://access.redhat.com/security/team/contact/",
      "issuing_authority": "Red Hat Product Security is responsible for vulnerability handling across all Red Hat products and services.",
      "name": "Red Hat Product Security",
      "namespace": "https://www.redhat.com"
    },
    "references": [
      {
        "category": "self",
        "summary": "https://access.redhat.com/errata/RHSA-2024:9193",
        "url": "https://access.redhat.com/errata/RHSA-2024:9193"
      },
      {
        "category": "external",
        "summary": "https://docs.redhat.com/en/documentation/red_hat_enterprise_linux/9/html/9.5_release_notes/index",
        "url": "https://docs.redhat.com/en/documentation/red_hat_enterprise_linux/9/html/9.5_release_notes/index"
      },
      {
        "category": "external",
        "summary": "https://access.redhat.com/security/updates/classification/#moderate",
        "url": "https://access.redhat.com/security/updates/classification/#moderate"
      },
      {
        "category": "external",
        "summary": "2282821",
        "url": "https://bugzilla.redhat.com/show_bug.cgi?id=2282821"
      },
      {
        "category": "self",
        "summary": "Canonical URL",
        "url": "https://security.access.redhat.com/data/csaf/v2/advisories/2024/rhsa-2024_9193.json"
      }
    ],
    "title": "Red Hat Security Advisory: python3.12-PyMySQL security update",
    "tracking": {
      "current_release_date": "2026-03-18T02:40:19+00:00",
      "generator": {
        "date": "2026-03-18T02:40:19+00:00",
        "engine": {
          "name": "Red Hat SDEngine",
          "version": "4.7.3"
        }
      },
      "id": "RHSA-2024:9193",
      "initial_release_date": "2024-11-12T08:56:27+00:00",
      "revision_history": [
        {
          "date": "2024-11-12T08:56:27+00:00",
          "number": "1",
          "summary": "Initial version"
        },
        {
          "date": "2024-11-12T08:56:27+00:00",
          "number": "2",
          "summary": "Last updated version"
        },
        {
          "date": "2026-03-18T02:40:19+00:00",
          "number": "3",
          "summary": "Last generated version"
        }
      ],
      "status": "final",
      "version": "3"
    }
  },
  "product_tree": {
    "branches": [
      {
        "branches": [
          {
            "branches": [
              {
                "category": "product_name",
                "name": "Red Hat Enterprise Linux AppStream (v. 9)",
                "product": {
                  "name": "Red Hat Enterprise Linux AppStream (v. 9)",
                  "product_id": "AppStream-9.5.0.GA",
                  "product_identification_helper": {
                    "cpe": "cpe:/a:redhat:enterprise_linux:9::appstream"
                  }
                }
              }
            ],
            "category": "product_family",
            "name": "Red Hat Enterprise Linux"
          },
          {
            "branches": [
              {
                "category": "product_version",
                "name": "python3.12-PyMySQL+rsa-0:1.1.0-3.el9.noarch",
                "product": {
                  "name": "python3.12-PyMySQL+rsa-0:1.1.0-3.el9.noarch",
                  "product_id": "python3.12-PyMySQL+rsa-0:1.1.0-3.el9.noarch",
                  "product_identification_helper": {
                    "purl": "pkg:rpm/redhat/python3.12-PyMySQL%2Brsa@1.1.0-3.el9?arch=noarch"
                  }
                }
              },
              {
                "category": "product_version",
                "name": "python3.12-PyMySQL-0:1.1.0-3.el9.noarch",
                "product": {
                  "name": "python3.12-PyMySQL-0:1.1.0-3.el9.noarch",
                  "product_id": "python3.12-PyMySQL-0:1.1.0-3.el9.noarch",
                  "product_identification_helper": {
                    "purl": "pkg:rpm/redhat/python3.12-PyMySQL@1.1.0-3.el9?arch=noarch"
                  }
                }
              }
            ],
            "category": "architecture",
            "name": "noarch"
          },
          {
            "branches": [
              {
                "category": "product_version",
                "name": "python3.12-PyMySQL-0:1.1.0-3.el9.src",
                "product": {
                  "name": "python3.12-PyMySQL-0:1.1.0-3.el9.src",
                  "product_id": "python3.12-PyMySQL-0:1.1.0-3.el9.src",
                  "product_identification_helper": {
                    "purl": "pkg:rpm/redhat/python3.12-PyMySQL@1.1.0-3.el9?arch=src"
                  }
                }
              }
            ],
            "category": "architecture",
            "name": "src"
          }
        ],
        "category": "vendor",
        "name": "Red Hat"
      }
    ],
    "relationships": [
      {
        "category": "default_component_of",
        "full_product_name": {
          "name": "python3.12-PyMySQL+rsa-0:1.1.0-3.el9.noarch as a component of Red Hat Enterprise Linux AppStream (v. 9)",
          "product_id": "AppStream-9.5.0.GA:python3.12-PyMySQL+rsa-0:1.1.0-3.el9.noarch"
        },
        "product_reference": "python3.12-PyMySQL+rsa-0:1.1.0-3.el9.noarch",
        "relates_to_product_reference": "AppStream-9.5.0.GA"
      },
      {
        "category": "default_component_of",
        "full_product_name": {
          "name": "python3.12-PyMySQL-0:1.1.0-3.el9.noarch as a component of Red Hat Enterprise Linux AppStream (v. 9)",
          "product_id": "AppStream-9.5.0.GA:python3.12-PyMySQL-0:1.1.0-3.el9.noarch"
        },
        "product_reference": "python3.12-PyMySQL-0:1.1.0-3.el9.noarch",
        "relates_to_product_reference": "AppStream-9.5.0.GA"
      },
      {
        "category": "default_component_of",
        "full_product_name": {
          "name": "python3.12-PyMySQL-0:1.1.0-3.el9.src as a component of Red Hat Enterprise Linux AppStream (v. 9)",
          "product_id": "AppStream-9.5.0.GA:python3.12-PyMySQL-0:1.1.0-3.el9.src"
        },
        "product_reference": "python3.12-PyMySQL-0:1.1.0-3.el9.src",
        "relates_to_product_reference": "AppStream-9.5.0.GA"
      }
    ]
  },
  "vulnerabilities": [
    {
      "cve": "CVE-2024-36039",
      "cwe": {
        "id": "CWE-89",
        "name": "Improper Neutralization of Special Elements used in an SQL Command (\u0027SQL Injection\u0027)"
      },
      "discovery_date": "2024-05-21T00:00:00+00:00",
      "ids": [
        {
          "system_name": "Red Hat Bugzilla ID",
          "text": "2282821"
        }
      ],
      "notes": [
        {
          "category": "description",
          "text": "A flaw was found in PyMySQL. When processing untrusted JSON input, keys are not escaped by the escape_dict function due to insufficient input sanitization, allowing an attacker to inject malicious SQL queries.",
          "title": "Vulnerability description"
        },
        {
          "category": "summary",
          "text": "python-pymysql: SQL injection if used with untrusted JSON input",
          "title": "Vulnerability summary"
        },
        {
          "category": "other",
          "text": "Applications not exposed to untrusted JSON input are not vulnerable to this issue. Additionally, exploitation of this vulnerability depends on the permissions granted to the database user, limiting the security impact. For this reason, this flaw was rated with a Moderate severity.",
          "title": "Statement"
        },
        {
          "category": "general",
          "text": "The CVSS score(s) listed for this vulnerability do not reflect the associated product\u0027s status, and are included for informational purposes to better understand the severity of this vulnerability.",
          "title": "CVSS score applicability"
        }
      ],
      "product_status": {
        "fixed": [
          "AppStream-9.5.0.GA:python3.12-PyMySQL+rsa-0:1.1.0-3.el9.noarch",
          "AppStream-9.5.0.GA:python3.12-PyMySQL-0:1.1.0-3.el9.noarch",
          "AppStream-9.5.0.GA:python3.12-PyMySQL-0:1.1.0-3.el9.src"
        ]
      },
      "references": [
        {
          "category": "self",
          "summary": "Canonical URL",
          "url": "https://access.redhat.com/security/cve/CVE-2024-36039"
        },
        {
          "category": "external",
          "summary": "RHBZ#2282821",
          "url": "https://bugzilla.redhat.com/show_bug.cgi?id=2282821"
        },
        {
          "category": "external",
          "summary": "https://www.cve.org/CVERecord?id=CVE-2024-36039",
          "url": "https://www.cve.org/CVERecord?id=CVE-2024-36039"
        },
        {
          "category": "external",
          "summary": "https://nvd.nist.gov/vuln/detail/CVE-2024-36039",
          "url": "https://nvd.nist.gov/vuln/detail/CVE-2024-36039"
        }
      ],
      "release_date": "2024-05-21T00:00:00+00:00",
      "remediations": [
        {
          "category": "vendor_fix",
          "date": "2024-11-12T08:56:27+00:00",
          "details": "For details on how to apply this update, which includes the changes described in this advisory, refer to:\n\nhttps://access.redhat.com/articles/11258",
          "product_ids": [
            "AppStream-9.5.0.GA:python3.12-PyMySQL+rsa-0:1.1.0-3.el9.noarch",
            "AppStream-9.5.0.GA:python3.12-PyMySQL-0:1.1.0-3.el9.noarch",
            "AppStream-9.5.0.GA:python3.12-PyMySQL-0:1.1.0-3.el9.src"
          ],
          "restart_required": {
            "category": "none"
          },
          "url": "https://access.redhat.com/errata/RHSA-2024:9193"
        },
        {
          "category": "workaround",
          "details": "Make sure the permissions are set correctly for each user, database, table, operation, etc. Do not expose the PyMySQL library to untrusted JSON input.",
          "product_ids": [
            "AppStream-9.5.0.GA:python3.12-PyMySQL+rsa-0:1.1.0-3.el9.noarch",
            "AppStream-9.5.0.GA:python3.12-PyMySQL-0:1.1.0-3.el9.noarch",
            "AppStream-9.5.0.GA:python3.12-PyMySQL-0:1.1.0-3.el9.src"
          ]
        }
      ],
      "scores": [
        {
          "cvss_v3": {
            "attackComplexity": "LOW",
            "attackVector": "NETWORK",
            "availabilityImpact": "LOW",
            "baseScore": 6.3,
            "baseSeverity": "MEDIUM",
            "confidentialityImpact": "LOW",
            "integrityImpact": "LOW",
            "privilegesRequired": "LOW",
            "scope": "UNCHANGED",
            "userInteraction": "NONE",
            "vectorString": "CVSS:3.1/AV:N/AC:L/PR:L/UI:N/S:U/C:L/I:L/A:L",
            "version": "3.1"
          },
          "products": [
            "AppStream-9.5.0.GA:python3.12-PyMySQL+rsa-0:1.1.0-3.el9.noarch",
            "AppStream-9.5.0.GA:python3.12-PyMySQL-0:1.1.0-3.el9.noarch",
            "AppStream-9.5.0.GA:python3.12-PyMySQL-0:1.1.0-3.el9.src"
          ]
        }
      ],
      "threats": [
        {
          "category": "impact",
          "details": "Moderate"
        }
      ],
      "title": "python-pymysql: SQL injection if used with untrusted JSON input"
    }
  ]
}

{
  "document": {
    "aggregate_severity": {
      "namespace": "https://access.redhat.com/security/updates/classification/",
      "text": "Moderate"
    },
    "category": "csaf_security_advisory",
    "csaf_version": "2.0",
    "distribution": {
      "text": "Copyright \u00a9 Red Hat, Inc. All rights reserved.",
      "tlp": {
        "label": "WHITE",
        "url": "https://www.first.org/tlp/"
      }
    },
    "lang": "en",
    "notes": [
      {
        "category": "summary",
        "text": "An update for python3.11-PyMySQL is now available for Red Hat Enterprise Linux 9.\n\nRed Hat Product Security has rated this update as having a security impact of Moderate. A Common Vulnerability Scoring System (CVSS) base score, which gives a detailed severity rating, is available for each vulnerability from the CVE link(s) in the References section.",
        "title": "Topic"
      },
      {
        "category": "general",
        "text": "This package contains a pure-Python MySQL client library. The goal of PyMySQL is to be a drop-in replacement for MySQLdb and work on CPython, PyPy, IronPython and Jython.\n\nSecurity Fix(es):\n\n* python-pymysql: SQL injection if used with untrusted JSON input (CVE-2024-36039)\n\nFor more details about the security issue(s), including the impact, a CVSS score, acknowledgments, and other related information, refer to the CVE page(s) listed in the References section.\n\nAdditional Changes:\n\nFor detailed information on changes in this release, see the Red Hat Enterprise Linux 9.5 Release Notes linked from the References section.",
        "title": "Details"
      },
      {
        "category": "legal_disclaimer",
        "text": "This content is licensed under the Creative Commons Attribution 4.0 International License (https://creativecommons.org/licenses/by/4.0/). If you distribute this content, or a modified version of it, you must provide attribution to Red Hat Inc. and provide a link to the original.",
        "title": "Terms of Use"
      }
    ],
    "publisher": {
      "category": "vendor",
      "contact_details": "https://access.redhat.com/security/team/contact/",
      "issuing_authority": "Red Hat Product Security is responsible for vulnerability handling across all Red Hat products and services.",
      "name": "Red Hat Product Security",
      "namespace": "https://www.redhat.com"
    },
    "references": [
      {
        "category": "self",
        "summary": "https://access.redhat.com/errata/RHSA-2024:9194",
        "url": "https://access.redhat.com/errata/RHSA-2024:9194"
      },
      {
        "category": "external",
        "summary": "https://docs.redhat.com/en/documentation/red_hat_enterprise_linux/9/html/9.5_release_notes/index",
        "url": "https://docs.redhat.com/en/documentation/red_hat_enterprise_linux/9/html/9.5_release_notes/index"
      },
      {
        "category": "external",
        "summary": "https://access.redhat.com/security/updates/classification/#moderate",
        "url": "https://access.redhat.com/security/updates/classification/#moderate"
      },
      {
        "category": "external",
        "summary": "2282821",
        "url": "https://bugzilla.redhat.com/show_bug.cgi?id=2282821"
      },
      {
        "category": "self",
        "summary": "Canonical URL",
        "url": "https://security.access.redhat.com/data/csaf/v2/advisories/2024/rhsa-2024_9194.json"
      }
    ],
    "title": "Red Hat Security Advisory: python3.11-PyMySQL security update",
    "tracking": {
      "current_release_date": "2026-03-18T02:40:20+00:00",
      "generator": {
        "date": "2026-03-18T02:40:20+00:00",
        "engine": {
          "name": "Red Hat SDEngine",
          "version": "4.7.3"
        }
      },
      "id": "RHSA-2024:9194",
      "initial_release_date": "2024-11-12T09:06:00+00:00",
      "revision_history": [
        {
          "date": "2024-11-12T09:06:00+00:00",
          "number": "1",
          "summary": "Initial version"
        },
        {
          "date": "2024-11-12T09:06:00+00:00",
          "number": "2",
          "summary": "Last updated version"
        },
        {
          "date": "2026-03-18T02:40:20+00:00",
          "number": "3",
          "summary": "Last generated version"
        }
      ],
      "status": "final",
      "version": "3"
    }
  },
  "product_tree": {
    "branches": [
      {
        "branches": [
          {
            "branches": [
              {
                "category": "product_name",
                "name": "Red Hat Enterprise Linux AppStream (v. 9)",
                "product": {
                  "name": "Red Hat Enterprise Linux AppStream (v. 9)",
                  "product_id": "AppStream-9.5.0.GA",
                  "product_identification_helper": {
                    "cpe": "cpe:/a:redhat:enterprise_linux:9::appstream"
                  }
                }
              }
            ],
            "category": "product_family",
            "name": "Red Hat Enterprise Linux"
          },
          {
            "branches": [
              {
                "category": "product_version",
                "name": "python3.11-PyMySQL+rsa-0:1.0.2-2.el9.noarch",
                "product": {
                  "name": "python3.11-PyMySQL+rsa-0:1.0.2-2.el9.noarch",
                  "product_id": "python3.11-PyMySQL+rsa-0:1.0.2-2.el9.noarch",
                  "product_identification_helper": {
                    "purl": "pkg:rpm/redhat/python3.11-PyMySQL%2Brsa@1.0.2-2.el9?arch=noarch"
                  }
                }
              },
              {
                "category": "product_version",
                "name": "python3.11-PyMySQL-0:1.0.2-2.el9.noarch",
                "product": {
                  "name": "python3.11-PyMySQL-0:1.0.2-2.el9.noarch",
                  "product_id": "python3.11-PyMySQL-0:1.0.2-2.el9.noarch",
                  "product_identification_helper": {
                    "purl": "pkg:rpm/redhat/python3.11-PyMySQL@1.0.2-2.el9?arch=noarch"
                  }
                }
              }
            ],
            "category": "architecture",
            "name": "noarch"
          },
          {
            "branches": [
              {
                "category": "product_version",
                "name": "python3.11-PyMySQL-0:1.0.2-2.el9.src",
                "product": {
                  "name": "python3.11-PyMySQL-0:1.0.2-2.el9.src",
                  "product_id": "python3.11-PyMySQL-0:1.0.2-2.el9.src",
                  "product_identification_helper": {
                    "purl": "pkg:rpm/redhat/python3.11-PyMySQL@1.0.2-2.el9?arch=src"
                  }
                }
              }
            ],
            "category": "architecture",
            "name": "src"
          }
        ],
        "category": "vendor",
        "name": "Red Hat"
      }
    ],
    "relationships": [
      {
        "category": "default_component_of",
        "full_product_name": {
          "name": "python3.11-PyMySQL+rsa-0:1.0.2-2.el9.noarch as a component of Red Hat Enterprise Linux AppStream (v. 9)",
          "product_id": "AppStream-9.5.0.GA:python3.11-PyMySQL+rsa-0:1.0.2-2.el9.noarch"
        },
        "product_reference": "python3.11-PyMySQL+rsa-0:1.0.2-2.el9.noarch",
        "relates_to_product_reference": "AppStream-9.5.0.GA"
      },
      {
        "category": "default_component_of",
        "full_product_name": {
          "name": "python3.11-PyMySQL-0:1.0.2-2.el9.noarch as a component of Red Hat Enterprise Linux AppStream (v. 9)",
          "product_id": "AppStream-9.5.0.GA:python3.11-PyMySQL-0:1.0.2-2.el9.noarch"
        },
        "product_reference": "python3.11-PyMySQL-0:1.0.2-2.el9.noarch",
        "relates_to_product_reference": "AppStream-9.5.0.GA"
      },
      {
        "category": "default_component_of",
        "full_product_name": {
          "name": "python3.11-PyMySQL-0:1.0.2-2.el9.src as a component of Red Hat Enterprise Linux AppStream (v. 9)",
          "product_id": "AppStream-9.5.0.GA:python3.11-PyMySQL-0:1.0.2-2.el9.src"
        },
        "product_reference": "python3.11-PyMySQL-0:1.0.2-2.el9.src",
        "relates_to_product_reference": "AppStream-9.5.0.GA"
      }
    ]
  },
  "vulnerabilities": [
    {
      "cve": "CVE-2024-36039",
      "cwe": {
        "id": "CWE-89",
        "name": "Improper Neutralization of Special Elements used in an SQL Command (\u0027SQL Injection\u0027)"
      },
      "discovery_date": "2024-05-21T00:00:00+00:00",
      "ids": [
        {
          "system_name": "Red Hat Bugzilla ID",
          "text": "2282821"
        }
      ],
      "notes": [
        {
          "category": "description",
          "text": "A flaw was found in PyMySQL. When processing untrusted JSON input, keys are not escaped by the escape_dict function due to insufficient input sanitization, allowing an attacker to inject malicious SQL queries.",
          "title": "Vulnerability description"
        },
        {
          "category": "summary",
          "text": "python-pymysql: SQL injection if used with untrusted JSON input",
          "title": "Vulnerability summary"
        },
        {
          "category": "other",
          "text": "Applications not exposed to untrusted JSON input are not vulnerable to this issue. Additionally, exploitation of this vulnerability depends on the permissions granted to the database user, limiting the security impact. For this reason, this flaw was rated with a Moderate severity.",
          "title": "Statement"
        },
        {
          "category": "general",
          "text": "The CVSS score(s) listed for this vulnerability do not reflect the associated product\u0027s status, and are included for informational purposes to better understand the severity of this vulnerability.",
          "title": "CVSS score applicability"
        }
      ],
      "product_status": {
        "fixed": [
          "AppStream-9.5.0.GA:python3.11-PyMySQL+rsa-0:1.0.2-2.el9.noarch",
          "AppStream-9.5.0.GA:python3.11-PyMySQL-0:1.0.2-2.el9.noarch",
          "AppStream-9.5.0.GA:python3.11-PyMySQL-0:1.0.2-2.el9.src"
        ]
      },
      "references": [
        {
          "category": "self",
          "summary": "Canonical URL",
          "url": "https://access.redhat.com/security/cve/CVE-2024-36039"
        },
        {
          "category": "external",
          "summary": "RHBZ#2282821",
          "url": "https://bugzilla.redhat.com/show_bug.cgi?id=2282821"
        },
        {
          "category": "external",
          "summary": "https://www.cve.org/CVERecord?id=CVE-2024-36039",
          "url": "https://www.cve.org/CVERecord?id=CVE-2024-36039"
        },
        {
          "category": "external",
          "summary": "https://nvd.nist.gov/vuln/detail/CVE-2024-36039",
          "url": "https://nvd.nist.gov/vuln/detail/CVE-2024-36039"
        }
      ],
      "release_date": "2024-05-21T00:00:00+00:00",
      "remediations": [
        {
          "category": "vendor_fix",
          "date": "2024-11-12T09:06:00+00:00",
          "details": "For details on how to apply this update, which includes the changes described in this advisory, refer to:\n\nhttps://access.redhat.com/articles/11258",
          "product_ids": [
            "AppStream-9.5.0.GA:python3.11-PyMySQL+rsa-0:1.0.2-2.el9.noarch",
            "AppStream-9.5.0.GA:python3.11-PyMySQL-0:1.0.2-2.el9.noarch",
            "AppStream-9.5.0.GA:python3.11-PyMySQL-0:1.0.2-2.el9.src"
          ],
          "restart_required": {
            "category": "none"
          },
          "url": "https://access.redhat.com/errata/RHSA-2024:9194"
        },
        {
          "category": "workaround",
          "details": "Make sure the permissions are set correctly for each user, database, table, operation, etc. Do not expose the PyMySQL library to untrusted JSON input.",
          "product_ids": [
            "AppStream-9.5.0.GA:python3.11-PyMySQL+rsa-0:1.0.2-2.el9.noarch",
            "AppStream-9.5.0.GA:python3.11-PyMySQL-0:1.0.2-2.el9.noarch",
            "AppStream-9.5.0.GA:python3.11-PyMySQL-0:1.0.2-2.el9.src"
          ]
        }
      ],
      "scores": [
        {
          "cvss_v3": {
            "attackComplexity": "LOW",
            "attackVector": "NETWORK",
            "availabilityImpact": "LOW",
            "baseScore": 6.3,
            "baseSeverity": "MEDIUM",
            "confidentialityImpact": "LOW",
            "integrityImpact": "LOW",
            "privilegesRequired": "LOW",
            "scope": "UNCHANGED",
            "userInteraction": "NONE",
            "vectorString": "CVSS:3.1/AV:N/AC:L/PR:L/UI:N/S:U/C:L/I:L/A:L",
            "version": "3.1"
          },
          "products": [
            "AppStream-9.5.0.GA:python3.11-PyMySQL+rsa-0:1.0.2-2.el9.noarch",
            "AppStream-9.5.0.GA:python3.11-PyMySQL-0:1.0.2-2.el9.noarch",
            "AppStream-9.5.0.GA:python3.11-PyMySQL-0:1.0.2-2.el9.src"
          ]
        }
      ],
      "threats": [
        {
          "category": "impact",
          "details": "Moderate"
        }
      ],
      "title": "python-pymysql: SQL injection if used with untrusted JSON input"
    }
  ]
}

{
  "document": {
    "aggregate_severity": {
      "namespace": "https://access.redhat.com/security/updates/classification/",
      "text": "Moderate"
    },
    "category": "csaf_security_advisory",
    "csaf_version": "2.0",
    "distribution": {
      "text": "Copyright \u00a9 Red Hat, Inc. All rights reserved.",
      "tlp": {
        "label": "WHITE",
        "url": "https://www.first.org/tlp/"
      }
    },
    "lang": "en",
    "notes": [
      {
        "category": "summary",
        "text": "An update for python3.11-PyMySQL is now available for Red Hat Enterprise Linux 8.\n\nRed Hat Product Security has rated this update as having a security impact of Moderate. A Common Vulnerability Scoring System (CVSS) base score, which gives a detailed severity rating, is available for each vulnerability from the CVE link(s) in the References section.",
        "title": "Topic"
      },
      {
        "category": "general",
        "text": "This package contains a pure-Python MySQL client library. The goal of PyMySQL is to be a drop-in replacement for MySQLdb and work on CPython, PyPy, IronPython and Jython.\n\nSecurity Fix(es):\n\n* python-pymysql: SQL injection if used with untrusted JSON input (CVE-2024-36039)\n\nFor more details about the security issue(s), including the impact, a CVSS score, acknowledgments, and other related information, refer the CVE page(s) listed in the References section.",
        "title": "Details"
      },
      {
        "category": "legal_disclaimer",
        "text": "This content is licensed under the Creative Commons Attribution 4.0 International License (https://creativecommons.org/licenses/by/4.0/). If you distribute this content, or a modified version of it, you must provide attribution to Red Hat Inc. and provide a link to the original.",
        "title": "Terms of Use"
      }
    ],
    "publisher": {
      "category": "vendor",
      "contact_details": "https://access.redhat.com/security/team/contact/",
      "issuing_authority": "Red Hat Product Security is responsible for vulnerability handling across all Red Hat products and services.",
      "name": "Red Hat Product Security",
      "namespace": "https://www.redhat.com"
    },
    "references": [
      {
        "category": "self",
        "summary": "https://access.redhat.com/errata/RHSA-2024:4244",
        "url": "https://access.redhat.com/errata/RHSA-2024:4244"
      },
      {
        "category": "external",
        "summary": "https://access.redhat.com/security/updates/classification/#moderate",
        "url": "https://access.redhat.com/security/updates/classification/#moderate"
      },
      {
        "category": "external",
        "summary": "2282821",
        "url": "https://bugzilla.redhat.com/show_bug.cgi?id=2282821"
      },
      {
        "category": "self",
        "summary": "Canonical URL",
        "url": "https://security.access.redhat.com/data/csaf/v2/advisories/2024/rhsa-2024_4244.json"
      }
    ],
    "title": "Red Hat Security Advisory: python3.11-PyMySQL security update",
    "tracking": {
      "current_release_date": "2024-11-13T21:11:38+00:00",
      "generator": {
        "date": "2024-11-13T21:11:38+00:00",
        "engine": {
          "name": "Red Hat SDEngine",
          "version": "4.2.0"
        }
      },
      "id": "RHSA-2024:4244",
      "initial_release_date": "2024-07-02T15:29:12+00:00",
      "revision_history": [
        {
          "date": "2024-07-02T15:29:12+00:00",
          "number": "1",
          "summary": "Initial version"
        },
        {
          "date": "2024-07-02T15:29:12+00:00",
          "number": "2",
          "summary": "Last updated version"
        },
        {
          "date": "2024-11-13T21:11:38+00:00",
          "number": "3",
          "summary": "Last generated version"
        }
      ],
      "status": "final",
      "version": "3"
    }
  },
  "product_tree": {
    "branches": [
      {
        "branches": [
          {
            "branches": [
              {
                "category": "product_name",
                "name": "Red Hat Enterprise Linux AppStream (v. 8)",
                "product": {
                  "name": "Red Hat Enterprise Linux AppStream (v. 8)",
                  "product_id": "AppStream-8.10.0.Z.MAIN.EUS",
                  "product_identification_helper": {
                    "cpe": "cpe:/a:redhat:enterprise_linux:8::appstream"
                  }
                }
              }
            ],
            "category": "product_family",
            "name": "Red Hat Enterprise Linux"
          },
          {
            "branches": [
              {
                "category": "product_version",
                "name": "python3.11-PyMySQL-0:1.0.2-2.el8_10.src",
                "product": {
                  "name": "python3.11-PyMySQL-0:1.0.2-2.el8_10.src",
                  "product_id": "python3.11-PyMySQL-0:1.0.2-2.el8_10.src",
                  "product_identification_helper": {
                    "purl": "pkg:rpm/redhat/python3.11-PyMySQL@1.0.2-2.el8_10?arch=src"
                  }
                }
              }
            ],
            "category": "architecture",
            "name": "src"
          },
          {
            "branches": [
              {
                "category": "product_version",
                "name": "python3.11-PyMySQL-0:1.0.2-2.el8_10.noarch",
                "product": {
                  "name": "python3.11-PyMySQL-0:1.0.2-2.el8_10.noarch",
                  "product_id": "python3.11-PyMySQL-0:1.0.2-2.el8_10.noarch",
                  "product_identification_helper": {
                    "purl": "pkg:rpm/redhat/python3.11-PyMySQL@1.0.2-2.el8_10?arch=noarch"
                  }
                }
              }
            ],
            "category": "architecture",
            "name": "noarch"
          }
        ],
        "category": "vendor",
        "name": "Red Hat"
      }
    ],
    "relationships": [
      {
        "category": "default_component_of",
        "full_product_name": {
          "name": "python3.11-PyMySQL-0:1.0.2-2.el8_10.noarch as a component of Red Hat Enterprise Linux AppStream (v. 8)",
          "product_id": "AppStream-8.10.0.Z.MAIN.EUS:python3.11-PyMySQL-0:1.0.2-2.el8_10.noarch"
        },
        "product_reference": "python3.11-PyMySQL-0:1.0.2-2.el8_10.noarch",
        "relates_to_product_reference": "AppStream-8.10.0.Z.MAIN.EUS"
      },
      {
        "category": "default_component_of",
        "full_product_name": {
          "name": "python3.11-PyMySQL-0:1.0.2-2.el8_10.src as a component of Red Hat Enterprise Linux AppStream (v. 8)",
          "product_id": "AppStream-8.10.0.Z.MAIN.EUS:python3.11-PyMySQL-0:1.0.2-2.el8_10.src"
        },
        "product_reference": "python3.11-PyMySQL-0:1.0.2-2.el8_10.src",
        "relates_to_product_reference": "AppStream-8.10.0.Z.MAIN.EUS"
      }
    ]
  },
  "vulnerabilities": [
    {
      "cve": "CVE-2024-36039",
      "cwe": {
        "id": "CWE-89",
        "name": "Improper Neutralization of Special Elements used in an SQL Command (\u0027SQL Injection\u0027)"
      },
      "discovery_date": "2024-05-21T00:00:00+00:00",
      "ids": [
        {
          "system_name": "Red Hat Bugzilla ID",
          "text": "2282821"
        }
      ],
      "notes": [
        {
          "category": "description",
          "text": "A flaw was found in PyMySQL. When processing untrusted JSON input, keys are not escaped by the escape_dict function due to insufficient input sanitization, allowing an attacker to inject malicious SQL queries.",
          "title": "Vulnerability description"
        },
        {
          "category": "summary",
          "text": "python-pymysql: SQL injection if used with untrusted JSON input",
          "title": "Vulnerability summary"
        },
        {
          "category": "other",
          "text": "Applications not exposed to untrusted JSON input are not vulnerable to this issue. Additionally, exploitation of this vulnerability depends on the permissions granted to the database user, limiting the security impact. For this reason, this flaw was rated with a Moderate severity.",
          "title": "Statement"
        },
        {
          "category": "general",
          "text": "The CVSS score(s) listed for this vulnerability do not reflect the associated product\u0027s status, and are included for informational purposes to better understand the severity of this vulnerability.",
          "title": "CVSS score applicability"
        }
      ],
      "product_status": {
        "fixed": [
          "AppStream-8.10.0.Z.MAIN.EUS:python3.11-PyMySQL-0:1.0.2-2.el8_10.noarch",
          "AppStream-8.10.0.Z.MAIN.EUS:python3.11-PyMySQL-0:1.0.2-2.el8_10.src"
        ]
      },
      "references": [
        {
          "category": "self",
          "summary": "Canonical URL",
          "url": "https://access.redhat.com/security/cve/CVE-2024-36039"
        },
        {
          "category": "external",
          "summary": "RHBZ#2282821",
          "url": "https://bugzilla.redhat.com/show_bug.cgi?id=2282821"
        },
        {
          "category": "external",
          "summary": "https://www.cve.org/CVERecord?id=CVE-2024-36039",
          "url": "https://www.cve.org/CVERecord?id=CVE-2024-36039"
        },
        {
          "category": "external",
          "summary": "https://nvd.nist.gov/vuln/detail/CVE-2024-36039",
          "url": "https://nvd.nist.gov/vuln/detail/CVE-2024-36039"
        }
      ],
      "release_date": "2024-05-21T00:00:00+00:00",
      "remediations": [
        {
          "category": "vendor_fix",
          "date": "2024-07-02T15:29:12+00:00",
          "details": "For details on how to apply this update, which includes the changes described in this advisory, refer to:\n\nhttps://access.redhat.com/articles/11258",
          "product_ids": [
            "AppStream-8.10.0.Z.MAIN.EUS:python3.11-PyMySQL-0:1.0.2-2.el8_10.noarch",
            "AppStream-8.10.0.Z.MAIN.EUS:python3.11-PyMySQL-0:1.0.2-2.el8_10.src"
          ],
          "restart_required": {
            "category": "none"
          },
          "url": "https://access.redhat.com/errata/RHSA-2024:4244"
        },
        {
          "category": "workaround",
          "details": "Make sure the permissions are set correctly for each user, database, table, operation, etc. Do not expose the PyMySQL library to untrusted JSON input.",
          "product_ids": [
            "AppStream-8.10.0.Z.MAIN.EUS:python3.11-PyMySQL-0:1.0.2-2.el8_10.noarch",
            "AppStream-8.10.0.Z.MAIN.EUS:python3.11-PyMySQL-0:1.0.2-2.el8_10.src"
          ]
        }
      ],
      "scores": [
        {
          "cvss_v3": {
            "attackComplexity": "LOW",
            "attackVector": "NETWORK",
            "availabilityImpact": "LOW",
            "baseScore": 6.3,
            "baseSeverity": "MEDIUM",
            "confidentialityImpact": "LOW",
            "integrityImpact": "LOW",
            "privilegesRequired": "LOW",
            "scope": "UNCHANGED",
            "userInteraction": "NONE",
            "vectorString": "CVSS:3.1/AV:N/AC:L/PR:L/UI:N/S:U/C:L/I:L/A:L",
            "version": "3.1"
          },
          "products": [
            "AppStream-8.10.0.Z.MAIN.EUS:python3.11-PyMySQL-0:1.0.2-2.el8_10.noarch",
            "AppStream-8.10.0.Z.MAIN.EUS:python3.11-PyMySQL-0:1.0.2-2.el8_10.src"
          ]
        }
      ],
      "threats": [
        {
          "category": "impact",
          "details": "Moderate"
        }
      ],
      "title": "python-pymysql: SQL injection if used with untrusted JSON input"
    }
  ]
}

{
  "document": {
    "aggregate_severity": {
      "namespace": "https://access.redhat.com/security/updates/classification/",
      "text": "Moderate"
    },
    "category": "csaf_security_advisory",
    "csaf_version": "2.0",
    "distribution": {
      "text": "Copyright \u00a9 Red Hat, Inc. All rights reserved.",
      "tlp": {
        "label": "WHITE",
        "url": "https://www.first.org/tlp/"
      }
    },
    "lang": "en",
    "notes": [
      {
        "category": "summary",
        "text": "An update for python3 is now available for Red Hat Enterprise Linux 8.\n\nRed Hat Product Security has rated this update as having a security impact of Moderate. A Common Vulnerability Scoring System (CVSS) base score, which gives a detailed severity rating, is available for each vulnerability from the CVE link(s) in the References section.",
        "title": "Topic"
      },
      {
        "category": "general",
        "text": "Python is an interpreted, interactive, object-oriented programming language, which includes modules, classes, exceptions, very high level dynamic data types and dynamic typing. Python supports interfaces to many system calls and libraries, as well as to various windowing systems.\n\nSecurity Fix(es):\n\n* python-pymysql: SQL injection if used with untrusted JSON input (CVE-2024-36039)\n\nFor more details about the security issue(s), including the impact, a CVSS score, acknowledgments, and other related information, refer to the CVE page(s) listed in the References section.",
        "title": "Details"
      },
      {
        "category": "legal_disclaimer",
        "text": "This content is licensed under the Creative Commons Attribution 4.0 International License (https://creativecommons.org/licenses/by/4.0/). If you distribute this content, or a modified version of it, you must provide attribution to Red Hat Inc. and provide a link to the original.",
        "title": "Terms of Use"
      }
    ],
    "publisher": {
      "category": "vendor",
      "contact_details": "https://access.redhat.com/security/team/contact/",
      "issuing_authority": "Red Hat Product Security is responsible for vulnerability handling across all Red Hat products and services.",
      "name": "Red Hat Product Security",
      "namespace": "https://www.redhat.com"
    },
    "references": [
      {
        "category": "self",
        "summary": "https://access.redhat.com/errata/RHSA-2024:4245",
        "url": "https://access.redhat.com/errata/RHSA-2024:4245"
      },
      {
        "category": "external",
        "summary": "https://access.redhat.com/security/updates/classification/#moderate",
        "url": "https://access.redhat.com/security/updates/classification/#moderate"
      },
      {
        "category": "external",
        "summary": "2282821",
        "url": "https://bugzilla.redhat.com/show_bug.cgi?id=2282821"
      },
      {
        "category": "self",
        "summary": "Canonical URL",
        "url": "https://security.access.redhat.com/data/csaf/v2/advisories/2024/rhsa-2024_4245.json"
      }
    ],
    "title": "Red Hat Security Advisory: python3 security update",
    "tracking": {
      "current_release_date": "2024-11-13T21:11:48+00:00",
      "generator": {
        "date": "2024-11-13T21:11:48+00:00",
        "engine": {
          "name": "Red Hat SDEngine",
          "version": "4.2.0"
        }
      },
      "id": "RHSA-2024:4245",
      "initial_release_date": "2024-07-02T15:24:34+00:00",
      "revision_history": [
        {
          "date": "2024-07-02T15:24:34+00:00",
          "number": "1",
          "summary": "Initial version"
        },
        {
          "date": "2024-07-02T15:24:35+00:00",
          "number": "2",
          "summary": "Last updated version"
        },
        {
          "date": "2024-11-13T21:11:48+00:00",
          "number": "3",
          "summary": "Last generated version"
        }
      ],
      "status": "final",
      "version": "3"
    }
  },
  "product_tree": {
    "branches": [
      {
        "branches": [
          {
            "branches": [
              {
                "category": "product_name",
                "name": "Red Hat Enterprise Linux AppStream (v. 8)",
                "product": {
                  "name": "Red Hat Enterprise Linux AppStream (v. 8)",
                  "product_id": "AppStream-8.10.0.Z.MAIN.EUS",
                  "product_identification_helper": {
                    "cpe": "cpe:/a:redhat:enterprise_linux:8::appstream"
                  }
                }
              }
            ],
            "category": "product_family",
            "name": "Red Hat Enterprise Linux"
          },
          {
            "branches": [
              {
                "category": "product_version",
                "name": "python3.12-PyMySQL-0:1.1.0-3.el8_10.src",
                "product": {
                  "name": "python3.12-PyMySQL-0:1.1.0-3.el8_10.src",
                  "product_id": "python3.12-PyMySQL-0:1.1.0-3.el8_10.src",
                  "product_identification_helper": {
                    "purl": "pkg:rpm/redhat/python3.12-PyMySQL@1.1.0-3.el8_10?arch=src"
                  }
                }
              }
            ],
            "category": "architecture",
            "name": "src"
          },
          {
            "branches": [
              {
                "category": "product_version",
                "name": "python3.12-PyMySQL-0:1.1.0-3.el8_10.noarch",
                "product": {
                  "name": "python3.12-PyMySQL-0:1.1.0-3.el8_10.noarch",
                  "product_id": "python3.12-PyMySQL-0:1.1.0-3.el8_10.noarch",
                  "product_identification_helper": {
                    "purl": "pkg:rpm/redhat/python3.12-PyMySQL@1.1.0-3.el8_10?arch=noarch"
                  }
                }
              }
            ],
            "category": "architecture",
            "name": "noarch"
          }
        ],
        "category": "vendor",
        "name": "Red Hat"
      }
    ],
    "relationships": [
      {
        "category": "default_component_of",
        "full_product_name": {
          "name": "python3.12-PyMySQL-0:1.1.0-3.el8_10.noarch as a component of Red Hat Enterprise Linux AppStream (v. 8)",
          "product_id": "AppStream-8.10.0.Z.MAIN.EUS:python3.12-PyMySQL-0:1.1.0-3.el8_10.noarch"
        },
        "product_reference": "python3.12-PyMySQL-0:1.1.0-3.el8_10.noarch",
        "relates_to_product_reference": "AppStream-8.10.0.Z.MAIN.EUS"
      },
      {
        "category": "default_component_of",
        "full_product_name": {
          "name": "python3.12-PyMySQL-0:1.1.0-3.el8_10.src as a component of Red Hat Enterprise Linux AppStream (v. 8)",
          "product_id": "AppStream-8.10.0.Z.MAIN.EUS:python3.12-PyMySQL-0:1.1.0-3.el8_10.src"
        },
        "product_reference": "python3.12-PyMySQL-0:1.1.0-3.el8_10.src",
        "relates_to_product_reference": "AppStream-8.10.0.Z.MAIN.EUS"
      }
    ]
  },
  "vulnerabilities": [
    {
      "cve": "CVE-2024-36039",
      "cwe": {
        "id": "CWE-89",
        "name": "Improper Neutralization of Special Elements used in an SQL Command (\u0027SQL Injection\u0027)"
      },
      "discovery_date": "2024-05-21T00:00:00+00:00",
      "ids": [
        {
          "system_name": "Red Hat Bugzilla ID",
          "text": "2282821"
        }
      ],
      "notes": [
        {
          "category": "description",
          "text": "A flaw was found in PyMySQL. When processing untrusted JSON input, keys are not escaped by the escape_dict function due to insufficient input sanitization, allowing an attacker to inject malicious SQL queries.",
          "title": "Vulnerability description"
        },
        {
          "category": "summary",
          "text": "python-pymysql: SQL injection if used with untrusted JSON input",
          "title": "Vulnerability summary"
        },
        {
          "category": "other",
          "text": "Applications not exposed to untrusted JSON input are not vulnerable to this issue. Additionally, exploitation of this vulnerability depends on the permissions granted to the database user, limiting the security impact. For this reason, this flaw was rated with a Moderate severity.",
          "title": "Statement"
        },
        {
          "category": "general",
          "text": "The CVSS score(s) listed for this vulnerability do not reflect the associated product\u0027s status, and are included for informational purposes to better understand the severity of this vulnerability.",
          "title": "CVSS score applicability"
        }
      ],
      "product_status": {
        "fixed": [
          "AppStream-8.10.0.Z.MAIN.EUS:python3.12-PyMySQL-0:1.1.0-3.el8_10.noarch",
          "AppStream-8.10.0.Z.MAIN.EUS:python3.12-PyMySQL-0:1.1.0-3.el8_10.src"
        ]
      },
      "references": [
        {
          "category": "self",
          "summary": "Canonical URL",
          "url": "https://access.redhat.com/security/cve/CVE-2024-36039"
        },
        {
          "category": "external",
          "summary": "RHBZ#2282821",
          "url": "https://bugzilla.redhat.com/show_bug.cgi?id=2282821"
        },
        {
          "category": "external",
          "summary": "https://www.cve.org/CVERecord?id=CVE-2024-36039",
          "url": "https://www.cve.org/CVERecord?id=CVE-2024-36039"
        },
        {
          "category": "external",
          "summary": "https://nvd.nist.gov/vuln/detail/CVE-2024-36039",
          "url": "https://nvd.nist.gov/vuln/detail/CVE-2024-36039"
        }
      ],
      "release_date": "2024-05-21T00:00:00+00:00",
      "remediations": [
        {
          "category": "vendor_fix",
          "date": "2024-07-02T15:24:34+00:00",
          "details": "For details on how to apply this update, which includes the changes described in this advisory, refer to:\n\nhttps://access.redhat.com/articles/11258",
          "product_ids": [
            "AppStream-8.10.0.Z.MAIN.EUS:python3.12-PyMySQL-0:1.1.0-3.el8_10.noarch",
            "AppStream-8.10.0.Z.MAIN.EUS:python3.12-PyMySQL-0:1.1.0-3.el8_10.src"
          ],
          "restart_required": {
            "category": "none"
          },
          "url": "https://access.redhat.com/errata/RHSA-2024:4245"
        },
        {
          "category": "workaround",
          "details": "Make sure the permissions are set correctly for each user, database, table, operation, etc. Do not expose the PyMySQL library to untrusted JSON input.",
          "product_ids": [
            "AppStream-8.10.0.Z.MAIN.EUS:python3.12-PyMySQL-0:1.1.0-3.el8_10.noarch",
            "AppStream-8.10.0.Z.MAIN.EUS:python3.12-PyMySQL-0:1.1.0-3.el8_10.src"
          ]
        }
      ],
      "scores": [
        {
          "cvss_v3": {
            "attackComplexity": "LOW",
            "attackVector": "NETWORK",
            "availabilityImpact": "LOW",
            "baseScore": 6.3,
            "baseSeverity": "MEDIUM",
            "confidentialityImpact": "LOW",
            "integrityImpact": "LOW",
            "privilegesRequired": "LOW",
            "scope": "UNCHANGED",
            "userInteraction": "NONE",
            "vectorString": "CVSS:3.1/AV:N/AC:L/PR:L/UI:N/S:U/C:L/I:L/A:L",
            "version": "3.1"
          },
          "products": [
            "AppStream-8.10.0.Z.MAIN.EUS:python3.12-PyMySQL-0:1.1.0-3.el8_10.noarch",
            "AppStream-8.10.0.Z.MAIN.EUS:python3.12-PyMySQL-0:1.1.0-3.el8_10.src"
          ]
        }
      ],
      "threats": [
        {
          "category": "impact",
          "details": "Moderate"
        }
      ],
      "title": "python-pymysql: SQL injection if used with untrusted JSON input"
    }
  ]
}

{
  "document": {
    "aggregate_severity": {
      "namespace": "https://access.redhat.com/security/updates/classification/",
      "text": "Moderate"
    },
    "category": "csaf_security_advisory",
    "csaf_version": "2.0",
    "distribution": {
      "text": "Copyright \u00a9 Red Hat, Inc. All rights reserved.",
      "tlp": {
        "label": "WHITE",
        "url": "https://www.first.org/tlp/"
      }
    },
    "lang": "en",
    "notes": [
      {
        "category": "summary",
        "text": "An update for python3.12-PyMySQL is now available for Red Hat Enterprise Linux 9.\n\nRed Hat Product Security has rated this update as having a security impact of Moderate. A Common Vulnerability Scoring System (CVSS) base score, which gives a detailed severity rating, is available for each vulnerability from the CVE link(s) in the References section.",
        "title": "Topic"
      },
      {
        "category": "general",
        "text": "This package contains a pure-Python MySQL client library. The goal of PyMySQL is to be a drop-in replacement for MySQLdb and work on CPython, PyPy, IronPython and Jython.\n\nSecurity Fix(es):\n\n* python-pymysql: SQL injection if used with untrusted JSON input (CVE-2024-36039)\n\nFor more details about the security issue(s), including the impact, a CVSS score, acknowledgments, and other related information, refer to the CVE page(s) listed in the References section.\n\nAdditional Changes:\n\nFor detailed information on changes in this release, see the Red Hat Enterprise Linux 9.5 Release Notes linked from the References section.",
        "title": "Details"
      },
      {
        "category": "legal_disclaimer",
        "text": "This content is licensed under the Creative Commons Attribution 4.0 International License (https://creativecommons.org/licenses/by/4.0/). If you distribute this content, or a modified version of it, you must provide attribution to Red Hat Inc. and provide a link to the original.",
        "title": "Terms of Use"
      }
    ],
    "publisher": {
      "category": "vendor",
      "contact_details": "https://access.redhat.com/security/team/contact/",
      "issuing_authority": "Red Hat Product Security is responsible for vulnerability handling across all Red Hat products and services.",
      "name": "Red Hat Product Security",
      "namespace": "https://www.redhat.com"
    },
    "references": [
      {
        "category": "self",
        "summary": "https://access.redhat.com/errata/RHSA-2024:9193",
        "url": "https://access.redhat.com/errata/RHSA-2024:9193"
      },
      {
        "category": "external",
        "summary": "https://docs.redhat.com/en/documentation/red_hat_enterprise_linux/9/html/9.5_release_notes/index",
        "url": "https://docs.redhat.com/en/documentation/red_hat_enterprise_linux/9/html/9.5_release_notes/index"
      },
      {
        "category": "external",
        "summary": "https://access.redhat.com/security/updates/classification/#moderate",
        "url": "https://access.redhat.com/security/updates/classification/#moderate"
      },
      {
        "category": "external",
        "summary": "2282821",
        "url": "https://bugzilla.redhat.com/show_bug.cgi?id=2282821"
      },
      {
        "category": "self",
        "summary": "Canonical URL",
        "url": "https://security.access.redhat.com/data/csaf/v2/advisories/2024/rhsa-2024_9193.json"
      }
    ],
    "title": "Red Hat Security Advisory: python3.12-PyMySQL security update",
    "tracking": {
      "current_release_date": "2024-11-13T21:19:07+00:00",
      "generator": {
        "date": "2024-11-13T21:19:07+00:00",
        "engine": {
          "name": "Red Hat SDEngine",
          "version": "4.2.0"
        }
      },
      "id": "RHSA-2024:9193",
      "initial_release_date": "2024-11-12T08:56:27+00:00",
      "revision_history": [
        {
          "date": "2024-11-12T08:56:27+00:00",
          "number": "1",
          "summary": "Initial version"
        },
        {
          "date": "2024-11-12T08:56:27+00:00",
          "number": "2",
          "summary": "Last updated version"
        },
        {
          "date": "2024-11-13T21:19:07+00:00",
          "number": "3",
          "summary": "Last generated version"
        }
      ],
      "status": "final",
      "version": "3"
    }
  },
  "product_tree": {
    "branches": [
      {
        "branches": [
          {
            "branches": [
              {
                "category": "product_name",
                "name": "Red Hat Enterprise Linux AppStream (v. 9)",
                "product": {
                  "name": "Red Hat Enterprise Linux AppStream (v. 9)",
                  "product_id": "AppStream-9.5.0.GA",
                  "product_identification_helper": {
                    "cpe": "cpe:/a:redhat:enterprise_linux:9::appstream"
                  }
                }
              }
            ],
            "category": "product_family",
            "name": "Red Hat Enterprise Linux"
          },
          {
            "branches": [
              {
                "category": "product_version",
                "name": "python3.12-PyMySQL+rsa-0:1.1.0-3.el9.noarch",
                "product": {
                  "name": "python3.12-PyMySQL+rsa-0:1.1.0-3.el9.noarch",
                  "product_id": "python3.12-PyMySQL+rsa-0:1.1.0-3.el9.noarch",
                  "product_identification_helper": {
                    "purl": "pkg:rpm/redhat/python3.12-PyMySQL%2Brsa@1.1.0-3.el9?arch=noarch"
                  }
                }
              },
              {
                "category": "product_version",
                "name": "python3.12-PyMySQL-0:1.1.0-3.el9.noarch",
                "product": {
                  "name": "python3.12-PyMySQL-0:1.1.0-3.el9.noarch",
                  "product_id": "python3.12-PyMySQL-0:1.1.0-3.el9.noarch",
                  "product_identification_helper": {
                    "purl": "pkg:rpm/redhat/python3.12-PyMySQL@1.1.0-3.el9?arch=noarch"
                  }
                }
              }
            ],
            "category": "architecture",
            "name": "noarch"
          },
          {
            "branches": [
              {
                "category": "product_version",
                "name": "python3.12-PyMySQL-0:1.1.0-3.el9.src",
                "product": {
                  "name": "python3.12-PyMySQL-0:1.1.0-3.el9.src",
                  "product_id": "python3.12-PyMySQL-0:1.1.0-3.el9.src",
                  "product_identification_helper": {
                    "purl": "pkg:rpm/redhat/python3.12-PyMySQL@1.1.0-3.el9?arch=src"
                  }
                }
              }
            ],
            "category": "architecture",
            "name": "src"
          }
        ],
        "category": "vendor",
        "name": "Red Hat"
      }
    ],
    "relationships": [
      {
        "category": "default_component_of",
        "full_product_name": {
          "name": "python3.12-PyMySQL+rsa-0:1.1.0-3.el9.noarch as a component of Red Hat Enterprise Linux AppStream (v. 9)",
          "product_id": "AppStream-9.5.0.GA:python3.12-PyMySQL+rsa-0:1.1.0-3.el9.noarch"
        },
        "product_reference": "python3.12-PyMySQL+rsa-0:1.1.0-3.el9.noarch",
        "relates_to_product_reference": "AppStream-9.5.0.GA"
      },
      {
        "category": "default_component_of",
        "full_product_name": {
          "name": "python3.12-PyMySQL-0:1.1.0-3.el9.noarch as a component of Red Hat Enterprise Linux AppStream (v. 9)",
          "product_id": "AppStream-9.5.0.GA:python3.12-PyMySQL-0:1.1.0-3.el9.noarch"
        },
        "product_reference": "python3.12-PyMySQL-0:1.1.0-3.el9.noarch",
        "relates_to_product_reference": "AppStream-9.5.0.GA"
      },
      {
        "category": "default_component_of",
        "full_product_name": {
          "name": "python3.12-PyMySQL-0:1.1.0-3.el9.src as a component of Red Hat Enterprise Linux AppStream (v. 9)",
          "product_id": "AppStream-9.5.0.GA:python3.12-PyMySQL-0:1.1.0-3.el9.src"
        },
        "product_reference": "python3.12-PyMySQL-0:1.1.0-3.el9.src",
        "relates_to_product_reference": "AppStream-9.5.0.GA"
      }
    ]
  },
  "vulnerabilities": [
    {
      "cve": "CVE-2024-36039",
      "cwe": {
        "id": "CWE-89",
        "name": "Improper Neutralization of Special Elements used in an SQL Command (\u0027SQL Injection\u0027)"
      },
      "discovery_date": "2024-05-21T00:00:00+00:00",
      "ids": [
        {
          "system_name": "Red Hat Bugzilla ID",
          "text": "2282821"
        }
      ],
      "notes": [
        {
          "category": "description",
          "text": "A flaw was found in PyMySQL. When processing untrusted JSON input, keys are not escaped by the escape_dict function due to insufficient input sanitization, allowing an attacker to inject malicious SQL queries.",
          "title": "Vulnerability description"
        },
        {
          "category": "summary",
          "text": "python-pymysql: SQL injection if used with untrusted JSON input",
          "title": "Vulnerability summary"
        },
        {
          "category": "other",
          "text": "Applications not exposed to untrusted JSON input are not vulnerable to this issue. Additionally, exploitation of this vulnerability depends on the permissions granted to the database user, limiting the security impact. For this reason, this flaw was rated with a Moderate severity.",
          "title": "Statement"
        },
        {
          "category": "general",
          "text": "The CVSS score(s) listed for this vulnerability do not reflect the associated product\u0027s status, and are included for informational purposes to better understand the severity of this vulnerability.",
          "title": "CVSS score applicability"
        }
      ],
      "product_status": {
        "fixed": [
          "AppStream-9.5.0.GA:python3.12-PyMySQL+rsa-0:1.1.0-3.el9.noarch",
          "AppStream-9.5.0.GA:python3.12-PyMySQL-0:1.1.0-3.el9.noarch",
          "AppStream-9.5.0.GA:python3.12-PyMySQL-0:1.1.0-3.el9.src"
        ]
      },
      "references": [
        {
          "category": "self",
          "summary": "Canonical URL",
          "url": "https://access.redhat.com/security/cve/CVE-2024-36039"
        },
        {
          "category": "external",
          "summary": "RHBZ#2282821",
          "url": "https://bugzilla.redhat.com/show_bug.cgi?id=2282821"
        },
        {
          "category": "external",
          "summary": "https://www.cve.org/CVERecord?id=CVE-2024-36039",
          "url": "https://www.cve.org/CVERecord?id=CVE-2024-36039"
        },
        {
          "category": "external",
          "summary": "https://nvd.nist.gov/vuln/detail/CVE-2024-36039",
          "url": "https://nvd.nist.gov/vuln/detail/CVE-2024-36039"
        }
      ],
      "release_date": "2024-05-21T00:00:00+00:00",
      "remediations": [
        {
          "category": "vendor_fix",
          "date": "2024-11-12T08:56:27+00:00",
          "details": "For details on how to apply this update, which includes the changes described in this advisory, refer to:\n\nhttps://access.redhat.com/articles/11258",
          "product_ids": [
            "AppStream-9.5.0.GA:python3.12-PyMySQL+rsa-0:1.1.0-3.el9.noarch",
            "AppStream-9.5.0.GA:python3.12-PyMySQL-0:1.1.0-3.el9.noarch",
            "AppStream-9.5.0.GA:python3.12-PyMySQL-0:1.1.0-3.el9.src"
          ],
          "restart_required": {
            "category": "none"
          },
          "url": "https://access.redhat.com/errata/RHSA-2024:9193"
        },
        {
          "category": "workaround",
          "details": "Make sure the permissions are set correctly for each user, database, table, operation, etc. Do not expose the PyMySQL library to untrusted JSON input.",
          "product_ids": [
            "AppStream-9.5.0.GA:python3.12-PyMySQL+rsa-0:1.1.0-3.el9.noarch",
            "AppStream-9.5.0.GA:python3.12-PyMySQL-0:1.1.0-3.el9.noarch",
            "AppStream-9.5.0.GA:python3.12-PyMySQL-0:1.1.0-3.el9.src"
          ]
        }
      ],
      "scores": [
        {
          "cvss_v3": {
            "attackComplexity": "LOW",
            "attackVector": "NETWORK",
            "availabilityImpact": "LOW",
            "baseScore": 6.3,
            "baseSeverity": "MEDIUM",
            "confidentialityImpact": "LOW",
            "integrityImpact": "LOW",
            "privilegesRequired": "LOW",
            "scope": "UNCHANGED",
            "userInteraction": "NONE",
            "vectorString": "CVSS:3.1/AV:N/AC:L/PR:L/UI:N/S:U/C:L/I:L/A:L",
            "version": "3.1"
          },
          "products": [
            "AppStream-9.5.0.GA:python3.12-PyMySQL+rsa-0:1.1.0-3.el9.noarch",
            "AppStream-9.5.0.GA:python3.12-PyMySQL-0:1.1.0-3.el9.noarch",
            "AppStream-9.5.0.GA:python3.12-PyMySQL-0:1.1.0-3.el9.src"
          ]
        }
      ],
      "threats": [
        {
          "category": "impact",
          "details": "Moderate"
        }
      ],
      "title": "python-pymysql: SQL injection if used with untrusted JSON input"
    }
  ]
}

{
  "document": {
    "aggregate_severity": {
      "namespace": "https://access.redhat.com/security/updates/classification/",
      "text": "Moderate"
    },
    "category": "csaf_security_advisory",
    "csaf_version": "2.0",
    "distribution": {
      "text": "Copyright \u00a9 Red Hat, Inc. All rights reserved.",
      "tlp": {
        "label": "WHITE",
        "url": "https://www.first.org/tlp/"
      }
    },
    "lang": "en",
    "notes": [
      {
        "category": "summary",
        "text": "An update for python3.11-PyMySQL is now available for Red Hat Enterprise Linux 9.\n\nRed Hat Product Security has rated this update as having a security impact of Moderate. A Common Vulnerability Scoring System (CVSS) base score, which gives a detailed severity rating, is available for each vulnerability from the CVE link(s) in the References section.",
        "title": "Topic"
      },
      {
        "category": "general",
        "text": "This package contains a pure-Python MySQL client library. The goal of PyMySQL is to be a drop-in replacement for MySQLdb and work on CPython, PyPy, IronPython and Jython.\n\nSecurity Fix(es):\n\n* python-pymysql: SQL injection if used with untrusted JSON input (CVE-2024-36039)\n\nFor more details about the security issue(s), including the impact, a CVSS score, acknowledgments, and other related information, refer to the CVE page(s) listed in the References section.\n\nAdditional Changes:\n\nFor detailed information on changes in this release, see the Red Hat Enterprise Linux 9.5 Release Notes linked from the References section.",
        "title": "Details"
      },
      {
        "category": "legal_disclaimer",
        "text": "This content is licensed under the Creative Commons Attribution 4.0 International License (https://creativecommons.org/licenses/by/4.0/). If you distribute this content, or a modified version of it, you must provide attribution to Red Hat Inc. and provide a link to the original.",
        "title": "Terms of Use"
      }
    ],
    "publisher": {
      "category": "vendor",
      "contact_details": "https://access.redhat.com/security/team/contact/",
      "issuing_authority": "Red Hat Product Security is responsible for vulnerability handling across all Red Hat products and services.",
      "name": "Red Hat Product Security",
      "namespace": "https://www.redhat.com"
    },
    "references": [
      {
        "category": "self",
        "summary": "https://access.redhat.com/errata/RHSA-2024:9194",
        "url": "https://access.redhat.com/errata/RHSA-2024:9194"
      },
      {
        "category": "external",
        "summary": "https://docs.redhat.com/en/documentation/red_hat_enterprise_linux/9/html/9.5_release_notes/index",
        "url": "https://docs.redhat.com/en/documentation/red_hat_enterprise_linux/9/html/9.5_release_notes/index"
      },
      {
        "category": "external",
        "summary": "https://access.redhat.com/security/updates/classification/#moderate",
        "url": "https://access.redhat.com/security/updates/classification/#moderate"
      },
      {
        "category": "external",
        "summary": "2282821",
        "url": "https://bugzilla.redhat.com/show_bug.cgi?id=2282821"
      },
      {
        "category": "self",
        "summary": "Canonical URL",
        "url": "https://security.access.redhat.com/data/csaf/v2/advisories/2024/rhsa-2024_9194.json"
      }
    ],
    "title": "Red Hat Security Advisory: python3.11-PyMySQL security update",
    "tracking": {
      "current_release_date": "2024-11-13T21:19:17+00:00",
      "generator": {
        "date": "2024-11-13T21:19:17+00:00",
        "engine": {
          "name": "Red Hat SDEngine",
          "version": "4.2.0"
        }
      },
      "id": "RHSA-2024:9194",
      "initial_release_date": "2024-11-12T09:06:00+00:00",
      "revision_history": [
        {
          "date": "2024-11-12T09:06:00+00:00",
          "number": "1",
          "summary": "Initial version"
        },
        {
          "date": "2024-11-12T09:06:00+00:00",
          "number": "2",
          "summary": "Last updated version"
        },
        {
          "date": "2024-11-13T21:19:17+00:00",
          "number": "3",
          "summary": "Last generated version"
        }
      ],
      "status": "final",
      "version": "3"
    }
  },
  "product_tree": {
    "branches": [
      {
        "branches": [
          {
            "branches": [
              {
                "category": "product_name",
                "name": "Red Hat Enterprise Linux AppStream (v. 9)",
                "product": {
                  "name": "Red Hat Enterprise Linux AppStream (v. 9)",
                  "product_id": "AppStream-9.5.0.GA",
                  "product_identification_helper": {
                    "cpe": "cpe:/a:redhat:enterprise_linux:9::appstream"
                  }
                }
              }
            ],
            "category": "product_family",
            "name": "Red Hat Enterprise Linux"
          },
          {
            "branches": [
              {
                "category": "product_version",
                "name": "python3.11-PyMySQL+rsa-0:1.0.2-2.el9.noarch",
                "product": {
                  "name": "python3.11-PyMySQL+rsa-0:1.0.2-2.el9.noarch",
                  "product_id": "python3.11-PyMySQL+rsa-0:1.0.2-2.el9.noarch",
                  "product_identification_helper": {
                    "purl": "pkg:rpm/redhat/python3.11-PyMySQL%2Brsa@1.0.2-2.el9?arch=noarch"
                  }
                }
              },
              {
                "category": "product_version",
                "name": "python3.11-PyMySQL-0:1.0.2-2.el9.noarch",
                "product": {
                  "name": "python3.11-PyMySQL-0:1.0.2-2.el9.noarch",
                  "product_id": "python3.11-PyMySQL-0:1.0.2-2.el9.noarch",
                  "product_identification_helper": {
                    "purl": "pkg:rpm/redhat/python3.11-PyMySQL@1.0.2-2.el9?arch=noarch"
                  }
                }
              }
            ],
            "category": "architecture",
            "name": "noarch"
          },
          {
            "branches": [
              {
                "category": "product_version",
                "name": "python3.11-PyMySQL-0:1.0.2-2.el9.src",
                "product": {
                  "name": "python3.11-PyMySQL-0:1.0.2-2.el9.src",
                  "product_id": "python3.11-PyMySQL-0:1.0.2-2.el9.src",
                  "product_identification_helper": {
                    "purl": "pkg:rpm/redhat/python3.11-PyMySQL@1.0.2-2.el9?arch=src"
                  }
                }
              }
            ],
            "category": "architecture",
            "name": "src"
          }
        ],
        "category": "vendor",
        "name": "Red Hat"
      }
    ],
    "relationships": [
      {
        "category": "default_component_of",
        "full_product_name": {
          "name": "python3.11-PyMySQL+rsa-0:1.0.2-2.el9.noarch as a component of Red Hat Enterprise Linux AppStream (v. 9)",
          "product_id": "AppStream-9.5.0.GA:python3.11-PyMySQL+rsa-0:1.0.2-2.el9.noarch"
        },
        "product_reference": "python3.11-PyMySQL+rsa-0:1.0.2-2.el9.noarch",
        "relates_to_product_reference": "AppStream-9.5.0.GA"
      },
      {
        "category": "default_component_of",
        "full_product_name": {
          "name": "python3.11-PyMySQL-0:1.0.2-2.el9.noarch as a component of Red Hat Enterprise Linux AppStream (v. 9)",
          "product_id": "AppStream-9.5.0.GA:python3.11-PyMySQL-0:1.0.2-2.el9.noarch"
        },
        "product_reference": "python3.11-PyMySQL-0:1.0.2-2.el9.noarch",
        "relates_to_product_reference": "AppStream-9.5.0.GA"
      },
      {
        "category": "default_component_of",
        "full_product_name": {
          "name": "python3.11-PyMySQL-0:1.0.2-2.el9.src as a component of Red Hat Enterprise Linux AppStream (v. 9)",
          "product_id": "AppStream-9.5.0.GA:python3.11-PyMySQL-0:1.0.2-2.el9.src"
        },
        "product_reference": "python3.11-PyMySQL-0:1.0.2-2.el9.src",
        "relates_to_product_reference": "AppStream-9.5.0.GA"
      }
    ]
  },
  "vulnerabilities": [
    {
      "cve": "CVE-2024-36039",
      "cwe": {
        "id": "CWE-89",
        "name": "Improper Neutralization of Special Elements used in an SQL Command (\u0027SQL Injection\u0027)"
      },
      "discovery_date": "2024-05-21T00:00:00+00:00",
      "ids": [
        {
          "system_name": "Red Hat Bugzilla ID",
          "text": "2282821"
        }
      ],
      "notes": [
        {
          "category": "description",
          "text": "A flaw was found in PyMySQL. When processing untrusted JSON input, keys are not escaped by the escape_dict function due to insufficient input sanitization, allowing an attacker to inject malicious SQL queries.",
          "title": "Vulnerability description"
        },
        {
          "category": "summary",
          "text": "python-pymysql: SQL injection if used with untrusted JSON input",
          "title": "Vulnerability summary"
        },
        {
          "category": "other",
          "text": "Applications not exposed to untrusted JSON input are not vulnerable to this issue. Additionally, exploitation of this vulnerability depends on the permissions granted to the database user, limiting the security impact. For this reason, this flaw was rated with a Moderate severity.",
          "title": "Statement"
        },
        {
          "category": "general",
          "text": "The CVSS score(s) listed for this vulnerability do not reflect the associated product\u0027s status, and are included for informational purposes to better understand the severity of this vulnerability.",
          "title": "CVSS score applicability"
        }
      ],
      "product_status": {
        "fixed": [
          "AppStream-9.5.0.GA:python3.11-PyMySQL+rsa-0:1.0.2-2.el9.noarch",
          "AppStream-9.5.0.GA:python3.11-PyMySQL-0:1.0.2-2.el9.noarch",
          "AppStream-9.5.0.GA:python3.11-PyMySQL-0:1.0.2-2.el9.src"
        ]
      },
      "references": [
        {
          "category": "self",
          "summary": "Canonical URL",
          "url": "https://access.redhat.com/security/cve/CVE-2024-36039"
        },
        {
          "category": "external",
          "summary": "RHBZ#2282821",
          "url": "https://bugzilla.redhat.com/show_bug.cgi?id=2282821"
        },
        {
          "category": "external",
          "summary": "https://www.cve.org/CVERecord?id=CVE-2024-36039",
          "url": "https://www.cve.org/CVERecord?id=CVE-2024-36039"
        },
        {
          "category": "external",
          "summary": "https://nvd.nist.gov/vuln/detail/CVE-2024-36039",
          "url": "https://nvd.nist.gov/vuln/detail/CVE-2024-36039"
        }
      ],
      "release_date": "2024-05-21T00:00:00+00:00",
      "remediations": [
        {
          "category": "vendor_fix",
          "date": "2024-11-12T09:06:00+00:00",
          "details": "For details on how to apply this update, which includes the changes described in this advisory, refer to:\n\nhttps://access.redhat.com/articles/11258",
          "product_ids": [
            "AppStream-9.5.0.GA:python3.11-PyMySQL+rsa-0:1.0.2-2.el9.noarch",
            "AppStream-9.5.0.GA:python3.11-PyMySQL-0:1.0.2-2.el9.noarch",
            "AppStream-9.5.0.GA:python3.11-PyMySQL-0:1.0.2-2.el9.src"
          ],
          "restart_required": {
            "category": "none"
          },
          "url": "https://access.redhat.com/errata/RHSA-2024:9194"
        },
        {
          "category": "workaround",
          "details": "Make sure the permissions are set correctly for each user, database, table, operation, etc. Do not expose the PyMySQL library to untrusted JSON input.",
          "product_ids": [
            "AppStream-9.5.0.GA:python3.11-PyMySQL+rsa-0:1.0.2-2.el9.noarch",
            "AppStream-9.5.0.GA:python3.11-PyMySQL-0:1.0.2-2.el9.noarch",
            "AppStream-9.5.0.GA:python3.11-PyMySQL-0:1.0.2-2.el9.src"
          ]
        }
      ],
      "scores": [
        {
          "cvss_v3": {
            "attackComplexity": "LOW",
            "attackVector": "NETWORK",
            "availabilityImpact": "LOW",
            "baseScore": 6.3,
            "baseSeverity": "MEDIUM",
            "confidentialityImpact": "LOW",
            "integrityImpact": "LOW",
            "privilegesRequired": "LOW",
            "scope": "UNCHANGED",
            "userInteraction": "NONE",
            "vectorString": "CVSS:3.1/AV:N/AC:L/PR:L/UI:N/S:U/C:L/I:L/A:L",
            "version": "3.1"
          },
          "products": [
            "AppStream-9.5.0.GA:python3.11-PyMySQL+rsa-0:1.0.2-2.el9.noarch",
            "AppStream-9.5.0.GA:python3.11-PyMySQL-0:1.0.2-2.el9.noarch",
            "AppStream-9.5.0.GA:python3.11-PyMySQL-0:1.0.2-2.el9.src"
          ]
        }
      ],
      "threats": [
        {
          "category": "impact",
          "details": "Moderate"
        }
      ],
      "title": "python-pymysql: SQL injection if used with untrusted JSON input"
    }
  ]
}

{
  "document": {
    "aggregate_severity": {
      "namespace": "https://www.suse.com/support/security/rating/",
      "text": "important"
    },
    "category": "csaf_security_advisory",
    "csaf_version": "2.0",
    "distribution": {
      "text": "Copyright 2024 SUSE LLC. All rights reserved.",
      "tlp": {
        "label": "WHITE",
        "url": "https://www.first.org/tlp/"
      }
    },
    "lang": "en",
    "notes": [
      {
        "category": "summary",
        "text": "Security update for python-PyMySQL",
        "title": "Title of the patch"
      },
      {
        "category": "description",
        "text": "This update for python-PyMySQL fixes the following issues:\n\n- CVE-2024-36039: Fixed SQL injection if used with untrusted JSON input (bsc#1225070).\n",
        "title": "Description of the patch"
      },
      {
        "category": "details",
        "text": "SUSE-2024-1855,SUSE-SLE-Module-Packagehub-Subpackages-15-SP5-2024-1855,SUSE-SLE-Module-Packagehub-Subpackages-15-SP6-2024-1855,openSUSE-SLE-15.5-2024-1855",
        "title": "Patchnames"
      },
      {
        "category": "legal_disclaimer",
        "text": "CSAF 2.0 data is provided by SUSE under the Creative Commons License 4.0 with Attribution (CC-BY-4.0).",
        "title": "Terms of use"
      }
    ],
    "publisher": {
      "category": "vendor",
      "contact_details": "https://www.suse.com/support/security/contact/",
      "name": "SUSE Product Security Team",
      "namespace": "https://www.suse.com/"
    },
    "references": [
      {
        "category": "external",
        "summary": "SUSE ratings",
        "url": "https://www.suse.com/support/security/rating/"
      },
      {
        "category": "self",
        "summary": "URL of this CSAF notice",
        "url": "https://ftp.suse.com/pub/projects/security/csaf/suse-su-2024_1855-1.json"
      },
      {
        "category": "self",
        "summary": "URL for SUSE-SU-2024:1855-1",
        "url": "https://www.suse.com/support/update/announcement/2024/suse-su-20241855-1/"
      },
      {
        "category": "self",
        "summary": "E-Mail link for SUSE-SU-2024:1855-1",
        "url": "https://lists.suse.com/pipermail/sle-security-updates/2024-August/019265.html"
      },
      {
        "category": "self",
        "summary": "SUSE Bug 1225070",
        "url": "https://bugzilla.suse.com/1225070"
      },
      {
        "category": "self",
        "summary": "SUSE CVE CVE-2024-36039 page",
        "url": "https://www.suse.com/security/cve/CVE-2024-36039/"
      }
    ],
    "title": "Security update for python-PyMySQL",
    "tracking": {
      "current_release_date": "2024-05-30T12:11:59Z",
      "generator": {
        "date": "2024-05-30T12:11:59Z",
        "engine": {
          "name": "cve-database.git:bin/generate-csaf.pl",
          "version": "1"
        }
      },
      "id": "SUSE-SU-2024:1855-1",
      "initial_release_date": "2024-05-30T12:11:59Z",
      "revision_history": [
        {
          "date": "2024-05-30T12:11:59Z",
          "number": "1",
          "summary": "Current version"
        }
      ],
      "status": "final",
      "version": "1"
    }
  },
  "product_tree": {
    "branches": [
      {
        "branches": [
          {
            "branches": [
              {
                "category": "product_version",
                "name": "python2-PyMySQL-0.7.11-150000.3.3.1.noarch",
                "product": {
                  "name": "python2-PyMySQL-0.7.11-150000.3.3.1.noarch",
                  "product_id": "python2-PyMySQL-0.7.11-150000.3.3.1.noarch"
                }
              },
              {
                "category": "product_version",
                "name": "python3-PyMySQL-0.7.11-150000.3.3.1.noarch",
                "product": {
                  "name": "python3-PyMySQL-0.7.11-150000.3.3.1.noarch",
                  "product_id": "python3-PyMySQL-0.7.11-150000.3.3.1.noarch"
                }
              }
            ],
            "category": "architecture",
            "name": "noarch"
          },
          {
            "branches": [
              {
                "category": "product_name",
                "name": "SUSE Linux Enterprise Module for Package Hub 15 SP5",
                "product": {
                  "name": "SUSE Linux Enterprise Module for Package Hub 15 SP5",
                  "product_id": "SUSE Linux Enterprise Module for Package Hub 15 SP5",
                  "product_identification_helper": {
                    "cpe": "cpe:/o:suse:packagehub:15:sp5"
                  }
                }
              },
              {
                "category": "product_name",
                "name": "SUSE Linux Enterprise Module for Package Hub 15 SP6",
                "product": {
                  "name": "SUSE Linux Enterprise Module for Package Hub 15 SP6",
                  "product_id": "SUSE Linux Enterprise Module for Package Hub 15 SP6",
                  "product_identification_helper": {
                    "cpe": "cpe:/o:suse:packagehub:15:sp6"
                  }
                }
              },
              {
                "category": "product_name",
                "name": "openSUSE Leap 15.5",
                "product": {
                  "name": "openSUSE Leap 15.5",
                  "product_id": "openSUSE Leap 15.5",
                  "product_identification_helper": {
                    "cpe": "cpe:/o:opensuse:leap:15.5"
                  }
                }
              }
            ],
            "category": "product_family",
            "name": "SUSE Linux Enterprise"
          }
        ],
        "category": "vendor",
        "name": "SUSE"
      }
    ],
    "relationships": [
      {
        "category": "default_component_of",
        "full_product_name": {
          "name": "python3-PyMySQL-0.7.11-150000.3.3.1.noarch as component of SUSE Linux Enterprise Module for Package Hub 15 SP5",
          "product_id": "SUSE Linux Enterprise Module for Package Hub 15 SP5:python3-PyMySQL-0.7.11-150000.3.3.1.noarch"
        },
        "product_reference": "python3-PyMySQL-0.7.11-150000.3.3.1.noarch",
        "relates_to_product_reference": "SUSE Linux Enterprise Module for Package Hub 15 SP5"
      },
      {
        "category": "default_component_of",
        "full_product_name": {
          "name": "python3-PyMySQL-0.7.11-150000.3.3.1.noarch as component of SUSE Linux Enterprise Module for Package Hub 15 SP6",
          "product_id": "SUSE Linux Enterprise Module for Package Hub 15 SP6:python3-PyMySQL-0.7.11-150000.3.3.1.noarch"
        },
        "product_reference": "python3-PyMySQL-0.7.11-150000.3.3.1.noarch",
        "relates_to_product_reference": "SUSE Linux Enterprise Module for Package Hub 15 SP6"
      },
      {
        "category": "default_component_of",
        "full_product_name": {
          "name": "python3-PyMySQL-0.7.11-150000.3.3.1.noarch as component of openSUSE Leap 15.5",
          "product_id": "openSUSE Leap 15.5:python3-PyMySQL-0.7.11-150000.3.3.1.noarch"
        },
        "product_reference": "python3-PyMySQL-0.7.11-150000.3.3.1.noarch",
        "relates_to_product_reference": "openSUSE Leap 15.5"
      }
    ]
  },
  "vulnerabilities": [
    {
      "cve": "CVE-2024-36039",
      "ids": [
        {
          "system_name": "SUSE CVE Page",
          "text": "https://www.suse.com/security/cve/CVE-2024-36039"
        }
      ],
      "notes": [
        {
          "category": "general",
          "text": "PyMySQL through 1.1.0 allows SQL injection if used with untrusted JSON input because keys are not escaped by escape_dict.",
          "title": "CVE description"
        }
      ],
      "product_status": {
        "recommended": [
          "SUSE Linux Enterprise Module for Package Hub 15 SP5:python3-PyMySQL-0.7.11-150000.3.3.1.noarch",
          "SUSE Linux Enterprise Module for Package Hub 15 SP6:python3-PyMySQL-0.7.11-150000.3.3.1.noarch",
          "openSUSE Leap 15.5:python3-PyMySQL-0.7.11-150000.3.3.1.noarch"
        ]
      },
      "references": [
        {
          "category": "external",
          "summary": "CVE-2024-36039",
          "url": "https://www.suse.com/security/cve/CVE-2024-36039"
        },
        {
          "category": "external",
          "summary": "SUSE Bug 1225070 for CVE-2024-36039",
          "url": "https://bugzilla.suse.com/1225070"
        }
      ],
      "remediations": [
        {
          "category": "vendor_fix",
          "details": "To install this SUSE Security Update use the SUSE recommended installation methods like YaST online_update or \"zypper patch\".\n",
          "product_ids": [
            "SUSE Linux Enterprise Module for Package Hub 15 SP5:python3-PyMySQL-0.7.11-150000.3.3.1.noarch",
            "SUSE Linux Enterprise Module for Package Hub 15 SP6:python3-PyMySQL-0.7.11-150000.3.3.1.noarch",
            "openSUSE Leap 15.5:python3-PyMySQL-0.7.11-150000.3.3.1.noarch"
          ]
        }
      ],
      "scores": [
        {
          "cvss_v3": {
            "baseScore": 8.1,
            "baseSeverity": "HIGH",
            "vectorString": "CVSS:3.1/AV:N/AC:H/PR:N/UI:N/S:U/C:H/I:H/A:H",
            "version": "3.1"
          },
          "products": [
            "SUSE Linux Enterprise Module for Package Hub 15 SP5:python3-PyMySQL-0.7.11-150000.3.3.1.noarch",
            "SUSE Linux Enterprise Module for Package Hub 15 SP6:python3-PyMySQL-0.7.11-150000.3.3.1.noarch",
            "openSUSE Leap 15.5:python3-PyMySQL-0.7.11-150000.3.3.1.noarch"
          ]
        }
      ],
      "threats": [
        {
          "category": "impact",
          "date": "2024-05-30T12:11:59Z",
          "details": "important"
        }
      ],
      "title": "CVE-2024-36039"
    }
  ]
}

{
  "document": {
    "aggregate_severity": {
      "namespace": "https://www.suse.com/support/security/rating/",
      "text": "important"
    },
    "category": "csaf_security_advisory",
    "csaf_version": "2.0",
    "distribution": {
      "text": "Copyright 2024 SUSE LLC. All rights reserved.",
      "tlp": {
        "label": "WHITE",
        "url": "https://www.first.org/tlp/"
      }
    },
    "lang": "en",
    "notes": [
      {
        "category": "summary",
        "text": "Security update for python-PyMySQL",
        "title": "Title of the patch"
      },
      {
        "category": "description",
        "text": "This update for python-PyMySQL fixes the following issues:\n\n- CVE-2024-36039: Fixed SQL injection when used with untrusted JSON input (bsc#1225070).\n",
        "title": "Description of the patch"
      },
      {
        "category": "details",
        "text": "SUSE-2024-1925,openSUSE-SLE-15.6-2024-1925",
        "title": "Patchnames"
      },
      {
        "category": "legal_disclaimer",
        "text": "CSAF 2.0 data is provided by SUSE under the Creative Commons License 4.0 with Attribution (CC-BY-4.0).",
        "title": "Terms of use"
      }
    ],
    "publisher": {
      "category": "vendor",
      "contact_details": "https://www.suse.com/support/security/contact/",
      "name": "SUSE Product Security Team",
      "namespace": "https://www.suse.com/"
    },
    "references": [
      {
        "category": "external",
        "summary": "SUSE ratings",
        "url": "https://www.suse.com/support/security/rating/"
      },
      {
        "category": "self",
        "summary": "URL of this CSAF notice",
        "url": "https://ftp.suse.com/pub/projects/security/csaf/suse-su-2024_1925-1.json"
      },
      {
        "category": "self",
        "summary": "URL for SUSE-SU-2024:1925-1",
        "url": "https://www.suse.com/support/update/announcement/2024/suse-su-20241925-1/"
      },
      {
        "category": "self",
        "summary": "E-Mail link for SUSE-SU-2024:1925-1",
        "url": "https://lists.suse.com/pipermail/sle-security-updates/2024-June/018656.html"
      },
      {
        "category": "self",
        "summary": "SUSE Bug 1225070",
        "url": "https://bugzilla.suse.com/1225070"
      },
      {
        "category": "self",
        "summary": "SUSE CVE CVE-2024-36039 page",
        "url": "https://www.suse.com/security/cve/CVE-2024-36039/"
      }
    ],
    "title": "Security update for python-PyMySQL",
    "tracking": {
      "current_release_date": "2024-06-05T11:51:49Z",
      "generator": {
        "date": "2024-06-05T11:51:49Z",
        "engine": {
          "name": "cve-database.git:bin/generate-csaf.pl",
          "version": "1"
        }
      },
      "id": "SUSE-SU-2024:1925-1",
      "initial_release_date": "2024-06-05T11:51:49Z",
      "revision_history": [
        {
          "date": "2024-06-05T11:51:49Z",
          "number": "1",
          "summary": "Current version"
        }
      ],
      "status": "final",
      "version": "1"
    }
  },
  "product_tree": {
    "branches": [
      {
        "branches": [
          {
            "branches": [
              {
                "category": "product_version",
                "name": "python311-PyMySQL-1.1.0-150600.3.3.1.noarch",
                "product": {
                  "name": "python311-PyMySQL-1.1.0-150600.3.3.1.noarch",
                  "product_id": "python311-PyMySQL-1.1.0-150600.3.3.1.noarch"
                }
              }
            ],
            "category": "architecture",
            "name": "noarch"
          },
          {
            "branches": [
              {
                "category": "product_name",
                "name": "openSUSE Leap 15.6",
                "product": {
                  "name": "openSUSE Leap 15.6",
                  "product_id": "openSUSE Leap 15.6",
                  "product_identification_helper": {
                    "cpe": "cpe:/o:opensuse:leap:15.6"
                  }
                }
              }
            ],
            "category": "product_family",
            "name": "SUSE Linux Enterprise"
          }
        ],
        "category": "vendor",
        "name": "SUSE"
      }
    ],
    "relationships": [
      {
        "category": "default_component_of",
        "full_product_name": {
          "name": "python311-PyMySQL-1.1.0-150600.3.3.1.noarch as component of openSUSE Leap 15.6",
          "product_id": "openSUSE Leap 15.6:python311-PyMySQL-1.1.0-150600.3.3.1.noarch"
        },
        "product_reference": "python311-PyMySQL-1.1.0-150600.3.3.1.noarch",
        "relates_to_product_reference": "openSUSE Leap 15.6"
      }
    ]
  },
  "vulnerabilities": [
    {
      "cve": "CVE-2024-36039",
      "ids": [
        {
          "system_name": "SUSE CVE Page",
          "text": "https://www.suse.com/security/cve/CVE-2024-36039"
        }
      ],
      "notes": [
        {
          "category": "general",
          "text": "PyMySQL through 1.1.0 allows SQL injection if used with untrusted JSON input because keys are not escaped by escape_dict.",
          "title": "CVE description"
        }
      ],
      "product_status": {
        "recommended": [
          "openSUSE Leap 15.6:python311-PyMySQL-1.1.0-150600.3.3.1.noarch"
        ]
      },
      "references": [
        {
          "category": "external",
          "summary": "CVE-2024-36039",
          "url": "https://www.suse.com/security/cve/CVE-2024-36039"
        },
        {
          "category": "external",
          "summary": "SUSE Bug 1225070 for CVE-2024-36039",
          "url": "https://bugzilla.suse.com/1225070"
        }
      ],
      "remediations": [
        {
          "category": "vendor_fix",
          "details": "To install this SUSE Security Update use the SUSE recommended installation methods like YaST online_update or \"zypper patch\".\n",
          "product_ids": [
            "openSUSE Leap 15.6:python311-PyMySQL-1.1.0-150600.3.3.1.noarch"
          ]
        }
      ],
      "scores": [
        {
          "cvss_v3": {
            "baseScore": 8.1,
            "baseSeverity": "HIGH",
            "vectorString": "CVSS:3.1/AV:N/AC:H/PR:N/UI:N/S:U/C:H/I:H/A:H",
            "version": "3.1"
          },
          "products": [
            "openSUSE Leap 15.6:python311-PyMySQL-1.1.0-150600.3.3.1.noarch"
          ]
        }
      ],
      "threats": [
        {
          "category": "impact",
          "date": "2024-06-05T11:51:49Z",
          "details": "important"
        }
      ],
      "title": "CVE-2024-36039"
    }
  ]
}

{
  "document": {
    "aggregate_severity": {
      "text": "mittel"
    },
    "category": "csaf_base",
    "csaf_version": "2.0",
    "distribution": {
      "tlp": {
        "label": "WHITE",
        "url": "https://www.first.org/tlp/"
      }
    },
    "lang": "de-DE",
    "notes": [
      {
        "category": "legal_disclaimer",
        "text": "Das BSI ist als Anbieter f\u00fcr die eigenen, zur Nutzung bereitgestellten Inhalte nach den allgemeinen Gesetzen verantwortlich. Nutzerinnen und Nutzer sind jedoch daf\u00fcr verantwortlich, die Verwendung und/oder die Umsetzung der mit den Inhalten bereitgestellten Informationen sorgf\u00e4ltig im Einzelfall zu pr\u00fcfen."
      },
      {
        "category": "description",
        "text": "Red Hat Enterprise Linux (RHEL) ist eine popul\u00e4re Linux-Distribution.",
        "title": "Produktbeschreibung"
      },
      {
        "category": "summary",
        "text": "Ein entfernter, authentisierter Angreifer kann eine Schwachstelle in Red Hat Enterprise Linux ausnutzen, um eine SQL Injection durchzuf\u00fchren.",
        "title": "Angriff"
      },
      {
        "category": "general",
        "text": "- UNIX",
        "title": "Betroffene Betriebssysteme"
      }
    ],
    "publisher": {
      "category": "other",
      "contact_details": "csaf-provider@cert-bund.de",
      "name": "Bundesamt f\u00fcr Sicherheit in der Informationstechnik",
      "namespace": "https://www.bsi.bund.de"
    },
    "references": [
      {
        "category": "self",
        "summary": "WID-SEC-W-2024-1513 - CSAF Version",
        "url": "https://wid.cert-bund.de/.well-known/csaf/white/2024/wid-sec-w-2024-1513.json"
      },
      {
        "category": "self",
        "summary": "WID-SEC-2024-1513 - Portal Version",
        "url": "https://wid.cert-bund.de/portal/wid/securityadvisory?name=WID-SEC-2024-1513"
      },
      {
        "category": "external",
        "summary": "Red Hat Security Advisory vom 2024-07-02",
        "url": "https://access.redhat.com/errata/RHSA-2024:4244"
      },
      {
        "category": "external",
        "summary": "Red Hat Security Advisory vom 2024-07-02",
        "url": "https://access.redhat.com/errata/RHSA-2024:4245"
      },
      {
        "category": "external",
        "summary": "Oracle Linux Security Advisory ELSA-2024-4245 vom 2024-07-04",
        "url": "https://linux.oracle.com/errata/ELSA-2024-4245.html"
      },
      {
        "category": "external",
        "summary": "Oracle Linux Security Advisory ELSA-2024-4244 vom 2024-07-03",
        "url": "https://linux.oracle.com/errata/ELSA-2024-4244.html"
      },
      {
        "category": "external",
        "summary": "Red Hat Security Advisory RHSA-2024:9193 vom 2024-11-12",
        "url": "https://access.redhat.com/errata/RHSA-2024:9193"
      },
      {
        "category": "external",
        "summary": "Red Hat Security Advisory RHSA-2024:9194 vom 2024-11-12",
        "url": "https://access.redhat.com/errata/RHSA-2024:9194"
      }
    ],
    "source_lang": "en-US",
    "title": "Red Hat Enterprise Linux (PyMySQL): Schwachstelle erm\u00f6glicht SQL Injection",
    "tracking": {
      "current_release_date": "2024-11-11T23:00:00.000+00:00",
      "generator": {
        "date": "2024-11-12T12:16:51.036+00:00",
        "engine": {
          "name": "BSI-WID",
          "version": "1.3.8"
        }
      },
      "id": "WID-SEC-W-2024-1513",
      "initial_release_date": "2024-07-02T22:00:00.000+00:00",
      "revision_history": [
        {
          "date": "2024-07-02T22:00:00.000+00:00",
          "number": "1",
          "summary": "Initiale Fassung"
        },
        {
          "date": "2024-07-03T22:00:00.000+00:00",
          "number": "2",
          "summary": "Neue Updates von Oracle Linux aufgenommen"
        },
        {
          "date": "2024-11-11T23:00:00.000+00:00",
          "number": "3",
          "summary": "Neue Updates von Red Hat aufgenommen"
        }
      ],
      "status": "final",
      "version": "3"
    }
  },
  "product_tree": {
    "branches": [
      {
        "branches": [
          {
            "category": "product_name",
            "name": "Oracle Linux",
            "product": {
              "name": "Oracle Linux",
              "product_id": "T004914",
              "product_identification_helper": {
                "cpe": "cpe:/o:oracle:linux:-"
              }
            }
          }
        ],
        "category": "vendor",
        "name": "Oracle"
      },
      {
        "branches": [
          {
            "branches": [
              {
                "category": "product_name",
                "name": "Red Hat Enterprise Linux",
                "product": {
                  "name": "Red Hat Enterprise Linux",
                  "product_id": "67646",
                  "product_identification_helper": {
                    "cpe": "cpe:/o:redhat:enterprise_linux:-"
                  }
                }
              },
              {
                "category": "product_version_range",
                "name": "pymysql \u003c1.1.1",
                "product": {
                  "name": "Red Hat Enterprise Linux pymysql \u003c1.1.1",
                  "product_id": "T035779"
                }
              },
              {
                "category": "product_version",
                "name": "pymysql 1.1.1",
                "product": {
                  "name": "Red Hat Enterprise Linux pymysql 1.1.1",
                  "product_id": "T035779-fixed",
                  "product_identification_helper": {
                    "cpe": "cpe:/o:redhat:enterprise_linux:pymysql__1.1.1"
                  }
                }
              }
            ],
            "category": "product_name",
            "name": "Enterprise Linux"
          }
        ],
        "category": "vendor",
        "name": "Red Hat"
      }
    ]
  },
  "vulnerabilities": [
    {
      "cve": "CVE-2024-36039",
      "notes": [
        {
          "category": "description",
          "text": "Es existiert eine Schwachstelle in Red Hat Enterprise Linux, die PyMySQL betrifft, da die Eingaben nicht ausreichend bereinigt werden. Dieser Fehler f\u00fchrt dazu, dass die Schl\u00fcssel von der escape_dict-Funktion nicht entschl\u00fcsselt werden, was die Einspeisung von b\u00f6sartigen SQL-Abfragen erm\u00f6glicht. Ein entfernter, authentisierter Angreifer kann diese Schwachstelle ausnutzen, um einen SQL-Injection Angriff durchzuf\u00fchren."
        }
      ],
      "product_status": {
        "known_affected": [
          "T035779",
          "67646",
          "T004914"
        ]
      },
      "release_date": "2024-07-02T22:00:00.000+00:00",
      "title": "CVE-2024-36039"
    }
  ]
}