Vulnerability-Lookup

SUSE-SU-2024:1861-1

Vulnerability from csaf_suse - Published: 2024-05-30 12:16 - Updated: 2024-05-30 12:16

Summary

Security update for python3-sqlparse

Severity

Important

Notes

Title of the patch: Security update for python3-sqlparse

Description of the patch: This update for python3-sqlparse fixes the following issues: - CVE-2024-4340: Fixed RecursionError catch to avoid a denial-of-service issue (bsc#1223603).

Patchnames: SUSE-2024-1861,SUSE-SLE-Module-Basesystem-15-SP5-2024-1861,SUSE-SLE-Module-Basesystem-15-SP6-2024-1861,SUSE-SLE-Product-HPC-15-SP3-LTSS-2024-1861,SUSE-SLE-Product-HPC-15-SP4-ESPOS-2024-1861,SUSE-SLE-Product-HPC-15-SP4-LTSS-2024-1861,SUSE-SLE-Product-SLED-15-SP4-LTSS-2024-1861,SUSE-SLE-Product-SLES-15-SP3-LTSS-2024-1861,SUSE-SLE-Product-SLES-15-SP4-LTSS-2024-1861,SUSE-SLE-Product-SLES_SAP-15-SP3-2024-1861,SUSE-SLE-Product-SLES_SAP-15-SP4-2024-1861,SUSE-SLE-Product-SUSE-Manager-Proxy-4.3-2024-1861,SUSE-SLE-Product-SUSE-Manager-Server-4.3-2024-1861,SUSE-Storage-7.1-2024-1861,openSUSE-SLE-15.5-2024-1861

CVE-2024-4340

7.5 (High)


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

Affected products

Recommended 13 products

Product	Version	Remediation
Unresolved product id: SUSE Enterprise Storage 7.1:python3-sqlparse-0.4.2-150300.12.1.noarch	—	Vendor Fix
Unresolved product id: SUSE Linux Enterprise High Performance Computing 15 SP3-LTSS:python3-sqlparse-0.4.2-150300.12.1.noarch	—	Vendor Fix
Unresolved product id: SUSE Linux Enterprise High Performance Computing 15 SP4-ESPOS:python3-sqlparse-0.4.2-150300.12.1.noarch	—	Vendor Fix
Unresolved product id: SUSE Linux Enterprise High Performance Computing 15 SP4-LTSS:python3-sqlparse-0.4.2-150300.12.1.noarch	—	Vendor Fix
Unresolved product id: SUSE Linux Enterprise Module for Basesystem 15 SP5:python3-sqlparse-0.4.2-150300.12.1.noarch	—	Vendor Fix
Unresolved product id: SUSE Linux Enterprise Module for Basesystem 15 SP6:python3-sqlparse-0.4.2-150300.12.1.noarch	—	Vendor Fix
Unresolved product id: SUSE Linux Enterprise Server 15 SP3-LTSS:python3-sqlparse-0.4.2-150300.12.1.noarch	—	Vendor Fix
Unresolved product id: SUSE Linux Enterprise Server 15 SP4-LTSS:python3-sqlparse-0.4.2-150300.12.1.noarch	—	Vendor Fix
Unresolved product id: SUSE Linux Enterprise Server for SAP Applications 15 SP3:python3-sqlparse-0.4.2-150300.12.1.noarch	—	Vendor Fix
Unresolved product id: SUSE Linux Enterprise Server for SAP Applications 15 SP4:python3-sqlparse-0.4.2-150300.12.1.noarch	—	Vendor Fix
Unresolved product id: SUSE Manager Proxy 4.3:python3-sqlparse-0.4.2-150300.12.1.noarch	—	Vendor Fix
Unresolved product id: SUSE Manager Server 4.3:python3-sqlparse-0.4.2-150300.12.1.noarch	—	Vendor Fix
Unresolved product id: openSUSE Leap 15.5:python3-sqlparse-0.4.2-150300.12.1.noarch	—	Vendor Fix

Threats

Impact important

References

8 references

URL	Category
https://www.suse.com/support/security/rating/	external
https://ftp.suse.com/pub/projects/security/csaf/s…	self
https://www.suse.com/support/update/announcement/…	self
https://lists.suse.com/pipermail/sle-security-upd…	self
https://bugzilla.suse.com/1223603	self
https://www.suse.com/security/cve/CVE-2024-4340/	self
https://www.suse.com/security/cve/CVE-2024-4340	external
https://bugzilla.suse.com/1223603	external

JSON

To clipboard

{
  "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 python3-sqlparse",
        "title": "Title of the patch"
      },
      {
        "category": "description",
        "text": "This update for python3-sqlparse fixes the following issues:\n\n- CVE-2024-4340: Fixed RecursionError catch to avoid a denial-of-service issue (bsc#1223603).\n",
        "title": "Description of the patch"
      },
      {
        "category": "details",
        "text": "SUSE-2024-1861,SUSE-SLE-Module-Basesystem-15-SP5-2024-1861,SUSE-SLE-Module-Basesystem-15-SP6-2024-1861,SUSE-SLE-Product-HPC-15-SP3-LTSS-2024-1861,SUSE-SLE-Product-HPC-15-SP4-ESPOS-2024-1861,SUSE-SLE-Product-HPC-15-SP4-LTSS-2024-1861,SUSE-SLE-Product-SLED-15-SP4-LTSS-2024-1861,SUSE-SLE-Product-SLES-15-SP3-LTSS-2024-1861,SUSE-SLE-Product-SLES-15-SP4-LTSS-2024-1861,SUSE-SLE-Product-SLES_SAP-15-SP3-2024-1861,SUSE-SLE-Product-SLES_SAP-15-SP4-2024-1861,SUSE-SLE-Product-SUSE-Manager-Proxy-4.3-2024-1861,SUSE-SLE-Product-SUSE-Manager-Server-4.3-2024-1861,SUSE-Storage-7.1-2024-1861,openSUSE-SLE-15.5-2024-1861",
        "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_1861-1.json"
      },
      {
        "category": "self",
        "summary": "URL for SUSE-SU-2024:1861-1",
        "url": "https://www.suse.com/support/update/announcement/2024/suse-su-20241861-1/"
      },
      {
        "category": "self",
        "summary": "E-Mail link for SUSE-SU-2024:1861-1",
        "url": "https://lists.suse.com/pipermail/sle-security-updates/2024-August/019255.html"
      },
      {
        "category": "self",
        "summary": "SUSE Bug 1223603",
        "url": "https://bugzilla.suse.com/1223603"
      },
      {
        "category": "self",
        "summary": "SUSE CVE CVE-2024-4340 page",
        "url": "https://www.suse.com/security/cve/CVE-2024-4340/"
      }
    ],
    "title": "Security update for python3-sqlparse",
    "tracking": {
      "current_release_date": "2024-05-30T12:16:37Z",
      "generator": {
        "date": "2024-05-30T12:16:37Z",
        "engine": {
          "name": "cve-database.git:bin/generate-csaf.pl",
          "version": "1"
        }
      },
      "id": "SUSE-SU-2024:1861-1",
      "initial_release_date": "2024-05-30T12:16:37Z",
      "revision_history": [
        {
          "date": "2024-05-30T12:16:37Z",
          "number": "1",
          "summary": "Current version"
        }
      ],
      "status": "final",
      "version": "1"
    }
  },
  "product_tree": {
    "branches": [
      {
        "branches": [
          {
            "branches": [
              {
                "category": "product_version",
                "name": "python3-sqlparse-0.4.2-150300.12.1.noarch",
                "product": {
                  "name": "python3-sqlparse-0.4.2-150300.12.1.noarch",
                  "product_id": "python3-sqlparse-0.4.2-150300.12.1.noarch"
                }
              }
            ],
            "category": "architecture",
            "name": "noarch"
          },
          {
            "branches": [
              {
                "category": "product_name",
                "name": "SUSE Linux Enterprise Module for Basesystem 15 SP5",
                "product": {
                  "name": "SUSE Linux Enterprise Module for Basesystem 15 SP5",
                  "product_id": "SUSE Linux Enterprise Module for Basesystem 15 SP5",
                  "product_identification_helper": {
                    "cpe": "cpe:/o:suse:sle-module-basesystem:15:sp5"
                  }
                }
              },
              {
                "category": "product_name",
                "name": "SUSE Linux Enterprise Module for Basesystem 15 SP6",
                "product": {
                  "name": "SUSE Linux Enterprise Module for Basesystem 15 SP6",
                  "product_id": "SUSE Linux Enterprise Module for Basesystem 15 SP6",
                  "product_identification_helper": {
                    "cpe": "cpe:/o:suse:sle-module-basesystem:15:sp6"
                  }
                }
              },
              {
                "category": "product_name",
                "name": "SUSE Linux Enterprise High Performance Computing 15 SP3-LTSS",
                "product": {
                  "name": "SUSE Linux Enterprise High Performance Computing 15 SP3-LTSS",
                  "product_id": "SUSE Linux Enterprise High Performance Computing 15 SP3-LTSS",
                  "product_identification_helper": {
                    "cpe": "cpe:/o:suse:sle_hpc-ltss:15:sp3"
                  }
                }
              },
              {
                "category": "product_name",
                "name": "SUSE Linux Enterprise High Performance Computing 15 SP4-ESPOS",
                "product": {
                  "name": "SUSE Linux Enterprise High Performance Computing 15 SP4-ESPOS",
                  "product_id": "SUSE Linux Enterprise High Performance Computing 15 SP4-ESPOS",
                  "product_identification_helper": {
                    "cpe": "cpe:/o:suse:sle_hpc-espos:15:sp4"
                  }
                }
              },
              {
                "category": "product_name",
                "name": "SUSE Linux Enterprise High Performance Computing 15 SP4-LTSS",
                "product": {
                  "name": "SUSE Linux Enterprise High Performance Computing 15 SP4-LTSS",
                  "product_id": "SUSE Linux Enterprise High Performance Computing 15 SP4-LTSS",
                  "product_identification_helper": {
                    "cpe": "cpe:/o:suse:sle_hpc-ltss:15:sp4"
                  }
                }
              },
              {
                "category": "product_name",
                "name": "SUSE Linux Enterprise Server 15 SP3-LTSS",
                "product": {
                  "name": "SUSE Linux Enterprise Server 15 SP3-LTSS",
                  "product_id": "SUSE Linux Enterprise Server 15 SP3-LTSS",
                  "product_identification_helper": {
                    "cpe": "cpe:/o:suse:sles-ltss:15:sp3"
                  }
                }
              },
              {
                "category": "product_name",
                "name": "SUSE Linux Enterprise Server 15 SP4-LTSS",
                "product": {
                  "name": "SUSE Linux Enterprise Server 15 SP4-LTSS",
                  "product_id": "SUSE Linux Enterprise Server 15 SP4-LTSS",
                  "product_identification_helper": {
                    "cpe": "cpe:/o:suse:sles-ltss:15:sp4"
                  }
                }
              },
              {
                "category": "product_name",
                "name": "SUSE Linux Enterprise Server for SAP Applications 15 SP3",
                "product": {
                  "name": "SUSE Linux Enterprise Server for SAP Applications 15 SP3",
                  "product_id": "SUSE Linux Enterprise Server for SAP Applications 15 SP3",
                  "product_identification_helper": {
                    "cpe": "cpe:/o:suse:sles_sap:15:sp3"
                  }
                }
              },
              {
                "category": "product_name",
                "name": "SUSE Linux Enterprise Server for SAP Applications 15 SP4",
                "product": {
                  "name": "SUSE Linux Enterprise Server for SAP Applications 15 SP4",
                  "product_id": "SUSE Linux Enterprise Server for SAP Applications 15 SP4",
                  "product_identification_helper": {
                    "cpe": "cpe:/o:suse:sles_sap:15:sp4"
                  }
                }
              },
              {
                "category": "product_name",
                "name": "SUSE Manager Proxy 4.3",
                "product": {
                  "name": "SUSE Manager Proxy 4.3",
                  "product_id": "SUSE Manager Proxy 4.3",
                  "product_identification_helper": {
                    "cpe": "cpe:/o:suse:suse-manager-proxy:4.3"
                  }
                }
              },
              {
                "category": "product_name",
                "name": "SUSE Manager Server 4.3",
                "product": {
                  "name": "SUSE Manager Server 4.3",
                  "product_id": "SUSE Manager Server 4.3",
                  "product_identification_helper": {
                    "cpe": "cpe:/o:suse:suse-manager-server:4.3"
                  }
                }
              },
              {
                "category": "product_name",
                "name": "SUSE Enterprise Storage 7.1",
                "product": {
                  "name": "SUSE Enterprise Storage 7.1",
                  "product_id": "SUSE Enterprise Storage 7.1",
                  "product_identification_helper": {
                    "cpe": "cpe:/o:suse:ses:7.1"
                  }
                }
              },
              {
                "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-sqlparse-0.4.2-150300.12.1.noarch as component of SUSE Linux Enterprise Module for Basesystem 15 SP5",
          "product_id": "SUSE Linux Enterprise Module for Basesystem 15 SP5:python3-sqlparse-0.4.2-150300.12.1.noarch"
        },
        "product_reference": "python3-sqlparse-0.4.2-150300.12.1.noarch",
        "relates_to_product_reference": "SUSE Linux Enterprise Module for Basesystem 15 SP5"
      },
      {
        "category": "default_component_of",
        "full_product_name": {
          "name": "python3-sqlparse-0.4.2-150300.12.1.noarch as component of SUSE Linux Enterprise Module for Basesystem 15 SP6",
          "product_id": "SUSE Linux Enterprise Module for Basesystem 15 SP6:python3-sqlparse-0.4.2-150300.12.1.noarch"
        },
        "product_reference": "python3-sqlparse-0.4.2-150300.12.1.noarch",
        "relates_to_product_reference": "SUSE Linux Enterprise Module for Basesystem 15 SP6"
      },
      {
        "category": "default_component_of",
        "full_product_name": {
          "name": "python3-sqlparse-0.4.2-150300.12.1.noarch as component of SUSE Linux Enterprise High Performance Computing 15 SP3-LTSS",
          "product_id": "SUSE Linux Enterprise High Performance Computing 15 SP3-LTSS:python3-sqlparse-0.4.2-150300.12.1.noarch"
        },
        "product_reference": "python3-sqlparse-0.4.2-150300.12.1.noarch",
        "relates_to_product_reference": "SUSE Linux Enterprise High Performance Computing 15 SP3-LTSS"
      },
      {
        "category": "default_component_of",
        "full_product_name": {
          "name": "python3-sqlparse-0.4.2-150300.12.1.noarch as component of SUSE Linux Enterprise High Performance Computing 15 SP4-ESPOS",
          "product_id": "SUSE Linux Enterprise High Performance Computing 15 SP4-ESPOS:python3-sqlparse-0.4.2-150300.12.1.noarch"
        },
        "product_reference": "python3-sqlparse-0.4.2-150300.12.1.noarch",
        "relates_to_product_reference": "SUSE Linux Enterprise High Performance Computing 15 SP4-ESPOS"
      },
      {
        "category": "default_component_of",
        "full_product_name": {
          "name": "python3-sqlparse-0.4.2-150300.12.1.noarch as component of SUSE Linux Enterprise High Performance Computing 15 SP4-LTSS",
          "product_id": "SUSE Linux Enterprise High Performance Computing 15 SP4-LTSS:python3-sqlparse-0.4.2-150300.12.1.noarch"
        },
        "product_reference": "python3-sqlparse-0.4.2-150300.12.1.noarch",
        "relates_to_product_reference": "SUSE Linux Enterprise High Performance Computing 15 SP4-LTSS"
      },
      {
        "category": "default_component_of",
        "full_product_name": {
          "name": "python3-sqlparse-0.4.2-150300.12.1.noarch as component of SUSE Linux Enterprise Server 15 SP3-LTSS",
          "product_id": "SUSE Linux Enterprise Server 15 SP3-LTSS:python3-sqlparse-0.4.2-150300.12.1.noarch"
        },
        "product_reference": "python3-sqlparse-0.4.2-150300.12.1.noarch",
        "relates_to_product_reference": "SUSE Linux Enterprise Server 15 SP3-LTSS"
      },
      {
        "category": "default_component_of",
        "full_product_name": {
          "name": "python3-sqlparse-0.4.2-150300.12.1.noarch as component of SUSE Linux Enterprise Server 15 SP4-LTSS",
          "product_id": "SUSE Linux Enterprise Server 15 SP4-LTSS:python3-sqlparse-0.4.2-150300.12.1.noarch"
        },
        "product_reference": "python3-sqlparse-0.4.2-150300.12.1.noarch",
        "relates_to_product_reference": "SUSE Linux Enterprise Server 15 SP4-LTSS"
      },
      {
        "category": "default_component_of",
        "full_product_name": {
          "name": "python3-sqlparse-0.4.2-150300.12.1.noarch as component of SUSE Linux Enterprise Server for SAP Applications 15 SP3",
          "product_id": "SUSE Linux Enterprise Server for SAP Applications 15 SP3:python3-sqlparse-0.4.2-150300.12.1.noarch"
        },
        "product_reference": "python3-sqlparse-0.4.2-150300.12.1.noarch",
        "relates_to_product_reference": "SUSE Linux Enterprise Server for SAP Applications 15 SP3"
      },
      {
        "category": "default_component_of",
        "full_product_name": {
          "name": "python3-sqlparse-0.4.2-150300.12.1.noarch as component of SUSE Linux Enterprise Server for SAP Applications 15 SP4",
          "product_id": "SUSE Linux Enterprise Server for SAP Applications 15 SP4:python3-sqlparse-0.4.2-150300.12.1.noarch"
        },
        "product_reference": "python3-sqlparse-0.4.2-150300.12.1.noarch",
        "relates_to_product_reference": "SUSE Linux Enterprise Server for SAP Applications 15 SP4"
      },
      {
        "category": "default_component_of",
        "full_product_name": {
          "name": "python3-sqlparse-0.4.2-150300.12.1.noarch as component of SUSE Manager Proxy 4.3",
          "product_id": "SUSE Manager Proxy 4.3:python3-sqlparse-0.4.2-150300.12.1.noarch"
        },
        "product_reference": "python3-sqlparse-0.4.2-150300.12.1.noarch",
        "relates_to_product_reference": "SUSE Manager Proxy 4.3"
      },
      {
        "category": "default_component_of",
        "full_product_name": {
          "name": "python3-sqlparse-0.4.2-150300.12.1.noarch as component of SUSE Manager Server 4.3",
          "product_id": "SUSE Manager Server 4.3:python3-sqlparse-0.4.2-150300.12.1.noarch"
        },
        "product_reference": "python3-sqlparse-0.4.2-150300.12.1.noarch",
        "relates_to_product_reference": "SUSE Manager Server 4.3"
      },
      {
        "category": "default_component_of",
        "full_product_name": {
          "name": "python3-sqlparse-0.4.2-150300.12.1.noarch as component of SUSE Enterprise Storage 7.1",
          "product_id": "SUSE Enterprise Storage 7.1:python3-sqlparse-0.4.2-150300.12.1.noarch"
        },
        "product_reference": "python3-sqlparse-0.4.2-150300.12.1.noarch",
        "relates_to_product_reference": "SUSE Enterprise Storage 7.1"
      },
      {
        "category": "default_component_of",
        "full_product_name": {
          "name": "python3-sqlparse-0.4.2-150300.12.1.noarch as component of openSUSE Leap 15.5",
          "product_id": "openSUSE Leap 15.5:python3-sqlparse-0.4.2-150300.12.1.noarch"
        },
        "product_reference": "python3-sqlparse-0.4.2-150300.12.1.noarch",
        "relates_to_product_reference": "openSUSE Leap 15.5"
      }
    ]
  },
  "vulnerabilities": [
    {
      "cve": "CVE-2024-4340",
      "ids": [
        {
          "system_name": "SUSE CVE Page",
          "text": "https://www.suse.com/security/cve/CVE-2024-4340"
        }
      ],
      "notes": [
        {
          "category": "general",
          "text": "Passing a heavily nested list to sqlparse.parse() leads to a Denial of Service due to RecursionError.\n\n",
          "title": "CVE description"
        }
      ],
      "product_status": {
        "recommended": [
          "SUSE Enterprise Storage 7.1:python3-sqlparse-0.4.2-150300.12.1.noarch",
          "SUSE Linux Enterprise High Performance Computing 15 SP3-LTSS:python3-sqlparse-0.4.2-150300.12.1.noarch",
          "SUSE Linux Enterprise High Performance Computing 15 SP4-ESPOS:python3-sqlparse-0.4.2-150300.12.1.noarch",
          "SUSE Linux Enterprise High Performance Computing 15 SP4-LTSS:python3-sqlparse-0.4.2-150300.12.1.noarch",
          "SUSE Linux Enterprise Module for Basesystem 15 SP5:python3-sqlparse-0.4.2-150300.12.1.noarch",
          "SUSE Linux Enterprise Module for Basesystem 15 SP6:python3-sqlparse-0.4.2-150300.12.1.noarch",
          "SUSE Linux Enterprise Server 15 SP3-LTSS:python3-sqlparse-0.4.2-150300.12.1.noarch",
          "SUSE Linux Enterprise Server 15 SP4-LTSS:python3-sqlparse-0.4.2-150300.12.1.noarch",
          "SUSE Linux Enterprise Server for SAP Applications 15 SP3:python3-sqlparse-0.4.2-150300.12.1.noarch",
          "SUSE Linux Enterprise Server for SAP Applications 15 SP4:python3-sqlparse-0.4.2-150300.12.1.noarch",
          "SUSE Manager Proxy 4.3:python3-sqlparse-0.4.2-150300.12.1.noarch",
          "SUSE Manager Server 4.3:python3-sqlparse-0.4.2-150300.12.1.noarch",
          "openSUSE Leap 15.5:python3-sqlparse-0.4.2-150300.12.1.noarch"
        ]
      },
      "references": [
        {
          "category": "external",
          "summary": "CVE-2024-4340",
          "url": "https://www.suse.com/security/cve/CVE-2024-4340"
        },
        {
          "category": "external",
          "summary": "SUSE Bug 1223603 for CVE-2024-4340",
          "url": "https://bugzilla.suse.com/1223603"
        }
      ],
      "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 Enterprise Storage 7.1:python3-sqlparse-0.4.2-150300.12.1.noarch",
            "SUSE Linux Enterprise High Performance Computing 15 SP3-LTSS:python3-sqlparse-0.4.2-150300.12.1.noarch",
            "SUSE Linux Enterprise High Performance Computing 15 SP4-ESPOS:python3-sqlparse-0.4.2-150300.12.1.noarch",
            "SUSE Linux Enterprise High Performance Computing 15 SP4-LTSS:python3-sqlparse-0.4.2-150300.12.1.noarch",
            "SUSE Linux Enterprise Module for Basesystem 15 SP5:python3-sqlparse-0.4.2-150300.12.1.noarch",
            "SUSE Linux Enterprise Module for Basesystem 15 SP6:python3-sqlparse-0.4.2-150300.12.1.noarch",
            "SUSE Linux Enterprise Server 15 SP3-LTSS:python3-sqlparse-0.4.2-150300.12.1.noarch",
            "SUSE Linux Enterprise Server 15 SP4-LTSS:python3-sqlparse-0.4.2-150300.12.1.noarch",
            "SUSE Linux Enterprise Server for SAP Applications 15 SP3:python3-sqlparse-0.4.2-150300.12.1.noarch",
            "SUSE Linux Enterprise Server for SAP Applications 15 SP4:python3-sqlparse-0.4.2-150300.12.1.noarch",
            "SUSE Manager Proxy 4.3:python3-sqlparse-0.4.2-150300.12.1.noarch",
            "SUSE Manager Server 4.3:python3-sqlparse-0.4.2-150300.12.1.noarch",
            "openSUSE Leap 15.5:python3-sqlparse-0.4.2-150300.12.1.noarch"
          ]
        }
      ],
      "scores": [
        {
          "cvss_v3": {
            "baseScore": 7.5,
            "baseSeverity": "HIGH",
            "vectorString": "CVSS:3.1/AV:N/AC:L/PR:N/UI:N/S:U/C:N/I:N/A:H",
            "version": "3.1"
          },
          "products": [
            "SUSE Enterprise Storage 7.1:python3-sqlparse-0.4.2-150300.12.1.noarch",
            "SUSE Linux Enterprise High Performance Computing 15 SP3-LTSS:python3-sqlparse-0.4.2-150300.12.1.noarch",
            "SUSE Linux Enterprise High Performance Computing 15 SP4-ESPOS:python3-sqlparse-0.4.2-150300.12.1.noarch",
            "SUSE Linux Enterprise High Performance Computing 15 SP4-LTSS:python3-sqlparse-0.4.2-150300.12.1.noarch",
            "SUSE Linux Enterprise Module for Basesystem 15 SP5:python3-sqlparse-0.4.2-150300.12.1.noarch",
            "SUSE Linux Enterprise Module for Basesystem 15 SP6:python3-sqlparse-0.4.2-150300.12.1.noarch",
            "SUSE Linux Enterprise Server 15 SP3-LTSS:python3-sqlparse-0.4.2-150300.12.1.noarch",
            "SUSE Linux Enterprise Server 15 SP4-LTSS:python3-sqlparse-0.4.2-150300.12.1.noarch",
            "SUSE Linux Enterprise Server for SAP Applications 15 SP3:python3-sqlparse-0.4.2-150300.12.1.noarch",
            "SUSE Linux Enterprise Server for SAP Applications 15 SP4:python3-sqlparse-0.4.2-150300.12.1.noarch",
            "SUSE Manager Proxy 4.3:python3-sqlparse-0.4.2-150300.12.1.noarch",
            "SUSE Manager Server 4.3:python3-sqlparse-0.4.2-150300.12.1.noarch",
            "openSUSE Leap 15.5:python3-sqlparse-0.4.2-150300.12.1.noarch"
          ]
        }
      ],
      "threats": [
        {
          "category": "impact",
          "date": "2024-05-30T12:16:37Z",
          "details": "important"
        }
      ],
      "title": "CVE-2024-4340"
    }
  ]
}

