Problem importing from rt2 mysql to rt3 postgres (v1.7 importer)

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

I currently am having a problem importing from rt2 mysql to rt3 postgres;
moving from mysql to mysql worked fine, but going from rt2 mysql to postgres
7.3.2 for rt3 resulted in this error:

Tue Mar 25 18:07:18 2003] [error]: Could not create a new user
(/usr/local/rt3/lib/RT/User_Overlay.pm:217)
Failed to create user for$VAR1 = {
‘Creator’ => ‘1’,
‘LastUpdated’ => ‘2002-12-09 02:42:41’,
‘Comments’ => ‘Autocreated on ticket submission’,
‘Name’ => ‘Nilo.LosBanos@asia.bigfoot.com’,
‘RealName’ => ‘Nilo Los Baños’,
‘LastUpdatedBy’ => ‘1’,
‘Created’ => ‘2002-12-09 02:42:41’,
‘EmailAddress’ => ‘Nilo.LosBanos@asia.bigfoot.com’
};

Not sure why this is happening; it doesn’t look like anything is different
from this user to the previous user; any ideas?

  • -Doug

Douglas E. Warner dwarner@ctinetworks.com Network Engineer
CTI/PAdotNET http://ctinetworks.com +1 717 975 9000
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.7 (GNU/Linux)

iD8DBQE+gJ0NJV36su0A0xIRAmeOAKCFLxI/6l1JZl37Kgoo0R5zWJMc4QCg2e1K
mz0xwFnwVk5f0P45dzHZxd4=
=/UQ3
-----END PGP SIGNATURE-----

-----BEGIN PGP SIGNED MESSAGE-----

On 25-Mar-2003, Douglas E. Warner wrote message “[rt-devel] problem importing
from rt2 mysql to rt3 postgres (v1.”

Not sure why this is happening; it doesn’t look like anything is different
from this user to the previous user; any ideas?

Haven’t see that particular error yet, although the postgres import is still
flakey.

First make sure you’re using the latest rt2-to-rt3 and the latest rt and take
another crack at it.

Andy Harrison
Great Works Internet
System Operations
ajharrison@gwi.net
RSA 1024 pgp key: http://www.nachoz.com/andy.pub

-----BEGIN PGP SIGNATURE-----
Version: PGP 6.5.8

iQCVAwUBPoCjT1PEkLgodAWVAQH1UQQAjsdiCPS+c8e5nr0VwLDcipndLCwtbQE/
xjsW6jd8f6RBExJIqafuvSi0/HWOu9bL8YDLqmDM5O9YCGEjpJl6dLO9b/SiubzJ
n+zTF9DX5HPl3H8vSkSb066mCXd16L7mPBazznrkFLQzzag71hqWC5FalT2K+LFq
IrK5WseeVS8=
=BS/i
-----END PGP SIGNATURE-----

To me, that looks like postgres is failing on the “interesting” real
name characters. I’d try chopping them out for the moment.On Tue, Mar 25, 2003 at 01:16:41PM -0500, Douglas E. Warner wrote:

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

I currently am having a problem importing from rt2 mysql to rt3 postgres;
moving from mysql to mysql worked fine, but going from rt2 mysql to postgres
7.3.2 for rt3 resulted in this error:

Tue Mar 25 18:07:18 2003] [error]: Could not create a new user
(/usr/local/rt3/lib/RT/User_Overlay.pm:217)
Failed to create user for$VAR1 = {
‘Creator’ => ‘1’,
‘LastUpdated’ => ‘2002-12-09 02:42:41’,
‘Comments’ => ‘Autocreated on ticket submission’,
‘Name’ => ‘Nilo.LosBanos@asia.bigfoot.com’,
‘RealName’ => ‘Nilo Los Ba�os’,
‘LastUpdatedBy’ => ‘1’,
‘Created’ => ‘2002-12-09 02:42:41’,
‘EmailAddress’ => ‘Nilo.LosBanos@asia.bigfoot.com’
};

Not sure why this is happening; it doesn’t look like anything is different
from this user to the previous user; any ideas?

  • -Doug

Douglas E. Warner dwarner@ctinetworks.com Network Engineer
CTI/PAdotNET http://ctinetworks.com +1 717 975 9000
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.7 (GNU/Linux)

iD8DBQE+gJ0NJV36su0A0xIRAmeOAKCFLxI/6l1JZl37Kgoo0R5zWJMc4QCg2e1K
mz0xwFnwVk5f0P45dzHZxd4=
=/UQ3
-----END PGP SIGNATURE-----


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

http://www.bestpractical.com/rt – Trouble Ticketing. Free.

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1On Tuesday 25 March 2003 13:46, Jesse Vincent wrote:

To me, that looks like postgres is failing on the “interesting” real
name characters. I’d try chopping them out for the moment.

Thanks for the tip. I replaced the character, and it proceeded past this
part.
Could another problem be that I’m not using Perl 5.8? I stuck with a RedHat
7.3 box due to the problems w/ Apache 2 on RedHat 8 (and, being a lazy admin,
didn’t want to compile everything). Just trying to help debug whether this
is a Perl or Postgres issue.

  • -Doug

Douglas E. Warner dwarner@ctinetworks.com Network Engineer
CTI/PAdotNET http://ctinetworks.com +1 717 975 9000
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.7 (GNU/Linux)

iD8DBQE+gKvUJV36su0A0xIRAkzeAKC9yIOe/55yGk1iiWFW1y/vHyk8TQCfeHXg
wVtx6yWQ4l+OEpDupoGUC6M=
=wJvQ
-----END PGP SIGNATURE-----