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.
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.
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.
The rt-users Archives
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
[rt-users] sendmail aliases
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
The rt-users Archives
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