CVE-2024-4340 (GCVE-0-2024-4340)

Vulnerability from cvelistv5 – Published: 2024-04-30 14:23 – Updated: 2025-11-03 22:05

Title

Passing a heavily nested list to sqlparse.parse() leads to a Denial of Service due to RecursionError.

Summary

Passing a heavily nested list to sqlparse.parse() leads to a Denial of Service due to RecursionError.

Severity

7.5 (High)


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

SSVC

Exploitation: poc Automatable: yes Technical Impact: partial

CISA Coordinator · CISA-ADP (v2.0.3)

Decision recorded 2024-04-30 16:07 UTC

CWE

CWE-674 - Uncontrolled Recursion

Assigner

JFROG CNA under the mitre root

CNA scorecard B 76/100 over 66 records in the last 180 days details

References

4 references

URL	Tags
https://research.jfrog.com/vulnerabilities/sqlpar…	third-party-advisory
https://github.com/andialbrecht/sqlparse/commit/b…	patch
https://github.com/advisories/GHSA-2m57-hf25-phgg
https://lists.debian.org/debian-lts-announce/2024…

Impacted products

2 products

Vendor	Product	Version
		Affected: 0 , < 0.5.0 (python)
sqlparse_project	sqlparse	Affected: 0 cpe:2.3:a:sqlparse_project:sqlparse::::::::

