<div class="gmail_quote">Hello Kevin,<br>
<br>
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.<br>
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
initialize-database.<br>
<br>
So this breakage seems to be in MySQL 5.5.8 itself, or the way the port maintainer configured it.<br>On Mon, Jan 3, 2011 at 7:01 PM, Kevin Falcone <span dir="ltr"><<a href="mailto:falcone@bestpractical.com">falcone@bestpractical.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;"><div class="im">On Fri, Dec 31, 2010 at 01:42:33PM +0300, Odhiambo Washington wrote:<br>
> Has anyone seen and solved the problem below? All my efforts at Go-ogle have<br>
> yielded no solution.<br>
<br>
</div>This looks like you have mysql configured to default to latin1 tables,<br>
but haven't compiled in latin1. Is it possible that you have a my.cnf<br>
from one version of mysql and have built your own newer version of<br>
mysql without including latin1?<br>
<br>
The sessions table doesn't specify an encoding, so it uses the<br>
default which appears to be set to latin1 for you.<br>
<font color="#888888"><br>
-kevin<br>
</font><div><div></div><div class="h5"><br>
> mail# make initialize-database<br>
> /usr/bin/perl -I/opt/rt4/local/lib -I/opt/rt4/lib sbin/rt-setup-database<br>
> --action init --dba root --prompt-for-dba-password<br>
> In order to create or update your RT database, this script needs to connect<br>
> to your mysql instance on localhost as root<br>
> Please specify that user's database password below. If the user has no<br>
> database<br>
> password, just press return.<br>
><br>
> Password:<br>
> Working with:<br>
> Type: mysql<br>
> Host: localhost<br>
> Name: rt4<br>
> User: rt3xuser<br>
> DBA: root<br>
> Character set 'latin1' is not a compiled character set and is not specified<br>
> in the '/usr/local/share/mysql/charsets/Index.xml' file<br>
> Failed to connect to dbi:mysql:;host=localhost as user 'root': Can't<br>
> initialize character set latin1 (path: /usr/local/share/mysql/charsets/)***<br>
> Error code 255<br>
><br>
> Stop in /usr/home/wash/Tools/RT/RT-4/rt-4.0.0rc1.<br>
</div></div><br>_______________________________________________<br>
List info: <a href="http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-devel" target="_blank">http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-devel</a><br>
<br></blockquote></div><br><br clear="all"><br>-- <br>Best regards,<br>Odhiambo WASHINGTON,<br>Nairobi,KE<br>+254733744121/+254722743223<br>_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ <br>Damn!!<br><br>