RT2 to RT3 v1.7 problems

Cassidy_B_Larson · March 25, 2003, 10:40pm

OK, so I finally got a successful dump of my RT2 database after upgrading my
MySQL to version 4.0.12.

However, now when running the dumpfile-to-rt-3.0 file, I get through the
Importing of Users (10000 rows large mind you), then I get this:

…
…
Importing groups
[Tue Mar 25 22:23:18 2003] [crit]: 1 (/usr/local/rt3/lib/RT/ACE_Overlay.pm:884)
[Tue Mar 25 22:23:18 2003] [crit]: Can’t load a principal for id
(/usr/local/rt3/lib/RT/ACE_Overlay.pm:885)
[Tue Mar 25 22:23:58 2003] [crit]: Couldn’t load principal to grant them
SeeQueue on queue admin-talk
$VAR1 = {
‘PrincipalId’ => undef,
‘PrincipalType’ => ‘User’,
‘Name’ => ‘SeeQueue’
};
(/usr/local/rt3/lib/RT.pm:228)

I did initialize the rt3 database before I ran the dump-to-rt3 script.
Test Dependencies runs without any problems as well.

Running 3.0.0 release.
Perl v5.6.1
FreeBSD 4.7-STABLE
MySQL 4.0.12
apache 1.3.27 + mod_perl 1.27
Mason 1.18

Anybody experience the same in their importing?

–c

Jesse_Vincent · March 26, 2003, 5:40am

can you send us the ACL section of the admin-talk queue’s database dump?On Tue, Mar 25, 2003 at 03:40:00PM -0700, butch@infowest.com wrote:

OK, so I finally got a successful dump of my RT2 database after upgrading my
MySQL to version 4.0.12.

However, now when running the dumpfile-to-rt-3.0 file, I get through the
Importing of Users (10000 rows large mind you), then I get this:

…
…
Importing groups
[Tue Mar 25 22:23:18 2003] [crit]: 1 (/usr/local/rt3/lib/RT/ACE_Overlay.pm:884)
[Tue Mar 25 22:23:18 2003] [crit]: Can’t load a principal for id
(/usr/local/rt3/lib/RT/ACE_Overlay.pm:885)
[Tue Mar 25 22:23:58 2003] [crit]: Couldn’t load principal to grant them
SeeQueue on queue admin-talk
$VAR1 = {
‘PrincipalId’ => undef,
‘PrincipalType’ => ‘User’,
‘Name’ => ‘SeeQueue’
};
(/usr/local/rt3/lib/RT.pm:228)

I did initialize the rt3 database before I ran the dump-to-rt3 script.
Test Dependencies runs without any problems as well.

Running 3.0.0 release.
Perl v5.6.1
FreeBSD 4.7-STABLE
MySQL 4.0.12
apache 1.3.27 + mod_perl 1.27
Mason 1.18

Anybody experience the same in their importing?

–c

rt-devel mailing list
rt-devel@lists.fsck.com
http://lists.fsck.com/mailman/listinfo/rt-devel

Request Tracker... So much more than a help desk — Best Practical Solutions – Trouble Ticketing. Free.

Cassidy_B_Larson · March 26, 2003, 5:57am

Quoting Jesse Vincent jesse@bestpractical.com:

can you send us the ACL section of the admin-talk queue’s database dump?

Is this what you’re looking for? From the RT2 database, ACL table?

