Login | Register For Free | Help
Search for: (Advanced)

Mailing List Archive: Request Tracker: Users

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

 

 

Request Tracker users RSS feed   Index | Next | Previous | View Threaded


tomas.valenta at trustica

Jan 15, 2007, 1:19 PM

Post #1 of 5 (1216 views)
Permalink
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
_______________________________________________
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


jmoseley at pgtv

Jan 15, 2007, 1:22 PM

Post #2 of 5 (1143 views)
Permalink
Re: Link problem in "ticket's I own" after hostname changed [In reply to]

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[at]tr To
ustica.cz> rt-users[at]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[at]bestpractical.com


Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com


jmoseley at pgtv

Jan 15, 2007, 2:02 PM

Post #3 of 5 (1145 views)
Permalink
Re: Link problem in "ticket's I own" after hostname changed [In reply to]

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 <rt dir>/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[at]tr To
ustica.cz> jmoseley[at]pgtv.com
cc
01/15/2007 03:33
PM Subject
Re: [rt-users] Link problem in
"ticket's I own" after hostname
changed










On Mon, 15 Jan 2007 22:22:25 +0100, <jmoseley[at]pgtv.com> wrote:

> 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[at]jabber.com

--
Ing. Tomáš Valenta
www.Trustica.cz


tomas.valenta at trustica

Jan 15, 2007, 3:06 PM

Post #4 of 5 (1129 views)
Permalink
Re: Link problem in "ticket's I own" after hostname changed [In reply to]

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[at]bestpractical.com


Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com


jmoseley at pgtv

Jan 15, 2007, 4:25 PM

Post #5 of 5 (1131 views)
Permalink
Re: Link problem in "ticket's I own" after hostname changed [In reply to]

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[at]tr To
ustica.cz> rt-users[at]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[at]bestpractical.com


Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com

Request Tracker users RSS feed   Index | Next | Previous | View Threaded
 
 


Interested in having your list archived? Contact lists@gossamer-threads.com
 
  Web Applications & Managed Hosting Powered by Gossamer Threads Inc.