Skip to navigation

Security Advisory Moderate: mysql security, bug fix, and enhancement update

Advisory: RHSA-2008:0768-9
Type: Security Advisory
Severity: Moderate
Issued on: 2008-07-24
Last updated on: 2008-07-24
Affected Products: Red Hat Desktop (v. 4)
Red Hat Enterprise Linux AS (v. 4)
Red Hat Enterprise Linux ES (v. 4)
Red Hat Enterprise Linux WS (v. 4)
CVEs (cve.mitre.org): CVE-2006-3469
CVE-2006-4031
CVE-2007-2691
CVE-2008-2079

Details

Updated mysql packages that fix various security issues, several bugs, and
add an enhancement are now available for Red Hat Enterprise Linux 4.

This update has been rated as having moderate 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.

MySQL did not correctly check directories used as arguments for the DATA
DIRECTORY and INDEX DIRECTORY directives. Using this flaw, an authenticated
attacker could elevate their access privileges to tables created by other
database users. Note: this attack does not work on existing tables. An
attacker can only elevate their access to another user's tables as the
tables are created. As well, the names of these created tables need to be
predicted correctly for this attack to succeed. (CVE-2008-2079)

MySQL did not require the "DROP" privilege for "RENAME TABLE" statements.
An authenticated user could use this flaw to rename arbitrary tables.
(CVE-2007-2691)

MySQL allowed an authenticated user to access a table through a previously
created MERGE table, even after the user's privileges were revoked from the
original table, which might violate intended security policy. This is
addressed by allowing the MERGE storage engine to be disabled, which can be
done by running mysqld with the "--skip-merge" option. (CVE-2006-4031)

A flaw in MySQL allowed an authenticated user to cause the MySQL daemon to
crash via crafted SQL queries. This only caused a temporary denial of
service, as the MySQL daemon is automatically restarted after the crash.
(CVE-2006-3469)

As well, these updated packages fix the following bugs:

* in the previous mysql packages, if a column name was referenced more
than once in an "ORDER BY" section of a query, a segmentation fault
occurred.

* when MySQL failed to start, the init script returned a successful (0)
exit code. When using the Red Hat Cluster Suite, this may have caused
cluster services to report a successful start, even when MySQL failed to
start. In these updated packages, the init script returns the correct exit
codes, which resolves this issue.

* it was possible to use the mysqld_safe command to specify invalid port
numbers (higher than 65536), causing invalid ports to be created, and, in
some cases, a "port number definition: unsigned short" error. In these
updated packages, when an invalid port number is specified, the default
port number is used.

* when setting "myisam_repair_threads > 1", any repair set the index
cardinality to "1", regardless of the table size.

* the MySQL init script no longer runs "chmod -R" on the entire database
directory tree during every startup.

* when running "mysqldump" with the MySQL 4.0 compatibility mode option,
"--compatible=mysql40", mysqldump created dumps that omitted the
"auto_increment" field.

As well, the MySQL init script now uses more reliable methods for
determining parameters, such as the data directory location.

Note: these updated packages upgrade MySQL to version 4.1.22. For a full
list of bug fixes and enhancements, refer to the MySQL release notes:
http://dev.mysql.com/doc/refman/4.1/en/news-4-1-22.html

All mysql users are advised to upgrade to these updated packages, which
resolve these issues and add this enhancement.


Solution

Before applying this update, make sure that all previously-released
errata relevant to your system have been applied.

This update is available via Red Hat Network. Details on how to use
the Red Hat Network to apply this update are available at
http://kbase.redhat.com/faq/FAQ_58_10188

Updated packages

Red Hat Desktop (v. 4)

SRPMS:
mysql-4.1.22-2.el4.src.rpm
File outdated by:  RHSA-2010:0824
    MD5: dc17c0b97952d2ce3826db006246392d
 
IA-32:
mysql-4.1.22-2.el4.i386.rpm
File outdated by:  RHSA-2010:0824
    MD5: 3b5ebe1d600ff77736e1c7d79f1684b4
mysql-bench-4.1.22-2.el4.i386.rpm
File outdated by:  RHSA-2010:0824
    MD5: 0885407d02afa3503dc41b17af52904f
mysql-devel-4.1.22-2.el4.i386.rpm
File outdated by:  RHSA-2010:0824
    MD5: 8d8ce33607456d956b868b9267916f13
