{
  "document": {
    "aggregate_severity": {
      "namespace": "https://www.suse.com/support/security/rating/",
      "text": "moderate"
    },
    "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-sqlparse",
        "title": "Title of the patch"
      },
      {
        "category": "description",
        "text": "This update for python-sqlparse fixes the following issues:\n\n- CVE-2021-32839: Fixed ReDoS via regular expression in StripComments filter (bsc#1190741).\n",
        "title": "Description of the patch"
      },
      {
        "category": "details",
        "text": "SUSE-2021-3857,SUSE-SLE-Module-Basesystem-15-SP3-2021-3857",
        "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-2021_3857-1.json"
      },
      {
        "category": "self",
        "summary": "URL for SUSE-SU-2021:3857-1",
        "url": "https://www.suse.com/support/update/announcement/2021/suse-su-20213857-1/"
      },
      {
        "category": "self",
        "summary": "E-Mail link for SUSE-SU-2021:3857-1",
        "url": "https://lists.suse.com/pipermail/sle-security-updates/2021-December/009797.html"
      },
      {
        "category": "self",
        "summary": "SUSE Bug 1190741",
        "url": "https://bugzilla.suse.com/1190741"
      },
      {
        "category": "self",
        "summary": "SUSE CVE CVE-2021-32839 page",
        "url": "https://www.suse.com/security/cve/CVE-2021-32839/"
      }
    ],
    "title": "Security update for python-sqlparse",
    "tracking": {
      "current_release_date": "2021-12-01T16:02:13Z",
      "generator": {
        "date": "2021-12-01T16:02:13Z",
        "engine": {
          "name": "cve-database.git:bin/generate-csaf.pl",
          "version": "1"
        }
      },
      "id": "SUSE-SU-2021:3857-1",
      "initial_release_date": "2021-12-01T16:02:13Z",
      "revision_history": [
        {
          "date": "2021-12-01T16:02:13Z",
          "number": "1",
          "summary": "Current version"
        }
      ],
      "status": "final",
      "version": "1"
    }
  },
  "product_tree": {
    "branches": [
      {
        "branches": [
          {
            "branches": [
              {
                "category": "product_version",
                "name": "python3-sqlparse-0.4.2-3.3.1.noarch",
                "product": {
                  "name": "python3-sqlparse-0.4.2-3.3.1.noarch",
                  "product_id": "python3-sqlparse-0.4.2-3.3.1.noarch"
                }
              }
            ],
            "category": "architecture",
            "name": "noarch"
          },
          {
            "branches": [
              {
                "category": "product_name",
                "name": "SUSE Linux Enterprise Module for Basesystem 15 SP3",
                "product": {
                  "name": "SUSE Linux Enterprise Module for Basesystem 15 SP3",
                  "product_id": "SUSE Linux Enterprise Module for Basesystem 15 SP3",
                  "product_identification_helper": {
                    "cpe": "cpe:/o:suse:sle-module-basesystem:15:sp3"
                  }
                }
              }
            ],
            "category": "product_family",
            "name": "SUSE Linux Enterprise"
          }
        ],
        "category": "vendor",
        "name": "SUSE"
      }
    ],
    "relationships": [
      {
        "category": "default_component_of",
        "full_product_name": {
          "name": "python3-sqlparse-0.4.2-3.3.1.noarch as component of SUSE Linux Enterprise Module for Basesystem 15 SP3",
          "product_id": "SUSE Linux Enterprise Module for Basesystem 15 SP3:python3-sqlparse-0.4.2-3.3.1.noarch"
        },
        "product_reference": "python3-sqlparse-0.4.2-3.3.1.noarch",
        "relates_to_product_reference": "SUSE Linux Enterprise Module for Basesystem 15 SP3"
      }
    ]
  },
  "vulnerabilities": [
    {
      "cve": "CVE-2021-32839",
      "ids": [
        {
          "system_name": "SUSE CVE Page",
          "text": "https://www.suse.com/security/cve/CVE-2021-32839"
        }
      ],
      "notes": [
        {
          "category": "general",
          "text": "sqlparse is a non-validating SQL parser module for Python. In sqlparse versions 0.4.0 and 0.4.1 there is a regular Expression Denial of Service in sqlparse vulnerability. The regular expression may cause exponential backtracking on strings containing many repetitions of \u0027\\r\\n\u0027 in SQL comments. Only the formatting feature that removes comments from SQL statements is affected by this regular expression. As a workaround don\u0027t use the sqlformat.format function with keyword strip_comments=True or the --strip-comments command line flag when using the sqlformat command line tool. The issues has been fixed in sqlparse 0.4.2.",
          "title": "CVE description"
        }
      ],
      "product_status": {
        "recommended": [
          "SUSE Linux Enterprise Module for Basesystem 15 SP3:python3-sqlparse-0.4.2-3.3.1.noarch"
        ]
      },
      "references": [
        {
          "category": "external",
          "summary": "CVE-2021-32839",
          "url": "https://www.suse.com/security/cve/CVE-2021-32839"
        },
        {
          "category": "external",
          "summary": "SUSE Bug 1190741 for CVE-2021-32839",
          "url": "https://bugzilla.suse.com/1190741"
        }
      ],
      "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 Basesystem 15 SP3:python3-sqlparse-0.4.2-3.3.1.noarch"
          ]
        }
      ],
      "scores": [
        {
          "cvss_v3": {
            "baseScore": 6.5,
            "baseSeverity": "MEDIUM",
            "vectorString": "CVSS:3.1/AV:N/AC:L/PR:L/UI:N/S:U/C:N/I:N/A:H",
            "version": "3.1"
          },
          "products": [
            "SUSE Linux Enterprise Module for Basesystem 15 SP3:python3-sqlparse-0.4.2-3.3.1.noarch"
          ]
        }
      ],
      "threats": [
        {
          "category": "impact",
          "date": "2021-12-01T16:02:13Z",
          "details": "moderate"
        }
      ],
      "title": "CVE-2021-32839"
    }
  ]
}