[rt-users] Two questions regarding an upgrade installation

[Patterson, Craig]

Check out the README that is included with the rt tar.  

Basically you need to...
1.  cd into the directory that you unpacked the rtX.X.X.tar into(not the
folder you installed rt into).  

2. ls the etc/upgrade folder.  

3.  For each folder higher than your current version
      {rt-home}/sbin/rt-setup-database --action schema --datadir
etc/upgrade/[version] --dba rt --dba-password *****

      {rt-home}/sbin/rt-setup-database --action acl  --datadir
etc/upgrade/[version] --dba rt --dba-password *****

      {rt-home}/sbin/rt-setup-database --action insert --datadir
etc/upgrade/[version] --dba rt --dba-password ******

Depending on what variables to set in your RT_SiteConfig, you'll have to
set different options in the above commands.


-----Original Message-----
From: rt-users-bounces at lists.bestpractical.com
[mailto:rt-users-bounces at lists.bestpractical.com] On Behalf Of Erik
Anderson
Sent: Tuesday, October 23, 2007 12:42 PM
To: rt-users at lists.bestpractical.com
Subject: [rt-users] Two questions regarding an upgrade installation

All - we've been running on an install of rt-3.2.0 for several years
now and I've decided it's time to upgrade.  I have two questions so
far:

1. I've installed rt-3.6.5 on a different server and have initialized
the db.  I can get to the login page of RT and can login with the
default root user and password.  However, when I click on any of the
links in RT, I'm sent back to the login screen.

After logging in, I can see that RT sets a cookie as well as inserting
a matching row into the sessions table. My DB is mysql-5.0.42, and I'm
running on apache-2.0.58/mod_perl2

2. After resolving the above issue, what's the best way to bring my
old rt database over. Ideally, I'd like to run a mysqldump of the old
database and import it into the new server.  At that point, I'd
imagine I'd need to run some sort of db schema update script, correct?
 I didn't see anything obvious in the wiki about this.

Thank you
-Erik

-- 
Erik Anderson
http://andersonfam.org
_______________________________________________
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

SAVE THOUSANDS OF DOLLARS ON RT SUPPORT:

If you sign up for a new RT support contract before December 31, we'll
take
up to 20 percent off the price. This sale won't last long, so get in
touch today. 
    Email us at sales at bestpractical.com or call us at +1 617 812 0745.


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