Re: Note for mysql55-server

["OBATA Akio" <obache%netbsd.org@localhost>]

On Sun, 01 May 2011 23:36:36 +0900, Takahiro Kambe 
<taca%back-street.net@localhost> wrote:

> 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'.

From INSTALL-SOURCE file, it came from DEFAULT_COLLATION.
Also from the file, DEFAULT_CHARSET should be latin1.
Do you have MYSQL_CHARSET=utf8 in /etc/mk.conf?
Maybe, mysql55 should have MYSQL_COLLATION build variable.

How about following changes?

 Add following to mysql55-client/Makefile.common
   MYSQL_COLLATION?= latin1_swedish_ci
   CMAKE_ARGS+= -DDEFAULT_COLLATION=${MYSQL_COLLATION}

 then put MYSQL_COLLATION=utf8_general_ci on your /etc/mk.conf.

> 2. mysqld listen only [::1]:3306.
>
> mysqld might believe that IPv4/IPv6 can accept one socket.  I don't
> have right solution.

network_init() in sql/mysqld.cc?

--
OBATA Akio / obache%NetBSD.org@localhost