Vulnerabilities > CVE-2006-2753 - SQL Injection vulnerability in MySQL Mysql_real_escape Function

#%NASL_MIN_LEVEL 80502
#
# (C) Tenable Network Security, Inc.
#
# The descriptive text and package checks in this plugin were  
# extracted from Red Hat Security Advisory RHSA-2006:0544. The text 
# itself is copyright (C) Red Hat, Inc.
#

include("compat.inc");

if (description)
{
  script_id(21683);
  script_version ("1.24");
  script_cvs_date("Date: 2019/10/25 13:36:12");

  script_cve_id("CVE-2006-0903", "CVE-2006-1516", "CVE-2006-1517", "CVE-2006-2753", "CVE-2006-3081", "CVE-2006-4380");
  script_bugtraq_id(17780);
  script_xref(name:"RHSA", value:"2006:0544");

  script_name(english:"RHEL 4 : mysql (RHSA-2006:0544)");
  script_summary(english:"Checks the rpm output for the updated packages");

  script_set_attribute(
    attribute:"synopsis", 
    value:"The remote Red Hat host is missing one or more security updates."
  );
  script_set_attribute(
    attribute:"description", 
    value:
"Updated mysql packages that fix multiple security flaws are now
available.

This update has been rated as having important security impact by the
Red Hat Security Response Team.

MySQL is a multi-user, multi-threaded SQL database server. MySQL is a
client/server implementation consisting of a server daemon (mysqld)
and many different client programs and libraries.

A flaw was found in the way the MySQL mysql_real_escape() function
escaped strings when operating in a multibyte character encoding. An
attacker could provide an application a carefully crafted string
containing invalidly-encoded characters which may be improperly
escaped, leading to the injection of malicious SQL commands.
(CVE-2006-2753)

An information disclosure flaw was found in the way the MySQL server
processed malformed usernames. An attacker could view a small portion
of server memory by supplying an anonymous login username which was
not null terminated. (CVE-2006-1516)

An information disclosure flaw was found in the way the MySQL server
executed the COM_TABLE_DUMP command. An authenticated malicious user
could send a specially crafted packet to the MySQL server which
returned random unallocated memory. (CVE-2006-1517)

A log file obfuscation flaw was found in the way the
mysql_real_query() function creates log file entries. An attacker with
the the ability to call the mysql_real_query() function against a
mysql server can obfuscate the entry the server will write to the log
file. However, an attacker needed to have complete control over a
server in order to attempt this attack. (CVE-2006-0903)

This update also fixes numerous non-security-related flaws, such as
intermittent authentication failures.

All users of mysql are advised to upgrade to these updated packages
containing MySQL version 4.1.20, which is not vulnerable to these
issues."
  );
  script_set_attribute(
    attribute:"see_also",
    value:"https://access.redhat.com/security/cve/cve-2006-0903"
  );
  script_set_attribute(
    attribute:"see_also",
    value:"https://access.redhat.com/security/cve/cve-2006-1516"
  );
  script_set_attribute(
    attribute:"see_also",
    value:"https://access.redhat.com/security/cve/cve-2006-1517"
  );
  script_set_attribute(
    attribute:"see_also",
    value:"https://access.redhat.com/security/cve/cve-2006-2753"
  );
  script_set_attribute(
    attribute:"see_also",
    value:"https://access.redhat.com/security/cve/cve-2006-3081"
  );
  script_set_attribute(
    attribute:"see_also",
    value:"https://access.redhat.com/security/cve/cve-2006-4380"
  );
  # http://lists.mysql.com/announce/364
  script_set_attribute(
    attribute:"see_also",
    value:"https://lists.mysql.com/announce/364"
  );
  script_set_attribute(
    attribute:"see_also",
    value:"https://access.redhat.com/errata/RHSA-2006:0544"
  );
  script_set_attribute(attribute:"solution", value:"Update the affected packages.");
  script_set_cvss_base_vector("CVSS2#AV:N/AC:L/Au:N/C:P/I:P/A:P");
  script_set_cvss_temporal_vector("CVSS2#E:POC/RL:OF/RC:C");
  script_set_attribute(attribute:"exploitability_ease", value:"Exploits are available");
  script_set_attribute(attribute:"exploit_available", value:"true");

  script_set_attribute(attribute:"plugin_type", value:"local");
  script_set_attribute(attribute:"cpe", value:"p-cpe:/a:redhat:enterprise_linux:mysql");
  script_set_attribute(attribute:"cpe", value:"p-cpe:/a:redhat:enterprise_linux:mysql-bench");
  script_set_attribute(attribute:"cpe", value:"p-cpe:/a:redhat:enterprise_linux:mysql-devel");
  script_set_attribute(attribute:"cpe", value:"p-cpe:/a:redhat:enterprise_linux:mysql-server");
  script_set_attribute(attribute:"cpe", value:"cpe:/o:redhat:enterprise_linux:4");

  script_set_attribute(attribute:"vuln_publication_date", value:"2006/02/27");
  script_set_attribute(attribute:"patch_publication_date", value:"2006/06/08");
  script_set_attribute(attribute:"plugin_publication_date", value:"2006/06/11");
  script_set_attribute(attribute:"generated_plugin", value:"current");
  script_end_attributes();

  script_category(ACT_GATHER_INFO);
  script_copyright(english:"This script is Copyright (C) 2006-2019 and is owned by Tenable, Inc. or an Affiliate thereof.");
  script_family(english:"Red Hat Local Security Checks");

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

  exit(0);
}


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

