SUSE SLES11 Security Update : MySQL (SUSE-SU-2015:1177-2) (Logjam)

#%NASL_MIN_LEVEL 70300
#
# (C) Tenable Network Security, Inc.
#
# The descriptive text and package checks in this plugin were
# extracted from SUSE update advisory SUSE-SU-2015:1177-2.
# The text itself is copyright (C) SUSE.
#

include('deprecated_nasl_level.inc');
include('compat.inc');

if (description)
{
  script_id(84723);
  script_version("2.15");
  script_set_attribute(attribute:"plugin_modification_date", value:"2022/12/05");

  script_cve_id("CVE-2015-4000");
  script_bugtraq_id(74733);
  script_xref(name:"CEA-ID", value:"CEA-2021-0004");

  script_name(english:"SUSE SLES11 Security Update : MySQL (SUSE-SU-2015:1177-2) (Logjam)");

  script_set_attribute(attribute:"synopsis", value:
"The remote SUSE host is missing one or more security updates.");
  script_set_attribute(attribute:"description", value:
"This update fixes the following security issue :

Logjam Attack: mysql uses 512 bit dh groups in SSL (bnc#934789)

Note that Tenable Network Security has extracted the preceding
description block directly from the SUSE security advisory. Tenable
has attempted to automatically clean and format it as much as possible
without introducing additional issues.");
  script_set_attribute(attribute:"see_also", value:"https://bugzilla.suse.com/show_bug.cgi?id=934789");
  # https://download.suse.com/patch/finder/?keywords=981d8f54c6495496c156cd451d10c084
  script_set_attribute(attribute:"see_also", value:"http://www.nessus.org/u?cf92ee4a");
  # https://download.suse.com/patch/finder/?keywords=9bf49a65c370d89b69d6200ce055b991
  script_set_attribute(attribute:"see_also", value:"http://www.nessus.org/u?957285dc");
  script_set_attribute(attribute:"see_also", value:"https://www.suse.com/security/cve/CVE-2015-4000/");
  # https://www.suse.com/support/update/announcement/2015/suse-su-20151177-2.html
  script_set_attribute(attribute:"see_also", value:"http://www.nessus.org/u?f6a3f222");
  script_set_attribute(attribute:"solution", value:
"To install this SUSE Security Update use YaST online_update.
Alternatively you can run the command listed for your product :

SUSE Linux Enterprise Server 11 SP2 LTSS :

zypper in -t patch slessp2-libmysqlclient-devel=10835

SUSE Linux Enterprise Server 11 SP1 LTSS :

zypper in -t patch slessp1-libmysqlclient-devel=10834

To bring your system up-to-date, use 'zypper patch'.");
  script_set_cvss_base_vector("CVSS2#AV:N/AC:M/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:H/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:"exploitability_ease", value:"No known exploits are available");
  script_set_attribute(attribute:"exploit_available", value:"false");
  script_set_attribute(attribute:"in_the_news", value:"true");

  script_set_attribute(attribute:"vuln_publication_date", value:"2015/05/21");
  script_set_attribute(attribute:"patch_publication_date", value:"2015/07/10");
  script_set_attribute(attribute:"plugin_publication_date", value:"2015/07/14");

  script_set_attribute(attribute:"plugin_type", value:"local");
  script_set_attribute(attribute:"cpe", value:"p-cpe:/a:novell:suse_linux:libmysqlclient15");
  script_set_attribute(attribute:"cpe", value:"p-cpe:/a:novell:suse_linux:libmysqlclient_r15");
  script_set_attribute(attribute:"cpe", value:"p-cpe:/a:novell:suse_linux:mysql");
  script_set_attribute(attribute:"cpe", value:"p-cpe:/a:novell:suse_linux:mysql-Max");
  script_set_attribute(attribute:"cpe", value:"p-cpe:/a:novell:suse_linux:mysql-client");
  script_set_attribute(attribute:"cpe", value:"p-cpe:/a:novell:suse_linux:mysql-tools");
  script_set_attribute(attribute:"cpe", value:"cpe:/o:novell:suse_linux:11");
  script_set_attribute(attribute:"generated_plugin", value:"current");
  script_end_attributes();

  script_category(ACT_GATHER_INFO);
  script_family(english:"SuSE Local Security Checks");

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

  script_dependencies("ssh_get_info.nasl");
  script_require_keys("Host/local_checks_enabled", "Host/cpu", "Host/SuSE/release", "Host/SuSE/rpm-list");

  exit(0);
}


include("audit.inc");
include("global_settings.inc");
include("rpm.inc");


if (!get_kb_item("Host/local_checks_enabled")) audit(AUDIT_LOCAL_CHECKS_NOT_ENABLED);
release = get_kb_item("Host/SuSE/release");
if (isnull(release) || release !~ "^(SLED|SLES)") audit(AUDIT_OS_NOT, "SUSE");
os_ver = pregmatch(pattern: "^(SLE(S|D)\d+)", string:release);
if (isnull(os_ver)) audit(AUDIT_UNKNOWN_APP_VER, "SUSE");
os_ver = os_ver[1];
if (! preg(pattern:"^(SLES11)$", string:os_ver)) audit(AUDIT_OS_NOT, "SUSE SLES11", "SUSE " + os_ver);

if (!get_kb_item("Host/SuSE/rpm-list")) audit(AUDIT_PACKAGE_LIST_MISSING);

cpu = get_kb_item("Host/cpu");
if (isnull(cpu)) audit(AUDIT_UNKNOWN_ARCH);
if (cpu !~ "^i[3-6]86$" && "x86_64" >!< cpu && "s390x" >!< cpu) audit(AUDIT_LOCAL_CHECKS_NOT_IMPLEMENTED, "SUSE " + os_ver, cpu);

sp = get_kb_item("Host/SuSE/patchlevel");
if (isnull(sp)) sp = "0";
if (os_ver == "SLES11" && (! preg(pattern:"^(1|2)$", string:sp))) audit(AUDIT_OS_NOT, "SLES11 SP1/2", os_ver + " SP" + sp);


flag = 0;
if (rpm_check(release:"SLES11", sp:"1", cpu:"x86_64", reference:"libmysqlclient15-32bit-5.0.96-0.8.8.2")) flag++;
if (rpm_check(release:"SLES11", sp:"1", cpu:"s390x", reference:"libmysqlclient15-32bit-5.0.96-0.8.8.2")) flag++;
if (rpm_check(release:"SLES11", sp:"1", reference:"libmysqlclient15-5.0.96-0.8.8.2")) flag++;
if (rpm_check(release:"SLES11", sp:"1", reference:"libmysqlclient_r15-5.0.96-0.8.8.2")) flag++;
if (rpm_check(release:"SLES11", sp:"1", reference:"mysql-5.0.96-0.8.8.2")) flag++;
if (rpm_check(release:"SLES11", sp:"1", reference:"mysql-Max-5.0.96-0.8.8.2")) flag++;
if (rpm_check(release:"SLES11", sp:"1", reference:"mysql-client-5.0.96-0.8.8.2")) flag++;
if (rpm_check(release:"SLES11", sp:"1", reference:"mysql-tools-5.0.96-0.8.8.2")) flag++;
if (rpm_check(release:"SLES11", sp:"2", cpu:"x86_64", reference:"libmysqlclient15-32bit-5.0.96-0.8.8.2")) flag++;
if (rpm_check(release:"SLES11", sp:"2", cpu:"s390x", reference:"libmysqlclient15-32bit-5.0.96-0.8.8.2")) flag++;
if (rpm_check(release:"SLES11", sp:"2", reference:"libmysqlclient15-5.0.96-0.8.8.2")) flag++;
if (rpm_check(release:"SLES11", sp:"2", reference:"libmysqlclient_r15-5.0.96-0.8.8.2")) flag++;
if (rpm_check(release:"SLES11", sp:"2", reference:"mysql-5.0.96-0.8.8.2")) flag++;
if (rpm_check(release:"SLES11", sp:"2", reference:"mysql-Max-5.0.96-0.8.8.2")) flag++;
if (rpm_check(release:"SLES11", sp:"2", reference:"mysql-client-5.0.96-0.8.8.2")) flag++;
if (rpm_check(release:"SLES11", sp:"2", reference:"mysql-tools-5.0.96-0.8.8.2")) flag++;


if (flag)
{
  if (report_verbosity > 0) security_warning(port:0, extra:rpm_report_get());
  else security_warning(0);
  exit(0);
}
else
{
  tested = pkg_tests_get();
  if (tested) audit(AUDIT_PACKAGE_NOT_AFFECTED, tested);
  else audit(AUDIT_PACKAGE_NOT_INSTALLED, "MySQL");
}