Migration issues with RT

RT Users
1

Hi,

My company moved to a new domain - from xxx.com to yyy.com. I have to
migrate my RT installation too. :frowning:

  1. What are the changes I need to make? I can see $rtname and
    $Organization in config.pm. Do I have to change anywhere else? Or just
    perl -pi -e ‘s/xxx/yyy/g’ config.pm is enough?

  2. Our email addresses will also change (with a forwarding to the old
    address to the new address). Does this concern RT? Same question with
    the RT URL.

  3. Any changes to be made in database?

  4. I am sure people will correspond with [xxx.com #nnn] in the subject
    (at least for some time). How do I as RT to treat that as [yyy.com #nnn]?
    I can ask procmail to rewrite the subject header, I guess.

In a related query, anyone ever tried migrating RT (with tickets and
scrips and everything) from MySQL to PostgreSQL? My RT database dump is
about 10 MB now.

Binand

2

In article 20021226065421.GC14541@binand.cysphere.com,Binand Raj S. binand@gmx.net wrote:

  1. Any changes to be made in database?

Yes, you definitely have to change the Links table; I don’t know if
you need to change anything in other tables.

Ambrose Li a.c.li@ieee.org
http://ada.dhs.org/~acli/cmcc/ http://www.cccgt.org/

DRM is theft - We are the stakeholders

3

Binand Raj S. wrote:

My company moved to a new domain - from xxx.com to yyy.com. I have to
migrate my RT installation too. :frowning:

Fun…

  1. Our email addresses will also change (with a forwarding to the old
    address to the new address). Does this concern RT? Same question with
    the RT URL.

Make sure you tweak the CanonicalizeAddress function in config.pm
to make RT treat old-domain addresses the same as the new ones.

  1. I am sure people will correspond with [xxx.com #nnn] in the subject
    (at least for some time). How do I as RT to treat that as [yyy.com #nnn]?
    I can ask procmail to rewrite the subject header, I guess.

If procmail is available, use it. RT has no clean and simple way to
handle this.

(hmm… @rtnames…)
Phil Homewood, Systems Janitor, www.SnapGear.com
pdh@snapgear.com Ph: +61 7 3435 2810 Fx: +61 7 3891 3630
SnapGear - Custom Embedded Solutions and Security Appliances