Migrating mysql rt-3.6.3 db to new instance rt-3.8.8

Hi all,
need advice on migrating to newer rt version.
I built rt-3.8.8 on a new server [ubuntu 10.0.4 with perl 5.10 ]
All went ok
got rt at a glance page up fine.

Then I took a dump of rt3 database from our running instance rt-3.6.3.
loaded this into the new rt3 database
did the upgrade [from the src tree dir] :
/opt/rt3/sbin/rt-setup-database --dba root --prompt-for-dba-password
–action upgrade

But apache fails to start after this.
With this error:
RT since version 3.8 has new schema for MySQL versions after 4.1.0\nFollow
instructions in the UPGRADING.mysql file. at /opt/rt3/bin/webmux.pl line
146.\nCompilation failed in require at (eval 2) line 1.\n
[Sun Oct 31 12:57:39 2010] [error] Can’t load Perl file:
/opt/rt3/bin/webmux.pl for server 192.168.0.7:80, exiting…

Then I tried:-
etc/upgrade/upgrade-mysql-schema.pl rt3 root PASSWORD > 3.8queries.sql
and:
mysql -u root -p rt3 < ./3.8queries.sql

still fails to start apache
With slightly different errors:
[error] Require of RT::Action:: failed.\nCan’t locate RT/Action/.pm in
@INC (@INC contains: /opt/rt3/bin/…/local/lib /opt/rt3/bin/…/lib
/etc/perl /usr/local/lib/perl/5.10.1 /usr/local/share/perl/5.10.1
/usr/lib/perl5 /usr/share/perl5 /usr/lib/perl/5.10 /usr/share/perl/5.10
/usr/local/lib/site_perl . /usr/local/apache2) at (eval 1318) line
3.\n\nCompilation failed in require at (eval 2) line 1.\n
[Sun Oct 31 13:44:09 2010] [error] Can’t load Perl file:
/opt/rt3/bin/webmux.pl for server 192.168.0.7:80, exiting…

Perhaps I should have dropped the rt-3.8.8 database and created a new
blank one befor the import?

Any advice much appreciated.

Oliver Nash

With slightly different errors:
[error] Require of RT::Action:: failed.\nCan’t locate RT/Action/.pm
in @INC (@INC contains: /opt/rt3/bin/…/local/lib
/opt/rt3/bin/…/lib /etc/perl /usr/local/lib/perl/5.10.1
/usr/local/share/perl/5.10.1 /usr/lib/perl5 /usr/share/perl5
/usr/lib/perl/5.10 /usr/share/perl/5.10 /usr/local/lib/site_perl .
/usr/local/apache2) at (eval 1318) line 3.\n\nCompilation failed in
require at (eval 2) line 1.\n
[Sun Oct 31 13:44:09 2010] [error] Can’t load Perl file:
/opt/rt3/bin/webmux.pl for server 192.168.0.7:80, exiting…

Go back to your 3.6 instance and find the Scrip where you set an empty
Action and instead either delete that Scrip or pick a proper Action.

Then rerun the conversion

-kevin

Kevin,
thanks very much I eventually got it to start without errors.
I deleted 2 scrips that looked like the ones that we modified back in
2007.
| 15 | no-autoreply | 1 | 17 |
| 16 | autoreply with pw | 1 | 0 |

it still failed but then I re-ran
etc/upgrade/upgrade-mysql-schema.pl rt3 root ‘PASSWORD’ > 3.8queries.sql
and applied the result
Then apache started fine.

So progress
thanks again.
OllyOn Sun, 31 Oct 2010, Kevin Falcone wrote:

On Sun, Oct 31, 2010 at 02:08:41PM +0000, o.nash@cs.ucc.ie wrote:

With slightly different errors:
[error] Require of RT::Action:: failed.\nCan’t locate RT/Action/.pm
in @INC (@INC contains: /opt/rt3/bin/…/local/lib
/opt/rt3/bin/…/lib /etc/perl /usr/local/lib/perl/5.10.1
/usr/local/share/perl/5.10.1 /usr/lib/perl5 /usr/share/perl5
/usr/lib/perl/5.10 /usr/share/perl/5.10 /usr/local/lib/site_perl .
/usr/local/apache2) at (eval 1318) line 3.\n\nCompilation failed in
require at (eval 2) line 1.\n
[Sun Oct 31 13:44:09 2010] [error] Can’t load Perl file:
/opt/rt3/bin/webmux.pl for server 192.168.0.7:80, exiting…

Go back to your 3.6 instance and find the Scrip where you set an empty
Action and instead either delete that Scrip or pick a proper Action.

Then rerun the conversion

-kevin

Oliver Nash
Computer Systems Support Group
Department of Computer Science
University College Cork
Ireland
EMAIL:o.nash@cs.ucc.ie
PHONE:+35321 4205898

it still failed but then I re-ran
etc/upgrade/upgrade-mysql-schema.pl rt3 root ‘PASSWORD’ > 3.8queries.sql
and applied the result

I didn’t mean to imply that you should skip this step.
UPGRADING and UPGRADING.mysql should cover needing to run that step.

I was merely explaining the other error you had

-kevin