Upgrade database from 3.6.1 to new server running RT 3.8.1

RT Users
1

Hi people,

Can anyone help me to upgrade database from RT 3.6.1 to new server RT 3.8.1?
I don’t know what I’m doing wrong.
How can I do it?
I only found documentation to upgrade an existing server.

Thank you,
Pedro Bomente

2

Pedro,
Based on our offline conversation, I think the first thing issue that
needs to be tackled is why you can’t access your db properly in the 3.8
world. Unfortunately I’m not smart enough to answer that, but maybe I
can help troubleshoot with you. I too moved my RT installation to a new
server (3.6.3 to 3.8.0 to 3.8.1). Prior to me upgrading the db, I was
able to successfully access my new 3.8.0 installation and view my
tickets. I imagine you should be able to also.
I’m going to throw out some basic things (please do not take offense),
do you have all the dependencies met for 3.8.1? Did you update your
RT_SiteConfig.pm with your db name (I think you are using a different
name from the default).-----Original Message-----
From: rt-users-bounces@lists.bestpractical.com
[mailto:rt-users-bounces@lists.bestpractical.com] On Behalf Of Pedro
Bomente Filho
Sent: Tuesday, August 19, 2008 4:03 PM
To: RT Users
Subject: [rt-users] Upgrade database from 3.6.1 to new server running
RT3.8.1

Hi people,

Can anyone help me to upgrade database from RT 3.6.1 to new server RT
3.8.1?
I don’t know what I’m doing wrong.
How can I do it?
I only found documentation to upgrade an existing server.

Thank you,
Pedro Bomente
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

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

Hi again,

I’m sorry, I didn’t send to mail list, I forgot. But here it’s history:

I discovered my problem. In fact, my database upgrade was right, but
it’s happening something stranger.
In my main page on RT the url tickets are:

http://site/rt/Ticket/Display.html?id=1

and it should be:

http://gonzales/Ticket/Display.html?id=1

