Note for mysql55-server

[Takahiro Kambe <taca%back-street.net@localhost>]

Hi,

Here is two problem with mysql55-server pacakge.  I write them here
simply for memo.  I don't think it is pkgsrc specific problems.

1. server failed to start. 

log message contains:

        COLLATION 'latin1_swedish_ci' is not valid for CHARACTER SET 'utf8'

I don't know where came from 'latin1_swedish_ci'.

workaround:
        Add "--collation-server=utf8_general_ci" to mysql_install_db's
        parameter and mysqld_flags in /etc/rc.conf.

--- /usr/pkg/share/examples/rc.d/mysqld 2011-04-27 16:42:29.000000000 +0900
+++ /etc/rc.d/mysqld    2011-04-29 18:31:28.000000000 +0900
@@ -51,7 +51,8 @@
                echo "Skipping database initialization."
        else
                echo "Initializing MySQL database system tables."
-               ${initdb} --force --user=${mysqld_user} \
+               ${initdb} --user=mysql --collation-server=utf8_general_ci \
+                         --force --user=${mysqld_user} \
                          --datadir=${mysqld_datadir} || return 1
                if [ -d ${mysqld_datadir} ]; then
                        /usr/sbin/chown -R ${mysqld_user}:${mysqld_group} \


2. mysqld listen only [::1]:3306.

mysqld might believe that IPv4/IPv6 can accept one socket.  I don't
have right solution.

workaround:
        Add "--bind-address=127.0.0.1" to mysqld_flags in /etc/rc.conf.


So, now I have /etc/rc.conf:

mysqld_flags="--bind-address=127.0.0.1 --collation-server=utf8_general_ci"

I wish other people wouldn't suffer these problems.

-- 
Takahiro Kambe <taca%back-street.net@localhost>