[Rt-devel] rt-4.0.0rc1 and MySQL 5.5.8

[Kevin Falcone]

On Fri, Dec 31, 2010 at 01:42:33PM +0300, Odhiambo Washington wrote:
> Has anyone seen and solved the problem below? All my efforts at Go-ogle have
> yielded no solution.

This looks like you have mysql configured to default to latin1 tables,
but haven't compiled in latin1.  Is it possible that you have a my.cnf
from one version of mysql and have built your own newer version of
mysql without including latin1?

The sessions table doesn't specify an encoding, so it uses the
default which appears to be set to latin1 for you.

-kevin

> mail# make initialize-database
> /usr/bin/perl -I/opt/rt4/local/lib -I/opt/rt4/lib sbin/rt-setup-database
> --action init --dba root --prompt-for-dba-password
> In order to create or update your RT database, this script needs to connect
> to your  mysql instance on localhost as root
> Please specify that user's database password below. If the user has no
> database
> password, just press return.
> 
> Password:
> Working with:
> Type:   mysql
> Host:   localhost
> Name:   rt4
> User:   rt3xuser
> DBA:    root
> Character set 'latin1' is not a compiled character set and is not specified
> in the '/usr/local/share/mysql/charsets/Index.xml' file
> Failed to connect to dbi:mysql:;host=localhost as user 'root': Can't
> initialize character set latin1 (path: /usr/local/share/mysql/charsets/)***
> Error code 255
> 
> Stop in /usr/home/wash/Tools/RT/RT-4/rt-4.0.0rc1.
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 195 bytes
Desc: not available
URL: <http://lists.bestpractical.com/pipermail/rt-devel/attachments/20110103/5bfdeed2/attachment.pgp>