INSERT INTO ACL VALUES (851,5,‘Group’,‘CommentOnTicket’,‘Queue’,7);
INSERT INTO ACL VALUES (474,1,‘Group’,‘CreateTicket’,‘Queue’,7);
INSERT INTO ACL VALUES (475,7,‘User’,‘SeeQueue’,‘Queue’,7);
INSERT INTO ACL VALUES (476,7,‘User’,‘ShowTemplate’,‘Queue’,7);
INSERT INTO ACL VALUES (477,7,‘User’,‘ShowScrips’,‘Queue’,7);
INSERT INTO ACL VALUES (478,7,‘User’,‘ShowTicket’,‘Queue’,7);
INSERT INTO ACL VALUES (479,7,‘User’,‘ShowTicketComments’,‘Queue’,7);
INSERT INTO ACL VALUES (480,7,‘User’,‘CreateTicket’,‘Queue’,7);
INSERT INTO ACL VALUES (481,7,‘User’,‘ReplyToTicket’,‘Queue’,7);
INSERT INTO ACL VALUES (482,7,‘User’,‘CommentOnTicket’,‘Queue’,7);
INSERT INTO ACL VALUES (483,7,‘User’,‘OwnTicket’,‘Queue’,7);
INSERT INTO ACL VALUES (484,7,‘User’,‘ModifyTicket’,‘Queue’,7);
INSERT INTO ACL VALUES (485,7,‘User’,‘DeleteTicket’,‘Queue’,7);
INSERT INTO ACL VALUES (486,7,‘User’,‘ModifyACL’,‘Queue’,7);
INSERT INTO ACL VALUES (487,7,‘User’,‘ModifyQueueWatchers’,‘Queue’,7);
INSERT INTO ACL VALUES (488,7,‘User’,‘AdminKeywordSelects’,‘Queue’,7);
INSERT INTO ACL VALUES (489,7,‘User’,‘ModifyTemplate’,‘Queue’,7);
INSERT INTO ACL VALUES (490,7,‘User’,‘ModifyScrips’,‘Queue’,7);
INSERT INTO ACL VALUES (587,3,‘Group’,‘CommentOnTicket’,‘Queue’,7);
INSERT INTO ACL VALUES (588,3,‘Group’,‘ReplyToTicket’,‘Queue’,7);
INSERT INTO ACL VALUES (589,3,‘Group’,‘ShowTicket’,‘Queue’,7);
INSERT INTO ACL VALUES (852,5,‘Group’,‘CreateTicket’,‘Queue’,7);
INSERT INTO ACL VALUES (853,5,‘Group’,‘DeleteTicket’,‘Queue’,7);
INSERT INTO ACL VALUES (854,5,‘Group’,‘ModifyTicket’,‘Queue’,7);
INSERT INTO ACL VALUES (855,5,‘Group’,‘OwnTicket’,‘Queue’,7);
INSERT INTO ACL VALUES (856,5,‘Group’,‘ReplyToTicket’,‘Queue’,7);
INSERT INTO ACL VALUES (857,5,‘Group’,‘SeeQueue’,‘Queue’,7);
INSERT INTO ACL VALUES (858,5,‘Group’,‘ShowTemplate’,‘Queue’,7);
INSERT INTO ACL VALUES (859,5,‘Group’,‘ShowTicket’,‘Queue’,7);
INSERT INTO ACL VALUES (860,5,‘Group’,‘ShowTicketComments’,‘Queue’,7);
INSERT INTO ACL VALUES (861,5,‘Group’,‘Watch’,‘Queue’,7);
INSERT INTO ACL VALUES (862,5,‘Group’,‘WatchAsAdminCc’,‘Queue’,7);
INSERT INTO ACL VALUES (863,1,‘Group’,‘CommentOnTicket’,‘Queue’,7);
INSERT INTO ACL VALUES (864,1,‘Group’,‘ReplyToTicket’,‘Queue’,7);

Jesse_Vincent · March 26, 2003, 6:00am

I actually need to see what was in the database export generated by the
rt2 to rt3 import toolOn Tue, Mar 25, 2003 at 10:57:07PM -0700, butch@infowest.com wrote:

Quoting Jesse Vincent jesse@bestpractical.com:

can you send us the ACL section of the admin-talk queue’s database dump?

Is this what you’re looking for? From the RT2 database, ACL table?

