Migration from RT 2.0.15 to 3.0.11 using rt2-to-rt3-1.23 *failing*

Hi,

I’ve tried various versions of the rt2-to-rt3 export/import process
and always seem to hit the same snag. Exports using
rt-2.0-to-dumpfile are successful with no warnings. After
successfully installing 3.0 components and app(dependency check is
successful) I run a make initialize-database and verify I can login
successfully with generic credentials.

Sidenote: My 2.x database was the product of a 1.x system previously.

This is where the problem comes in. When I start the import using
dumpfile-to-rt-3.0, there are numerous errors.

After doing a make initialize-database:

[root@rt3 rt2-to-rt3-1.23]# ./dumpfile-to-rt-3.0 /u1/rt2_dump_20040623

import.txt 2&>1

[root@habanero rt2-to-rt3-1.23]# more 1
Importing users

Importing groups
gCouldn’t find user with RT2 userid 16 - not adding to AllRepsCouldn’t
find user with RT2 userid 27 - not adding to AllRepsCouldn’t find user
with RT2 userid 28 - not adding to AllRepsCouldn’t find user with RT2
userid 29 - not adding to AllRepsCouldn’t find user with RT2 userid 32

  • not adding to AllRepsCouldn’t find user with RT2 userid 35 - not
    adding to AllRepsCouldn’t find user with RT2 userid 36 - not adding to
    AllRepsCouldn’t find user with RT2 userid 39 - not adding to
    AllRepsCouldn’t find user with RT2 userid 40 - not adding to
    AllRepsCouldn’t find user with RT2 userid 42 - not adding to
    AllRepsCouldn’t find user with RT2 userid 55 - not adding to
    AllRepsCouldn’t find user with RT2 userid 1237 - not adding to
    AllRepsCouldn’t find user with RT2 userid 1537 - not adding to
    AllRepsCouldn’t find user with RT2 userid 1538 - not adding to
    AllRepsCouldn’t find user with RT2 userid 1539 - not adding to
    AllRepsCouldn’t find user with RT2 userid 1540 - not adding to
    AllRepsggCouldn’t find user with RT2 userid 5 - not adding to
    LeadsAdminCouldn’t find user with RT2 userid 8 - not adding to
    LeadsAdminCouldn’t find user with RT2 userid 14 - not adding to
    LeadsAdminCouldn’t find user with RT2 userid 56 - not adding to
    LeadsAdminCouldn’t find user with RT2 userid 899 - not adding to
    LeadsAdminCouldn’t find user with RT2 userid 1521 - not adding to
    LeadsAdmingrCouldn’t load principal to grant them CommentOnTicket
    globally
    $VAR1 = {
    ‘PrincipalType’ => ‘User’,
    ‘PrincipalId’ => ‘20’,
    ‘Name’ => ‘CommentOnTicket’
    };
    [Fri Jun 25 22:36:29 2004] [crit]: 1 (/opt/rt3/lib/RT/ACE_Overlay.pm:884)
    [Fri Jun 25 22:36:29 2004] [crit]: Can’t load a principal for id
    (/opt/rt3/lib/RT/ACE_Overlay.pm:885)
    rCouldn’t load principal to grant them ModifySelf globally
    $VAR1 = {
    ‘PrincipalType’ => ‘User’,
    ‘PrincipalId’ => ‘281984’,
    ‘Name’ => ‘ModifySelf’
    };
    [Fri Jun 25 22:36:29 2004] [crit]: 1 (/opt/rt3/lib/RT/ACE_Overlay.pm:884)
    [Fri Jun 25 22:36:29 2004] [crit]: Can’t load a principal for id
    (/opt/rt3/lib/RT/ACE_Overlay.pm:885)
    rCouldn’t load principal to grant them OwnTicket globally
    $VAR1 = {
    ‘PrincipalType’ => ‘User’,
    ‘PrincipalId’ => ‘20’,
    ‘Name’ => ‘OwnTicket’
    };
    [Fri Jun 25 22:36:29 2004] [crit]: 1 (/opt/rt3/lib/RT/ACE_Overlay.pm:884)
    [Fri Jun 25 22:36:29 2004] [crit]: Can’t load a principal for id
    (/opt/rt3/lib/RT/ACE_Overlay.pm:885)
    rCouldn’t load principal to grant them ReplyToTicket globally
    $VAR1 = {
    ‘PrincipalType’ => ‘User’,
    ‘PrincipalId’ => ‘20’,
    ‘Name’ => ‘ReplyToTicket’
    };
    [Fri Jun 25 22:36:29 2004] [crit]: 1 (/opt/rt3/lib/RT/ACE_Overlay.pm:884)
    [Fri Jun 25 22:36:29 2004] [crit]: Can’t load a principal for id
    (/opt/rt3/lib/RT/ACE_Overlay.pm:885)
    rCouldn’t load principal to grant them SeeQueue globally
    $VAR1 = {
    ‘PrincipalType’ => ‘User’,
    ‘PrincipalId’ => ‘20’,
    ‘Name’ => ‘SeeQueue’

And so on. Then the Ticket imports start, and those import without
any errors or warnings.

One more problem:

When the Users table is populated, there is barely any user info
transferred, including the password. Here is an example:

From the 3.x database:

mysql> select * from Users where Name = ‘bhouse’;

| id | Name | Password | Comments
|
Signature | EmailAddress | FreeformContactInfo |
Organization | RealName | NickName | Lang |
EmailEncoding | WebEncoding | ExternalContactInfoId |
ContactInfoSystem | ExternalAuthId | AuthSystem | Gecos | HomePhone |
WorkPhone | MobilePhone | PagerPhone | Address1 | Address2 | City |
State | Zip | Country | Timezone | PGPKey | Creator | Created
| LastUpdatedBy | LastUpdated |

| 164 | bhouse@domain.com | NO-PASSWORD | Autocreated when
added as a watcher
| NULL | bhouse@domain.com | NULL | NULL
| bhouse@domain.com | NULL | NULL | NULL | NULL
| NULL | NULL | NULL |
NULL | NULL | NULL | NULL | NULL | NULL
| NULL | NULL | NULL

From the 2.x database:

mysql> use rt2;
Database changed
mysql> select * from Users where Name=‘bhouse’;
| id | Name | Password | Comments | Signature | EmailAddress
| FreeformContactInfo | Organization | Privileged | RealName |
Nickname | Lang | EmailEncoding | WebEncoding | ExternalContactInfoId
| ContactInfoSystem | ExternalAuthId | AuthSystem | Gecos | HomePhone
| WorkPhone | MobilePhone | PagerPhone | Address1 | Address2 | City |
State | Zip | Country | Creator | Created | LastUpdatedBy
| LastUpdated | Disabled |
| 9 | bhouse | [SNIP password /SNIP] | | NULL |
bhouse@domain.com | NULL | NULL | 1 |
Carolyn House | NULL | NULL | NULL | NULL | NULL
| NULL | NULL | NULL |
chouse | NULL | | NULL | NULL | NULL |
NULL | NULL | NULL | NULL | NULL | 1 | 2002-09-22
18:35:08 | 5 | 2002-09-24 14:29:20 | 0 |
1 row in set (0.01)

Any help would be greatly appreciated.

Cheers,
Brian