[pkgsrc/trunk]: pkgsrc/databases/mysql5-server Update mysql5-server pacakge t...

[taca <taca%pkgsrc.org@localhost>]

details:   https://anonhg.NetBSD.org/pkgsrc/rev/814f12fc6237
branches:  trunk
changeset: 547501:814f12fc6237
user:      taca <taca%pkgsrc.org@localhost>
date:      Thu Sep 18 11:51:37 2008 +0000

description:
Update mysql5-server pacakge to 5.0.67.

This is security fix.

For complete changes, please refer
http://dev.mysql.com/doc/refman/5.0/en/releasenotes-cs-5-0-67.html.
Here is a part of it.


Functionality added or changed:

Security Enhancement:

  To enable stricter control over the location from which user-defined
  functions can be loaded, the plugin_dir system variable has been
  backported from MySQL 5.1. If the value is non-empty, user-defined
  function object files can be loaded only from the directory named by this
  variable. If the value is empty, the behavior that is used before 5.0.67
  applies: The UDF object files must be located in a directory that is
  searched by your system's dynamic linker. (Bug#37428)

Important Change: Incompatible Change:

  The FEDERATED storage engine is now disabled by default in the .cnf files
  shipped with MySQL distributions (my-huge.cnf, my-medium.cnf, and so
  forth). This affects server behavior only if you install one of these
  files. (Bug#37069)

Cluster API: Important Change:

  Because NDB_LE_MemoryUsage.page_size_kb shows memory page sizes in bytes
  rather than kilobytes, it has been renamed to page_size_bytes. The name
  page_size_kb is now deprecated and thus subject to removal in a future
  release, although it currently remains supported for reasons of backward
  compatibility. See The Ndb_logevent_type Type, for more information about
  NDB_LE_MemoryUsage. (Bug#30271)

Important Change:

  Some changes were made to CHECK TABLE ... FOR UPGRADE and REPAIR TABLE
  with respect to detection and handling of tables with incompatible .frm
  files (files created with a different version of the MySQL server). These
  changes also affect mysqlcheck because that program uses CHECK TABLE and
  REPAIR table, and thus also mysql_upgrade because that program invokes
  mysqlcheck.

diffstat:

 databases/mysql5-server/Makefile         |   14 +-
 databases/mysql5-server/PLIST            |  544 +++++++++++++++++++++++++++---
 databases/mysql5-server/distinfo         |   24 +-
 databases/mysql5-server/patches/patch-ad |   28 +-
 databases/mysql5-server/patches/patch-ag |    8 +-
 databases/mysql5-server/patches/patch-ai |    8 +-
 databases/mysql5-server/patches/patch-an |   26 +-
 databases/mysql5-server/patches/patch-ca |    8 +-
 databases/mysql5-server/patches/patch-cb |    8 +-
 databases/mysql5-server/patches/patch-cc |    8 +-
 databases/mysql5-server/patches/patch-da |   12 -
 databases/mysql5-server/patches/patch-db |   85 ----
 12 files changed, 546 insertions(+), 227 deletions(-)

diffs (truncated from 1358 to 300 lines):

diff -r 1d3ec70c1ef6 -r 814f12fc6237 databases/mysql5-server/Makefile
--- a/databases/mysql5-server/Makefile  Thu Sep 18 11:50:44 2008 +0000
+++ b/databases/mysql5-server/Makefile  Thu Sep 18 11:51:37 2008 +0000
@@ -1,7 +1,7 @@
-# $NetBSD: Makefile,v 1.24 2008/07/01 09:22:59 tron Exp $
+# $NetBSD: Makefile,v 1.25 2008/09/18 11:51:37 taca Exp $
 
 PKGNAME=               ${DISTNAME:S/-/-server-/}
-PKGREVISION=           1
+#PKGREVISION=          1
 SVR4_PKGNAME=          mysqs
 COMMENT=               MySQL 5, a free SQL database (server)
 
@@ -17,7 +17,7 @@
 CONFIGURE_ARGS+=       --with-raid
 CONFIGURE_ARGS+=       --without-berkeley-db
 CONFIGURE_ARGS+=       --without-mysqlfs
-CONFIGURE_ARGS+=       --with-mysqld-user=${MYSQL_USER:Q}
+CONFIGURE_ARGS+=       --with-mysqld-user=${MYSQL_USER}
 
 PTHREAD_OPTS+=         require
 CONFIGURE_ARGS+=       --with-pthreads
@@ -32,8 +32,8 @@
 RCD_SCRIPTS=           mysqld
 
 FILES_SUBST+=          HOSTNAME_CMD=${HOSTNAME_CMD:Q} \
-                       MYSQL_DATADIR=${MYSQL_DATADIR:Q} \
-                       MYSQL_USER=${MYSQL_USER:Q} MYSQL_GROUP=${MYSQL_GROUP:Q}
+                       MYSQL_DATADIR=${MYSQL_DATADIR} \
+                       MYSQL_USER=${MYSQL_USER} MYSQL_GROUP=${MYSQL_GROUP}
 MESSAGE_SUBST+=                MYSQL_DATADIR=${MYSQL_DATADIR} \
                        MYSQL_USER=${MYSQL_USER} MYSQL_GROUP=${MYSQL_GROUP}
 BUILD_DEFS+=           MYSQL_DATADIR
@@ -80,8 +80,8 @@
                ${DESTDIR}${PREFIX}/bin
        ${INSTALL_MAN} ${WRKSRC}/man/mysqld_multi.1 \
                ${DESTDIR}${PREFIX}/${PKGMANDIR}/man1
-       #${INSTALL_MAN} ${WRKSRC}/man/mysqld_safe.1 \
-               ${DESTDIR}${PREFIX}/${PKGMANDIR}/man1
+#      ${INSTALL_MAN} ${WRKSRC}/man/mysqld_safe.1 \
+#              ${DESTDIR}${PREFIX}/${PKGMANDIR}/man1
        ${INSTALL_SCRIPT} ${WRKSRC}/scripts/mysql_secure_installation.sh \
                ${DESTDIR}${PREFIX}/bin/mysql_secure_installation
 
diff -r 1d3ec70c1ef6 -r 814f12fc6237 databases/mysql5-server/PLIST
--- a/databases/mysql5-server/PLIST     Thu Sep 18 11:50:44 2008 +0000
+++ b/databases/mysql5-server/PLIST     Thu Sep 18 11:51:37 2008 +0000
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.12 2007/12/14 13:36:53 tron Exp $
+@comment $NetBSD: PLIST,v 1.13 2008/09/18 11:51:37 taca Exp $
 bin/comp_err
 bin/innochecksum
 bin/my_print_defaults
@@ -40,12 +40,15 @@
 share/mysql-test/include/ctype_filesort.inc
 share/mysql-test/include/ctype_innodb_like.inc
 share/mysql-test/include/ctype_like_escape.inc
+share/mysql-test/include/ctype_like_range_f1f2.inc
+share/mysql-test/include/ctype_regex.inc
 share/mysql-test/include/delete_anonymous_users.inc
 share/mysql-test/include/endspace.inc
 share/mysql-test/include/federated.inc
 share/mysql-test/include/federated_cleanup.inc
 share/mysql-test/include/get_binlog_dump_thread_id.inc
 share/mysql-test/include/gis_generic.inc
+share/mysql-test/include/gis_keys.inc
 share/mysql-test/include/have_archive.inc
 share/mysql-test/include/have_bdb.inc
 share/mysql-test/include/have_big5.inc
@@ -67,6 +70,7 @@
 share/mysql-test/include/have_geometry.inc
 share/mysql-test/include/have_innodb.inc
 share/mysql-test/include/have_latin2_ch.inc
+share/mysql-test/include/have_local_infile.inc
 share/mysql-test/include/have_log_bin.inc
 share/mysql-test/include/have_lowercase0.inc
 share/mysql-test/include/have_lowercase1.inc
@@ -88,6 +92,7 @@
 share/mysql-test/include/ndb_backup.inc
 share/mysql-test/include/ndb_backup_print.inc
 share/mysql-test/include/ndb_default_cluster.inc
+share/mysql-test/include/ndb_wait_connected.inc
 share/mysql-test/include/not_as_root.inc
 share/mysql-test/include/not_embedded.inc
 share/mysql-test/include/not_openssl.inc
@@ -100,7 +105,9 @@
 share/mysql-test/include/ps_renew.inc
 share/mysql-test/include/report-features.test
 share/mysql-test/include/rpl_stmt_seq.inc
+share/mysql-test/include/show_binary_logs.inc
 share/mysql-test/include/show_binlog_events.inc
+share/mysql-test/include/show_binlog_events2.inc
 share/mysql-test/include/show_msg.inc
 share/mysql-test/include/show_msg80.inc
 share/mysql-test/include/sp-vars.inc
@@ -110,6 +117,7 @@
 share/mysql-test/include/testdb_only.inc
 share/mysql-test/include/uses_vardir.inc
 share/mysql-test/include/varchar.inc
+share/mysql-test/include/wait_condition.inc
 share/mysql-test/include/wait_for_query_to_suceed.inc
 share/mysql-test/include/wait_for_slave_io_to_stop.inc
 share/mysql-test/include/wait_for_slave_param.inc
@@ -139,6 +147,7 @@
 share/mysql-test/mysql-test-run-shell
 share/mysql-test/mysql-test-run.pl
 share/mysql-test/r/alias.result
+share/mysql-test/r/almost_full.result
 share/mysql-test/r/alter_table-big.result
 share/mysql-test/r/alter_table.result
 share/mysql-test/r/analyse.result
@@ -162,8 +171,11 @@
 share/mysql-test/r/bigint.result
 share/mysql-test/r/binary.result
 share/mysql-test/r/binlog.result
+share/mysql-test/r/binlog_index.result
 share/mysql-test/r/binlog_innodb.result
 share/mysql-test/r/binlog_killed.result
+share/mysql-test/r/binlog_killed_simulate.result
+share/mysql-test/r/binlog_start_comment.result
 share/mysql-test/r/blackhole.result
 share/mysql-test/r/bool.result
 share/mysql-test/r/bootstrap.result
@@ -236,6 +248,7 @@
 share/mysql-test/r/federated_archive.result
 share/mysql-test/r/federated_bug_13118.result
 share/mysql-test/r/federated_bug_25714.result
+share/mysql-test/r/federated_disabled.result
 share/mysql-test/r/federated_innodb.result
 share/mysql-test/r/fix_priv_tables.result
 share/mysql-test/r/flush.result
@@ -312,6 +325,7 @@
 share/mysql-test/r/have_geometry.require
 share/mysql-test/r/have_innodb.require
 share/mysql-test/r/have_latin2_ch.require
+share/mysql-test/r/have_local_infile.require
 share/mysql-test/r/have_log_bin.require
 share/mysql-test/r/have_met_timezone.require
 share/mysql-test/r/have_moscow_leap_timezone.require
@@ -407,10 +421,13 @@
 share/mysql-test/r/mix_innodb_myisam_binlog.result
 share/mysql-test/r/multi_statement.result
 share/mysql-test/r/multi_update.result
+share/mysql-test/r/multi_update_tiny_hash.result
 share/mysql-test/r/myisam-blob.result
 share/mysql-test/r/myisam.result
+share/mysql-test/r/myisampack.result
 share/mysql-test/r/mysql.result
 share/mysql-test/r/mysql_client_test.result
+share/mysql-test/r/mysql_comments.result
 share/mysql-test/r/mysql_protocols.result
 share/mysql-test/r/mysql_upgrade.result
 share/mysql-test/r/mysqladmin.result
@@ -420,11 +437,14 @@
 share/mysql-test/r/mysqlcheck.result
 share/mysql-test/r/mysqldump-compat.result
 share/mysql-test/r/mysqldump-max.result
+share/mysql-test/r/mysqldump-no-binlog.result
 share/mysql-test/r/mysqldump.result
 share/mysql-test/r/mysqlshow.result
 share/mysql-test/r/mysqltest.result
+share/mysql-test/r/named_pipe.result
 share/mysql-test/r/ndb_alter_table.result
 share/mysql-test/r/ndb_alter_table2.result
+share/mysql-test/r/ndb_auto_increment.result
 share/mysql-test/r/ndb_autodiscover.result
 share/mysql-test/r/ndb_autodiscover2.result
 share/mysql-test/r/ndb_autodiscover3.result
@@ -433,6 +453,7 @@
 share/mysql-test/r/ndb_bitfield.result
 share/mysql-test/r/ndb_blob.result
 share/mysql-test/r/ndb_bug26793.result
+share/mysql-test/r/ndb_bug31477.result
 share/mysql-test/r/ndb_cache.result
 share/mysql-test/r/ndb_cache2.result
 share/mysql-test/r/ndb_cache_multi.result
@@ -481,8 +502,10 @@
 share/mysql-test/r/order_by.result
 share/mysql-test/r/order_fill_sortbuf.result
 share/mysql-test/r/outfile.result
+share/mysql-test/r/outfile_loaddata.result
 share/mysql-test/r/overflow.result
 share/mysql-test/r/packet.result
+share/mysql-test/r/parser.result
 share/mysql-test/r/parser_precedence.result
 share/mysql-test/r/perror.result
 share/mysql-test/r/preload.result
@@ -513,8 +536,12 @@
 share/mysql-test/r/row.result
 share/mysql-test/r/rowid_order_bdb.result
 share/mysql-test/r/rowid_order_innodb.result
+share/mysql-test/r/rpl000001.a.result
+share/mysql-test/r/rpl000001.b.result
 share/mysql-test/r/rpl000001.result
 share/mysql-test/r/rpl000002.result
+share/mysql-test/r/rpl000004.a.result
+share/mysql-test/r/rpl000004.b.result
 share/mysql-test/r/rpl000004.result
 share/mysql-test/r/rpl000005.result
 share/mysql-test/r/rpl000006.result
@@ -530,6 +557,8 @@
 share/mysql-test/r/rpl_alter.result
 share/mysql-test/r/rpl_auto_increment.result
 share/mysql-test/r/rpl_auto_increment_11932.result
+share/mysql-test/r/rpl_auto_increment_bug33029.result
+share/mysql-test/r/rpl_bug33931.result
 share/mysql-test/r/rpl_change_master.result
 share/mysql-test/r/rpl_charset.result
 share/mysql-test/r/rpl_charset_sjis.result
@@ -543,6 +572,7 @@
 share/mysql-test/r/rpl_drop.result
 share/mysql-test/r/rpl_drop_db.result
 share/mysql-test/r/rpl_drop_temp.result
+share/mysql-test/r/rpl_drop_view.result
 share/mysql-test/r/rpl_dual_pos_advance.result
 share/mysql-test/r/rpl_empty_master_crash.result
 share/mysql-test/r/rpl_error_ignored_table.result
@@ -564,6 +594,7 @@
 share/mysql-test/r/rpl_known_bugs_detection.result
 share/mysql-test/r/rpl_loaddata.result
 share/mysql-test/r/rpl_loaddata_charset.result
+share/mysql-test/r/rpl_loaddata_map.result
 share/mysql-test/r/rpl_loaddata_rule_m.result
 share/mysql-test/r/rpl_loaddata_rule_s.result
 share/mysql-test/r/rpl_loaddatalocal.result
@@ -594,11 +625,13 @@
 share/mysql-test/r/rpl_reset_slave.result
 share/mysql-test/r/rpl_rewrite_db.result
 share/mysql-test/r/rpl_rotate_logs.result
+share/mysql-test/r/rpl_server_id.result
 share/mysql-test/r/rpl_server_id1.result
 share/mysql-test/r/rpl_server_id2.result
 share/mysql-test/r/rpl_session_var.result
 share/mysql-test/r/rpl_set_charset.result
 share/mysql-test/r/rpl_skip_error.result
+share/mysql-test/r/rpl_slave_skip.result
 share/mysql-test/r/rpl_slave_status.result
 share/mysql-test/r/rpl_sp.result
 share/mysql-test/r/rpl_sp_effects.result
@@ -607,9 +640,11 @@
 share/mysql-test/r/rpl_start_stop_slave.result
 share/mysql-test/r/rpl_temporary.result
 share/mysql-test/r/rpl_timezone.result
+share/mysql-test/r/rpl_transaction.result
 share/mysql-test/r/rpl_trigger.result
 share/mysql-test/r/rpl_trunc_temp.result
 share/mysql-test/r/rpl_until.result
+share/mysql-test/r/rpl_user.result
 share/mysql-test/r/rpl_user_variables.result
 share/mysql-test/r/rpl_variables.result
 share/mysql-test/r/rpl_view.result
@@ -619,6 +654,7 @@
 share/mysql-test/r/select_safe.result
 share/mysql-test/r/server_id.require
 share/mysql-test/r/server_id1.require
+share/mysql-test/r/shm.result
 share/mysql-test/r/show_check.result
 share/mysql-test/r/skip_grants.result
 share/mysql-test/r/skip_name_resolve.result
@@ -699,6 +735,7 @@
 share/mysql-test/r/type_varchar.result
 share/mysql-test/r/type_year.result
 share/mysql-test/r/udf.result
+share/mysql-test/r/udf_skip_grants.result
 share/mysql-test/r/union.result
 share/mysql-test/r/update.result
 share/mysql-test/r/user_limits.result
@@ -712,7 +749,6 @@
 share/mysql-test/r/wait_timeout.result
 share/mysql-test/r/warnings.result
 share/mysql-test/r/windows.result
-share/mysql-test/r/windows_shm.result
 share/mysql-test/r/xa.result
 share/mysql-test/std_data/14897.frm
 share/mysql-test/std_data/Index.xml
@@ -723,10 +759,31 @@
 share/mysql-test/std_data/bug19371.MYD
 share/mysql-test/std_data/bug19371.MYI
 share/mysql-test/std_data/bug19371.frm
+share/mysql-test/std_data/bug35469.dat
+share/mysql-test/std_data/bug36055.MYD
+share/mysql-test/std_data/bug36055.MYI
+share/mysql-test/std_data/bug36055.frm
 share/mysql-test/std_data/cacert.pem
 share/mysql-test/std_data/client-cert.pem
 share/mysql-test/std_data/client-key.pem
 share/mysql-test/std_data/des_key_file
+share/mysql-test/std_data/funcs_1/innodb_tb1.txt
+share/mysql-test/std_data/funcs_1/innodb_tb2.txt
+share/mysql-test/std_data/funcs_1/innodb_tb3.txt
+share/mysql-test/std_data/funcs_1/innodb_tb4.txt
+share/mysql-test/std_data/funcs_1/load_file.txt
+share/mysql-test/std_data/funcs_1/memory_tb1.txt
+share/mysql-test/std_data/funcs_1/memory_tb2.txt
+share/mysql-test/std_data/funcs_1/memory_tb3.txt
+share/mysql-test/std_data/funcs_1/memory_tb4.txt
+share/mysql-test/std_data/funcs_1/myisam_tb1.txt
+share/mysql-test/std_data/funcs_1/myisam_tb2.txt
+share/mysql-test/std_data/funcs_1/myisam_tb3.txt
+share/mysql-test/std_data/funcs_1/myisam_tb4.txt