INSERT INTO ACL VALUES (851,5,‘Group’,‘CommentOnTicket’,‘Queue’,7);
INSERT INTO ACL VALUES (474,1,‘Group’,‘CreateTicket’,‘Queue’,7);
INSERT INTO ACL VALUES (475,7,‘User’,‘SeeQueue’,‘Queue’,7);
INSERT INTO ACL VALUES (476,7,‘User’,‘ShowTemplate’,‘Queue’,7);
INSERT INTO ACL VALUES (477,7,‘User’,‘ShowScrips’,‘Queue’,7);
INSERT INTO ACL VALUES (478,7,‘User’,‘ShowTicket’,‘Queue’,7);
INSERT INTO ACL VALUES (479,7,‘User’,‘ShowTicketComments’,‘Queue’,7);
INSERT INTO ACL VALUES (480,7,‘User’,‘CreateTicket’,‘Queue’,7);
INSERT INTO ACL VALUES (481,7,‘User’,‘ReplyToTicket’,‘Queue’,7);
INSERT INTO ACL VALUES (482,7,‘User’,‘CommentOnTicket’,‘Queue’,7);
INSERT INTO ACL VALUES (483,7,‘User’,‘OwnTicket’,‘Queue’,7);
INSERT INTO ACL VALUES (484,7,‘User’,‘ModifyTicket’,‘Queue’,7);
INSERT INTO ACL VALUES (485,7,‘User’,‘DeleteTicket’,‘Queue’,7);
INSERT INTO ACL VALUES (486,7,‘User’,‘ModifyACL’,‘Queue’,7);
INSERT INTO ACL VALUES (487,7,‘User’,‘ModifyQueueWatchers’,‘Queue’,7);
INSERT INTO ACL VALUES (488,7,‘User’,‘AdminKeywordSelects’,‘Queue’,7);
INSERT INTO ACL VALUES (489,7,‘User’,‘ModifyTemplate’,‘Queue’,7);
INSERT INTO ACL VALUES (490,7,‘User’,‘ModifyScrips’,‘Queue’,7);
INSERT INTO ACL VALUES (587,3,‘Group’,‘CommentOnTicket’,‘Queue’,7);
INSERT INTO ACL VALUES (588,3,‘Group’,‘ReplyToTicket’,‘Queue’,7);
INSERT INTO ACL VALUES (589,3,‘Group’,‘ShowTicket’,‘Queue’,7);
INSERT INTO ACL VALUES (852,5,‘Group’,‘CreateTicket’,‘Queue’,7);
INSERT INTO ACL VALUES (853,5,‘Group’,‘DeleteTicket’,‘Queue’,7);
INSERT INTO ACL VALUES (854,5,‘Group’,‘ModifyTicket’,‘Queue’,7);
INSERT INTO ACL VALUES (855,5,‘Group’,‘OwnTicket’,‘Queue’,7);
INSERT INTO ACL VALUES (856,5,‘Group’,‘ReplyToTicket’,‘Queue’,7);
INSERT INTO ACL VALUES (857,5,‘Group’,‘SeeQueue’,‘Queue’,7);
INSERT INTO ACL VALUES (858,5,‘Group’,‘ShowTemplate’,‘Queue’,7);
INSERT INTO ACL VALUES (859,5,‘Group’,‘ShowTicket’,‘Queue’,7);
INSERT INTO ACL VALUES (860,5,‘Group’,‘ShowTicketComments’,‘Queue’,7);
INSERT INTO ACL VALUES (861,5,‘Group’,‘Watch’,‘Queue’,7);
INSERT INTO ACL VALUES (862,5,‘Group’,‘WatchAsAdminCc’,‘Queue’,7);
INSERT INTO ACL VALUES (863,1,‘Group’,‘CommentOnTicket’,‘Queue’,7);
INSERT INTO ACL VALUES (864,1,‘Group’,‘ReplyToTicket’,‘Queue’,7);

rt-devel mailing list
rt-devel@lists.fsck.com
http://lists.fsck.com/mailman/listinfo/rt-devel

Request Tracker... So much more than a help desk — Best Practical Solutions – Trouble Ticketing. Free.

Cassidy_B_Larson · March 26, 2003, 6:10am

Quoting Jesse Vincent jesse@bestpractical.com:

I actually need to see what was in the database export generated by the
rt2 to rt3 import tool

