[rt-users] Upgrading to RT 3.6.1 from RT 3.4.1 and 3.0.11 witholder MySql versions on them.

[Mathew Snyder]

Farrell,Bob wrote:
> AND
> 
> /usr/local/rt3/sbin/rt-setup-database --dba root \
> --prompt-for-dba-password \ --action schema \ --datadir
> /MY/rt/sourcedir/rt-3.4.4/etc/upgrade/3.0.11
> 
> 
> 
> -----Original Message-----
> From: Farrell,Bob 
> Sent: Monday, August 21, 2006 9:07 PM
> To: Farrell,Bob; Mathew Snyder
> Cc: RT-Users at lists.bestpractical.com
> Subject: RE: [rt-users] Upgrading to RT 3.6.1 from RT 3.4.1 and 3.0.11
> witholder MySql versions on them.
> 
> I ran /usr/local/rt3/sbin/rt-setup-database --dba root \
> --prompt-for-dba-password \ --action schema \ --datadir
> /MY/rt/sourcedir/rt-3.0.11/etc/upgrade/3.6.1
> 
> -----Original Message-----
> From: rt-users-bounces at lists.bestpractical.com
> [mailto:rt-users-bounces at lists.bestpractical.com] On Behalf Of
> Farrell,Bob
> Sent: Monday, August 21, 2006 9:04 PM
> To: Mathew Snyder
> Cc: RT-Users at lists.bestpractical.com
> Subject: RE: [rt-users] Upgrading to RT 3.6.1 from RT 3.4.1 and 3.0.11
> witholder MySql versions on them.
> 
> What if there is no 3.0.11 ? ( it starts at 3.1.0 ) Thanks for all of
> your help.
> 
> Bob
> 
> -----Original Message-----
> From: Mathew Snyder [mailto:jokermjs19 at comcast.net]
> Sent: Monday, August 21, 2006 8:30 PM
> To: Farrell,Bob
> Cc: RT-Users at lists.bestpractical.com
> Subject: Re: [rt-users] Upgrading to RT 3.6.1 from RT 3.4.1 and 3.0.11
> with older MySql versions on them.
> 
> Farrell,Bob wrote:
>> Mathew, Do you mean make upgrade for the RT make or from the mysql 
>> prompt?
>>
>> Bob
>>
>> -----Original Message-----
>> From: Mathew Snyder [mailto:jokermjs19 at comcast.net]
>> Sent: Monday, August 21, 2006 6:47 PM
>> To: Farrell,Bob
>> Cc: RT-Users at lists.bestpractical.com
>> Subject: Re: [rt-users] Upgrading to RT 3.6.1 from RT 3.4.1 and 3.0.11
> 
>> with older MySql versions on them.
>>
>> You're stuck doing the upgrade.  Each revision introduces new aspects 
>> to the database schema that need to be integrated smoothly in order to
> 
>> make everything work well.  It isn't that big a process.  Simply 
>> import the database onto the new machine's instance of MySQL and run
> 'make upgrade'
>> for 3.6.1.  It will update the schema to the proper settings for use 
>> with the newer version.  The same can be done for 3.4.1.
>>
>> By trying other methods you are creating more work than will be done 
>> by simply running the upgrade in the first place.
>>
>> Mathew Snyder
>>
>> Farrell,Bob wrote:
>>> All,
>>>
>>>  I have two machines that I want to move to RT 3.6.1, on new machines
> 
>>> running MySql 5.0.22-1.
>>>
>>> Both units have MySql 4.0.18 on them.
>>>
>>> The RT machine with RT 3.4.1 imported just fine.
>>>
>>> The RT Machine with 3.0.11 did not.
>>>
>>> I built a standalone NEW box without issue.
>>>
>>> I understand this maybe a MySql issue, and no fault of RT, but was 
>>> wondering if anyone had any ideas that could assist me.
>>>
>>> The mysql dump from 3.4.1 was a simple mysql dump to a "backup.sql" 
>>> file and imported fine.
>>>
>>> The 3.0.11 mysql dump gave me table "rt3.atrribute missing" in the 
>>> logs when bringing up the RT interface after login, and I could not 
>>> navigate anywhere, although I did see the queues in the drop down
>> menu.
>>> Any MySql gurus out there that may have run across this before?
>>>
>>> I added the attribute table, and now can see ALL tickets, etc, but no
> 
>>> comments /data /email correspondence in them under the History
>> section.
>>> I also get "an internal error has occurred" when creating a ticket in
> 
>>> the RT 3.0.11 to 3.6.1 box, but the ticket does in fact get created. 
>>> (
>>> still won't fly with the admins though )
>>>
>>> A requirement of this facility that uses RT 3.0.11 is that all 
>>> History, time worked, etc. is retained in the migration. I am hoping 
>>> to use the existing Rt3.0.11 mysql dumps and move the data, not go 
>>> the
>>> upgrade mysql revision by revision route. Could this be repaired via 
>>> an RT setting, or am I stuck in mysql upgrade land ?
>>>
>>> Or perhaps a person has an idea I have not even thought of.
>>>
>>> Any help would be greatly appreciated.
>>>
>>> Kudos to Jesse Vincent and the Team, as the new box, and the 3.4.1 
>>> upgrade are working flawlessly !
>>>
>>> Thanks
>>>
>>> Bob
>>>
>>>  
>>>
>>>
>>> ---------------------------------------------------------------------
>>> -
>>> --
>>>
>>> _______________________________________________
>>> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
>>>
>>> Community help: http://wiki.bestpractical.com Commercial support: 
>>> sales at bestpractical.com
>>>
>>>
>>> Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
>>> Buy a copy at http://rtbook.bestpractical.com
>>
> 
> RT.  You will first run the ./configure with whichever options you
> require.  Then verify that all perl modules are installed with 'make
> testdeps'.  Once all modules are squared away run 'make upgrade'.  This
> will prepare all the scripts necessary to update the database schema.
> 
> Once 'make upgrade' has completed you will need to cd to etc/upgrade
> within the RT source directory.  Inside you will find several
> directories which require a command be run for each.  The command will
> look similar to this:
> 
> /usr/local/rt3/sbin/rt-setup-database --dba root \
> --prompt-for-dba-password \ --action schema \ --datadir
> /your/rt/sourcedir/rt-3.4.4/etc/upgrade/<version>
> 
> You'll have to replace '--action schema' with one of three options for
> each directory (you can find these options in the README; you can also
> find all of this in the same README).
> 
> Once you've run the command with the three options for each of the
> directories you will be all set to log in.  Everything should work.
> 
> Mathew Snyder
> 
> _______________________________________________
> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
> 
> Community help: http://wiki.bestpractical.com Commercial support:
> sales at bestpractical.com
> 
> 
> Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
> Buy a copy at http://rtbook.bestpractical.com
> 

You'll first want to run the upgrade from 3.0.11 to the 3.4 branch. 
 From the 3.4 branch you will be able to upgrade to the 3.6 branch.

Again, run the command above three times for each directory in 
etc/upgrade.  Once for --action schema, once for --action acl and once 
for --action insert.

So to rehash:

1: install 3.0.11 and MySQL on your new server.
2: import your old database into MySQL on the new server
3: install 3.4.5 using 'make upgrade' then run
/usr/local/rt3/sbin/rt-setup-database --dba root \
--prompt-for-dba-password \ --action schema \ --datadir
/your/rt/sourcedir/rt-3.4.4/etc/upgrade/<version>

/usr/local/rt3/sbin/rt-setup-database --dba root \
--prompt-for-dba-password \ --action acl \
--datadir /your/rt/sourcedir/rt-3.4.4/etc/upgrade/<version>

/usr/local/rt3/sbin/rt-setup-database --dba root \
--prompt-for-dba-password \ --action insert \
--datadir /your/rt/sourcedir/rt-3.4.4/etc/upgrade/<version>

for each directory in etc/upgrade

5: install 3.6.1 using 'make upgrade' and run the same commands above 
for each directory in etc/upgrade.

Make sure all the configurations in RT_Siteconfig.pm are correct, 
restart httpd, log in and enjoy.