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 <[EMAIL PROTECTED]>: > 2008/8/19 Helmuth Ramirez <[EMAIL PROTECTED]>: >> 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:[EMAIL PROTECTED] >> 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 <[EMAIL PROTECTED]>: >>> Pedro, >>> When you run the "rt-setup-database" script, what folder are you >> running >>> it from? >>> >>> -----Original Message----- >>> From: Pedro Bomente Filho [mailto:[EMAIL PROTECTED] >>> 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 <[EMAIL PROTECTED]>: >>>> 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: [EMAIL PROTECTED] >>>> [mailto:[EMAIL PROTECTED] 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: [EMAIL PROTECTED] >>>> >>>> >>>> Discover RT's hidden secrets with RT Essentials from O'Reilly Media. >>>> Buy a copy at http://rtbook.bestpractical.com >>>> >>> >> > _______________________________________________ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
