RT Migration

RT Users
1

I am migrating a RT environment onto a more powerful machine, and taking the
opportunity to upgrade the OS and RT version. Is there an may of moving the
historical data, queues, users etc. It is an mysql database on both
servers.

Thanx

	Mark

Mark J Hodge
mark.hodge@csf.co.uk
SP Program Manager Tel: +44
(0)870 7499292
CSF Solutions Ltd. Fax: +44
(0)870 7499290

This e-mail including any attachments is confidential and may be
legally privileged. If you have received it in error please advise the
sender immediately by return email and then delete it from your
system.
All electronic communications with the Company may be monitored
in accordance with the UK Regulation of Investigatory Powers Act,
Lawful Business Practice Regulations, 2000.
If you do not consent to such monitoring, you should contact
the sender of the e-mail.
The unauthorised use, distribution, copying or alteration of this
email is strictly forbidden. If you need assistance please contact
Head Office on (+44)(0)870 749 9000 between 9:00 am and 5:30 pm GMT

2

Mark Hodge wrote:

I am migrating a RT environment onto a more powerful machine, and
taking the opportunity to upgrade the OS and RT version. Is there an
may of moving the historical data, queues, users etc. It is an mysql
database on both servers.

I haven’t tried this, but I’d probably go for:

1 Install and configure version 2.0.13 on new server.

2 Remove (or rename) the (almost-empty) database.

3 Copy your existing database to the new server. Do appropriate
amounts of ‘MySQL’ flushing to get it recognized.

4 Run rt/etc/insertdata to upgrade the database from your previous
version to 2.0.13.

I can’t see why that wouldn’t work – so far as insertdata is concerned,
you are doing an upgrade.

Simon
GBdirect

3

A simple dump and import of the data will do:

/usr/local/mysql/bin/mysqldump -c -t -uroot -p rt2 >
rt2.sqldump
/usr/local/mysql/bin/mysqldump -d -uroot -p rt2 >
rt2.sqlschema

Replace the above path to mysqldump according to your path.

Then do:
mysql -uroot -p < rt2.sqldump

After you have installed RT!

Regards,
Ales
Ales Mustar
direktor
Opensource-Technologies
Ales Mustar s.p.On Fri, 10 May 2002, Mark Hodge wrote:

Date: Fri, 10 May 2002 10:57:44 +0100
From: Mark Hodge Mark.Hodge@csf.co.uk
To: “‘rt-users@lists.fsck.com’” rt-users@lists.fsck.com
Subject: [rt-users] RT Migration

I am migrating a RT environment onto a more powerful machine, and taking the
opportunity to upgrade the OS and RT version. Is there an may of moving the
historical data, queues, users etc. It is an mysql database on both
servers.

Thanx

  Mark

Mark J Hodge
mark.hodge@csf.co.uk
SP Program Manager Tel: +44
(0)870 7499292
CSF Solutions Ltd. Fax: +44
(0)870 7499290

This e-mail including any attachments is confidential and may be
legally privileged. If you have received it in error please advise the
sender immediately by return email and then delete it from your
system.
All electronic communications with the Company may be monitored
in accordance with the UK Regulation of Investigatory Powers Act,
Lawful Business Practice Regulations, 2000.
If you do not consent to such monitoring, you should contact
the sender of the e-mail.
The unauthorised use, distribution, copying or alteration of this
email is strictly forbidden. If you need assistance please contact
Head Office on (+44)(0)870 749 9000 between 9:00 am and 5:30 pm GMT

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

Have you read the FAQ? The RT FAQ Manager lives at http://fsck.com/rtfm

4

A simple dump and import of the data will do:

[snip]

Make sure you run
/path/to/rt/etc/insertdata <previous_rt_version>
otherwise you’ll miss some functionality - I
lost the NotifyOtherRecipients Scrip for a
couple of months that way

s

5

hello all,

I had a RT-Server (3.2.1) on a linux Server (suse 9.3). Now I will migrate RT to new Server with Suse 10.2. the database migration worked well. On the old Server the installtion path was /opt/rt3.

I have just copied this folder to my new server on suse 10.2. After that I can start the server and do some things with, but not all things worked properly.

Sometime I bekome errors like this:

error: Can’t call method “Scrips” on an undefined value at /opt/rt3/share/html/Ticket/Elements/PreviewScrips line 49.
context:
…
45:
46: my @non_recipients = $TicketObj->SquelchMailTo;
47: </%init>
48:

<&|/l&>This message will be sent to…</&>


49: <&|/l&>(Check boxes to disable notifications to the listed recipients)</&>

50: % foreach my $scrip (@{$Object->Scrips->Prepared}) {
51: % next unless $scrip->ActionObj->Action->isa(‘RT::Action::SendEmail’);
52: <%$scrip->Description%>

53: <&|/l, $scrip->ConditionObj->Name, $scrip->ActionObj->Name, $scrip->TemplateObj->Name&>[_1] [_2] with template [_3]</&>
…
code stack: /opt/rt3/share/html/Ticket/Elements/PreviewScrips:49
g /opt/rt3/local/html/Ticket/Update.html:113
g /opt/rt3/share/html/autohandler:199
g
raw error

thanks for any idea !!!

Doukkali

6

I suspect that new version is not RT 3.6.6 as something like that was
fixed in 3.6.2.On Thu, Jun 5, 2008 at 2:19 PM, Tariq Doukkali tariq.doukkali@autoform.de wrote:

hello all,

I had a RT-Server (3.2.1) on a linux Server (suse 9.3). Now I will migrate RT to new Server with Suse 10.2. the database migration worked well. On the old Server the installtion path was /opt/rt3.

I have just copied this folder to my new server on suse 10.2. After that I can start the server and do some things with, but not all things worked properly.

Sometime I bekome errors like this:

error: Can’t call method “Scrips” on an undefined value at /opt/rt3/share/html/Ticket/Elements/PreviewScrips line 49.
context:
…
45:
46: my @non_recipients = $TicketObj->SquelchMailTo;
47: </%init>
48:

<&|/l&>This message will be sent to…</&>


49: <&|/l&>(Check boxes to disable notifications to the listed recipients)</&>

50: % foreach my $scrip (@{$Object->Scrips->Prepared}) {
51: % next unless $scrip->ActionObj->Action->isa(‘RT::Action::SendEmail’);
52: <%$scrip->Description%>

53: <&|/l, $scrip->ConditionObj->Name, $scrip->ActionObj->Name, $scrip->TemplateObj->Name&>[_1] [_2] with template [_3]</&>
…
code stack: /opt/rt3/share/html/Ticket/Elements/PreviewScrips:49
g /opt/rt3/local/html/Ticket/Update.html:113
g /opt/rt3/share/html/autohandler:199
g
raw error

thanks for any idea !!!

Doukkali

The rt-users Archives

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

Best regards, Ruslan.