[rt-users] Upgrade database from 3.6.1 to new server running RT3.8.1

[Pedro Bomente Filho]

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

2008/8/19 Pedro Bomente Filho <pebomente at gmail.com>:
> 2008/8/19 Helmuth Ramirez <HelmuthRamirez at 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 at 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 at 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 at 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 at 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 at lists.bestpractical.com
>>>> [mailto:rt-users-bounces at 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 at bestpractical.com
>>>>
>>>>
>>>> Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
>>>> Buy a copy at http://rtbook.bestpractical.com
>>>>
>>>
>>
>