Migration problems (rt 2.0.15 to rt 3.0...)

Hi,

I’m trying to migrate our RT installation from 2.0.15 on an old server to rt
3 on a new server. As someone else pointed out, I have to go to rt
3.0first, then move to
3.4.

I’m as far as reading the dumpfile back to rt 3 and get a problem with
unicode in the attachments. Here is an excerpt (including the actual
content):

.t-5045
Couldn’t create attachment
$VAR1 = {
‘Subject’ => ‘webhostlist.de http://webhostlist.de: Abgelaufene Angebote’,
‘ContentType’ => ‘text/plain’,
‘Headers’ => ‘Received: from alphastar.gocept.comhttp://alphastar.gocept.com(
alphastar.whq.gocept.com http://alphastar.whq.gocept.com
[10.1.1.1http://10.1.1.1])
by lisa.whq.gocept.com http://lisa.whq.gocept.com (8.12.3/8.12.3/Debian-
6.4) with ESMTP id h5T0Eu5Q011118 (version=TLSv1/SSLv3
cipher=EDH-RSA-DES-CBC3-SHA bits=168 verify=FAIL) for mail@gocept.com;
Sun, 29 Jun 2003 02:14:56 +0200
Received: from www2.webhostlist.de http://www2.webhostlist.de (
www.webhostlist.de http://www.webhostlist.de
[62.146.43.10http://62.146.43.10]
(may be forged)) by alphastar.gocept.com http://alphastar.gocept.com (
8.12.3/8.12.3/Debian-6.4) with ESMTP id h5T0ErbH022364 for mail@gocept.com;
Sun, 29 Jun 2003 02:14:54 +0200
Received: from www2.webhostlist.de http://www2.webhostlist.de (
localhost.localdomain [127.0.0.1 http://127.0.0.1]) by
www2.webhostlist.dehttp://www2.webhostlist.de(
8.12.9/8.12.9) with ESMTP id h5T0EktT020492 for mail@gocept.com; Sun, 29
Jun 2003 02:14:47 +0200
Received: (from nobody@localhost) by
www2.webhostlist.dehttp://www2.webhostlist.de(
8.12.9/8.12.9/Submit) id h5T0EjES020491; Sun, 29 Jun 2003 02:14:45 +0200
Message-Id: 200306290014.h5T0EjES020491@www2.webhostlist.deTo: mail@gocept.com
Subject: webhostlist.de http://webhostlist.de: Abgelaufene Angebote
From: WebHostlist hosting@mail.netscouts.de
’,
‘Creator’ => ‘506’,
‘Parent’ => ‘0’,
‘Created’ => ‘2003-06-29 00:14:56’,
‘id’ => ‘64’,
‘Content’ => 'Achtung!

Ihre eingetragenen Angebote sind abgelaufen und wurden nicht von Ihnen
bestätigt. Wir werden sie deshalb aus unserem Verzeichnis entfernen, es
sei denn Sie wünschen einen weiterhin bestehenden Eintrag bei uns.

Falls Sie weiter bei uns gelistet werden möchten, so sollten Sie innerhalb
der nächsten 5 Tage Ihr eingetragenen Angebote bestätigen. Sofern die
Angebotsdaten der folgenden Angebote gleichgeblieben sind, können Sie dies
jetzt innerhalb von 5 Sekunden bestätigen.

250 MB, eingetragen am 11.03.2003
75 MB, eingetragen am 11.03.2003
ZOPE-Account, eingetragen am 11.03.2003
ZOPE-Instanz, eingetragen am 11.03.2003

Um diese Angebote jetzt zu bestätigen klicken Sie bitte einfach auf
folgenden
Link:
http://www2.webhostlist.de/host/data/doconfirmall.php3?aid=893

Ihr WebHostlist Team

',
‘ContentEncoding’ => ‘none’,
‘TransactionId’ => ‘98’
};

ERROR: invalid byte sequence for encoding “UNICODE”: 0xe47469

I also made it ignore broken attachments for a while and it brought a lot of
errors, probably on every attachment.

Hints appreciated.

Christian

I was able to go from rt 2.0.13 straight to rt 3.4.4 using the
rt2-to-rt3 that’s in the subversion repository.

Dunno about your unicode problems.

–Andy

Christian Theune wrote:

I had this same problem when (well, I’m still in the process of importing my
rt2 install to rt3) importing-

I’m guessing you’re moving to a postgresql database?

I changed the “client-encoding” value in my postgresql.conf file to
"iso-8859-1"

–snip–

client_encoding = iso-8859-1

–snip–

and restarted postgresql, and I didnt’ see the error anymore.

I’m not sure if this is the best solution, like I say- I’m still in the
process.

Cheers,

MikeFrom: “Andy Moran” andy@wildbrain.com
To: “Christian Theune” theuni@gmail.com
Cc: “RT User Mailinglist” rt-users@lists.bestpractical.com
Sent: Monday, October 03, 2005 5:39 PM
Subject: Re: [rt-users] Migration problems (rt 2.0.15 to rt 3.0…)

I was able to go from rt 2.0.13 straight to rt 3.4.4 using the
rt2-to-rt3 that’s in the subversion repository.

