Ubuntu Update for mysql-dfsg-5.0 regression USN-588-2

###############################################################################
# OpenVAS Vulnerability Test
# $Id: gb_ubuntu_USN_588_2.nasl 7969 2017-12-01 09:23:16Z santu $
#
# Ubuntu Update for mysql-dfsg-5.0 regression USN-588-2
#
# Authors:
# System Generated Check
#
# Copyright:
# Copyright (c) 2009 Greenbone Networks GmbH, http://www.greenbone.net
#
# This program is free software; you can redistribute it and/or modify
# it under the terms of the GNU General Public License version 2
# (or any later version), as published by the Free Software Foundation.
#
# This program is distributed in the hope that it will be useful,
# but WITHOUT ANY WARRANTY; without even the implied warranty of
# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
# GNU General Public License for more details.
#
# You should have received a copy of the GNU General Public License
# along with this program; if not, write to the Free Software
# Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA 02110-1301 USA.
###############################################################################

include("revisions-lib.inc");
tag_insight = "USN-588-1 fixed vulnerabilities in MySQL. In fixing CVE-2007-2692 for
  Ubuntu 6.06, additional improvements were made to make privilege checks
  more restictive. As a result, an upstream bug was exposed which could
  cause operations on tables or views in a different database to fail. This
  update fixes the problem.

  We apologize for the inconvenience.
  
  Original advisory details:
  
  Masaaki Hirose discovered that MySQL could be made to dereference
  a NULL pointer. An authenticated user could cause a denial of service
  (application crash) via an EXPLAIN SELECT FROM on the INFORMATION_SCHEMA
  table. This issue only affects Ubuntu 6.06 and 6.10. (CVE-2006-7232)
  
  Alexander Nozdrin discovered that MySQL did not restore database access
  privileges when returning from SQL SECURITY INVOKER stored routines. An
  authenticated user could exploit this to gain privileges. This issue
  does not affect Ubuntu 7.10. (CVE-2007-2692)
  
  Martin Friebe discovered that MySQL did not properly update the DEFINER
  value of an altered view. An authenticated user could use CREATE SQL
  SECURITY DEFINER VIEW and ALTER VIEW statements to gain privileges.
  (CVE-2007-6303)
  
  Luigi Auriemma discovered that yaSSL as included in MySQL did not
  properly validate its input. A remote attacker could send crafted
  requests and cause a denial of service or possibly execute arbitrary
  code. This issue did not affect Ubuntu 6.06 in the default installation.
  (CVE-2008-0226, CVE-2008-0227)";

tag_summary = "Ubuntu Update for Linux kernel vulnerabilities USN-588-2";
tag_affected = "mysql-dfsg-5.0 regression on Ubuntu 6.06 LTS";
tag_solution = "Please Install the Updated Packages.";



if(description)
{
  script_xref(name: "URL" , value: "http://www.ubuntu.com/usn/usn-588-2/");
  script_id(840240);
  script_version("$Revision: 7969 $");
  script_tag(name:"last_modification", value:"$Date: 2017-12-01 10:23:16 +0100 (Fri, 01 Dec 2017) $");
  script_tag(name:"creation_date", value:"2009-03-23 10:59:50 +0100 (Mon, 23 Mar 2009)");
  script_tag(name:"cvss_base", value:"7.5");
  script_tag(name:"cvss_base_vector", value:"AV:N/AC:L/Au:N/C:P/I:P/A:P");
  script_xref(name: "USN", value: "588-2");
  script_cve_id("CVE-2007-2692", "CVE-2006-7232", "CVE-2007-6303", "CVE-2008-0226", "CVE-2008-0227");
  script_name( "Ubuntu Update for mysql-dfsg-5.0 regression USN-588-2");

  script_category(ACT_GATHER_INFO);
  script_copyright("Copyright (C) 2009 Greenbone Networks GmbH");
  script_family("Ubuntu Local Security Checks");
  script_dependencies("gather-package-list.nasl");
  script_mandatory_keys("ssh/login/ubuntu_linux", "ssh/login/packages");
  script_tag(name : "summary" , value : tag_summary);
  script_tag(name : "affected" , value : tag_affected);
  script_tag(name : "solution" , value : tag_solution);
  script_tag(name : "insight" , value : tag_insight);
  script_tag(name:"qod_type", value:"package");
  script_tag(name:"solution_type", value:"VendorFix");
  exit(0);
}


include("pkg-lib-deb.inc");

release = get_kb_item("ssh/login/release");


res = "";
if(release == NULL){
  exit(0);
}

if(release == "UBUNTU6.06 LTS")
{

  if ((res = isdpkgvuln(pkg:"libmysqlclient15-dev", ver:"5.0.22-0ubuntu6.06.9", rls:"UBUNTU6.06 LTS")) != NULL)
  {
    security_message(data:res);
    exit(0);
  }

  if ((res = isdpkgvuln(pkg:"libmysqlclient15off", ver:"5.0.22-0ubuntu6.06.9", rls:"UBUNTU6.06 LTS")) != NULL)
  {
    security_message(data:res);
    exit(0);
  }

  if ((res = isdpkgvuln(pkg:"mysql-client", ver:"5.0_5.0.22-0ubuntu6.06.9", rls:"UBUNTU6.06 LTS")) != NULL)
  {
    security_message(data:res);
    exit(0);
  }

  if ((res = isdpkgvuln(pkg:"mysql-server", ver:"5.0_5.0.22-0ubuntu6.06.9", rls:"UBUNTU6.06 LTS")) != NULL)
  {
    security_message(data:res);
    exit(0);
  }

  if ((res = isdpkgvuln(pkg:"mysql-client", ver:"5.0.22-0ubuntu6.06.9", rls:"UBUNTU6.06 LTS")) != NULL)
  {
    security_message(data:res);
    exit(0);
  }

  if ((res = isdpkgvuln(pkg:"mysql-common", ver:"5.0.22-0ubuntu6.06.9", rls:"UBUNTU6.06 LTS")) != NULL)
  {
    security_message(data:res);
    exit(0);
  }

  if ((res = isdpkgvuln(pkg:"mysql-server", ver:"5.0.22-0ubuntu6.06.9", rls:"UBUNTU6.06 LTS")) != NULL)
  {
    security_message(data:res);
    exit(0);
  }

  if (__pkg_match) exit(99); # Not vulnerable.
  exit(0);
}