[rt-users] Re: Help - RT2.0.15 migration to 3.0.11 Failing
brianBOFH
kerrboy at gmail.com
Thu Jul 29 14:37:35 EDT 2004
I guess this is a dead end :)
Is there any way to move rt2 "metadata" to an rt3 schema without using
the provided scripts and or manual entry? Would paying for support
get me anywhere?
24081 root 25 0 1022M 842M 856 R 97.0 41.7 4:17 1
rt-2.0-to-dumpf
Thanks,
Brian
On Tue, 27 Jul 2004 08:45:45 -0400, brianBOFH <kerrboy at gmail.com> wrote:
> 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