Moving rt to another machine

RT Users
1

Hi,

I’d like to move our rt to another machine. I have rt all set up on
the new machine and was wondering if I can just tar up certain
directories on the old machine, then untar them in the proper place on
the new machines, and have everything like it was, with all the tickets
in tact and such. If so, what directories would I want to
migrate? What might break when I do this? I know to add the aliases
and such but am not sure where rt has put stuff for mysql.

Thanks in advance,
Todd

2

Hi,

I’d like to move our rt to another machine. I have rt all set up on
the new machine and was wondering if I can just tar up certain
directories on the old machine, then untar them in the proper place on
the new machines, and have everything like it was, with all the tickets
in tact and such. If so, what directories would I want to
migrate? What might break when I do this? I know to add the aliases
and such but am not sure where rt has put stuff for mysql.

I’ve done this once, and this is what I did (from memory – may be
missing some steps – back up everything!)

  1. Get RT installed on the new machine, preferably with the same options
    as the other RT.
  2. Create a new queue and mysql database, with the same name as the
    other RT.
  3. Backup the mysql database(s), and replace it/them with the databases
    from the old machine.
    4.Start using the new RT.

I’m sure there are cleaner ways of doing it, but this one worked…

Greg White
Those who make peaceful revolution impossible will make violent
revolution inevitable.
– John F. Kennedy

3

This is a quick and dirty list of
the things that need to be done to move an RT1 instance from one host
to another are as follows:
Install RT on the new host.
On the old host:
mysqldump rt > rtdb
tar cvf transactions.tar rt/transactions

    copy those files to the new host.

    On the new host
      mysqladmin drop rt
      mysqladmin create rt
      mysql rt <rtdb
      cd /opt/rt; tar xvf transactions.tar

     on your rt install dir on the new host:
      make fixpermsOn Tue, Feb 06, 2001 at 08:28:35PM -0600, Todd Jagger wrote:

Hi,

I’d like to move our rt to another machine. I have rt all set up on
the new machine and was wondering if I can just tar up certain
directories on the old machine, then untar them in the proper place on
the new machines, and have everything like it was, with all the tickets
in tact and such. If so, what directories would I want to
migrate? What might break when I do this? I know to add the aliases
and such but am not sure where rt has put stuff for mysql.

Thanks in advance,
Todd

rt-users mailing list
rt-users@lists.fsck.com
http://lists.fsck.com/mailman/listinfo/rt-users

jesse reed vincent – root@eruditorum.org – jesse@fsck.com
70EBAC90: 2A07 FC22 7DB4 42C1 9D71 0108 41A3 3FB3 70EB AC90

There are no supercomputer applications that are solvable that cannot be solved
in finite time using a fucking TRS-80 with approprite disk/tape drives. Zero.
-Tanj

4

Does the procedure below work also when the versions of WebRT are not
the same, i.e. if I have 1.0.1 on the old host and 1.0.6 on the new? I’m
using Debian GNU/Linux.

Jesse wrote:

This is a quick and dirty list of
the things that need to be done to move an RT1 instance from one host
to another are as follows:
Install RT on the new host.
On the old host:
mysqldump rt > rtdb
tar cvf transactions.tar rt/transactions

    copy those files to the new host.

    On the new host
      mysqladmin drop rt
      mysqladmin create rt
      mysql rt <rtdb
      cd /opt/rt; tar xvf transactions.tar

     on your rt install dir on the new host:
      make fixperms

Hi,

I’d like to move our rt to another machine. I have rt all set up on
the new machine and was wondering if I can just tar up certain
directories on the old machine, then untar them in the proper place on
the new machines, and have everything like it was, with all the tickets
in tact and such. If so, what directories would I want to
migrate? What might break when I do this? I know to add the aliases
and such but am not sure where rt has put stuff for mysql.

Thanks in advance,
Todd

rt-users mailing list
rt-users@lists.fsck.com
http://lists.fsck.com/mailman/listinfo/rt-users

–
jesse reed vincent – root@eruditorum.org – jesse@fsck.com
70EBAC90: 2A07 FC22 7DB4 42C1 9D71 0108 41A3 3FB3 70EB AC90

There are no supercomputer applications that are solvable that cannot be solved
in finite time using a fucking TRS-80 with approprite disk/tape drives. Zero.
-Tanj

rt-users mailing list
rt-users@lists.fsck.com
http://lists.fsck.com/mailman/listinfo/rt-users

Tapio Lehtonen tel: +358 9 4131 2206

Tellabs Oy fax: +358 9 4131 2030

Sinim�entie 6 email: Tapio.Lehtonen@Tellabs.COM

