Home / mailings [RHSA-2008:0364-01] Low: mysql security and bug fix update
Posted on 21 May 2008
RedHat-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
=====================================================================
Red Hat Security Advisory
Synopsis: Low: mysql security and bug fix update
Advisory ID: RHSA-2008:0364-01
Product: Red Hat Enterprise Linux
Advisory URL: https://rhn.redhat.com/errata/RHSA-2008-0364.html
Issue date: 2008-05-20
Updated on: 2008-05-21
CVE Names: CVE-2006-0903 CVE-2006-4031 CVE-2006-4227
CVE-2006-7232 CVE-2007-1420 CVE-2007-2583
CVE-2007-2691 CVE-2007-2692 CVE-2007-3781
CVE-2007-3782
=====================================================================
1. Summary:
Updated mysql packages that fix various security issues and several bugs
are now available for Red Hat Enterprise Linux 5.
This update has been rated as having low security impact by the Red Hat
Security Response Team.
2. Relevant releases/architectures:
Red Hat Enterprise Linux Desktop (v. 5 client) - i386, x86_64
RHEL Desktop Workstation (v. 5 client) - i386, x86_64
Red Hat Enterprise Linux (v. 5 server) - i386, ia64, ppc, s390x, x86_64
3. Description:
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 require privileges such as "SELECT" for the source table in a
"CREATE TABLE LIKE" statement. An authenticated user could obtain sensitive
information, such as the table structure. (CVE-2007-3781)
A flaw was discovered in MySQL that allowed an authenticated user to gain
update privileges for a table in another database, via a view that refers
to the external table. (CVE-2007-3782)
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)
A flaw was discovered in the mysql_change_db function when returning from
SQL SECURITY INVOKER stored routines. An authenticated user could use this
flaw to gain database privileges. (CVE-2007-2692)
MySQL allowed an authenticated user to bypass logging mechanisms via SQL
queries that contain the NULL character, which were not properly handled by
the mysql_real_query function. (CVE-2006-0903)
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)
MySQL evaluated arguments in the wrong security context, which allowed an
authenticated user to gain privileges through a routine that had been made
available using "GRANT EXECUTE". (CVE-2006-4227)
Multiple flaws 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-7232, CVE-2007-1420, CVE-2007-2583)
As well, these updated packages fix the following bugs:
* a separate counter was used for "insert delayed" statements, which caused
rows to be discarded. In these updated packages, "insert delayed"
statements no longer use a separate counter, which resolves this issue.
* due to a bug in the Native POSIX Thread Library, in certain situations,
"flush tables" caused a deadlock on tables that had a read lock. The mysqld
daemon had to be killed forcefully. Now, "COND_refresh" has been replaced
with "COND_global_read_lock", which resolves this issue.
* mysqld crashed if a query for an unsigned column type contained a
negative value for a "WHERE [column] NOT IN" subquery.
* in master and slave server situations, specifying "on duplicate key
update" for "insert" statements did not update slave servers.
* in the mysql client, empty strings were displayed as "NULL". For
example, running "insert into [table-name] values (' ');" resulted in a
"NULL" entry being displayed when querying the table using "select * from
[table-name];".
* a bug in the optimizer code resulted in certain queries executing much
slower than expected.
* on 64-bit PowerPC architectures, MySQL did not calculate the thread stack
size correctly, which could have caused MySQL to crash when overly-complex
queries were used.
Note: these updated packages upgrade MySQL to version 5.0.45. For a full
list of bug fixes and enhancements, refer to the MySQL release notes:
http://dev.mysql.com/doc/refman/5.0/en/releasenotes-cs-5-0.html
All mysql users are advised to upgrade to these updated packages, which
resolve these issues.
4. 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
5. Bugs fixed (http://bugzilla.redhat.com/):
194613 - CVE-2006-0903 Mysql log file obfuscation
202246 - CVE-2006-4031 MySQL improper permission revocation
216427 - CVE-2006-4227 mysql improper suid argument evaluation
232603 - CVE-2007-1420 Single MySQL worker can be crashed (NULL deref) with certain SELECT statements
240813 - CVE-2007-2583 mysql: DoS via statement with crafted IF clause
241688 - CVE-2007-2691 mysql DROP privilege not enforced when renaming tables
241689 - CVE-2007-2692 mysql SECURITY INVOKER functions do not drop privileges
248553 - CVE-2007-3781 CVE-2007-3782 New release of MySQL fixes security bugs
254012 - Mysql bug 20048: 5.0.22 FLUSH TABLES WITH READ LOCK bug; need upgrade to 5.0.23
256501 - mysql 5.0.22 still has a lot of bugs ; need upgrade
349121 - MySQL client will display empty strings as NULL (fixed in 5.0.23)
434264 - CVE-2006-7232 mysql: daemon crash via EXPLAIN on queries on information schema
435391 - mysql does not calculate thread stack size correctly for RHEL5
6. Package List:
Red Hat Enterprise Linux Desktop (v. 5 client):
Source:
ftp://ftp.redhat.com/pub/redhat/linux/enterprise/5Client/en/os/SRPMS/mysql-5.0.45-7.el5.src.rpm
i386:
mysql-5.0.45-7.el5.i386.rpm
mysql-debuginfo-5.0.45-7.el5.i386.rpm
x86_64:
mysql-5.0.45-7.el5.i386.rpm
mysql-5.0.45-7.el5.x86_64.rpm
mysql-debuginfo-5.0.45-7.el5.i386.rpm
mysql-debuginfo-5.0.45-7.el5.x86_64.rpm
RHEL Desktop Workstation (v. 5 client):
Source:
ftp://ftp.redhat.com/pub/redhat/linux/enterprise/5Client/en/os/SRPMS/mysql-5.0.45-7.el5.src.rpm
i386:
mysql-bench-5.0.45-7.el5.i386.rpm
mysql-debuginfo-5.0.45-7.el5.i386.rpm
mysql-devel-5.0.45-7.el5.i386.rpm
mysql-server-5.0.45-7.el5.i386.rpm
mysql-test-5.0.45-7.el5.i386.rpm
x86_64:
mysql-bench-5.0.45-7.el5.x86_64.rpm
mysql-debuginfo-5.0.45-7.el5.i386.rpm
mysql-debuginfo-5.0.45-7.el5.x86_64.rpm
mysql-devel-5.0.45-7.el5.i386.rpm
mysql-devel-5.0.45-7.el5.x86_64.rpm
mysql-server-5.0.45-7.el5.x86_64.rpm
mysql-test-5.0.45-7.el5.x86_64.rpm
Red Hat Enterprise Linux (v. 5 server):
Source:
ftp://ftp.redhat.com/pub/redhat/linux/enterprise/5Server/en/os/SRPMS/mysql-5.0.45-7.el5.src.rpm
i386:
mysql-5.0.45-7.el5.i386.rpm
mysql-bench-5.0.45-7.el5.i386.rpm
mysql-debuginfo-5.0.45-7.el5.i386.rpm
mysql-devel-5.0.45-7.el5.i386.rpm
mysql-server-5.0.45-7.el5.i386.rpm
mysql-test-5.0.45-7.el5.i386.rpm
ia64:
mysql-5.0.45-7.el5.i386.rpm
mysql-5.0.45-7.el5.ia64.rpm
mysql-bench-5.0.45-7.el5.ia64.rpm
mysql-debuginfo-5.0.45-7.el5.i386.rpm
mysql-debuginfo-5.0.45-7.el5.ia64.rpm
mysql-devel-5.0.45-7.el5.ia64.rpm
mysql-server-5.0.45-7.el5.ia64.rpm
mysql-test-5.0.45-7.el5.ia64.rpm
ppc:
mysql-5.0.45-7.el5.ppc.rpm
mysql-5.0.45-7.el5.ppc64.rpm
mysql-bench-5.0.45-7.el5.ppc.rpm
mysql-debuginfo-5.0.45-7.el5.ppc.rpm
mysql-debuginfo-5.0.45-7.el5.ppc64.rpm
mysql-devel-5.0.45-7.el5.ppc.rpm
mysql-devel-5.0.45-7.el5.ppc64.rpm
mysql-server-5.0.45-7.el5.ppc.rpm
mysql-server-5.0.45-7.el5.ppc64.rpm
mysql-test-5.0.45-7.el5.ppc.rpm
s390x:
mysql-5.0.45-7.el5.s390.rpm
mysql-5.0.45-7.el5.s390x.rpm
mysql-bench-5.0.45-7.el5.s390x.rpm
mysql-debuginfo-5.0.45-7.el5.s390.rpm
mysql-debuginfo-5.0.45-7.el5.s390x.rpm
mysql-devel-5.0.45-7.el5.s390.rpm
mysql-devel-5.0.45-7.el5.s390x.rpm
mysql-server-5.0.45-7.el5.s390x.rpm
mysql-test-5.0.45-7.el5.s390x.rpm
x86_64:
mysql-5.0.45-7.el5.i386.rpm
mysql-5.0.45-7.el5.x86_64.rpm
mysql-bench-5.0.45-7.el5.x86_64.rpm
mysql-debuginfo-5.0.45-7.el5.i386.rpm
mysql-debuginfo-5.0.45-7.el5.x86_64.rpm
mysql-devel-5.0.45-7.el5.i386.rpm
mysql-devel-5.0.45-7.el5.x86_64.rpm
mysql-server-5.0.45-7.el5.x86_64.rpm
mysql-test-5.0.45-7.el5.x86_64.rpm
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
7. References:
http://cve.mitre.org/cgi-bin/cvename.cgi?name=CVE-2006-0903
http://cve.mitre.org/cgi-bin/cvename.cgi?name=CVE-2006-4031
http://cve.mitre.org/cgi-bin/cvename.cgi?name=CVE-2006-4227
http://cve.mitre.org/cgi-bin/cvename.cgi?name=CVE-2006-7232
http://cve.mitre.org/cgi-bin/cvename.cgi?name=CVE-2007-1420
http://cve.mitre.org/cgi-bin/cvename.cgi?name=CVE-2007-2583
http://cve.mitre.org/cgi-bin/cvename.cgi?name=CVE-2007-2691
http://cve.mitre.org/cgi-bin/cvename.cgi?name=CVE-2007-2692
http://cve.mitre.org/cgi-bin/cvename.cgi?name=CVE-2007-3781
http://cve.mitre.org/cgi-bin/cvename.cgi?name=CVE-2007-3782
http://www.redhat.com/security/updates/classification/#low
8. Contact:
The Red Hat security contact is <secalert@redhat.com>. More contact
details at https://www.redhat.com/security/team/contact/
Copyright 2008 Red Hat, Inc.
