3.2.1 to 3.4.5 upgrade

So, back in August, there was the discussion that started at
http://lists.bestpractical.com/pipermail/rt-users/2005-August/033042.html
and continued with alexmv saying
"It looks like you’re upgrading from something earlier than 3.3.0, not
from 3.4 – 3.4 already contains a “NewReference” column. Please read
the README file that comes with the distribution, specifically the part
labeled ‘If you’re upgrading from RT 3.0 or newer’. ‘make upgrade’ does
not upgrade your database tables; you will need to run rt-setup-database
to do that."

So, I’m doing a test upgrade on a non-live server of an rsync of our
live server. I’ve got 3.2.1 working (though gods know it took long
enough - perl upgrade issues).

The README says:


./configure {–with-appropriate-options}
make testdeps
make fixdeps
make upgrade

Update etc/RT_SiteConfig.pm

ls etc/upgrade
For each item in that directory whose name is greater than
your previously installed RT version, run:

   /opt/rt3/sbin/rt-setup-database --action {various}

So, the make procedes and echos the same instructions about looking in
etc/upgrade and dealing as appropriate.

HOWEVER:

[root@braintree etc]# pwd
/usr/local/rt/etc
[root@braintree etc]# ls up*
ls: up*: No such file or directory

which will, sometime shortly, leave me with the same problem Alex was
replying to… a database without the correct Tables/Columns/Whatever.

I’ll happily take any advice.

Thanks,
JB
JB Segal 617-886-5575 www.smartertravel.com
Systems/Network Admin. 465 Medford St. Ste 400 www.bookingbuddy.com
Smarter Living, Inc. Boston, MA 02129 www.tripmania.com

[…snip…]
[root@braintree etc]# pwd
/usr/local/rt/etc
[root@braintree etc]# ls up*
ls: up*: No such file or directory

which will, sometime shortly, leave me with the same problem Alex was
replying to… a database without the correct Tables/Columns/Whatever.

I’ll happily take any advice.

Sounds like your RT package is incomplete. I suggest you download the
official tarball for the release in question (or pull from svn) and look
at the etc/upgrade/ directory therein.

  • Alex

Update etc/RT_SiteConfig.pm

ls etc/upgrade
For each item in that directory whose name is greater than
your previously installed RT version, run:

   /opt/rt3/sbin/rt-setup-database --action {various}

So, the make procedes and echos the same instructions about looking in
etc/upgrade and dealing as appropriate.

HOWEVER:

[root@braintree etc]# pwd
/usr/local/rt/etc
[root@braintree etc]# ls up*
ls: up*: No such file or directory

The etc directory of the build tree, not the etc directory that you
install to.

Michael
Michael S. Liebman m-liebman@northwestern.edu
http://msl521.freeshell.org/
“I have vision and the rest of the world wears bifocals.”
-Paul Newman in “Butch Cassidy & the Sundance Kid”

Quoth Alex Vandiver (alexmv@bestpractical.com):> On Thu, 2006-02-16 at 15:25 -0500, JB Segal wrote:

[…snip…]
[root@braintree etc]# pwd
/usr/local/rt/etc
[root@braintree etc]# ls up*
ls: up*: No such file or directory

which will, sometime shortly, leave me with the same problem Alex was
replying to… a database without the correct Tables/Columns/Whatever.

I’ll happily take any advice.

Sounds like your RT package is incomplete. I suggest you download the
official tarball for the release in question (or pull from svn) and look
at the etc/upgrade/ directory therein.

  • Alex

Ah. etc in $SRC_DIR, rather than etc in $RT_DIR.

That could be much clearer, as the previous instruction has you editing
$RT_DIR/etc/RT_SiteConfig.pm

(" Update etc/RT_SiteConfig.pm in your RT installation directory.
You’ll need to add any new values you need to change from the defaults
in etc/RT_Config.pm

 You may also need to update RT's database.  To find out, type:

   ls etc/upgrade

. . .")

Thanks,
JB
JB Segal 617-886-5575 www.smartertravel.com
Systems/Network Admin. 465 Medford St. Ste 400 www.bookingbuddy.com
Smarter Living, Inc. Boston, MA 02129 www.tripmania.com

As a follow-up, notice the difference in the directory prefixes in the
directions:
/opt/rt3/sbin/rt-setup-database --action schema
–datadir etc/upgrade/

The rt-setup-databse is in the INSTALLED location, while the DB schema
is in the untarred location.

Alex Vandiver wrote:> On Thu, 2006-02-16 at 15:25 -0500, JB Segal wrote:

[…snip…]
[root@braintree etc]# pwd
/usr/local/rt/etc
[root@braintree etc]# ls up*
ls: up*: No such file or directory

which will, sometime shortly, leave me with the same problem Alex was
replying to… a database without the correct Tables/Columns/Whatever.

I’ll happily take any advice.

Sounds like your RT package is incomplete. I suggest you download the
official tarball for the release in question (or pull from svn) and look
at the etc/upgrade/ directory therein.

  • Alex

http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Be sure to check out the RT Wiki at http://wiki.bestpractical.com

Download a free sample chapter of RT Essentials from O’Reilly Media at http://rtbook.bestpractical.com

WE’RE COMING TO YOUR TOWN SOON - RT Training in Amsterdam, Boston and
San Francisco - Find out more at http://bestpractical.com/services/training.html

Drew Barnes
Applications Analyst
Raymond Walters College
University of Cincinnati

Look in the directory you untarred and ran configure in.

JB Segal wrote:

So, back in August, there was the discussion that started at
http://lists.bestpractical.com/pipermail/rt-users/2005-August/033042.html
and continued with alexmv saying
"It looks like you’re upgrading from something earlier than 3.3.0, not
from 3.4 – 3.4 already contains a “NewReference” column. Please read
the README file that comes with the distribution, specifically the part
labeled ‘If you’re upgrading from RT 3.0 or newer’. ‘make upgrade’ does
not upgrade your database tables; you will need to run rt-setup-database
to do that."

So, I’m doing a test upgrade on a non-live server of an rsync of our
live server. I’ve got 3.2.1 working (though gods know it took long
enough - perl upgrade issues).

The README says:


./configure {–with-appropriate-options}
make testdeps
make fixdeps
make upgrade

Update etc/RT_SiteConfig.pm

ls etc/upgrade
For each item in that directory whose name is greater than
your previously installed RT version, run:

   /opt/rt3/sbin/rt-setup-database --action {various}

So, the make procedes and echos the same instructions about looking in
etc/upgrade and dealing as appropriate.

HOWEVER:

[root@braintree etc]# pwd
/usr/local/rt/etc
[root@braintree etc]# ls up*
ls: up*: No such file or directory

which will, sometime shortly, leave me with the same problem Alex was
replying to… a database without the correct Tables/Columns/Whatever.

I’ll happily take any advice.

Thanks,
JB

JB Segal 617-886-5575 www.smartertravel.com
Systems/Network Admin. 465 Medford St. Ste 400 www.bookingbuddy.com
Smarter Living, Inc. Boston, MA 02129 www.tripmania.com


http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Be sure to check out the RT Wiki at http://wiki.bestpractical.com

Download a free sample chapter of RT Essentials from O’Reilly Media at http://rtbook.bestpractical.com

WE’RE COMING TO YOUR TOWN SOON - RT Training in Amsterdam, Boston and
San Francisco - Find out more at http://bestpractical.com/services/training.html

Drew Barnes
Applications Analyst
Raymond Walters College
University of Cincinnati