Show details on NVD website

JSON

To clipboard

{
  "containers": {
    "adp": [
      {
        "affected": [
          {
            "cpes": [
              "cpe:2.3:a:sqlparse_project:sqlparse:*:*:*:*:*:*:*:*"
            ],
            "defaultStatus": "unknown",
            "product": "sqlparse",
            "vendor": "sqlparse_project",
            "versions": [
              {
                "status": "affected",
                "version": "0"
              }
            ]
          }
        ],
        "metrics": [
          {
            "other": {
              "content": {
                "id": "CVE-2024-4340",
                "options": [
                  {
                    "Exploitation": "poc"
                  },
                  {
                    "Automatable": "yes"
                  },
                  {
                    "Technical Impact": "partial"
                  }
                ],
                "role": "CISA Coordinator",
                "timestamp": "2024-04-30T16:07:16.196262Z",
                "version": "2.0.3"
              },
              "type": "ssvc"
            }
          }
        ],
        "providerMetadata": {
          "dateUpdated": "2024-06-04T17:54:10.848Z",
          "orgId": "134c704f-9b21-4f2e-91b3-4a467353bcc0",
          "shortName": "CISA-ADP"
        },
        "title": "CISA ADP Vulnrichment"
      },
      {
        "providerMetadata": {
          "dateUpdated": "2025-11-03T22:05:00.696Z",
          "orgId": "af854a3a-2127-422b-91ae-364da2661108",
          "shortName": "CVE"
        },
        "references": [
          {
            "tags": [
              "third-party-advisory",
              "x_transferred"
            ],
            "url": "https://research.jfrog.com/vulnerabilities/sqlparse-stack-exhaustion-dos-jfsa-2024-001031292/"
          },
          {
            "tags": [
              "patch",
              "x_transferred"
            ],
            "url": "https://github.com/andialbrecht/sqlparse/commit/b4a39d9850969b4e1d6940d32094ee0b42a2cf03"
          },
          {
            "tags": [
              "x_transferred"
            ],
            "url": "https://github.com/advisories/GHSA-2m57-hf25-phgg"
          },
          {
            "url": "https://lists.debian.org/debian-lts-announce/2024/12/msg00022.html"
          }
        ],
        "title": "CVE Program Container"
      }
    ],
    "cna": {
      "affected": [
        {
          "collectionURL": "https://pypi.org/project/pip",
          "packageName": "sqlparse",
          "versions": [
            {
              "lessThan": "0.5.0",
              "status": "affected",
              "version": "0",
              "versionType": "python"
            }
          ]
        }
      ],
      "descriptions": [
        {
          "lang": "en",
          "supportingMedia": [
            {
              "base64": false,
              "type": "text/html",
              "value": "\u003cp\u003ePassing a heavily nested list to sqlparse.parse() leads to a Denial of Service due to RecursionError.\u003c/p\u003e"
            }
          ],
          "value": "Passing a heavily nested list to sqlparse.parse() leads to a Denial of Service due to RecursionError.\n\n"
        }
      ],
      "metrics": [
        {
          "cvssV3_1": {
            "attackComplexity": "LOW",
            "attackVector": "NETWORK",
            "availabilityImpact": "HIGH",
            "baseScore": 7.5,
            "baseSeverity": "HIGH",
            "confidentialityImpact": "NONE",
            "integrityImpact": "NONE",
            "privilegesRequired": "NONE",
            "scope": "UNCHANGED",
            "userInteraction": "NONE",
            "vectorString": "CVSS:3.1/AV:N/AC:L/PR:N/UI:N/S:U/C:N/I:N/A:H",
            "version": "3.1"
          },
          "format": "CVSS",
          "scenarios": [
            {
              "lang": "en",
              "value": "GENERAL"
            }
          ]
        }
      ],
      "problemTypes": [
        {
          "descriptions": [
            {
              "cweId": "CWE-674",
              "description": "CWE-674 Uncontrolled Recursion",
              "lang": "en",
              "type": "CWE"
            }
          ]
        }
      ],
      "providerMetadata": {
        "dateUpdated": "2024-04-30T14:23:03.435Z",
        "orgId": "48a46f29-ae42-4e1d-90dd-c1676c1e5e6d",
        "shortName": "JFROG"
      },
      "references": [
        {
          "tags": [
            "third-party-advisory"
          ],
          "url": "https://research.jfrog.com/vulnerabilities/sqlparse-stack-exhaustion-dos-jfsa-2024-001031292/"
        },
        {
          "tags": [
            "patch"
          ],
          "url": "https://github.com/andialbrecht/sqlparse/commit/b4a39d9850969b4e1d6940d32094ee0b42a2cf03"
        },
        {
          "url": "https://github.com/advisories/GHSA-2m57-hf25-phgg"
        }
      ],
      "source": {
        "discovery": "EXTERNAL"
      },
      "title": "Passing a heavily nested list to sqlparse.parse() leads to a Denial of Service due to RecursionError."
    }
  },
  "cveMetadata": {
    "assignerOrgId": "48a46f29-ae42-4e1d-90dd-c1676c1e5e6d",
    "assignerShortName": "JFROG",
    "cveId": "CVE-2024-4340",
    "datePublished": "2024-04-30T14:23:03.435Z",
    "dateReserved": "2024-04-30T11:12:30.839Z",
    "dateUpdated": "2025-11-03T22:05:00.696Z",
    "state": "PUBLISHED"
  },
  "dataType": "CVE_RECORD",
  "dataVersion": "5.2"
}