mysql-server-4.1.22-2.el4.i386.rpm
File outdated by:  RHSA-2010:0824
    MD5: 3c1930449709680afaf320cfe5ff302e
 
x86_64:
mysql-4.1.22-2.el4.i386.rpm
File outdated by:  RHSA-2010:0824
    MD5: 3b5ebe1d600ff77736e1c7d79f1684b4
mysql-4.1.22-2.el4.x86_64.rpm
File outdated by:  RHSA-2010:0824
    MD5: 5ff518c812ff64a77f108e374d631459
mysql-bench-4.1.22-2.el4.x86_64.rpm
File outdated by:  RHSA-2010:0824
    MD5: 0b7c617e2c49785a33084f5d42923a8b
mysql-devel-4.1.22-2.el4.x86_64.rpm
File outdated by:  RHSA-2010:0824
    MD5: a0c7c7340599cc21f24ca028b354240e
mysql-server-4.1.22-2.el4.x86_64.rpm
File outdated by:  RHSA-2010:0824
    MD5: d85efe40973e8c6ed8abd859861cf04d
 
Red Hat Enterprise Linux AS (v. 4)

SRPMS:
mysql-4.1.22-2.el4.src.rpm
File outdated by:  RHSA-2010:0824
    MD5: dc17c0b97952d2ce3826db006246392d
 
IA-32:
mysql-4.1.22-2.el4.i386.rpm
File outdated by:  RHSA-2010:0824
    MD5: 3b5ebe1d600ff77736e1c7d79f1684b4
mysql-bench-4.1.22-2.el4.i386.rpm
File outdated by:  RHSA-2010:0824
    MD5: 0885407d02afa3503dc41b17af52904f
mysql-devel-4.1.22-2.el4.i386.rpm
File outdated by:  RHSA-2010:0824
    MD5: 8d8ce33607456d956b868b9267916f13
mysql-server-4.1.22-2.el4.i386.rpm
File outdated by:  RHSA-2010:0824
    MD5: 3c1930449709680afaf320cfe5ff302e
 
IA-64:
mysql-4.1.22-2.el4.i386.rpm
File outdated by:  RHSA-2010:0824
    MD5: 3b5ebe1d600ff77736e1c7d79f1684b4
mysql-4.1.22-2.el4.ia64.rpm
File outdated by:  RHSA-2010:0824
    MD5: 089ada2bd5466b8119befae40641a862
mysql-bench-4.1.22-2.el4.ia64.rpm
File outdated by:  RHSA-2010:0824
    MD5: 2306bf2bf935252e02658dbf87f87c06
mysql-devel-4.1.22-2.el4.ia64.rpm
File outdated by:  RHSA-2010:0824
    MD5: 733424072d9ddcab026d83f430ddb656
mysql-server-4.1.22-2.el4.ia64.rpm
File outdated by:  RHSA-2010:0824
    MD5: ab71c2421a0187e3a1e5bd5736fe5d2a
 
PPC:
mysql-4.1.22-2.el4.ppc.rpm
File outdated by:  RHSA-2010:0824
    MD5: ba64e77f6b0aac03711dbcd916f0d8c5
mysql-4.1.22-2.el4.ppc64.rpm
File outdated by:  RHSA-2010:0824
    MD5: ddef3e39fd09243d5a27f2ba51069a7e
mysql-bench-4.1.22-2.el4.ppc.rpm
File outdated by:  RHSA-2010:0824
    MD5: a67a213d654e70532c59c8cdfcd33d6e
mysql-devel-4.1.22-2.el4.ppc.rpm
File outdated by:  RHSA-2010:0824
    MD5: 5406a582e62f1e5e6680f46289efde7e
mysql-server-4.1.22-2.el4.ppc.rpm
File outdated by:  RHSA-2010:0824
    MD5: ef59f1b0f06e2ad5a2540ec3be5b61ca
 
s390:
mysql-4.1.22-2.el4.s390.rpm
File outdated by:  RHSA-2010:0824
    MD5: 8a74a88b7f4568960f00345223421e7b
mysql-bench-4.1.22-2.el4.s390.rpm
File outdated by:  RHSA-2010:0824
    MD5: baffe8c3620028d6c60451c862a38ea8
