<html>
<head>
<style><!--
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 10pt;
font-family:Tahoma
}
--></style></head>
<body class='hmmessage'><div dir='ltr'>
Hi, <br><br>UPGRADING.mysql contains the step:<br><br>1b) Configure the new MySQL to use Latin1 as the default character<br> set everywhere, not UTF-8. This is necessary so the import in<br> the next step assumes the data is Latin1.<br><br>Do I need to manually edit and convert latin1 from the output of mysqldump?<br><br>Here is my current system settings:<br><br>mysql> show variables like 'char%';<br>+--------------------------+----------------------------+<br>| Variable_name | Value |<br>+--------------------------+----------------------------+<br>| character_set_client | latin1 |<br>| character_set_connection | latin1 |<br>| character_set_database | latin1 |<br>| character_set_filesystem | binary |<br>| character_set_results | latin1 |<br>| character_set_server | latin1 |<br>| character_set_system | utf8 |<br>| character_sets_dir | /usr/share/mysql/charsets/ |<br>+--------------------------+----------------------------+<br>8 rows in set (0.01 sec)<br><br>I have the following error message:<br> Use of uninitialized value in join or string at etc/upgrade/upgrade-mysql-schema.pl line 330.<br>from the code.<br> perl etc/upgrade/upgrade-mysql-schema.pl db user pass > queries.sql<br><br>It indicated I need to do something for Latin1. is there any changes I need to do since my <br>original mysql is version 3 and "--default-character-set=binary" doesn't apply?<br><br>Thanks. <br><br>Wanli<br><br>From: wwcheng@hotmail.com<br><div>To: rt-users@lists.bestpractical.com<br>Date: Thu, 30 Aug 2012 21:33:08 +0000<br>Subject: Re: [rt-users] rt upgrade<br><br>
<style><!--
.ExternalClass .ecxhmmessage P
{padding:0px;}
.ExternalClass body.ecxhmmessage
{font-size:10pt;font-family:Tahoma;}
--></style>
<div dir="ltr">
<br><br><div><div id="ecxSkyDrivePlaceholder"></div>> Date: Thu, 30 Aug 2012 14:54:11 -0400<br>> From: falcone@bestpractical.com<br>> To: rt-users@lists.bestpractical.com<br>> Subject: Re: [rt-users] rt upgrade<br>> <br>> On Thu, Aug 30, 2012 at 07:42:42AM +0000, Wanli Cheng wrote:<br>> > I tried to convert my rt database from mysql version 3 to mysql version 5.<br>> > The database mysql version 3 doesn't have such an option:<br>> > --default-character-set=binary<br>> <br>> It's usually ok to exclude this on really old MySQL versions.<br>> But, test extensively after your upgrade.<br><br>Ok. now I get the following error for the updates:<br><br><br>[root@ rt-4.0.6]# perl etc/upgrade/vulnerable-passwords<br>116 users found with unsalted or weak-cryptography passwords<br><br>Run again with --fix to upgrade.<br>[root@ rt-4.0.6]# perl etc/upgrade/vulnerable-passwords --fix<br>Upgrading 116 users...<br> jasonm => Old crypt() format, cannot upgrade<br>Done.<br>[root@ rt-4.0.6]# perl -I /opt/rt4/local/lib -I /opt/rt4/lib etc/upgrade/shrink_transactions_table.pl<br>[Thu Aug 30 19:55:32 2012] [debug]: You've enabled GD, but we couldn't load the module: Can't locate GD.pm in @INC (@INC contains: /opt/rt4/local/lib /opt/rt4/lib /usr/local/lib64/perl5 /usr/local/share/perl5 /usr/lib64/perl5/vendor_perl /usr/share/perl5/vendor_perl /usr/lib64/perl5 /usr/share/perl5 .) at /opt/rt4/lib/RT/Config.pm line 571. (/opt/rt4/lib/RT/Config.pm:572)<br>[Thu Aug 30 19:55:32 2012] [debug]: You've enabled GraphViz, but we couldn't load the module: Can't locate GraphViz.pm in @INC (@INC contains: /opt/rt4/local/lib /opt/rt4/lib /usr/local/lib64/perl5 /usr/local/share/perl5 /usr/lib64/perl5/vendor_perl /usr/share/perl5/vendor_perl /usr/lib64/perl5 /usr/share/perl5 .) at /opt/rt4/lib/RT/Config.pm line 558. (/opt/rt4/lib/RT/Config.pm:559)<br>[Thu Aug 30 19:55:32 2012] [debug]: RT's GnuPG libraries couldn't successfully read your configured GnuPG home directory (/opt/rt4/var/data/gpg). PGP support has been disabled (/opt/rt4/lib/RT/Config.pm:595)<br>[root@wiki rt-4.0.6]#<br><br>I further checked.<br>graphviz-perl and perl-GD cannot be installed. here is the error message:<br><br>[root@ ~]# yum install perl-GD<br>Loaded plugins: product-id, subscription-manager<br>Updating certificate-based repositories.<br>Setting up Install Process<br>Resolving Dependencies<br>--> Running transaction check<br>---> Package perl-GD.x86_64 0:2.35-2.el5 will be installed<br>--> Processing Dependency: perl(:MODULE_COMPAT_5.8.8) for package: perl-GD-2.35-2.el5.x86_64<br>--> Finished Dependency Resolution<br>Error: Package: perl-GD-2.35-2.el5.x86_64 (egwn)<br> Requires: perl(:MODULE_COMPAT_5.8.8)<br> You could try using --skip-broken to work around the problem<br> You could try running: rpm -Va --nofiles --nodigest<br><br>Error: Package: perl-GD-2.35-2.el5.x86_64 (egwn)<br> Requires: perl(:MODULE_COMPAT_5.8.8)<br><br>[root@rt-4.0.6]# yum install graphviz-perl<br>Loaded plugins: product-id, subscription-manager<br>Updating certificate-based repositories.<br>Setting up Install Process<br>Resolving Dependencies<br>--> Running transaction check<br>---> Package graphviz-perl.x86_64 0:2.26.3-0.1.el5 will be installed<br>--> Processing Dependency: perl(:MODULE_COMPAT_5.8.8) for package: graphviz-perl-2.26.3-0.1.el5.x86_64<br>--> Finished Dependency Resolution<br>Error: Package: graphviz-perl-2.26.3-0.1.el5.x86_64 (egwn)<br> Requires: perl(:MODULE_COMPAT_5.8.8)<br> You could try using --skip-broken to work around the problem<br> You could try running: rpm -Va --nofiles --nodigest<br>[root@ rt-4.0.6]#<br><br><br>If I run "install Graphviz" from CPAN, I got the following error:<br><br>Please install Graphviz from http://www.graphviz.org/.<br>Warning: No success on command[/usr/bin/perl Build.PL --installdirs site]<br> RSAVAGE/GraphViz-2.10.tgz<br> /usr/bin/perl Build.PL --installdirs site -- NOT OK<br>Running Build test<br> Make had some problems, won't test<br>Running Build install<br> Make had some problems, won't install<br>Failed during this command:<br> RSAVAGE/GraphViz-2.10.tgz : writemakefile NO '/usr/bin/perl Build.PL --installdirs site' returned status 512<br><br>Thanks.<br><br>Wanli<br></div> </div></div> </div></body>
</html>