Dunno about your unicode problems.

–Andy

Christian Theune wrote:

Hi,

I’m trying to migrate our RT installation from 2.0.15 on an old server
to rt 3 on a new server. As someone else pointed out, I have to go to rt
3.0 first, then move to 3.4.

I’m as far as reading the dumpfile back to rt 3 and get a problem with
unicode in the attachments. Here is an excerpt (including the actual
content):

===================================================================================
.t-5045
Couldn’t create attachment
$VAR1 = {
‘Subject’ => ‘webhostlist.de http://webhostlist.de:
Abgelaufene Angebote’,
‘ContentType’ => ‘text/plain’,
‘Headers’ => ‘Received: from alphastar.gocept.com
http://alphastar.gocept.com (alphastar.whq.gocept.com
http://alphastar.whq.gocept.com [MailScanner has detected a possible
fraud attempt from “10.1.1.1” claiming to be
10.1.1.1
http://10.1.1.1]) by lisa.whq.gocept.com http://lisa.whq.gocept.com
(8.12.3/8.12.3/Debian-6.4) with ESMTP id h5T0Eu5Q011118
(version=TLSv1/SSLv3 cipher=EDH-RSA-DES-CBC3-SHA bits=168 verify=FAIL)
for <mail@gocept.com mailto:mail@gocept.com>; Sun, 29 Jun 2003
02:14:56 +0200
Received: from www2.webhostlist.de http://www2.webhostlist.de
(www.webhostlist.de http://www.webhostlist.de [MailScanner has
detected a possible fraud attempt from “62.146.43.10” claiming to be

62.146.43.10 http://62.146.43.10] (may be forged)) by
alphastar.gocept.com http://alphastar.gocept.com
(8.12.3/8.12.3/Debian-6.4) with ESMTP id h5T0ErbH022364 for
<mail@gocept.com mailto:mail@gocept.com>; Sun, 29 Jun 2003 02:14:54
+0200
Received: from www2.webhostlist.de http://www2.webhostlist.de
(localhost.localdomain [MailScanner has detected a possible fraud
attempt from “127.0.0.1” claiming to be
127.0.0.1 http://127.0.0.1])
by www2.webhostlist.de http://www2.webhostlist.de (8.12.9/8.12.9) with
ESMTP id h5T0EktT020492 for <mail@gocept.com mailto:mail@gocept.com>;
Sun, 29 Jun 2003 02:14:47 +0200
Received: (from nobody@localhost) by www2.webhostlist.de
http://www2.webhostlist.de (8.12.9/8.12.9/Submit) id h5T0EjES020491;
Sun, 29 Jun 2003 02:14:45 +0200
Date: Sun, 29 Jun 2003 02:14:45 +0200
Message-Id: <200306290014.h5T0EjES020491@www2.webhostlist.de
mailto:200306290014.h5T0EjES020491@www2.webhostlist.de>
To: mail@gocept.com mailto:mail@gocept.com
Subject: webhostlist.de http://webhostlist.de: Abgelaufene Angebote
From: WebHostlist <hosting@mail.netscouts.de
mailto:hosting@mail.netscouts.de>
’,
‘Creator’ => ‘506’,
‘Parent’ => ‘0’,
‘Created’ => ‘2003-06-29 00:14:56’,
‘id’ => ‘64’,
‘Content’ => 'Achtung!

Ihre eingetragenen Angebote sind abgelaufen und wurden nicht von Ihnen
best�tigt. Wir werden sie deshalb aus unserem Verzeichnis entfernen, es
sei denn Sie w�nschen einen weiterhin bestehenden Eintrag bei uns.

Falls Sie weiter bei uns gelistet werden m�chten, so sollten Sie innerhalb
der n�chsten 5 Tage Ihr eingetragenen Angebote best�tigen. Sofern die
Angebotsdaten der folgenden Angebote gleichgeblieben sind, k�nnen Sie
dies jetzt innerhalb von 5 Sekunden best�tigen.

250 MB, eingetragen am 11.03.2003
75 MB, eingetragen am 11.03.2003
ZOPE-Account, eingetragen am 11.03.2003
ZOPE-Instanz, eingetragen am 11.03.2003

Um diese Angebote jetzt zu best�tigen klicken Sie bitte einfach auf
folgenden
Link:
http://www2.webhostlist.de/host/data/doconfirmall.php3?aid=893

Ihr WebHostlist Team

',
‘ContentEncoding’ => ‘none’,
‘TransactionId’ => ‘98’
};

ERROR: invalid byte sequence for encoding “UNICODE”: 0xe47469

I also made it ignore broken attachments for a while and it brought a
lot of errors, probably on every attachment.

Hints appreciated.

Christian



http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Be sure to check out the RT Wiki at http://wiki.bestpractical.com

Buy your copy of our new book, RT Essentials, today!

Download a free sample chapter from http://rtbook.bestpractical.com

http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Be sure to check out the RT Wiki at http://wiki.bestpractical.com

Buy your copy of our new book, RT Essentials, today!

Download a free sample chapter from http://rtbook.bestpractical.com