[rt-users] Two questions regarding an upgrade installation

[Erik Anderson]

Thanks Craig - that worked perfectly.  I should have looked around a
bit more before posting.

Anyway - does anyone have any clue as to my login session problem?

-erik

On 10/23/07, Patterson, Craig <crpatter at ci.grand-rapids.mi.us> wrote:
> 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
>


-- 
Erik Anderson
http://andersonfam.org