How about this? You’ll notice a couple of undef’s as PrincipalIds, which I
believe is where I’m running into the snag.

                   'Right' => [
                                  {
                                    'PrincipalId' => '7',
                                    'Name' => 'AdminQueue',
                                    'PrincipalType' => 'Group'
                                  },
                                  {
                                    'Role' => 'Requestor',
                                    'Name' => 'CommentOnTicket',
                                    'PrincipalType' => 'Group'
                                  },
                                  {
                                    'PrincipalId' => '6',
                                    'Name' => 'CommentOnTicket',
                                    'PrincipalType' => 'Group'
                                  },
                                  {
                                    'PrincipalId' => '7',
                                    'Name' => 'CommentOnTicket',
                                    'PrincipalType' => 'Group'
                                  },
                                  {
                                    'Role' => 'Everyone',
                                    'Name' => 'CreateTicket',
                                    'PrincipalType' => 'Group'
                                  },
                                  {
                                    'PrincipalId' => '6',
                                    'Name' => 'CreateTicket',
                                    'PrincipalType' => 'Group'
                                  },
                                  {
                                    'PrincipalId' => '7',
                                    'Name' => 'CreateTicket',
                                    'PrincipalType' => 'Group'
                                  },
                                  {
                                    'PrincipalId' => '8',
                                    'Name' => 'CreateTicket',
                                    'PrincipalType' => 'Group'
                                  },
                                  {
                                    'PrincipalId' => '7',
                                    'Name' => 'DeleteTicket',
                                    'PrincipalType' => 'Group'
                                  },
                                  {
                                    'PrincipalId' => '7',
                                    'Name' => 'ModifyTicket',
                                    'PrincipalType' => 'Group'
                                  },
                                  {
                                    'PrincipalId' => '6',
                                    'Name' => 'OwnTicket',
                                    'PrincipalType' => 'Group'
                                  },
                                  {
                                    'PrincipalId' => '7',
                                    'Name' => 'OwnTicket',
                                    'PrincipalType' => 'Group'
                                  },
                                  {
                                    'Role' => 'Requestor',
                                    'Name' => 'ReplyToTicket',
                                    'PrincipalType' => 'Group'
                                  },
                                  {
                                    'PrincipalId' => '6',
                                    'Name' => 'ReplyToTicket',
                                    'PrincipalType' => 'Group'
                                  },
                                  {
                                    'PrincipalId' => '7',
                                    'Name' => 'ReplyToTicket',
                                    'PrincipalType' => 'Group'
                                  },
                                  {
                                    'PrincipalId' => '8',
                                    'Name' => 'ReplyToTicket',
                                    'PrincipalType' => 'Group'
                                  },
                                  {
                                    'PrincipalId' => '7',
                                    'Name' => 'SeeQueue',
                                    'PrincipalType' => 'Group'
                                  },
                                 {
                                    'PrincipalId' => undef,
                                    'Name' => 'SeeQueue',
                                    'PrincipalType' => 'User'
                                  },
                                  {
                                    'PrincipalId' => '15',
                                    'Name' => 'SeeQueue',
                                    'PrincipalType' => 'User'
                                  },
                                  {
                                    'PrincipalId' => '1749',
                                    'Name' => 'SeeQueue',
                                    'PrincipalType' => 'User'
                                  },
                                  {
                                    'PrincipalId' => undef,
                                    'Name' => 'ShowScrips',
                                    'PrincipalType' => 'User'
                                  },
                                  {
                                    'PrincipalId' => undef,
                                    'Name' => 'ShowTemplate',
                                    'PrincipalType' => 'User'
                                  },
                                  {
                                    'Role' => 'Requestor',
                                    'Name' => 'ShowTicket',
                                    'PrincipalType' => 'Group'
                                  },
                                  {
                                    'PrincipalId' => '6',
                                    'Name' => 'ShowTicket',
                                    'PrincipalType' => 'Group'
                                  },
                                  {
                                    'PrincipalId' => '7',
                                    'Name' => 'ShowTicket',
                                    'PrincipalType' => 'Group'
                                  },
                                  {
                                    'PrincipalId' => '8',
                                    'Name' => 'ShowTicket',
                                    'PrincipalType' => 'Group'
                                  },
                                  { 
                                    'PrincipalId' => undef,
                                    'Name' => 'ShowTicket',
                                    'PrincipalType' => 'User'
                                  },
                                  { 
                                    'PrincipalId' => '7',
                                    'Name' => 'ShowTicketComments',
                                    'PrincipalType' => 'Group'     
                                  },
                                  { 
                                    'PrincipalId' => undef,
                                    'Name' => 'ShowTicketComments',
                                    'PrincipalType' => 'User'      
                                  },
                                  { 
                                    'PrincipalId' => '6',
                                    'Name' => 'Watch',   
                                    'PrincipalType' => 'Group'
                                  },
                                  { 
                                    'PrincipalId' => '7',
                                    'Name' => 'Watch',   
                                    'PrincipalType' => 'Group'
                                  },
                                  { 
                                    'PrincipalId' => '8',
                                    'Name' => 'Watch',   
                                    'PrincipalType' => 'Group'
                                  },
                                  { 
                                    'PrincipalId' => '7',
                                    'Name' => 'WatchAsAdminCc',
                                    'PrincipalType' => 'Group'
                                  }
                                ],

