[rt-users] Migration from RT 2.0.15 to 3.0.11 using rt2-to-rt3-1.23 *failing*

[brianBOFH]

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 at rt3 rt2-to-rt3-1.23]# ./dumpfile-to-rt-3.0 /u1/rt2_dump_20040623
> import.txt 2&>1

[root at 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 at domain.com      | *NO-PASSWORD* | Autocreated when
added as a watcher
| NULL      | bhouse at domain.com      | NULL                | NULL
  | bhouse at 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 at 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