When installing MyQL using FreeBSD ports, usually there is not much in the
way for the installer to customize, bar for doing a “make config”. In my
case, there is nothing in the options available to disable any encoding.
And yes, I was using my.conf which was from MySQL 5.5.7. I only upgraded
that to 5.5.8 and things broke! rt-3.9.7 was not complaining about this
latin1 encoding when I initialized the db. All I had to change was
s/TYPE=Innodb/ENGINE=Innodb/g in schema.mysql for MySQL-5.5 to agree to
So this breakage seems to be in MySQL 5.5.8 itself, or the way the port
maintainer configured it.On Mon, Jan 3, 2011 at 7:01 PM, Kevin Falcone firstname.lastname@example.org:
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
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.
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
to your mysql instance on localhost as root
Please specify that user’s database password below. If the user has no
password, just press return.
Character set ‘latin1’ is not a compiled character set and is not
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:
Error code 255
Stop in /usr/home/wash/Tools/RT/RT-4/rt-4.0.0rc1.