Rt upgrade

michael-list · July 13, 2004, 4:23pm

Just upgraded to rt2,

Finished the install and data import from rt1, brings up login page, i can authenticate but get following error, I’m pretty sure its one of my installed modules, To me it looks like a mason error, I can log into the Admin area with no problems.just wondering if anyone can help me out

thanks all

michael

this is the Nice error:

  error:  Unsatisfied dependency chain in Joins Users_2 at /usr/local/share/perl/5.8.4/DBIx/SearchBuilder/Handle.pm line 889.
 
  context:  ...   
        885:  $seen_aliases{$join} = 1; 
        886:  } 
        887:  else { 
        888:  push ( @keys, $join ); 
        889:  die "Unsatisfied dependency chain in Joins @keys" 
        890:  if $seen{"@keys"}++; 
        891:  } 
        892:   
        893:  } 
        ...   
 
  code stack:  /usr/local/share/perl/5.8.4/DBIx/SearchBuilder/Handle.pm:889
  /usr/local/share/perl/5.8.4/DBIx/SearchBuilder.pm:316
  /usr/local/share/perl/5.8.4/DBIx/SearchBuilder.pm:109
  /usr/local/share/perl/5.8.4/DBIx/SearchBuilder.pm:400
  /opt/rt2/lib/RT/Tickets.pm:996
  /opt/rt2/WebRT/html/Elements/MyRequests:11
  /opt/rt2/WebRT/html/index.html:9
  /opt/rt2/WebRT/html/autohandler:58

And the raw error:

Unsatisfied dependency chain in Joins Users_2 at /usr/local/share/perl/5.8.4/DBIx/SearchBuilder/Handle.pm line 889.

Trace begun at /usr/local/share/perl/5.8.4/HTML/Mason/Exceptions.pm line 131
HTML::Mason::Exceptions::rethrow_exception(‘Unsatisfied dependency chain in Joins Users_2 at /usr/local/share/perl/5.8.4/DBIx/SearchBuilder/Handle.pm line 889.^J’) called at /usr/local/share/perl/5.8.4/DBIx/SearchBuilder/Handle.pm line 889
DBIx::SearchBuilder::Handle::_BuildJoins(‘RT::Handle=HASH(0x82601e4)’, ‘RT::Tickets=HASH(0x904b048)’) called at /usr/local/share/perl/5.8.4/DBIx/SearchBuilder.pm line 316
DBIx::SearchBuilder::_BuildJoins(‘RT::Tickets=HASH(0x904b048)’) called at /usr/local/share/perl/5.8.4/DBIx/SearchBuilder.pm line 109
DBIx::SearchBuilder::_DoSearch(‘RT::Tickets=HASH(0x904b048)’) called at /usr/local/share/perl/5.8.4/DBIx/SearchBuilder.pm line 400
DBIx::SearchBuilder::Next(‘RT::Tickets=HASH(0x904b048)’) called at /opt/rt2/lib/RT/Tickets.pm line 996
RT::Next(‘RT::Tickets=HASH(0x904b048)’) called at /opt/rt2/WebRT/html/Elements/MyRequests line 11
HTML::Mason::Commands::ANON at /usr/local/share/perl/5.8.4/HTML/Mason/Component.pm line 134
HTML::Mason::Component::run(‘HTML::Mason::Component::FileBased=HASH(0x902ce0c)’) called at /usr/local/share/perl/5.8.4/HTML/Mason/Request.pm line 1074
eval {…} at /usr/local/share/perl/5.8.4/HTML/Mason/Request.pm line 1068
HTML::Mason::Request::comp(undef, undef) called at /opt/rt2/WebRT/html/index.html line 9
HTML::Mason::Commands::ANON(‘pass’, , ‘user’, ) called at /usr/local/share/perl/5.8.4/HTML/Mason/Component.pm line 134
HTML::Mason::Component::run(‘HTML::Mason::Component::FileBased=HASH(0x8f71004)’, ‘pass’, , ‘user’, ) called at /usr/local/share/perl/5.8.4/HTML/Mason/Request.pm line 1074
eval {…} at /usr/local/share/perl/5.8.4/HTML/Mason/Request.pm line 1068
HTML::Mason::Request::comp(undef, undef, ‘pass’, , ‘user’, ) called at /usr/local/share/perl/5.8.4/HTML/Mason/Request.pm line 760
HTML::Mason::Request::call_next(‘HTML::Mason::Request::ApacheHandler=HASH(0x8fa3474)’) called at /opt/rt2/WebRT/html/autohandler line 58
HTML::Mason::Commands::ANON(‘pass’, , ‘user’, ) called at /usr/local/share/perl/5.8.4/HTML/Mason/Component.pm line 134
HTML::Mason::Component::run(‘HTML::Mason::Component::FileBased=HASH(0x8f5a448)’, ‘pass’, , ‘user’, ) called at /usr/local/share/perl/5.8.4/HTML/Mason/Request.pm line 1069
eval {…} at /usr/local/share/perl/5.8.4/HTML/Mason/Request.pm line 1068
HTML::Mason::Request::comp(undef, undef, undef, ‘pass’, , ‘user’, ) called at /usr/local/share/perl/5.8.4/HTML/Mason/Request.pm line 338
eval {…} at /usr/local/share/perl/5.8.4/HTML/Mason/Request.pm line 338
eval {…} at /usr/local/share/perl/5.8.4/HTML/Mason/Request.pm line 297
HTML::Mason::Request::exec(‘HTML::Mason::Request::ApacheHandler=HASH(0x8fa3474)’) called at /usr/local/share/perl/5.8.4/HTML/Mason/ApacheHandler.pm line 134
eval {…} at /usr/local/share/perl/5.8.4/HTML/Mason/ApacheHandler.pm line 134
HTML::Mason::Request::ApacheHandler::exec(‘HTML::Mason::Request::ApacheHandler=HASH(0x8fa3474)’) called at /usr/local/share/perl/5.8.4/HTML/Mason/ApacheHandler.pm line 792
HTML::Mason::ApacheHandler::handle_request(‘HTML::Mason::ApacheHandler=HASH(0x8260040)’, ‘Apache=SCALAR(0x8f2eb04)’) called at /opt/rt2/bin/webmux.pl line 170
RT::Mason::handler(‘Apache=SCALAR(0x8f2eb04)’) called at /dev/null line 0
eval {…} at /dev/null line 0

http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Be sure to check out the RT wiki at http://wiki.bestpractical.com

Wanli_Cheng · August 30, 2012, 7:42am

Hello,

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

anybody have any suggestions? Thanks.

Wanli

Kevin_Falcone · August 30, 2012, 6:54pm

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.

-kevin

Wanli_Cheng · August 30, 2012, 9:33pm

Date: Thu, 30 Aug 2012 14:54:11 -0400
From: falcone@bestpractical.com
To: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] rt upgrade

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@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@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

Wanli_Cheng · August 31, 2012, 7:08am

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:

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.

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