[rt-users] RT 3.0.1 to 3.latest user and mysql db import possible?

[Frank Saxton]

Oh... it's actually ./etc/upgrades... :)

I get the same errors as another forum query I posted tonight having to do 
with DBIx::SearchBuilder 1.26...MISSING.  Looks like it's failing the 
Oracle test, of all things...:

Someone suggested installing SearchBuilder without doing the tests but 
didn't say how...

BEGIN failed--compilation aborted at /opt/rt3/lib/RT/SearchBuilder.pm line 71.
Compilation failed in require at /opt/rt3/lib/RT/Principals.pm line 72.
BEGIN failed--compilation aborted at /opt/rt3/lib/RT/Principals.pm line 72.
Compilation failed in require at /opt/rt3/lib/RT/User_Overlay.pm line 80.
BEGIN failed--compilation aborted at /opt/rt3/lib/RT/User_Overlay.pm line 80.
Compilation failed in require at (eval 43) line 3.
Compilation failed in require at /opt/rt3/lib/RT/Record.pm line 69.
BEGIN failed--compilation aborted at /opt/rt3/lib/RT/Record.pm line 69.
Compilation failed in require at /opt/rt3/lib/RT/CurrentUser.pm line 73.
BEGIN failed--compilation aborted at /opt/rt3/lib/RT/CurrentUser.pm line 73.
Compilation failed in require at /opt/rt3/lib/RT.pm line 49.
BEGIN failed--compilation aborted at /opt/rt3/lib/RT.pm line 49.
Compilation failed in require at /opt/rt3/sbin/rt-setup-database line 57.
BEGIN failed--compilation aborted at /opt/rt3/sbin/rt-setup-database line 57.
[root at frankie rt-3.4.4]#

At 10:18 PM 8/31/2005 -0500, Les Mikesell wrote:
>On Wed, 2005-08-31 at 22:02, Frank Saxton wrote:
> > Am I going to run into trouble here?  I have this file (RT_SiteConfig.pm)
> > set pretty much to the defaults, per the example file,  I set the
> > mysaqladmin password because that's what the instructions said to do :(
> >
> > The README instructions for upgrading old databases seems to relate to
> > upgrading an existing RT install, not importing an old database to use 
> in a
> > new install.  /etc/upgrade on the new machine is empty...
>
>You should treat the database like you were upgrading from the
>old version (because you are...).   Your rt's etc/updgrade
>directory should have subdirectories for at least:
>3.1.0  3.1.15  3.1.17  3.3.0  3.3.11
>and you need to do the steps in the README for the ones
>that have schema changes.
>
> > I presume I should skip the make initialize-database step, yes?
>
>Yes - do the upgrade steps instead.
>
>
> > README sez:
> >
> > (You will definitely need to set RT's database password in
> > /opt/rt3/etc/RT_SiteConfig.pm before continuing. Not doing so could be
> > very dangerous.  Note that you do not have to manually add a
> > database user or set up a database for RT.  These actions will be
> > taken care of in the next step.)
>
>I think the rt user/password/permissions will come over with
>the old database, but if not you can can fix it by
>finding the GRANT statments in the initialize-database
>script an running them by hand in mysql.  You can do the
>upgrade steps as root so it won't matter until that is
>done and you try to run RT.
>
>--
>   Les Mikesell
>     les