Link problem in "ticket's I own" after hostname changed

Hello,

I installed RT 3.6.1 on Debain from a package, configured and imported
data from old 3.4 database on testing machine with some hostname.
Then when everything was OK I changed the testing machine hostname
to replace the production machine and … on Homepage in section “X
highest priority ticket’s I own” the hyperlink from task number goes
to the right ticket but the ticket subject goes to adress containing
the old hostname, whis no longer exist. Can anyone help me please?

There is not a single entry of the old hostname in config files (not
even in whole /etc) and same for the source code. I also checked the
database and I can’t find any obvious traces of old hostname.

I am not able to debud the sources so well to trace the problem :-/

Thank’s for any help.

Ing. Tomďż˝ Valenta
www.Trustica.cz

Have you updated the database schema? What is the value of the $rtname in
the old and new RT_Siteconfig files?

James Moseley

         "Ing. Tomas                                                   
         Valenta"                                                      
         <tomas.valenta@tr                                          To 
         ustica.cz>                rt-users@lists.bestpractical.com    
         Sent by:                                                   cc 
         rt-users-bounces@                                             
         lists.bestpractic                                     Subject 
         al.com                    [rt-users] Link problem in          
                                   "ticket's I own" after hostname     
                                   changed                             
         01/15/2007 03:19                                              
         PM                                                            

Hello,

I installed RT 3.6.1 on Debain from a package, configured and imported
data from old 3.4 database on testing machine with some hostname.
Then when everything was OK I changed the testing machine hostname
to replace the production machine and … on Homepage in section “X
highest priority ticket’s I own” the hyperlink from task number goes
to the right ticket but the ticket subject goes to adress containing
the old hostname, whis no longer exist. Can anyone help me please?

There is not a single entry of the old hostname in config files (not
even in whole /etc) and same for the source code. I also checked the
database and I can’t find any obvious traces of old hostname.

I am not able to debud the sources so well to trace the problem :-/

Thank’s for any help.

Ing. Tomáš Valenta
www.Trustica.cz
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

Have you manually checked the database to see if the tables were updated
with updates contained in the script?

Also, check the httpd configs.

Actually, I think the problem is that after you made the change on the test
server, you didn’t clear out the mason cache.

Perform:

rm -fr /var/mason_data/obj

and then restart your httpd daemon (probably Apache).

See if that clears up your problem.

James Moseley

         "Ing. Tomas                                                   
         Valenta"                                                      
         <tomas.valenta@tr                                          To 
         ustica.cz>                jmoseley@pgtv.com                   
                                                                    cc 
         01/15/2007 03:33                                              
         PM                                                    Subject 
                                   Re: [rt-users] Link problem in      
                                   "ticket's I own" after hostname     
                                   changed                             

Have you updated the database schema? What is the value of the $rtname
in
the old and new RT_Siteconfig files?

Hello,

according to docs, I used this after importing the old database:
for x in /etc/request-tracker3.6/upgrade/*; do
for y in schema acl insert; do
/usr/sbin/rt-setup-database-3.6 --action $y --datadir $x
–dba rtuser --dba-password wibble;
done;
done;
I tried to run this again now, and no change.

Value of $rtname is the same as the DNS hostname for my computer -
helpdesk.
It was on old instalation as well as now on new. WebPath and WebBaseURL is
the same as before. Both instances are running on debian on virtual Xen
host.
I’m quite confused.

ICQ: 18270020
Jabber: borland@jabber.com

Ing. Tomáš Valenta
www.Trustica.cz

Thanks to James Moseley and some further research I solve the problem.
The DB upgrade process created some predefined searches accoding to
/etc/request-tracker3.6/upgrade/3.5.1/content recipy. This was done
when I update the DB with the old hostname.

To repair my problem I deleted “Search - My Ticket”, “Search -
Unowned Tickets” and “HomepageSetting” and run the 3.5.1 upgrade
recipy again.

Now everythink is OK.

Ing. Tomďż˝ Valenta
www.Trustica.cz

You are welcome. Whenever upgrading or making changes to the config, you
need to clear out the mason cache and restart the web service. This
process is documented in the README and other docs.

James Moseley

         "Ing. Tomas                                                   
         Valenta"                                                      
         <tomas.valenta@tr                                          To 
         ustica.cz>                rt-users@lists.bestpractical.com    
         Sent by:                                                   cc 
         rt-users-bounces@                                             
         lists.bestpractic                                     Subject 
         al.com                    Re: [rt-users] Link problem in      
                                   "ticket's I own" after hostname     
                                   changed                             
         01/15/2007 05:06                                              
         PM                                                            

Thanks to James Moseley and some further research I solve the problem.
The DB upgrade process created some predefined searches accoding to
/etc/request-tracker3.6/upgrade/3.5.1/content recipy. This was done
when I update the DB with the old hostname.

To repair my problem I deleted “Search - My Ticket”, “Search -
Unowned Tickets” and “HomepageSetting” and run the 3.5.1 upgrade
recipy again.

Now everythink is OK.

Ing. Tomáš Valenta
www.Trustica.cz
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

I have a question about searching/query builder.

I am wanting to setup multiple queues for example queueA queueB queueC

and i want users userA1,userA2 to only have access to queueA
userB1, userB2 to queueB
userC1, userC2 to queueC
etc

I am wanting to know if userA1 create a query to search would it search
queueA only or would it search the other queues as well ?

is there a way to only limit it the queue that they have access to ?

Thanks for your reply