mysql-devel-4.1.22-2.el4.s390.rpm
File outdated by:  RHSA-2010:0824
    MD5: 451df7d9ed21ae16e056033c55a1bce0
mysql-server-4.1.22-2.el4.s390.rpm
File outdated by:  RHSA-2010:0824
    MD5: 64eccc1df24f836079b92e4fdd9ebeeb
 
s390x:
mysql-4.1.22-2.el4.s390.rpm
File outdated by:  RHSA-2010:0824
    MD5: 8a74a88b7f4568960f00345223421e7b
mysql-4.1.22-2.el4.s390x.rpm
File outdated by:  RHSA-2010:0824
    MD5: 4ac68d1222c729b0d9b49943142ab8c7
mysql-bench-4.1.22-2.el4.s390x.rpm
File outdated by:  RHSA-2010:0824
    MD5: 3bb928e3e36483e3e14ecc3deb53e79c
mysql-devel-4.1.22-2.el4.s390x.rpm
File outdated by:  RHSA-2010:0824
    MD5: ecf27022c74309ddaaa465e6b7018a92
mysql-server-4.1.22-2.el4.s390x.rpm
File outdated by:  RHSA-2010:0824
    MD5: 0ad1981015fee1598bb46169ea502c12
 
x86_64:
mysql-4.1.22-2.el4.i386.rpm
File outdated by:  RHSA-2010:0824
    MD5: 3b5ebe1d600ff77736e1c7d79f1684b4
mysql-4.1.22-2.el4.x86_64.rpm
File outdated by:  RHSA-2010:0824
    MD5: 5ff518c812ff64a77f108e374d631459
mysql-bench-4.1.22-2.el4.x86_64.rpm
File outdated by:  RHSA-2010:0824
    MD5: 0b7c617e2c49785a33084f5d42923a8b
mysql-devel-4.1.22-2.el4.x86_64.rpm
File outdated by:  RHSA-2010:0824
    MD5: a0c7c7340599cc21f24ca028b354240e
mysql-server-4.1.22-2.el4.x86_64.rpm
File outdated by:  RHSA-2010:0824
    MD5: d85efe40973e8c6ed8abd859861cf04d
 
Red Hat Enterprise Linux ES (v. 4)

SRPMS:
mysql-4.1.22-2.el4.src.rpm
File outdated by:  RHSA-2010:0824
    MD5: dc17c0b97952d2ce3826db006246392d
 
IA-32:
mysql-4.1.22-2.el4.i386.rpm
File outdated by:  RHSA-2010:0824
    MD5: 3b5ebe1d600ff77736e1c7d79f1684b4
mysql-bench-4.1.22-2.el4.i386.rpm
File outdated by:  RHSA-2010:0824
    MD5: 0885407d02afa3503dc41b17af52904f
mysql-devel-4.1.22-2.el4.i386.rpm
File outdated by:  RHSA-2010:0824
    MD5: 8d8ce33607456d956b868b9267916f13
mysql-server-4.1.22-2.el4.i386.rpm
File outdated by:  RHSA-2010:0824
    MD5: 3c1930449709680afaf320cfe5ff302e
 
IA-64:
mysql-4.1.22-2.el4.i386.rpm
File outdated by:  RHSA-2010:0824
    MD5: 3b5ebe1d600ff77736e1c7d79f1684b4
mysql-4.1.22-2.el4.ia64.rpm
File outdated by:  RHSA-2010:0824
    MD5: 089ada2bd5466b8119befae40641a862
mysql-bench-4.1.22-2.el4.ia64.rpm
File outdated by:  RHSA-2010:0824
    MD5: 2306bf2bf935252e02658dbf87f87c06
mysql-devel-4.1.22-2.el4.ia64.rpm
File outdated by:  RHSA-2010:0824
    MD5: 733424072d9ddcab026d83f430ddb656
mysql-server-4.1.22-2.el4.ia64.rpm
File outdated by:  RHSA-2010:0824
    MD5: ab71c2421a0187e3a1e5bd5736fe5d2a
 
x86_64:
mysql-4.1.22-2.el4.i386.rpm
File outdated by:  RHSA-2010:0824
    MD5: 3b5ebe1d600ff77736e1c7d79f1684b4
mysql-4.1.22-2.el4.x86_64.rpm
File outdated by:  RHSA-2010:0824
    MD5: 5ff518c812ff64a77f108e374d631459
