Two questions regarding an upgrade installation

RT Users
1

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

  1. 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

2

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@lists.bestpractical.com
[mailto:rt-users-bounces@lists.bestpractical.com] On Behalf Of Erik
Anderson
Sent: Tuesday, October 23, 2007 12:42 PM
To: rt-users@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

  1. 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@bestpractical.com or call us at +1 617 812 0745.

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

3

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?

-erikOn 10/23/07, Patterson, Craig crpatter@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@lists.bestpractical.com
[mailto:rt-users-bounces@lists.bestpractical.com] On Behalf Of Erik
Anderson
Sent: Tuesday, October 23, 2007 12:42 PM
To: rt-users@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

  1. 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

The rt-users Archives

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@bestpractical.com or call us at +1 617 812 0745.

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

Erik Anderson
http://andersonfam.org

4

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?

This has been resolved - there was a little snippet at the bottom of
one of the wiki pages:

A table structure issue: take a look at the “sessions” table in the RT
database. There should be a column named “a_session”. This column must
have the type “longblob” not “longtext”. Also note that if there are
any records in the table, the entire table should be emptied (either
before or after making the change), otherwise the problem will
persist.

I changed the a_session column type to LONGBLOB and the problem went away.

Thanks!
-erik