{
  "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": "openSUSE-SLE-15.3-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/opensuse-su-2021_3857-1.json"
      },
      {
        "category": "self",
        "summary": "URL for openSUSE-SU-2021:3857-1",
        "url": "https://lists.opensuse.org/archives/list/security-announce@lists.opensuse.org/thread/IYCTMYSALFWYSEWJYEO6WJYBAK6J5D4X/"
      },
      {
        "category": "self",
        "summary": "E-Mail link for openSUSE-SU-2021:3857-1",
        "url": "https://lists.opensuse.org/archives/list/security-announce@lists.opensuse.org/thread/IYCTMYSALFWYSEWJYEO6WJYBAK6J5D4X/"
      },
      {
        "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": "2026-09-20T19:36:32Z",
      "generator": {
        "date": "2021-12-01T16:02:14Z",
        "engine": {
          "name": "cve-database.git:bin/generate-csaf.pl",
          "version": "1"
        }
      },
      "id": "openSUSE-SU-2021:3857-1",
      "initial_release_date": "2021-12-01T16:02:14Z",
      "revision_history": [
        {
          "date": "2021-12-01T16:02:14Z",
          "number": "1",
          "summary": "Current version"
        },
        {
          "date": "2026-09-20T19:36:32Z",
          "number": "2",
          "summary": "unknown changes"
        }
      ],
      "status": "final",
      "version": "2"
    }
  },
  "product_tree": {
    "branches": [
      {
        "branches": [
          {
            "branches": [
              {
                "category": "product_version",
                "name": "python3-sqlparse-0:0.4.2-3.3.1.noarch",
                "product": {
                  "name": "python3-sqlparse-0:0.4.2-3.3.1.noarch",
                  "product_id": "python3-sqlparse-0:0.4.2-3.3.1.noarch",
                  "product_identification_helper": {
                    "purl": "pkg:rpm/suse/python3-sqlparse@0.4.2-3.3.1?arch=noarch\u0026upstream=python3-sqlparse-0:0.4.2-3.3.1.src.rpm"
                  }
                }
              }
            ],
            "category": "architecture",
            "name": "noarch"
          },
          {
            "branches": [
              {
                "category": "product_name",
                "name": "openSUSE Leap 15.3",
                "product": {
                  "name": "openSUSE Leap 15.3",
                  "product_id": "openSUSE Leap 15.3",
                  "product_identification_helper": {
                    "cpe": "cpe:/o:opensuse:leap:15.3"
                  }
                }
              }
            ],
            "category": "product_family",
            "name": "SUSE Linux Enterprise"
          }
        ],
        "category": "vendor",
        "name": "SUSE"
      }
    ],
    "relationships": [
      {
        "category": "default_component_of",
        "full_product_name": {
          "name": "python3-sqlparse-0:0.4.2-3.3.1.noarch as component of openSUSE Leap 15.3",
          "product_id": "openSUSE Leap 15.3:python3-sqlparse-0:0.4.2-3.3.1.noarch"
        },
        "product_reference": "python3-sqlparse-0:0.4.2-3.3.1.noarch",
        "relates_to_product_reference": "openSUSE Leap 15.3"
      }
    ]
  },
  "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": [
          "openSUSE Leap 15.3:python3-sqlparse-0: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": [
            "openSUSE Leap 15.3:python3-sqlparse-0: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": [
            "openSUSE Leap 15.3:python3-sqlparse-0:0.4.2-3.3.1.noarch"
          ]
        }
      ],
      "threats": [
        {
          "category": "impact",
          "date": "2021-12-01T16:02:14Z",
          "details": "moderate"
        }
      ],
      "title": "CVE-2021-32839"
    }
  ]
}