Re: Note for mysql55-server

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

In message <op.vut04qc9cmitfu%ponkan.lins.jp@localhost>
        on Mon, 02 May 2011 11:27:52 +0900,
        "OBATA Akio" <obache%netbsd.org@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?
Exactly.

> 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.
I completly agree.  (MySQL came from Sweeden?)

>> 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?
I never read the code of MySQL 5.5.x.  ;)

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