Subject: CVS commit: [pkgsrc-2014Q1] pkgsrc/databases
From: Matthias Scheler
Date: 2014-04-14 19:14:14
Message id: 20140414171414.1C82096@cvs.netbsd.org

Log Message:
Pullup ticket #4374 - requested by taca
databases/mysql56-client: security update
databases/mysql56-server: update to keep in sync with with "mysql56-client"

Revisions pulled up:
- databases/mysql56-client/Makefile.common                      1.14
- databases/mysql56-client/distinfo                             1.14
- databases/mysql56-server/PLIST                                1.9

---
   Module Name:	pkgsrc
   Committed By:	adam
   Date:		Mon Mar 31 10:32:13 UTC 2014

   Modified Files:
   	pkgsrc/databases/mysql56-client: Makefile.common distinfo
   	pkgsrc/databases/mysql56-server: PLIST

   Log Message:
   Changes 5.6.17:

   Functionality Added or Changed

   Incompatible Change: The AES_ENCRYPT() and AES_DECRYPT() functions now permit \ 
control of the block encryption mode and take an optional initialization vector \ 
argument:

   The new block_encryption_mode system variable controls the mode for \ 
block-based encryption algorithms. Its default value is aes-128-ecb, which \ 
signifies encryption using a key length of 128 bits and ECB mode.

   An optional init_vector argument provides an initialization vector for \ 
encryption modes that require it:

   AES_ENCRYPT(str,key_str[,init_vector])
   AES_DECRYPT(crypt_str,key_str[,init_vector])
   A random string of bytes to use for the initialization vector can be produced \ 
by calling the new RANDOM_BYTES() function.

   For more information, see Encryption and Compression Functions.

   These changes make statements that use AES_ENCRYPT() or AES_DECRYPT() unsafe \ 
for statement-based replication and they cannot be stored in the query cache. \ 
Queries that use RANDOM_BYTES() are unsafe for statement-based replication and \ 
cannot be stored in the query cache.

   Incompatible Change: The ERROR_FOR_DIVISION_BY_ZERO, NO_ZERO_DATE, and \ 
NO_ZERO_IN_DATE SQL modes now are deprecated and setting the sql_mode value to \ 
include any of them generates a warning. In MySQL 5.7, these modes do nothing. \ 
Instead, their effects are included in the effects of strict SQL mode \ 
(STRICT_ALL_TABLES or STRICT_TRANS_TABLES). The motivation for the change in \ 
MySQL 5.7 is to reduce the number of SQL modes with an effect dependent on \ 
strict mode and make them part of strict mode itself.

   To make advance preparation for an upgrade to MySQL 5.7, see SQL Mode Changes \ 
in MySQL 5.7. That discussion provides guidelines to assess whether your \ 
applications will be affected by the SQL mode changes in MySQL 5.7.

   InnoDB: MySQL now supports rebuilding regular and partitioned InnoDB tables \ 
using online DDL (ALGORITHM=INPLACE) for the following operations:

   OPTIMIZE TABLE

   ALTER TABLE ... FORCE

   ALTER TABLE ... ENGINE=INNODB (when run on an InnoDB table)

   Online DDL support reduces table rebuild time and permits concurrent DML, \ 
which helps reduce user application downtime. For additional information, see \ 
Overview of Online DDL.

   On Solaris, mysql_config --libs now includes -R/path/to/library so that \ 
libraries can be found at runtime.

   mysql_install_db provides a more informative diagnostic message when required \ 
Perl modules are missing.

   The IGNORE clause for ALTER TABLE is now deprecated and will be removed in a \ 
future version of MySQL. ALTER IGNORE TABLE causes problems for replication, \ 
prevents online ALTER TABLE for unique index creation, and causes problems with \ 
foreign keys (rows removed in the parent table).

   Bugs Fixed

Files:
RevisionActionfile
1.13.2.1modifypkgsrc/databases/mysql56-client/Makefile.common
1.13.2.1modifypkgsrc/databases/mysql56-client/distinfo
1.8.2.1modifypkgsrc/databases/mysql56-server/PLIST