Upgrading to RT 3.6.1 from RT 3.4.1 and 3.0.11 with older MySql versions on them

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

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:

Mathew, Do you mean make upgrade for the RT make or from the mysql
prompt?

BobFrom: Mathew Snyder [mailto:jokermjs19@comcast.net]
Sent: Monday, August 21, 2006 6:47 PM
To: Farrell,Bob
Cc: RT-Users@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



The rt-users Archives

Community help: http://wiki.bestpractical.com Commercial support:
sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com

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@comcast.net]
Sent: Monday, August 21, 2006 6:47 PM
To: Farrell,Bob
Cc: RT-Users@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



The rt-users Archives

Community help: http://wiki.bestpractical.com Commercial support:
sales@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/

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

What if there is no 3.0.11 ? ( it starts at 3.1.0 )
Thanks for all of your help.

BobFrom: Mathew Snyder [mailto:jokermjs19@comcast.net]
Sent: Monday, August 21, 2006 8:30 PM
To: Farrell,Bob
Cc: RT-Users@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@comcast.net]
Sent: Monday, August 21, 2006 6:47 PM
To: Farrell,Bob
Cc: RT-Users@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



The rt-users Archives

Community help: http://wiki.bestpractical.com Commercial support:
sales@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/

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

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

[mailto:rt-users-bounces@lists.bestpractical.com] On Behalf Of
Farrell,BobSent: Monday, August 21, 2006 9:04 PM
To: Mathew Snyder
Cc: RT-Users@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

From: Mathew Snyder [mailto:jokermjs19@comcast.net]
Sent: Monday, August 21, 2006 8:30 PM
To: Farrell,Bob
Cc: RT-Users@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@comcast.net]
Sent: Monday, August 21, 2006 6:47 PM
To: Farrell,Bob
Cc: RT-Users@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



The rt-users Archives

Community help: http://wiki.bestpractical.com Commercial support:
sales@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/

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@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com

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.11From: Farrell,Bob
Sent: Monday, August 21, 2006 9:07 PM
To: Farrell,Bob; Mathew Snyder
Cc: RT-Users@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

From: rt-users-bounces@lists.bestpractical.com
[mailto:rt-users-bounces@lists.bestpractical.com] On Behalf Of
Farrell,Bob
Sent: Monday, August 21, 2006 9:04 PM
To: Mathew Snyder
Cc: RT-Users@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

From: Mathew Snyder [mailto:jokermjs19@comcast.net]
Sent: Monday, August 21, 2006 8:30 PM
To: Farrell,Bob
Cc: RT-Users@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@comcast.net]
Sent: Monday, August 21, 2006 6:47 PM
To: Farrell,Bob
Cc: RT-Users@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



The rt-users Archives

Community help: http://wiki.bestpractical.com Commercial support:
sales@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/

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@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com

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@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@lists.bestpractical.com
[mailto:rt-users-bounces@lists.bestpractical.com] On Behalf Of
Farrell,Bob
Sent: Monday, August 21, 2006 9:04 PM
To: Mathew Snyder
Cc: RT-Users@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@comcast.net]
Sent: Monday, August 21, 2006 8:30 PM
To: Farrell,Bob
Cc: RT-Users@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@comcast.net]
Sent: Monday, August 21, 2006 6:47 PM
To: Farrell,Bob
Cc: RT-Users@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



The rt-users Archives

Community help: http://wiki.bestpractical.com Commercial support:
sales@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/

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


The rt-users Archives

Community help: http://wiki.bestpractical.com Commercial support:
sales@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/

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

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

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.

IT WORKED !

Thanks Mathew !From: Farrell,Bob
Sent: Monday, August 21, 2006 9:13 PM
To: Farrell,Bob; ‘Mathew Snyder’
Cc: ‘RT-Users@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

From: Farrell,Bob
Sent: Monday, August 21, 2006 9:07 PM
To: Farrell,Bob; Mathew Snyder
Cc: RT-Users@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

From: rt-users-bounces@lists.bestpractical.com
[mailto:rt-users-bounces@lists.bestpractical.com] On Behalf Of
Farrell,Bob
Sent: Monday, August 21, 2006 9:04 PM
To: Mathew Snyder
Cc: RT-Users@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

From: Mathew Snyder [mailto:jokermjs19@comcast.net]
Sent: Monday, August 21, 2006 8:30 PM
To: Farrell,Bob
Cc: RT-Users@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@comcast.net]
Sent: Monday, August 21, 2006 6:47 PM
To: Farrell,Bob
Cc: RT-Users@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



The rt-users Archives

Community help: http://wiki.bestpractical.com Commercial support:
sales@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/

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@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com

I did not do it properly it appears, but so far so good. EVERYTHING is
there !From: Farrell,Bob
Sent: Monday, August 21, 2006 9:34 PM
To: Farrell,Bob; ‘Mathew Snyder’
Cc: ‘RT-Users@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.

IT WORKED !

Thanks Mathew !

From: Farrell,Bob
Sent: Monday, August 21, 2006 9:13 PM
To: Farrell,Bob; ‘Mathew Snyder’
Cc: ‘RT-Users@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

From: Farrell,Bob
Sent: Monday, August 21, 2006 9:07 PM
To: Farrell,Bob; Mathew Snyder
Cc: RT-Users@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

From: rt-users-bounces@lists.bestpractical.com
[mailto:rt-users-bounces@lists.bestpractical.com] On Behalf Of
Farrell,Bob
Sent: Monday, August 21, 2006 9:04 PM
To: Mathew Snyder
Cc: RT-Users@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

From: Mathew Snyder [mailto:jokermjs19@comcast.net]
Sent: Monday, August 21, 2006 8:30 PM
To: Farrell,Bob
Cc: RT-Users@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@comcast.net]
Sent: Monday, August 21, 2006 6:47 PM
To: Farrell,Bob
Cc: RT-Users@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



The rt-users Archives

Community help: http://wiki.bestpractical.com Commercial support:
sales@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/

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@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com

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@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@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@lists.bestpractical.com
[mailto:rt-users-bounces@lists.bestpractical.com] On Behalf Of
Farrell,Bob
Sent: Monday, August 21, 2006 9:04 PM
To: Mathew Snyder
Cc: RT-Users@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@comcast.net]
Sent: Monday, August 21, 2006 8:30 PM
To: Farrell,Bob
Cc: RT-Users@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@comcast.net]
Sent: Monday, August 21, 2006 6:47 PM
To: Farrell,Bob
Cc: RT-Users@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



The rt-users Archives

Community help: http://wiki.bestpractical.com Commercial support:
sales@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/

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


The rt-users Archives

Community help: http://wiki.bestpractical.com Commercial support:
sales@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

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

Thanks Again !

BFFrom: Mathew Snyder [mailto:jokermjs19@comcast.net]
Sent: Monday, August 21, 2006 9:41 PM
To: Farrell,Bob
Cc: RT-Users@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@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@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@lists.bestpractical.com
[mailto:rt-users-bounces@lists.bestpractical.com] On Behalf Of
Farrell,Bob
Sent: Monday, August 21, 2006 9:04 PM
To: Mathew Snyder
Cc: RT-Users@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@comcast.net]
Sent: Monday, August 21, 2006 8:30 PM
To: Farrell,Bob
Cc: RT-Users@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@comcast.net]
Sent: Monday, August 21, 2006 6:47 PM
To: Farrell,Bob
Cc: RT-Users@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



The rt-users Archives

Community help: http://wiki.bestpractical.com Commercial support:
sales@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/

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


The rt-users Archives

Community help: http://wiki.bestpractical.com Commercial support:
sales@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