SuSE 10 Security Update : MySQL (ZYPP Patch Number 5338)

#%NASL_MIN_LEVEL 70300
#
# (C) Tenable Network Security, Inc.
#
# The text description of this plugin is (C) Novell, Inc.
#

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

if (description)
{
  script_id(33886);
  script_version("1.22");
  script_set_attribute(attribute:"plugin_modification_date", value:"2021/01/14");

  script_cve_id("CVE-2006-7232", "CVE-2008-2079");

  script_name(english:"SuSE 10 Security Update : MySQL (ZYPP Patch Number 5338)");
  script_summary(english:"Checks rpm output for the updated packages");

  script_set_attribute(
    attribute:"synopsis", 
    value:"The remote SuSE 10 host is missing a security-related patch."
  );
  script_set_attribute(
    attribute:"description", 
    value:
"The database server mySQL was updated to fix two security problems :

  - MySQL allowed local users to bypass certain privilege
    checks by calling CREATE TABLE on a MyISAM table with
    modified (1) DATA DIRECTORY or (2) INDEX DIRECTORY
    arguments that are within the MySQL home data directory,
    which can point to tables that are created in the
    future. (CVE-2008-2079)

  - sql_select.cc in MySQL 5.0.x before 5.0.32 and 5.1.x
    before 5.1.14 allows remote authenticated users to cause
    a denial of service (crash) via an EXPLAIN SELECT FROM
    on the INFORMATION_SCHEMA table, as originally
    demonstrated using ORDER BY. (CVE-2006-7232)"
  );
  script_set_attribute(
    attribute:"see_also",
    value:"http://support.novell.com/security/cve/CVE-2006-7232.html"
  );
  script_set_attribute(
    attribute:"see_also",
    value:"http://support.novell.com/security/cve/CVE-2008-2079.html"
  );
  script_set_attribute(attribute:"solution", value:"Apply ZYPP patch number 5338.");
  script_set_cvss_base_vector("CVSS2#AV:N/AC:H/Au:S/C:P/I:P/A:P");
  script_cwe_id(89, 264);

  script_set_attribute(attribute:"plugin_type", value:"local");
  script_set_attribute(attribute:"cpe", value:"cpe:/o:suse:suse_linux");

  script_set_attribute(attribute:"patch_publication_date", value:"2008/06/09");
  script_set_attribute(attribute:"plugin_publication_date", value:"2008/08/14");
  script_end_attributes();

  script_category(ACT_GATHER_INFO);
  script_copyright(english:"This script is Copyright (C) 2008-2021 Tenable Network Security, Inc.");
  script_family(english:"SuSE Local Security Checks");

  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("global_settings.inc");
include("rpm.inc");


if (!get_kb_item("Host/local_checks_enabled")) exit(0, "Local checks are not enabled.");
if (!get_kb_item("Host/SuSE/release")) exit(0, "The host is not running SuSE.");
if (!get_kb_item("Host/SuSE/rpm-list")) exit(1, "Could not obtain the list of installed packages.");

cpu = get_kb_item("Host/cpu");
if (isnull(cpu)) exit(1, "Failed to determine the architecture type.");
if (cpu >!< "x86_64" && cpu !~ "^i[3-6]86$") exit(1, "Local checks for SuSE 10 on the '"+cpu+"' architecture have not been implemented.");


flag = 0;
if (rpm_check(release:"SLED10", sp:1, reference:"mysql-5.0.26-12.17.5")) flag++;
if (rpm_check(release:"SLED10", sp:1, reference:"mysql-client-5.0.26-12.17.5")) flag++;
if (rpm_check(release:"SLED10", sp:1, reference:"mysql-devel-5.0.26-12.17.5")) flag++;
if (rpm_check(release:"SLED10", sp:1, reference:"mysql-shared-5.0.26-12.17.5")) flag++;
if (rpm_check(release:"SLED10", sp:1, cpu:"x86_64", reference:"mysql-shared-32bit-5.0.26-12.17.5")) flag++;
if (rpm_check(release:"SLED10", sp:2, reference:"mysql-5.0.26-12.20")) flag++;
if (rpm_check(release:"SLED10", sp:2, reference:"mysql-client-5.0.26-12.20")) flag++;
if (rpm_check(release:"SLED10", sp:2, reference:"mysql-devel-5.0.26-12.20")) flag++;
if (rpm_check(release:"SLED10", sp:2, reference:"mysql-shared-5.0.26-12.20")) flag++;
if (rpm_check(release:"SLED10", sp:2, cpu:"x86_64", reference:"mysql-shared-32bit-5.0.26-12.20")) flag++;
if (rpm_check(release:"SLES10", sp:1, reference:"mysql-5.0.26-12.17.5")) flag++;
if (rpm_check(release:"SLES10", sp:1, reference:"mysql-Max-5.0.26-12.17.5")) flag++;
if (rpm_check(release:"SLES10", sp:1, reference:"mysql-client-5.0.26-12.17.5")) flag++;
if (rpm_check(release:"SLES10", sp:1, reference:"mysql-devel-5.0.26-12.17.5")) flag++;
if (rpm_check(release:"SLES10", sp:1, reference:"mysql-shared-5.0.26-12.17.5")) flag++;
if (rpm_check(release:"SLES10", sp:1, cpu:"x86_64", reference:"mysql-shared-32bit-5.0.26-12.17.5")) flag++;
if (rpm_check(release:"SLES10", sp:2, reference:"mysql-5.0.26-12.20")) flag++;
if (rpm_check(release:"SLES10", sp:2, reference:"mysql-Max-5.0.26-12.20")) flag++;
if (rpm_check(release:"SLES10", sp:2, reference:"mysql-client-5.0.26-12.20")) flag++;
if (rpm_check(release:"SLES10", sp:2, reference:"mysql-devel-5.0.26-12.20")) flag++;
if (rpm_check(release:"SLES10", sp:2, reference:"mysql-shared-5.0.26-12.20")) flag++;
if (rpm_check(release:"SLES10", sp:2, cpu:"x86_64", reference:"mysql-shared-32bit-5.0.26-12.20")) flag++;


if (flag)
{
  if (report_verbosity > 0) security_warning(port:0, extra:rpm_report_get());
  else security_warning(0);
  exit(0);
}
else exit(0, "The host is not affected.");