Python Library sqlparse < 0.6.0 Multiple Vulnerabilities

#%NASL_MIN_LEVEL 80900
##
# (C) Tenable, Inc.
##

include('compat.inc');

if (description)
{
  script_id(338624);
  script_version("1.2");
  script_set_attribute(attribute:"plugin_modification_date", value:"2026/08/21");

  script_cve_id("CVE-2026-54284", "CVE-2026-59893", "CVE-2026-71491");
  script_xref(name:"IAVA", value:"2026-A-0893");

  script_name(english:"Python Library sqlparse < 0.6.0 Multiple Vulnerabilities");

  script_set_attribute(attribute:"synopsis", value:
"A Python library installed on the remote host is affected by multiple vulnerabilities.");
  script_set_attribute(attribute:"description", value:
"The version of the sqlparse Python library installed on the remote host is prior to 0.6.0. It is, therefore, affected
by multiple vulnerabilities:

  - A denial of service vulnerability exists in sqlparse due to the regular expressions used by the lexer to
    match dollar-quoted strings and multiline comments. An unauthenticated, remote attacker can exploit this,
    by supplying specially crafted SQL input, to cause catastrophic backtracking and exhaust available
    resources. (CVE-2026-59893)

  - A denial of service vulnerability exists in sqlparse in the token list handling implemented in
    sqlparse/sql.py. An unauthenticated, remote attacker can exploit this, by supplying deeply nested SQL
    input, to consume excessive CPU and memory resources. (CVE-2026-54284)

  - A denial of service vulnerability exists in sqlparse in the comment grouping logic implemented in
    sqlparse/engine/grouping.py. An unauthenticated, remote attacker can exploit this, by supplying specially
    crafted SQL input containing many comments, to consume excessive resources due to repeated rescanning of
    the token stream. (CVE-2026-71491)

Note that Nessus has not tested for this issue but has instead relied only on the application's self-reported version
number.");
  # https://github.com/andialbrecht/sqlparse/security/advisories/GHSA-prg7-hcfm-mfcr
  script_set_attribute(attribute:"see_also", value:"http://www.nessus.org/u?7bd9e3e2");
  # https://github.com/andialbrecht/sqlparse/security/advisories/GHSA-pwgv-4x5q-6m9f
  script_set_attribute(attribute:"see_also", value:"http://www.nessus.org/u?b80d3f95");
  # https://github.com/andialbrecht/sqlparse/security/advisories/GHSA-f2ff-p2ww-7p4p
  script_set_attribute(attribute:"see_also", value:"http://www.nessus.org/u?0e5d5073");
  script_set_attribute(attribute:"solution", value:
"Upgrade to sqlparse version 0.6.0 or later.");
  script_set_attribute(attribute:"agent", value:"all");
  script_set_cvss_base_vector("CVSS2#AV:N/AC:L/Au:N/C:N/I:N/A:C");
  script_set_cvss_temporal_vector("CVSS2#E:U/RL:OF/RC:C");
  script_set_cvss3_base_vector("CVSS:3.0/AV:N/AC:L/PR:N/UI:N/S:U/C:N/I:N/A:H");
  script_set_cvss3_temporal_vector("CVSS:3.0/E:U/RL:O/RC:C");
  script_set_attribute(attribute:"cvss4_vector", value:"CVSS:4.0/AV:N/AC:L/AT:N/PR:N/UI:N/VC:N/VI:N/VA:H/SC:N/SI:N/SA:N");
  script_set_attribute(attribute:"cvss4_threat_vector", value:"CVSS:4.0/E:U");
  script_set_attribute(attribute:"cvss_score_source", value:"CVE-2026-59893");
  script_set_attribute(attribute:"cvss4_score_source", value:"CVE-2026-71491");

  script_set_attribute(attribute:"exploitability_ease", value:"No known exploits are available");
  script_set_attribute(attribute:"exploit_available", value:"false");

  script_set_attribute(attribute:"vuln_publication_date", value:"2026/08/17");
  script_set_attribute(attribute:"patch_publication_date", value:"2026/08/13");
  script_set_attribute(attribute:"plugin_publication_date", value:"2026/08/21");

  script_set_attribute(attribute:"plugin_type", value:"local");
  script_set_attribute(attribute:"asset_categories", value:"component");
  script_set_attribute(attribute:"cpe", value:"cpe:/a:sqlparse_project:sqlparse");
  script_set_attribute(attribute:"stig_severity", value:"I");
  script_set_attribute(attribute:"thorough_tests", value:"true");
  script_end_attributes();

  script_category(ACT_GATHER_INFO);
  script_family(english:"Misc.");

  script_copyright(english:"This script is Copyright (C) 2026 and is owned by Tenable, Inc. or an Affiliate thereof.");

  script_dependencies("python_packages_installed_nix.nbin", "python_packages_win_installed.nbin");
  script_require_ports("Host/nix/Python/Packages/Enumerated", "Host/win/Python/Packages/Enumerated");

  exit(0);
}

include('python.inc');

var pkg = 'sqlparse';
var cpe = 'cpe:/a:sqlparse_project:sqlparse';

var libs = python::get_package_info(pkg_name:pkg, cpe:cpe);

if (empty_or_null(libs))
  audit(AUDIT_NOT_INST, pkg);

vcf::check_all_backporting(app_info:libs);

var constraints = [
  { 'fixed_version' : '0.6.0' }
];

vcf::check_version_and_report(app_info:libs, constraints:constraints, severity:SECURITY_HOLE);