Sightings

Author	Source	Type	Date	Other

Nomenclature

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

Vulnerability timeline

Sightings and recorded dates, grouped by day · UTC

Order JSON

How durations are calculated

Following the VTEM framework (Black Hat USA 2015), time to patch starts when the vendor or a coordinator was informed, total time to patch at discovery, and disclosure to patch at public disclosure; vendor response time runs from the report to its acknowledgement. Time to exploit and time unpatched start at the earliest discovery or report, falling back to public disclosure. Unpatched time ends at the first recorded patch, or the calculation time when no patch is recorded. Exploitation to patch shows the interval between those two events; a published proof of concept is a public exploit, not exploitation.

Each result shows its source dates. A negative interval means the end event came first; when date-only inputs leave the order open, the result says so. Date-only inputs are approximate. The earliest evidence wins: KEV report dates and sightings are labelled as such. Records describing another vulnerability are listed but never calculated from, and a PoC alone does not establish exploitation. Missing patch evidence does not prove that no patch exists. Filters below change the event list only.

Publication & reservation Sightings KEV catalogs Other timestamps

Loading timeline…

The MITRE ATT&CK techniques below are AI-generated suggestions, inferred from the description of the vulnerability by the CIRCL/vulnerability-attack-technique-classification-roberta-base model, served locally by ML-Gateway. They have not been verified by an analyst and are provided for guidance only.
The approach is described in our paper Mapping CVEs to MITRE ATT&CK Techniques: A Curated Gold-Set Classifier and the Limits of LLM-Assisted Label Expansion.
Browse all ATT&CK techniques and the vulnerabilities related to each.

Related by attack behaviour

Vulnerabilities whose description is nearest to this one in the vector space of the CIRCL/vulnerability-attack-technique-biencoder model. This is a similarity search over the bi-encoder space (plain cosine), not a classification, and it has no measured accuracy.

Action not permitted