[rt-users] rt upgrade

[Wanli Cheng]

Hi, 

UPGRADING.mysql  contains the step:

1b) Configure the new MySQL to use Latin1 as the default character
       set everywhere, not UTF-8.  This is necessary so the import in
       the next step assumes the data is Latin1.

Do I need to manually  edit and convert latin1 from the output of mysqldump?

Here is my current system settings:

mysql> show variables like 'char%';
+--------------------------+----------------------------+
| Variable_name            | Value                      |
+--------------------------+----------------------------+
| character_set_client     | latin1                     |
| character_set_connection | latin1                     |
| character_set_database   | latin1                     |
| character_set_filesystem | binary                     |
| character_set_results    | latin1                     |
| character_set_server     | latin1                     |
| character_set_system     | utf8                       |
| character_sets_dir       | /usr/share/mysql/charsets/ |
+--------------------------+----------------------------+
8 rows in set (0.01 sec)

I have the following error message:
  Use of uninitialized value in join or string at etc/upgrade/upgrade-mysql-schema.pl line 330.
from the code.
  perl etc/upgrade/upgrade-mysql-schema.pl db user pass > queries.sql

It indicated I need to do something for Latin1. is there any changes I need to do since my 
original mysql is version 3 and  "--default-character-set=binary" doesn't apply?

Thanks. 

Wanli

From: wwcheng at hotmail.com
To: rt-users at lists.bestpractical.com
Date: Thu, 30 Aug 2012 21:33:08 +0000
Subject: Re: [rt-users] rt  upgrade







> Date: Thu, 30 Aug 2012 14:54:11 -0400
> From: falcone at bestpractical.com
> To: rt-users at lists.bestpractical.com
> Subject: Re: [rt-users] rt  upgrade
> 
> On Thu, Aug 30, 2012 at 07:42:42AM +0000, Wanli Cheng wrote:
> >    I tried to convert my rt database from mysql version 3 to mysql version 5.
> >    The database mysql version 3 doesn't have such an option:
> >     --default-character-set=binary
> 
> It's usually ok to exclude this on really old MySQL versions.
> But, test extensively after your upgrade.

Ok. now I get the following error for the updates:


[root@ rt-4.0.6]# perl etc/upgrade/vulnerable-passwords
116 users found with unsalted or weak-cryptography passwords

Run again with --fix to upgrade.
[root@ rt-4.0.6]# perl etc/upgrade/vulnerable-passwords --fix
Upgrading 116 users...
              jasonm => Old crypt() format, cannot upgrade
Done.
[root@ rt-4.0.6]# perl -I /opt/rt4/local/lib -I /opt/rt4/lib etc/upgrade/shrink_transactions_table.pl
[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)
[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)
[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)
[root at wiki rt-4.0.6]#

I further checked.
graphviz-perl and perl-GD cannot be installed. here is the error message:

[root@ ~]# yum install perl-GD
Loaded plugins: product-id, subscription-manager
Updating certificate-based repositories.
Setting up Install Process
Resolving Dependencies
--> Running transaction check
---> Package perl-GD.x86_64 0:2.35-2.el5 will be installed
--> Processing Dependency: perl(:MODULE_COMPAT_5.8.8) for package: perl-GD-2.35-2.el5.x86_64
--> Finished Dependency Resolution
Error: Package: perl-GD-2.35-2.el5.x86_64 (egwn)
           Requires: perl(:MODULE_COMPAT_5.8.8)
 You could try using --skip-broken to work around the problem
 You could try running: rpm -Va --nofiles --nodigest

Error: Package: perl-GD-2.35-2.el5.x86_64 (egwn)
           Requires: perl(:MODULE_COMPAT_5.8.8)

[root at rt-4.0.6]# yum install graphviz-perl
Loaded plugins: product-id, subscription-manager
Updating certificate-based repositories.
Setting up Install Process
Resolving Dependencies
--> Running transaction check
---> Package graphviz-perl.x86_64 0:2.26.3-0.1.el5 will be installed
--> Processing Dependency: perl(:MODULE_COMPAT_5.8.8) for package: graphviz-perl-2.26.3-0.1.el5.x86_64
--> Finished Dependency Resolution
Error: Package: graphviz-perl-2.26.3-0.1.el5.x86_64 (egwn)
           Requires: perl(:MODULE_COMPAT_5.8.8)
 You could try using --skip-broken to work around the problem
 You could try running: rpm -Va --nofiles --nodigest
[root@ rt-4.0.6]#


If I run  "install  Graphviz"  from CPAN,  I got the following error:

Please install Graphviz from http://www.graphviz.org/.
Warning: No success on command[/usr/bin/perl Build.PL --installdirs site]
  RSAVAGE/GraphViz-2.10.tgz
  /usr/bin/perl Build.PL --installdirs site -- NOT OK
Running Build test
  Make had some problems, won't test
Running Build install
  Make had some problems, won't install
Failed during this command:
 RSAVAGE/GraphViz-2.10.tgz                    : writemakefile NO '/usr/bin/perl Build.PL --installdirs site' returned status 512

Thanks.

Wanli
 		 	   		   		 	   		  
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20120831/51cd729a/attachment.htm>