[Rt-devel] dumpfile-to-rt-3.0 fails (rt2-to-rt3-1.23) "Could not create a new user"

[Jodok Ole Muellers]

Hi,

It is my task to migrate RT 1.0.1. from an old host to RT 3.4.1 on a new host.
Therefore I dumped the rt1 mysql database on the oldhost and copied it together with the transactions
to the newhost. On newhost i impored the rt1 mysql dump and after installing rt2 i ran import-1.0-to-2.0.
=> rt-2-0-15 runs well now.

I installed rt-3.4.1 fine as well.
To import the rt2 data into rt3 a did this:

mysql> drop database rt3;
shell> /prod/rt/perl/bin/perl /prod/rt/rt3/sbin/rt-setup-database -action init --dba root --prompt-for-dba-password

Then I have had no problems while running rt-2.0-to-dumpfile.
But when I ran "dumpfile-to-rt-3.0 dumpdir" I got this kind of errors:

Importing users
uCreating user Unnamed user 20408
.[Tue Feb 22 14:01:32 2005] [error]: Could not create a new user -  (/prod/rt/rt3/lib/RT/User_Overlay.pm:267)
Failed to create user for$VAR1 = {
          'CryptedPassword' => undef,
          'Name' => 'Unnamed user 20408'
        };
uCreating user Unnamed user 4805
.[Tue Feb 22 14:01:32 2005] [error]: Could not create a new user -  (/prod/rt/rt3/lib/RT/User_Overlay.pm:267)
Failed to create user for$VAR1 = {
          'CryptedPassword' => undef,
          'Name' => 'Unnamed user 4805'
        };


This type of error repeats about  26006 times

...


rCouldn't load principal  to grant them SuperUser globally
$VAR1 = {
          'PrincipalType' => 'User',
          'PrincipalId' => '1',
          'Name' => 'SuperUser'
        };
[Tue Feb 22 14:39:25 2005] [crit]: 1 (/prod/rt/rt3/lib/RT/ACE_Overlay.pm:915)
[Tue Feb 22 14:39:25 2005] [crit]: Can't load a principal for id  (/prod/rt/rt3/lib/RT/ACE_Overlay.pm:916)
rCouldn't load principal  to grant them SuperUser globally
$VAR1 = {
          'PrincipalType' => 'User',
          'PrincipalId' => '2',
          'Name' => 'SuperUser'
        };
[Tue Feb 22 14:39:25 2005] [crit]: 1 (/prod/rt/rt3/lib/RT/ACE_Overlay.pm:915)
[Tue Feb 22 14:39:25 2005] [crit]: Can't load a principal for id  (/prod/rt/rt3/lib/RT/ACE_Overlay.pm:916)
r[Tue Feb 22 14:39:25 2005] [crit]: 1 (/prod/rt/rt3/lib/RT/ACE_Overlay.pm:915)
[Tue Feb 22 14:39:25 2005] [crit]: Can't load a principal for id  (/prod/rt/rt3/lib/RT/ACE_Overlay.pm:916)
rCouldn't load principal  to grant them SuperUser globally
$VAR1 = {
          'PrincipalType' => 'User',
          'PrincipalId' => '4',
          'Name' => 'SuperUser'
        };

...

The resulting rt3 database does only contain a few users in the Users table
and no data in the Ticket table.

I have got no clue how to solve this problem nor what might
be the cause. Any ideas why this fails? 
Please let me know if you need to know further details.

details:

oldhost
=======
Request Tracker version 1.0.1. whith about 37375 tickets 

perl v5.6.1

Your MySQL connection id is 375 to server version: 3.22.29
mysql  Ver 11.18 Distrib 3.23.56, for sun-solaris2.8 (sparc)

newhost
=======
Request Tracker version 3.4.1 and 2.0.15 for migration of rt1 data

perl v5.8.5

Your MySQL connection id is 382 to server version: 4.1.7
mysql  Ver 14.7 Distrib 4.1.7, for sun-solaris2.8 (sparc)

-- 
Jodok Ole Muellers
Internet Software Systems Engineer
UUNet/MCI EMEA Server & Service Management