ClickHouse < 19.13.5.44

#%NASL_MIN_LEVEL 80900

##
# Tenable, Inc.
##

include('compat.inc');

if (description)
{
  script_id(216695);
  script_version("1.2");
  script_set_attribute(attribute:"plugin_modification_date", value:"2025/02/25");

  script_cve_id("CVE-2019-18657");

  script_name(english:"ClickHouse < 19.13.5.44");

  script_set_attribute(attribute:"synopsis", value:
"The remote host is affected by a vulnerability.");
  script_set_attribute(attribute:"description", value:
"The version of ClickHouse installed on the remote host is prior to 19.13.5.44. It is, therefore, affected by a
  HTTP header injection vulnerability via the url table function.

Note that Nessus has not tested for this issue but has instead relied only on the application's self-reported version number.");
  script_set_attribute(attribute:"see_also", value:"https://github.com/ClickHouse/ClickHouse/blob/master/CHANGELOG.md");
  script_set_attribute(attribute:"see_also", value:"https://github.com/ClickHouse/ClickHouse/pull/7526/files");
  script_set_attribute(attribute:"see_also", value:"https://github.com/ClickHouse/ClickHouse/pull/6466");
  script_set_attribute(attribute:"solution", value:
"Upgrade to ClickHouse version 19.13.5.44 or later.");
  script_set_cvss_base_vector("CVSS2#AV:N/AC:L/Au:N/C:N/I:P/A:N");
  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:L/A:N");
  script_set_cvss3_temporal_vector("CVSS:3.0/E:U/RL:O/RC:C");
  script_set_attribute(attribute:"cvss_score_source", value:"CVE-2019-18657");

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

  script_set_attribute(attribute:"vuln_publication_date", value:"2019/10/31");
  script_set_attribute(attribute:"patch_publication_date", value:"2019/10/31");
  script_set_attribute(attribute:"plugin_publication_date", value:"2025/02/24");

  script_set_attribute(attribute:"plugin_type", value:"remote");
  script_set_attribute(attribute:"cpe", value:"cpe:/a:yandex:clickhouse");
  script_end_attributes();

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

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

  script_dependencies("clickhouse_web_detect.nbin");
  script_require_keys("installed_sw/ClickHouse");

  exit(0);
}

include('vcf.inc');

var app_info = vcf::get_app_info(app:'ClickHouse');
var constraints = [
    { 'min_version':'1.0', 'fixed_version':'19.13.5.44' },
];

vcf::check_version_and_report(app_info:app_info, constraints:constraints, severity:SECURITY_WARNING);