if (!get_kb_item("Host/local_checks_enabled")) audit(AUDIT_LOCAL_CHECKS_NOT_ENABLED);
release = get_kb_item("Host/RedHat/release");
if (isnull(release) || "Red Hat" >!< release) audit(AUDIT_OS_NOT, "Red Hat");
os_ver = pregmatch(pattern: "Red Hat Enterprise Linux.*release ([0-9]+(\.[0-9]+)?)", string:release);
if (isnull(os_ver)) audit(AUDIT_UNKNOWN_APP_VER, "Red Hat");
os_ver = os_ver[1];
if (! preg(pattern:"^4([^0-9]|$)", string:os_ver)) audit(AUDIT_OS_NOT, "Red Hat 4.x", "Red Hat " + os_ver);

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

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

yum_updateinfo = get_kb_item("Host/RedHat/yum-updateinfo");
if (!empty_or_null(yum_updateinfo)) 
{
  rhsa = "RHSA-2006:0544";
  yum_report = redhat_generate_yum_updateinfo_report(rhsa:rhsa);
  if (!empty_or_null(yum_report))
  {
    security_report_v4(
      port       : 0,
      severity   : SECURITY_HOLE,
      extra      : yum_report 
    );
    exit(0);
  }
  else
  {
    audit_message = "affected by Red Hat security advisory " + rhsa;
    audit(AUDIT_OS_NOT, audit_message);
  }
}
else
{
  flag = 0;
  if (rpm_check(release:"RHEL4", reference:"mysql-4.1.20-1.RHEL4.1")) flag++;
  if (rpm_check(release:"RHEL4", reference:"mysql-bench-4.1.20-1.RHEL4.1")) flag++;
  if (rpm_check(release:"RHEL4", reference:"mysql-devel-4.1.20-1.RHEL4.1")) flag++;
  if (rpm_check(release:"RHEL4", reference:"mysql-server-4.1.20-1.RHEL4.1")) flag++;

  if (flag)
  {
    security_report_v4(
      port       : 0,
      severity   : SECURITY_HOLE,
      extra      : rpm_report_get() + redhat_report_package_caveat()
    );
    exit(0);
  }
  else
  {
    tested = pkg_tests_get();
    if (tested) audit(AUDIT_PACKAGE_NOT_AFFECTED, tested);
    else audit(AUDIT_PACKAGE_NOT_INSTALLED, "mysql / mysql-bench / mysql-devel / mysql-server");
  }
}