Jesse_Vincent · March 26, 2003, 6:14am

Indeed. that’s not right. did you manually delete users or groups from
your RT database?On Tue, Mar 25, 2003 at 11:10:32PM -0700, butch@infowest.com wrote:

Quoting Jesse Vincent jesse@bestpractical.com:

I actually need to see what was in the database export generated by the
rt2 to rt3 import tool

How about this? You’ll notice a couple of undef’s as PrincipalIds, which I
believe is where I’m running into the snag.

                   'Right' => [
                                  {
                                    'PrincipalId' => '7',
                                    'Name' => 'AdminQueue',
                                    'PrincipalType' => 'Group'
                                  },
                                  {
                                    'Role' => 'Requestor',
                                    'Name' => 'CommentOnTicket',
                                    'PrincipalType' => 'Group'
                                  },
                                  {
                                    'PrincipalId' => '6',
                                    'Name' => 'CommentOnTicket',
                                    'PrincipalType' => 'Group'
                                  },
                                  {
                                    'PrincipalId' => '7',
                                    'Name' => 'CommentOnTicket',
                                    'PrincipalType' => 'Group'
                                  },
                                  {
                                    'Role' => 'Everyone',
                                    'Name' => 'CreateTicket',
                                    'PrincipalType' => 'Group'
                                  },
                                  {
                                    'PrincipalId' => '6',
                                    'Name' => 'CreateTicket',
                                    'PrincipalType' => 'Group'
                                  },
                                  {
                                    'PrincipalId' => '7',
                                    'Name' => 'CreateTicket',
                                    'PrincipalType' => 'Group'
                                  },
                                  {
                                    'PrincipalId' => '8',
                                    'Name' => 'CreateTicket',
                                    'PrincipalType' => 'Group'
                                  },
                                  {
                                    'PrincipalId' => '7',
                                    'Name' => 'DeleteTicket',
                                    'PrincipalType' => 'Group'
                                  },
                                  {
                                    'PrincipalId' => '7',
                                    'Name' => 'ModifyTicket',
                                    'PrincipalType' => 'Group'
                                  },
                                  {
                                    'PrincipalId' => '6',
                                    'Name' => 'OwnTicket',
                                    'PrincipalType' => 'Group'
                                  },
                                  {
                                    'PrincipalId' => '7',
                                    'Name' => 'OwnTicket',
                                    'PrincipalType' => 'Group'
                                  },
                                  {
                                    'Role' => 'Requestor',
                                    'Name' => 'ReplyToTicket',
                                    'PrincipalType' => 'Group'
                                  },
                                  {
                                    'PrincipalId' => '6',
                                    'Name' => 'ReplyToTicket',
                                    'PrincipalType' => 'Group'
                                  },
                                  {
                                    'PrincipalId' => '7',
                                    'Name' => 'ReplyToTicket',
                                    'PrincipalType' => 'Group'
                                  },
                                  {
                                    'PrincipalId' => '8',
                                    'Name' => 'ReplyToTicket',
                                    'PrincipalType' => 'Group'
                                  },
                                  {
                                    'PrincipalId' => '7',
                                    'Name' => 'SeeQueue',
                                    'PrincipalType' => 'Group'
                                  },
                                 {
                                    'PrincipalId' => undef,
                                    'Name' => 'SeeQueue',
                                    'PrincipalType' => 'User'
                                  },
                                  {
                                    'PrincipalId' => '15',
                                    'Name' => 'SeeQueue',
                                    'PrincipalType' => 'User'
                                  },
                                  {
                                    'PrincipalId' => '1749',
                                    'Name' => 'SeeQueue',
                                    'PrincipalType' => 'User'
                                  },
                                  {
                                    'PrincipalId' => undef,
                                    'Name' => 'ShowScrips',
                                    'PrincipalType' => 'User'
                                  },
                                  {
                                    'PrincipalId' => undef,
                                    'Name' => 'ShowTemplate',
                                    'PrincipalType' => 'User'
                                  },
                                  {
                                    'Role' => 'Requestor',
                                    'Name' => 'ShowTicket',
                                    'PrincipalType' => 'Group'
                                  },
                                  {
                                    'PrincipalId' => '6',
                                    'Name' => 'ShowTicket',
                                    'PrincipalType' => 'Group'
                                  },
                                  {
                                    'PrincipalId' => '7',
                                    'Name' => 'ShowTicket',
                                    'PrincipalType' => 'Group'
                                  },
                                  {
                                    'PrincipalId' => '8',
                                    'Name' => 'ShowTicket',
                                    'PrincipalType' => 'Group'
                                  },
                                  { 
                                    'PrincipalId' => undef,
                                    'Name' => 'ShowTicket',
                                    'PrincipalType' => 'User'
                                  },
                                  { 
                                    'PrincipalId' => '7',
                                    'Name' => 'ShowTicketComments',
                                    'PrincipalType' => 'Group'     
                                  },
                                  { 
                                    'PrincipalId' => undef,
                                    'Name' => 'ShowTicketComments',
                                    'PrincipalType' => 'User'      
                                  },
                                  { 
                                    'PrincipalId' => '6',
                                    'Name' => 'Watch',   
                                    'PrincipalType' => 'Group'
                                  },
                                  { 
                                    'PrincipalId' => '7',
                                    'Name' => 'Watch',   
                                    'PrincipalType' => 'Group'
                                  },
                                  { 
                                    'PrincipalId' => '8',
                                    'Name' => 'Watch',   
                                    'PrincipalType' => 'Group'
                                  },
                                  { 
                                    'PrincipalId' => '7',
                                    'Name' => 'WatchAsAdminCc',
                                    'PrincipalType' => 'Group'
                                  }
                                ],

