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

Mon Aug 21 21:49:58 EDT 2006

WOW !
Yes, we run postgresql as well at our companies.
Funny, but seem easier to me.

Thanks Again !

BF

-----Original Message-----
From: Mathew Snyder [mailto:jokermjs19 at comcast.net] 
Sent: Monday, August 21, 2006 9:41 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
witholder MySql versions on them.

Farrell,Bob wrote:
> IT WORKED !
> 
> Thanks Mathew !
> 
> -----Original Message-----
> From: Farrell,Bob
> Sent: Monday, August 21, 2006 9:13 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.
> 
> 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're welcome.  I know how much of a fiasco it was for me to set this
stuff up the first time.  And I had to go from 3.0.9 to 3.6.0 and from
Postgres database to MySQL.

Mathew