[rt-users] Migration problems (rt 2.0.15 to rt 3.0...)

Mon Oct 3 20:39:51 EDT 2005

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,

Mike

----- Original Message ----- 
From: "Andy Moran" <andy at wildbrain.com>
To: "Christian Theune" <theuni at gmail.com>
Cc: "RT User Mailinglist" <rt-users at 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 at gocept.com <mailto:mail at 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 at gocept.com <mailto:mail at 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 at gocept.com <mailto:mail at gocept.com>>;
> Sun, 29 Jun 2003 02:14:47 +0200
> Received: (from nobody at 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 at www2.webhostlist.de
> <mailto:200306290014.h5T0EjES020491 at www2.webhostlist.de>>
> To: mail at gocept.com <mailto:mail at gocept.com>
> Subject: webhostlist.de <http://webhostlist.de>: Abgelaufene Angebote
> From: WebHostlist <hosting at mail.netscouts.de
> <mailto:hosting at 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 