If I access from that link (http://site/rt/Ticket/Display.html?id=1) ,
RT can’t access the page.

In search results page, the url is right:

http://gonzales/Ticket/Display.html?id=382

Why ?

I didn’t configure RT_SiteConfig.pm where it show “WebPath”, in fact,
I didn’t need set this parameter to work.

Thank’s,
Pedro2008/8/19 Pedro Bomente Filho pebomente@gmail.com:

2008/8/19 Helmuth Ramirez HelmuthRamirez@compupay.com:

Pedro, I’m sorry, I don’t think I’ll be able to be much help here. The
/usr/src location, is that where you extracted the .gz file to? For

Yes, that is.

what its worth, I was having trouble with my upgrade until I ran the
command from the location where I extracted the files.

In my case:
cd’d to source directory (example /tmp/stuff/rt/rt-3.8.0)
once there, ran /opt/rt3/sbin/rt-setup-database --dba root
–prompt-for-dba-password --action upgrade

I remember.

But, anyway, thank you for help me.

Pedro

-----Original Message-----
From: Pedro Bomente Filho [mailto:pebomente@gmail.com]
Sent: Tuesday, August 19, 2008 4:51 PM
To: Helmuth Ramirez
Subject: Re: [rt-users] Upgrade database from 3.6.1 to new server
running RT3.8.1

Helmuth,

From RT source, I mean:

/usr/src/rt-3.8.1

so, I ran:

perl sbin/rt-setup-database --dba root --prompt-for-dba-password
–action upgrade

These were my steps to upgrade database:

  • I installed RT 3.8.1 - Here it work normally! I did every steps from
    file README

  • I dumped my old RT 3.6.1:
    I ran: ’ mysqldump --opt --skip-lock-tables --single-transaction
    –default-character-set=binary --databases rtdb > backup.sql ’

  • I imported backup from old server to new server:
    I ran: ’ mysql -u root -p < backup.sql ’

  • Upgrade RT schema:
    I ran: ’ perl sbin/rt-setup-database --dba root
    –prompt-for-dba-password --action upgrade ’ from /usr/src/rt-3.8.1

Where can it be wrong?
I don’t know.

Thank you,
Pedro

2008/8/19 Helmuth Ramirez HelmuthRamirez@compupay.com:

Pedro,
When you run the “rt-setup-database” script, what folder are you
running
it from?

-----Original Message-----
From: Pedro Bomente Filho [mailto:pebomente@gmail.com]
Sent: Tuesday, August 19, 2008 4:31 PM
To: Helmuth Ramirez
Subject: Re: [rt-users] Upgrade database from 3.6.1 to new server
running RT3.8.1

Hi Helmuth, thank’s for answer again!

Well,

2008/8/19 Helmuth Ramirez HelmuthRamirez@compupay.com:

Pedro,
Based on our offline conversation, I think the first thing issue that
needs to be tackled is why you can’t access your db properly in the
3.8
world. Unfortunately I’m not smart enough to answer that, but maybe
I
can help troubleshoot with you. I too moved my RT installation to a
new
server (3.6.3 to 3.8.0 to 3.8.1). Prior to me upgrading the db, I
was
able to successfully access my new 3.8.0 installation and view my
tickets. I imagine you should be able to also.

I’m able to successfully access my new 3.8.1 and view my tickets.

I’m going to throw out some basic things (please do not take
offense),

Ok, no problem.

do you have all the dependencies met for 3.8.1? Did you update your

Yes, I ran “make testdeps” before installation and it returned me “All
dependencies have been found.”

RT_SiteConfig.pm with your db name (I think you are using a different
name from the default).

Yes, I did. In RT 3.8.1, when I run “make initialize-database”, it
create a db in mysql acordding RT_SiteConfig.pm. For example:

My RT_SiteConfig.pm:
“Set($DatabaseName , ‘rtdb’);”

My mysql:

mysql> show databases;

±-------------------+
| Database |
±-------------------+
| information_schema |
| mysql |
| rtdb |
±-------------------+

In my RT 3.8.1 without to upgrade database RT 3.6.1, I can use
normally.

-----Original Message-----
From: rt-users-bounces@lists.bestpractical.com
[mailto:rt-users-bounces@lists.bestpractical.com] On Behalf Of Pedro
Bomente Filho
Sent: Tuesday, August 19, 2008 4:03 PM
To: RT Users
Subject: [rt-users] Upgrade database from 3.6.1 to new server running
RT3.8.1

Hi people,

Can anyone help me to upgrade database from RT 3.6.1 to new server RT
3.8.1?
I don’t know what I’m doing wrong.
How can I do it?
I only found documentation to upgrade an existing server.

Thank you,
Pedro Bomente

The rt-users Archives

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

4

Try modifying this in your RT_SiteConfig.pm

Set($WebBaseURL , “http://gonzales”);-----Original Message-----
From: rt-users-bounces@lists.bestpractical.com
[mailto:rt-users-bounces@lists.bestpractical.com] On Behalf Of Pedro
Bomente Filho
Sent: Wednesday, August 20, 2008 4:03 PM
To: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] Upgrade database from 3.6.1 to new server
runningRT3.8.1

Hi again,

I’m sorry, I didn’t send to mail list, I forgot. But here it’s history:

I discovered my problem. In fact, my database upgrade was right, but
it’s happening something stranger.
In my main page on RT the url tickets are:

http://site/rt/Ticket/Display.html?id=1

and it should be:

http://gonzales/Ticket/Display.html?id=1

If I access from that link (http://site/rt/Ticket/Display.html?id=1) ,
RT can’t access the page.

In search results page, the url is right:

http://gonzales/Ticket/Display.html?id=382

Why ?

I didn’t configure RT_SiteConfig.pm where it show “WebPath”, in fact,
I didn’t need set this parameter to work.

Thank’s,
Pedro

5

Try modifying this in your RT_SiteConfig.pm

Set($WebBaseURL , “http://gonzales”);

It did work. But I did a thing tha worked. I added in my apache configution,
Alias /rt /opt/rt3/share/html

It worked, but I shouldn’t solve this, do you understand me? RT main
page should link to: http://gonzales/Ticket/Display.html?id=1 and not
to: http://gonzales/rt/Ticket/Display.html?id=1

6

Try modifying this in your RT_SiteConfig.pm

Set($WebBaseURL , “http://gonzales”);

Sorry, now it’s correct:

It did NOT work. But I did a thing thaT worked. I added in my apache
configution,
Alias /rt /opt/rt3/share/html

It worked, but I shouldn’t solve this way, do you understand me? RT main
page should link to: http://gonzales/Ticket/Display.html?id=1 and not
to: http://gonzales/rt/Ticket/Display.html?id=1