[rt-users] Help - RT2.0.15 migration to 3.0.11 Failing
brianBOFH
kerrboy at gmail.com
Tue Jul 27 08:45:45 EDT 2004
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_20040723
> 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...Jesse? :)
Cheers,
Brian
More information about the rt-users
mailing list