#%NASL_MIN_LEVEL 80502
#
# (C) Tenable Network Security, Inc.
#
# The descriptive text and package checks in this plugin were
# extracted from Ubuntu Security Notice USN-288-3. The text 
# itself is copyright (C) Canonical, Inc. See 
# <http://www.ubuntu.com/usn/>. Ubuntu(R) is a registered 
# trademark of Canonical, Inc.
#

include("compat.inc");

if (description)
{
  script_id(27859);
  script_version("1.12");
  script_cvs_date("Date: 2019/08/02 13:33:00");

  script_cve_id("CVE-2006-2313", "CVE-2006-2314", "CVE-2006-2753");
  script_xref(name:"USN", value:"288-3");

  script_name(english:"Ubuntu 5.04 / 5.10 / 6.06 LTS : dovecot, exim4, postfix vulnerabilities (USN-288-3)");
  script_summary(english:"Checks dpkg output for updated packages.");

  script_set_attribute(
    attribute:"synopsis", 
    value:
"The remote Ubuntu host is missing one or more security-related
patches."
  );
  script_set_attribute(
    attribute:"description", 
    value:
"USN-288-1 described a PostgreSQL client vulnerability in the way the
>>'<< character is escaped in SQL queries. It was determined that the
PostgreSQL backends of Exim, Dovecot, and Postfix used this unsafe
escaping method.

For reference, these are the details of the original USN :

CVE-2006-2313: Akio Ishida and Yasuo Ohgaki discovered a weakness in
the handling of invalidly-encoded multibyte text data. If a client
application processed untrusted input without respecting its encoding
and applied standard string escaping techniques (such as replacing a
single quote >>'<< with >>\'<< or >>''<<), the PostgreSQL server could
interpret the resulting string in a way that allowed an attacker to
inject arbitrary SQL commands into the resulting SQL query. The
PostgreSQL server has been modified to reject such invalidly encoded
strings now, which completely fixes the problem for some 'safe'
multibyte encodings like UTF-8.

CVE-2006-2314: However, there are some less popular and
client-only multibyte encodings (such as SJIS, BIG5, GBK,
GB18030, and UHC) which contain valid multibyte characters
that end with the byte 0x5c, which is the representation of
the backslash character >>\<< in ASCII. Many client
libraries and applications use the non-standard, but popular
way of escaping the >>'<< character by replacing all
occurences of it with >>\'<<. If a client application uses
one of the affected encodings and does not interpret
multibyte characters, and an attacker supplies a specially
crafted byte sequence as an input string parameter, this
escaping method would then produce a validly-encoded
character and an excess >>'<< character which would end the
string. All subsequent characters would then be interpreted
as SQL code, so the attacker could execute arbitrary SQL
commands.

To fix this vulnerability end-to-end, client-side applications must be
fixed to properly interpret multibyte encodings and use >>''<< instead
of >>\'<<. However, as a precautionary measure, the sequence >>\'<< is
now regarded as invalid when one of the affected client encodings is
in use. If you depend on the previous behaviour, you can restore it by
setting 'backslash_quote = on' in postgresql.conf. However, please be
aware that this could render you vulnerable again.

This issue does not affect you if you only use single-byte
(like SQL_ASCII or the ISO-8859-X family) or unaffected
multibyte (like UTF-8) encodings.

Please see http://www.postgresql.org/docs/techdocs.50 for
further details.

Note that Tenable Network Security has extracted the preceding
description block directly from the Ubuntu 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://usn.ubuntu.com/288-3/"
  );
  script_set_attribute(attribute:"solution", value:"Update the affected packages.");
  script_set_cvss_base_vector("CVSS2#AV:N/AC:L/Au:N/C:P/I:P/A:P");

  script_set_attribute(attribute:"plugin_type", value:"local");
  script_set_attribute(attribute:"cpe", value:"p-cpe:/a:canonical:ubuntu_linux:dovecot");
  script_set_attribute(attribute:"cpe", value:"p-cpe:/a:canonical:ubuntu_linux:dovecot-common");
  script_set_attribute(attribute:"cpe", value:"p-cpe:/a:canonical:ubuntu_linux:dovecot-imapd");
  script_set_attribute(attribute:"cpe", value:"p-cpe:/a:canonical:ubuntu_linux:dovecot-pop3d");
  script_set_attribute(attribute:"cpe", value:"p-cpe:/a:canonical:ubuntu_linux:exim4");
  script_set_attribute(attribute:"cpe", value:"p-cpe:/a:canonical:ubuntu_linux:exim4-base");
  script_set_attribute(attribute:"cpe", value:"p-cpe:/a:canonical:ubuntu_linux:exim4-config");
  script_set_attribute(attribute:"cpe", value:"p-cpe:/a:canonical:ubuntu_linux:exim4-daemon-heavy");
  script_set_attribute(attribute:"cpe", value:"p-cpe:/a:canonical:ubuntu_linux:exim4-daemon-light");
  script_set_attribute(attribute:"cpe", value:"p-cpe:/a:canonical:ubuntu_linux:eximon4");
  script_set_attribute(attribute:"cpe", value:"p-cpe:/a:canonical:ubuntu_linux:postfix");
  script_set_attribute(attribute:"cpe", value:"p-cpe:/a:canonical:ubuntu_linux:postfix-dev");
  script_set_attribute(attribute:"cpe", value:"p-cpe:/a:canonical:ubuntu_linux:postfix-doc");
  script_set_attribute(attribute:"cpe", value:"p-cpe:/a:canonical:ubuntu_linux:postfix-ldap");
  script_set_attribute(attribute:"cpe", value:"p-cpe:/a:canonical:ubuntu_linux:postfix-mysql");
  script_set_attribute(attribute:"cpe", value:"p-cpe:/a:canonical:ubuntu_linux:postfix-pcre");
  script_set_attribute(attribute:"cpe", value:"p-cpe:/a:canonical:ubuntu_linux:postfix-pgsql");
  script_set_attribute(attribute:"cpe", value:"p-cpe:/a:canonical:ubuntu_linux:postfix-tls");
  script_set_attribute(attribute:"cpe", value:"cpe:/o:canonical:ubuntu_linux:5.04");
  script_set_attribute(attribute:"cpe", value:"cpe:/o:canonical:ubuntu_linux:5.10");
  script_set_attribute(attribute:"cpe", value:"cpe:/o:canonical:ubuntu_linux:6.06:-:lts");

  script_set_attribute(attribute:"patch_publication_date", value:"2006/06/09");
  script_set_attribute(attribute:"plugin_publication_date", value:"2007/11/10");
  script_end_attributes();

  script_category(ACT_GATHER_INFO);
  script_copyright(english:"Ubuntu Security Notice (C) 2007-2019 Canonical, Inc. / NASL script (C) 2018 and is owned by Tenable, Inc. or an Affiliate thereof.");
  script_family(english:"Ubuntu Local Security Checks");

  script_dependencies("ssh_get_info.nasl");
  script_require_keys("Host/cpu", "Host/Ubuntu", "Host/Ubuntu/release", "Host/Debian/dpkg-l");

  exit(0);
}


include("audit.inc");
include("ubuntu.inc");
include("misc_func.inc");

if ( ! get_kb_item("Host/local_checks_enabled") ) audit(AUDIT_LOCAL_CHECKS_NOT_ENABLED);
release = get_kb_item("Host/Ubuntu/release");
if ( isnull(release) ) audit(AUDIT_OS_NOT, "Ubuntu");
release = chomp(release);
if (! ereg(pattern:"^(5\.04|5\.10|6\.06)$", string:release)) audit(AUDIT_OS_NOT, "Ubuntu 5.04 / 5.10 / 6.06", "Ubuntu " + release);
if ( ! get_kb_item("Host/Debian/dpkg-l") ) audit(AUDIT_PACKAGE_LIST_MISSING);

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

flag = 0;

if (ubuntu_check(osver:"5.04", pkgname:"dovecot", pkgver:"0.99.13-3ubuntu0.1")) flag++;
if (ubuntu_check(osver:"5.04", pkgname:"dovecot-common", pkgver:"0.99.13-3ubuntu0.1")) flag++;
if (ubuntu_check(osver:"5.04", pkgname:"dovecot-imapd", pkgver:"0.99.13-3ubuntu0.1")) flag++;
if (ubuntu_check(osver:"5.04", pkgname:"dovecot-pop3d", pkgver:"0.99.13-3ubuntu0.1")) flag++;
if (ubuntu_check(osver:"5.04", pkgname:"exim4", pkgver:"4.34-10ubuntu0.1")) flag++;
if (ubuntu_check(osver:"5.04", pkgname:"exim4-base", pkgver:"4.34-10ubuntu0.1")) flag++;
if (ubuntu_check(osver:"5.04", pkgname:"exim4-config", pkgver:"4.34-10ubuntu0.1")) flag++;
if (ubuntu_check(osver:"5.04", pkgname:"exim4-daemon-heavy", pkgver:"4.34-10ubuntu0.1")) flag++;
if (ubuntu_check(osver:"5.04", pkgname:"exim4-daemon-light", pkgver:"4.34-10ubuntu0.1")) flag++;
if (ubuntu_check(osver:"5.04", pkgname:"eximon4", pkgver:"4.34-10ubuntu0.1")) flag++;
if (ubuntu_check(osver:"5.04", pkgname:"postfix", pkgver:"2.1.5-9ubuntu3.1")) flag++;
if (ubuntu_check(osver:"5.04", pkgname:"postfix-dev", pkgver:"2.1.5-9ubuntu3.1")) flag++;
if (ubuntu_check(osver:"5.04", pkgname:"postfix-doc", pkgver:"2.1.5-9ubuntu3.1")) flag++;
if (ubuntu_check(osver:"5.04", pkgname:"postfix-ldap", pkgver:"2.1.5-9ubuntu3.1")) flag++;
if (ubuntu_check(osver:"5.04", pkgname:"postfix-mysql", pkgver:"2.1.5-9ubuntu3.1")) flag++;
if (ubuntu_check(osver:"5.04", pkgname:"postfix-pcre", pkgver:"2.1.5-9ubuntu3.1")) flag++;
if (ubuntu_check(osver:"5.04", pkgname:"postfix-pgsql", pkgver:"2.1.5-9ubuntu3.1")) flag++;
if (ubuntu_check(osver:"5.04", pkgname:"postfix-tls", pkgver:"2.1.5-9ubuntu3.1")) flag++;
if (ubuntu_check(osver:"5.10", pkgname:"dovecot", pkgver:"0.99.14-1ubuntu1.1")) flag++;
if (ubuntu_check(osver:"5.10", pkgname:"dovecot-common", pkgver:"0.99.14-1ubuntu1.1")) flag++;
if (ubuntu_check(osver:"5.10", pkgname:"dovecot-imapd", pkgver:"0.99.14-1ubuntu1.1")) flag++;
if (ubuntu_check(osver:"5.10", pkgname:"dovecot-pop3d", pkgver:"0.99.14-1ubuntu1.1")) flag++;
if (ubuntu_check(osver:"5.10", pkgname:"exim4", pkgver:"4.52-1ubuntu0.1")) flag++;
if (ubuntu_check(osver:"5.10", pkgname:"exim4-base", pkgver:"4.52-1ubuntu0.1")) flag++;
if (ubuntu_check(osver:"5.10", pkgname:"exim4-config", pkgver:"4.52-1ubuntu0.1")) flag++;
if (ubuntu_check(osver:"5.10", pkgname:"exim4-daemon-heavy", pkgver:"4.52-1ubuntu0.1")) flag++;
if (ubuntu_check(osver:"5.10", pkgname:"exim4-daemon-light", pkgver:"4.52-1ubuntu0.1")) flag++;
if (ubuntu_check(osver:"5.10", pkgname:"eximon4", pkgver:"4.52-1ubuntu0.1")) flag++;
if (ubuntu_check(osver:"5.10", pkgname:"postfix", pkgver:"2.2.4-1ubuntu2.1")) flag++;
if (ubuntu_check(osver:"5.10", pkgname:"postfix-dev", pkgver:"2.2.4-1ubuntu2.1")) flag++;
if (ubuntu_check(osver:"5.10", pkgname:"postfix-doc", pkgver:"2.2.4-1ubuntu2.1")) flag++;
if (ubuntu_check(osver:"5.10", pkgname:"postfix-ldap", pkgver:"2.2.4-1ubuntu2.1")) flag++;
if (ubuntu_check(osver:"5.10", pkgname:"postfix-mysql", pkgver:"2.2.4-1ubuntu2.1")) flag++;
if (ubuntu_check(osver:"5.10", pkgname:"postfix-pcre", pkgver:"2.2.4-1ubuntu2.1")) flag++;
if (ubuntu_check(osver:"5.10", pkgname:"postfix-pgsql", pkgver:"2.2.4-1ubuntu2.1")) flag++;
if (ubuntu_check(osver:"6.06", pkgname:"dovecot-common", pkgver:"1.0.beta3-3ubuntu5.1")) flag++;
if (ubuntu_check(osver:"6.06", pkgname:"dovecot-imapd", pkgver:"1.0.beta3-3ubuntu5.1")) flag++;
if (ubuntu_check(osver:"6.06", pkgname:"dovecot-pop3d", pkgver:"1.0.beta3-3ubuntu5.1")) flag++;
if (ubuntu_check(osver:"6.06", pkgname:"exim4", pkgver:"4.60-3ubuntu3.1")) flag++;
if (ubuntu_check(osver:"6.06", pkgname:"exim4-base", pkgver:"4.60-3ubuntu3.1")) flag++;
if (ubuntu_check(osver:"6.06", pkgname:"exim4-config", pkgver:"4.60-3ubuntu3.1")) flag++;
if (ubuntu_check(osver:"6.06", pkgname:"exim4-daemon-heavy", pkgver:"4.60-3ubuntu3.1")) flag++;
if (ubuntu_check(osver:"6.06", pkgname:"exim4-daemon-light", pkgver:"4.60-3ubuntu3.1")) flag++;
if (ubuntu_check(osver:"6.06", pkgname:"eximon4", pkgver:"4.60-3ubuntu3.1")) flag++;
if (ubuntu_check(osver:"6.06", pkgname:"postfix", pkgver:"2.2.10-1ubuntu0.1")) flag++;
if (ubuntu_check(osver:"6.06", pkgname:"postfix-dev", pkgver:"2.2.10-1ubuntu0.1")) flag++;
if (ubuntu_check(osver:"6.06", pkgname:"postfix-doc", pkgver:"2.2.10-1ubuntu0.1")) flag++;
if (ubuntu_check(osver:"6.06", pkgname:"postfix-ldap", pkgver:"2.2.10-1ubuntu0.1")) flag++;
if (ubuntu_check(osver:"6.06", pkgname:"postfix-mysql", pkgver:"2.2.10-1ubuntu0.1")) flag++;
if (ubuntu_check(osver:"6.06", pkgname:"postfix-pcre", pkgver:"2.2.10-1ubuntu0.1")) flag++;
if (ubuntu_check(osver:"6.06", pkgname:"postfix-pgsql", pkgver:"2.2.10-1ubuntu0.1")) flag++;

if (flag)
{
  security_report_v4(
    port       : 0,
    severity   : SECURITY_HOLE,
    extra      : ubuntu_report_get()
  );
  exit(0);
}
else
{
  tested = ubuntu_pkg_tests_get();
  if (tested) audit(AUDIT_PACKAGE_NOT_AFFECTED, tested);
  else audit(AUDIT_PACKAGE_NOT_INSTALLED, "dovecot / dovecot-common / dovecot-imapd / dovecot-pop3d / exim4 / etc");
}