[rt-users] RE: dumpfile-to-rt-3.0 choking on attachment

Rob Joost rob.joost at knowledgenet.com
Fri Jun 18 03:06:17 EDT 2004


From below, I noticed that after running ./dumpfile-to-rt-3.0 the queues table has the same number of rows
on both Postgres databases (the rt2 box and the new rt3 box I'm trying to import into) BUT
no more than a few tickets are being created in the tickets table....below are some of the errors...

I just inherited this project, it's great, it's Open Source, I'm just hoping there is an Open channel of information
on help with this :-) 
since I'm running rt 3.0.4, I found a bug report which was integrated into a newer version of rt...since I'm trying to stick to FreeBSD
ports, I added the diffs myself:
( it's late and I'm also exhausted, so I don't have the bug number...
--- lib/RT/Ticket_Overlay.pm Tue Nov 18 04:54:11 2003
+++ /opt/rt3/lib/RT/Ticket_Overlay.pm Thu Nov 20 20:13:14 2003
@@ -305,6 +305,7 @@
my $self = shift;

my %args = ( id => undef,
+ EffectiveId => undef,
Queue => undef,
Requestor => undef,
Cc => undef,
@@ -521,7 +522,7 @@
}

#Set the ticket's effective ID now that we've created it.
- my ( $val, $msg ) = $self->__Set( Field => 'EffectiveId', Value => $id );
+ my ( $val, $msg ) = $self->__Set( Field => 'EffectiveId', Value => $args{'EffectiveId'} || $id );

unless ($val) {
$RT::Logger->crit("$self ->Create couldn't set EffectiveId: $msg\n");

STILL it's no dice ...


Trying to upgrade from RT2 to RT3. I successfully exported RT2 using 
rt-2.0-to-dumpfile.
(Using VERSION 1.23 of rt2-to-rt3-1.23)
RT2 is running on an RH8 box with Postgres 7.2

RT2 is at 2.0.15 and RT3 is at rt-3-0-4

I built another box with FreeBSD and built RT3, scp'd the dump over to 
that box and ran
dumpfile-to-rt-3.0.

After running ./dumpfile-to-rt-3.0 /tmp/dump



Importing groups
gggggggggggggggggggggrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqImporting 
tickets...t-17
.t-18
.t-19
Couldn't create attachment
$VAR1 = {
'Subject' => '',
'ContentType' => 'application/msword',
'Filename' => 'Script for testing the functionality of RT ticket 273.doc',
'Headers' => 'Content-Type: application/msword;
name="Script for testing the functionality of RT ticket 273.doc"
Content-Disposition: inline;
filename="Script for testing the functionality of RT ticket 273.doc"
Content-Transfer-Encoding: base64
',
'Creator' => '19',
'Parent' => '1133',
'Created' => '2003-01-22 00:53:13+00',
'ContentEncoding' => 'base64',
'id' => '1135',
'TransactionId' => '2420'
};

ERROR: parser: unterminated quoted string at or near "'ÐÏࡱ?á" at 
character 682
[Fri Jun 18 00:16:02 2004] [crit]: Died at ./dumpfile-to-rt-3.0 line 719.
(/usr/local/rt3/lib/RT.pm:242)


 From the postgres log:
ERROR: parser: unterminated quoted string at or near "'ÐÏࡱ?á" at 
character 682
LOG: recycled transaction log file 0000000000000000

AFTER this error, a select on the users table in the RT3 database showed 
all the users and a few of my users were able to login. I was able to 
login as root as well. So all the user data from the user tables was 
successfully imported :-)

Upon logging in, I saw only 1 ticket (there are over 4,000).

So dumpfile-to-rt-3.0 is choking per the error above.

I'm hoping someone will help me with this.

Here's more information I got after re-running dumpfile-to-rt-3.0

Importing groups
gggggggggggggggggggggrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrqFailed
to create queue for$VAR1 = {
          'LastUpdatedBy' => '192',
          'Disabled' => '1',
          'Created' => '2003-03-18 21:31:16+00',
          'Creator' => '192',
          'LastUpdated' => '2004-01-09 19:38:13+00',
          'Name' => 'corp-web-bug'
        };
qFailed to create queue for$VAR1 = {
          'LastUpdatedBy' => '192',
          'Disabled' => '1',
          'Created' => '2003-03-18 21:31:00+00',
          'Creator' => '192',
          'LastUpdated' => '2004-01-09 19:38:24+00',
          'Name' => 'corp-web-dev'
        };
qFailed to create queue for$VAR1 = {
          'LastUpdatedBy' => '192',
          'Created' => '2002-11-14 23:59:32+00',
          'Name' => 'dba-request',
          'LastUpdated' => '2004-01-09 21:39:18+00',
          'Creator' => '192'
        };
Couldn't load principal  to grant them CommentOnTicket on queue
$VAR1 = {
          'PrincipalType' => 'Group',
          'Role' => 'Owner',
          'Name' => 'CommentOnTicket'
        };
[Fri Jun 18 00:51:48 2004] [crit]: 1
(/usr/local/rt3/lib/RT/ACE_Overlay.pm:884)
[Fri Jun 18 00:51:48 2004] [crit]: Can't load a principal for id 
(/usr/local/rt3/lib/RT/ACE_Overlay.pm:885)
Couldn't load principal  to grant them CreateTicket on queue
$VAR1 = {
          'PrincipalType' => 'Group',
          'Role' => 'Owner',
          'Name' => 'CreateTicket'
        };
[Fri Jun 18 00:51:48 2004] [crit]: 1
(/usr/local/rt3/lib/RT/ACE_Overlay.pm:884)
[Fri Jun 18 00:51:48 2004] [crit]: Can't load a principal for id 
(/usr/local/rt3/lib/RT/ACE_Overlay.pm:885)
Couldn't load principal  to grant them ReplyToTicket on queue
$VAR1 = {
          'PrincipalType' => 'Group',
          'Role' => 'Owner',
          'Name' => 'ReplyToTicket'
        };


Thanks!

-- 
Rob Joost
Unix Administrator

KnowledgeNet
14624 N. Scottsdale Road, #300
Scottsdale, AZ  85254
Phone:   (480) 315-4841
Cell:    (602) 920-6113
Email: rob.joost at knowledgenet.com
Web:   <http://www.knowledgenet.com/>

Why KnowledgeNet? Listen and learn from top customers -- Cisco, US
Postal Service, and EMC, to name a few!
<http://www.knowledgenet.com/onlineevents/>

NOTICE: This communication may contain privileged or other confidential information. If you are not the intended recipient or believe that you may have received this communication in error, please reply to the sender indicating that fact and delete the copy you received. Thank you.





-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20040618/f8ad2f55/attachment.htm>


More information about the rt-users mailing list