<html><body><div style="color:#000; background-color:#fff; font-family:times new roman, new york, times, serif;font-size:12pt">Hi Tim, thank you for the reply, bigest problem that I have not been a perl programer, hope you don't mind me asking bit more clarifications<br><br>I am using Oracle as my database and I could not make head or tail of the relations :) guess need to sit by this and real go through the DB<br><br>> 3. if I need to migrate to a new installation (with out upgrade) how<br>> would I go about this task (would it be as just to create the new<br>> instance and configure all the plugins as per the current and just do a<br>> backup and restore on the db)<br><br>Yes. I've done that before. As long as you're not changing the<br>software versions, just copying to a new system, it should be fine.<br><br>Asanka => so this is not the way to do an upgrade? is it because there could be DB changes in the new
release?<br><br>Thanks and Best Regards<br><br><div><span><br></span></div><div><br></div> <div style="font-family: times new roman, new york, times, serif; font-size: 12pt;"> <div style="font-family: times new roman, new york, times, serif; font-size: 12pt;"> <div dir="ltr"> <font face="Arial" size="2"> <hr size="1"> <b><span style="font-weight:bold;">From:</span></b> Tim Cutts <tjrc@sanger.ac.uk><br> <b><span style="font-weight: bold;">To:</span></b> Asanka Gunasekera <asanka_gunasekera@yahoo.co.uk> <br><b><span style="font-weight: bold;">Cc:</span></b> "rt-users@lists.bestpractical.com" <rt-users@lists.bestpractical.com> <br> <b><span style="font-weight: bold;">Sent:</span></b> Tuesday, 11 September 2012, 2:11<br> <b><span style="font-weight: bold;">Subject:</span></b> Re: [rt-users] RT internals<br> </font> </div> <br>On 10/09/2012 12:20, Asanka Gunasekera wrote:<br>> Hi does any one can point me to some reference that will
give me how RT<br>> works internally (Trouble shooting purposes) I need to know things like<br>> <br>> 1. where all this configurations are stored in RT (custom fields, actual<br>> Scripts, templates, Attachemnt etc)<br><br>In the database. The schema isn't that complicated; although some of<br>the configuration data is stored as data structures in blob columns,<br>which can make it a bit tricky to unpick.<br><br>> 2. Does the RT keep all the modification that I do using root dash board<br>> (or any other) in the DB<br><br>Yes.<br><br>> 3. if I need to migrate to a new installation (with out upgrade) how<br>> would I go about this task (would it be as just to create the new<br>> instance and configure all the plugins as per the current and just do a<br>> backup and restore on the db)<br><br>Yes. I've done that before. As long as you're not changing the<br>software versions, just copying to a new system, it
should be fine.<br><br>> 4. What would be the consequences if I try to change "webdomain"<br>> (problem is our organization domain has changed since the commission of RT)<br><br>That's just an RT_SiteConfig setting. I think you can comfortably<br>change it. You might want to check that the RT and mail configuration<br>is set to be happy with both domains, to catch any requests for the old<br>name.<br><br>> 5. I have below problem<br>> <br>> "Couldn't find Ticket for reminder 1656. Please contact administrator."<br>> <br>> though I have put this resolve reminder when the ticket resolved some<br>> times these messages keeps pooping up and I have to change the status<br>> manually from DB. I have tested this script and for me works perfectly.<br>> <br>> I tried to trace the ticket id by going through the DB from backebnd but<br>> I am unable to put tickets and reminders (how do I find the relations)<br>>
<br>> Appreciate any help that you can provide<br><br>It's much easier to follow these things, I find, by using the RT Perl<br>API. It's usually quite easy to write small perl scripts to inspect<br>particular parts of the database, and the API does the unpicking of the<br>database schema so you don't have to.<br><br>perldoc RT::Ticket and its friends will help you.<br><br>Tim<br><br><br><br><br>-- <br> The Wellcome Trust Sanger Institute is operated by Genome Research <br> Limited, a charity registered in England with number 1021457 and a <br> company registered in England with number 2742969, whose registered <br> office is 215 Euston Road, London, NW1 2BE. <br><br><br> </div> </div> </div></body></html>