FIN-02630 ESPOO URL http://www.Tellabs.com/

Finland Senior Design Engineer

tapio.lehtonen.vcf (348 Bytes)

5

Hi,

I couldn’t speak to your 1.01 version but I think Jesse means those
instructions would work for any RT1 installation. Mine was from 1.04
to 1.07 and it worked fine. (Thanks Jesse!)

The only thing I’d add to his instructions was my first ticket
complained of not having the template files for the queues so I further
just tarred up my templates/queues from the old machine and plopped 'em
in the new one. I only did the queues I created, not the
_rt_system. Then I fixed the permissions on the queue templates
manually (wonder if putting those in the directory before running the
make fixperms would’ve taken care of that).

Then I ran a diff on my manipulate.pm files to see where I had modified
anything (font size on the web ui and mail content in the emails in my
case).

Seeya,
TJ

At 11:37 AM 2/8/2001 +0200, you wrote:

6

Ack. right. you want to move templates and config files too.
That’ll teach me not to write directions when feverish :confused:

    -jOn Thu, Feb 08, 2001 at 10:24:46AM -0600, Todd Jagger wrote:

Hi,

I couldn’t speak to your 1.01 version but I think Jesse means those
instructions would work for any RT1 installation. Mine was from 1.04
to 1.07 and it worked fine. (Thanks Jesse!)

The only thing I’d add to his instructions was my first ticket
complained of not having the template files for the queues so I further
just tarred up my templates/queues from the old machine and plopped 'em
in the new one. I only did the queues I created, not the
_rt_system. Then I fixed the permissions on the queue templates
manually (wonder if putting those in the directory before running the
make fixperms would’ve taken care of that).

Then I ran a diff on my manipulate.pm files to see where I had modified
anything (font size on the web ui and mail content in the emails in my
case).

Seeya,
TJ

At 11:37 AM 2/8/2001 +0200, you wrote:

Does the procedure below work also when the versions of WebRT are not
the same, i.e. if I have 1.0.1 on the old host and 1.0.6 on the new?
I’m
using Debian GNU/Linux.

Jesse wrote:

This is a quick and dirty list of
the things that need to be done to move an RT1 instance from one
host
to another are as follows:
Install RT on the new host.
On the old host:
mysqldump rt > rtdb
tar cvf transactions.tar rt/transactions

    copy those files to the new host.

    On the new host
      mysqladmin drop rt
      mysqladmin create rt
      mysql rt <rtdb
      cd /opt/rt; tar xvf transactions.tar

     on your rt install dir on the new host:
      make fixperms

On Tue, Feb 06, 2001 at 08:28:35PM -0600, Todd Jagger wrote:

Hi,

I’d like to move our rt to another machine. I have rt all set up
on
the new machine and was wondering if I can just tar up certain
directories on the old machine, then untar them in the proper
place on
the new machines, and have everything like it was, with all the
tickets
in tact and such. If so, what directories would I want to
migrate? What might break when I do this? I know to add the
aliases
and such but am not sure where rt has put stuff for mysql.

Thanks in advance,
Todd

rt-users mailing list
rt-users@lists.fsck.com
http://lists.fsck.com/mailman/listinfo/rt-users

–
jesse reed vincent – root@eruditorum.org – jesse@fsck.com
70EBAC90: 2A07 FC22 7DB4 42C1 9D71 0108 41A3 3FB3 70EB AC90

There are no supercomputer applications that are solvable that
cannot be solved
in finite time using a fucking TRS-80 with approprite disk/tape
drives. Zero.

 -Tanj

rt-users mailing list
rt-users@lists.fsck.com
http://lists.fsck.com/mailman/listinfo/rt-users

–

Tapio Lehtonen tel: +358 9 4131 2206

Tellabs Oy fax: +358 9 4131 2030

Sinimäentie 6 email: Tapio.Lehtonen@Tellabs.COM

FIN-02630 ESPOO URL http://www.Tellabs.com/

Finland Senior Design Engineer

====================================================================

rt-users mailing list
rt-users@lists.fsck.com
http://lists.fsck.com/mailman/listinfo/rt-users

jesse reed vincent – root@eruditorum.org – jesse@fsck.com
70EBAC90: 2A07 FC22 7DB4 42C1 9D71 0108 41A3 3FB3 70EB AC90

I have images of Marc in well worn combat fatigues, covered in mud,
sweat and blood, knife in one hand and PSION int he other, being
restrained by several other people, screaming “Let me at it!
Just let me at it!” Eichin standing calmly by with something
automated, milspec, and likely recoilless.
-xiphmont on opensource peer review