Request Tracker... So much more than a help desk — Best Practical Solutions – Trouble Ticketing. Free.

Cassidy_B_Larson · March 26, 2003, 6:18am

Quoting Jesse Vincent jesse@bestpractical.com:

Indeed. that’s not right. did you manually delete users or groups from
your RT database?

I dont believe I have ever manually deleted users or groups. I’ll do some
further checking, unless you have a better idea.

Jesse_Vincent · March 26, 2003, 6:21am

Quoting Jesse Vincent jesse@bestpractical.com:

Indeed. that’s not right. did you manually delete users or groups from
your RT database?

I dont believe I have ever manually deleted users or groups. I’ll do some
further checking, unless you have a better idea.

Have a look at the bit in the exporter where it creates the hash of acls
and see why it’s not putting in the principal id.

Request Tracker... So much more than a help desk — Best Practical Solutions – Trouble Ticketing. Free.

Cassidy_B_Larson · March 26, 2003, 6:47am

Have a look at the bit in the exporter where it creates the hash of acls
and see why it’s not putting in the principal id.

yes, I believe you were right on your previous comment. Someone had deleted an
early priv’d user and left over acl’s were causing the problem.

Perhaps a dependency check when building the acl hash to see if that principal
id still exists, otherwise skip it?

I’ll run another dump and see if I run into any more irks.

Vivek_Khera · March 26, 2003, 2:39pm

“JV” == Jesse Vincent jesse@bestpractical.com writes:

JV> Indeed. that’s not right. did you manually delete users or groups from
JV> your RT database?

Another good reason to have referential integrety checks in the DB
engine itself

Peter_Mikeska · March 27, 2003, 7:22am

Hi I read mesages about problrm with manualy deleted ids in dumpfile
from rt2, but not
found yet how to solve this, so i was thinking if I can get rid of it just
replace “undef” in principal line in dumpfile to someone else, its not
so much important to get all proper-id import
sorry for lama kinda question, im not perl programer ;))
thnx in advance

Miki