mysql-bench-4.1.22-2.el4.x86_64.rpm
File outdated by:  RHSA-2010:0824
    MD5: 0b7c617e2c49785a33084f5d42923a8b
mysql-devel-4.1.22-2.el4.x86_64.rpm
File outdated by:  RHSA-2010:0824
    MD5: a0c7c7340599cc21f24ca028b354240e
mysql-server-4.1.22-2.el4.x86_64.rpm
File outdated by:  RHSA-2010:0824
    MD5: d85efe40973e8c6ed8abd859861cf04d
 
Red Hat Enterprise Linux WS (v. 4)

SRPMS:
mysql-4.1.22-2.el4.src.rpm
File outdated by:  RHSA-2010:0824
    MD5: dc17c0b97952d2ce3826db006246392d
 
IA-32:
mysql-4.1.22-2.el4.i386.rpm
File outdated by:  RHSA-2010:0824
    MD5: 3b5ebe1d600ff77736e1c7d79f1684b4
mysql-bench-4.1.22-2.el4.i386.rpm
File outdated by:  RHSA-2010:0824
    MD5: 0885407d02afa3503dc41b17af52904f
mysql-devel-4.1.22-2.el4.i386.rpm
File outdated by:  RHSA-2010:0824
    MD5: 8d8ce33607456d956b868b9267916f13
mysql-server-4.1.22-2.el4.i386.rpm
File outdated by:  RHSA-2010:0824
    MD5: 3c1930449709680afaf320cfe5ff302e
 
IA-64:
mysql-4.1.22-2.el4.i386.rpm
File outdated by:  RHSA-2010:0824
    MD5: 3b5ebe1d600ff77736e1c7d79f1684b4
mysql-4.1.22-2.el4.ia64.rpm
File outdated by:  RHSA-2010:0824
    MD5: 089ada2bd5466b8119befae40641a862
mysql-bench-4.1.22-2.el4.ia64.rpm
File outdated by:  RHSA-2010:0824
    MD5: 2306bf2bf935252e02658dbf87f87c06
mysql-devel-4.1.22-2.el4.ia64.rpm
File outdated by:  RHSA-2010:0824
    MD5: 733424072d9ddcab026d83f430ddb656
mysql-server-4.1.22-2.el4.ia64.rpm
File outdated by:  RHSA-2010:0824
    MD5: ab71c2421a0187e3a1e5bd5736fe5d2a
 
x86_64:
mysql-4.1.22-2.el4.i386.rpm
File outdated by:  RHSA-2010:0824
    MD5: 3b5ebe1d600ff77736e1c7d79f1684b4
mysql-4.1.22-2.el4.x86_64.rpm
File outdated by:  RHSA-2010:0824
    MD5: 5ff518c812ff64a77f108e374d631459
mysql-bench-4.1.22-2.el4.x86_64.rpm
File outdated by:  RHSA-2010:0824
    MD5: 0b7c617e2c49785a33084f5d42923a8b
mysql-devel-4.1.22-2.el4.x86_64.rpm
File outdated by:  RHSA-2010:0824
    MD5: a0c7c7340599cc21f24ca028b354240e
mysql-server-4.1.22-2.el4.x86_64.rpm
File outdated by:  RHSA-2010:0824
    MD5: d85efe40973e8c6ed8abd859861cf04d
 
(The unlinked packages above are only available from the Red Hat Network)

Bugs fixed (see bugzilla for more information)

201904 - CVE-2006-3469 mysql server DoS
201988 - Queries using a column name multiple times in ORDER BY crash mysql
202246 - CVE-2006-4031 MySQL improper permission revocation
221085 - chown -R of the mysql data directory every startup
233771 - RFE+patch: MySQLd "init.d" startup script should rely on "/usr/bin/my_print_defaults" to get at options
241688 - CVE-2007-2691 mysql DROP privilege not enforced when renaming tables
445222 - CVE-2008-2079 mysql: privilege escalation via DATA/INDEX DIRECTORY directives


References



These packages are GPG signed by Red Hat for security. Our key and details on how to verify the signature are available from:
https://www.redhat.com/security/team/key/#package

The Red Hat security contact is secalert@redhat.com. More contact details at http://www.redhat.com/security/team/contact/