ClickHouse < 19.14.3

#%NASL_MIN_LEVEL 80900

##
# Tenable, Inc.
##

include('compat.inc');

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

  script_cve_id("CVE-2019-15024");

  script_name(english:"ClickHouse < 19.14.3");

  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.14.3. It is, therefore, affected by a
arbitrary file write vulnerability.  In all versions of ClickHouse before 19.14.3, an attacker having write 
access to ZooKeeper and who is able to run a custom server available from the network where ClickHouse runs, 
can create a custom-built malicious server that will act as a ClickHouse replica and register it in ZooKeeper. 
When another replica will fetch data part from the malicious replica, it can force clickhouse-server to 
write to arbitrary path on filesystem.

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://clickhouse.yandex/docs/en/security_changelog/");
  script_set_attribute(attribute:"solution", value:
"Upgrade to ClickHouse version 19.14.3 or later.");
  script_set_cvss_base_vector("CVSS2#AV:N/AC:L/Au:S/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:L/UI:N/S:U/C:N/I:H/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-15024");

  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:"2019/12/30");
  script_set_attribute(attribute:"patch_publication_date", value:"2019/12/30");
  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.14.3' },
];

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