<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=utf-8">
<META NAME="Generator" CONTENT="MS Exchange Server version 6.5.6944.0">
<TITLE>RE: dumpfile-to-rt-3.0 choking on attachment</TITLE>
</HEAD>
<BODY>
<!-- Converted from text/plain format -->
<P><FONT SIZE=2>From below, I noticed that after running ./dumpfile-to-rt-3.0 the queues table has the same number of rows<BR>
on both Postgres databases (the rt2 box and the new rt3 box I'm trying to import into) BUT<BR>
no more than a few tickets are being created in the tickets table....below are some of the errors...<BR>
<BR>
I just inherited this project, it's great, it's Open Source, I'm just hoping there is an Open channel of information<BR>
on help with this :-)<BR>
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<BR>
ports, I added the diffs myself:<BR>
( it's late and I'm also exhausted, so I don't have the bug number...<BR>
--- lib/RT/Ticket_Overlay.pm Tue Nov 18 04:54:11 2003<BR>
+++ /opt/rt3/lib/RT/Ticket_Overlay.pm Thu Nov 20 20:13:14 2003<BR>
@@ -305,6 +305,7 @@<BR>
my $self = shift;<BR>
<BR>
my %args = ( id => undef,<BR>
+ EffectiveId => undef,<BR>
Queue => undef,<BR>
Requestor => undef,<BR>
Cc => undef,<BR>
@@ -521,7 +522,7 @@<BR>
}<BR>
<BR>
#Set the ticket's effective ID now that we've created it.<BR>
- my ( $val, $msg ) = $self->__Set( Field => 'EffectiveId', Value => $id );<BR>
+ my ( $val, $msg ) = $self->__Set( Field => 'EffectiveId', Value => $args{'EffectiveId'} || $id );<BR>
<BR>
unless ($val) {<BR>
$RT::Logger->crit("$self ->Create couldn't set EffectiveId: $msg\n");<BR>
<BR>
STILL it's no dice ...<BR>
<BR>
<BR>
Trying to upgrade from RT2 to RT3. I successfully exported RT2 using<BR>
rt-2.0-to-dumpfile.<BR>
(Using VERSION 1.23 of rt2-to-rt3-1.23)<BR>
RT2 is running on an RH8 box with Postgres 7.2<BR>
<BR>
RT2 is at 2.0.15 and RT3 is at rt-3-0-4<BR>
<BR>
I built another box with FreeBSD and built RT3, scp'd the dump over to<BR>
that box and ran<BR>
dumpfile-to-rt-3.0.<BR>
<BR>
After running ./dumpfile-to-rt-3.0 /tmp/dump<BR>
<BR>
<BR>
<BR>
Importing groups<BR>
gggggggggggggggggggggrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqImporting<BR>
tickets...t-17<BR>
.t-18<BR>
.t-19<BR>
Couldn't create attachment<BR>
$VAR1 = {<BR>
'Subject' => '',<BR>
'ContentType' => 'application/msword',<BR>
'Filename' => 'Script for testing the functionality of RT ticket 273.doc',<BR>
'Headers' => 'Content-Type: application/msword;<BR>
name="Script for testing the functionality of RT ticket 273.doc"<BR>
Content-Disposition: inline;<BR>
filename="Script for testing the functionality of RT ticket 273.doc"<BR>
Content-Transfer-Encoding: base64<BR>
',<BR>
'Creator' => '19',<BR>
'Parent' => '1133',<BR>
'Created' => '2003-01-22 00:53:13+00',<BR>
'ContentEncoding' => 'base64',<BR>
'id' => '1135',<BR>
'TransactionId' => '2420'<BR>
};<BR>
<BR>
ERROR: parser: unterminated quoted string at or near "'ÐÏࡱ?á" at<BR>
character 682<BR>
[Fri Jun 18 00:16:02 2004] [crit]: Died at ./dumpfile-to-rt-3.0 line 719.<BR>
(/usr/local/rt3/lib/RT.pm:242)<BR>
<BR>
<BR>
From the postgres log:<BR>
ERROR: parser: unterminated quoted string at or near "'ÐÏࡱ?á" at<BR>
character 682<BR>
LOG: recycled transaction log file 0000000000000000<BR>
<BR>
AFTER this error, a select on the users table in the RT3 database showed<BR>
all the users and a few of my users were able to login. I was able to<BR>
login as root as well. So all the user data from the user tables was<BR>
successfully imported :-)<BR>
<BR>
Upon logging in, I saw only 1 ticket (there are over 4,000).<BR>
<BR>
So dumpfile-to-rt-3.0 is choking per the error above.<BR>
<BR>
I'm hoping someone will help me with this.<BR>
<BR>
Here's more information I got after re-running dumpfile-to-rt-3.0<BR>
<BR>
Importing groups<BR>
gggggggggggggggggggggrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrqFailed<BR>
to create queue for$VAR1 = {<BR>
'LastUpdatedBy' => '192',<BR>
'Disabled' => '1',<BR>
'Created' => '2003-03-18 21:31:16+00',<BR>
'Creator' => '192',<BR>
'LastUpdated' => '2004-01-09 19:38:13+00',<BR>
'Name' => 'corp-web-bug'<BR>
};<BR>
qFailed to create queue for$VAR1 = {<BR>
'LastUpdatedBy' => '192',<BR>
'Disabled' => '1',<BR>
'Created' => '2003-03-18 21:31:00+00',<BR>
'Creator' => '192',<BR>
'LastUpdated' => '2004-01-09 19:38:24+00',<BR>
'Name' => 'corp-web-dev'<BR>
};<BR>
qFailed to create queue for$VAR1 = {<BR>
'LastUpdatedBy' => '192',<BR>
'Created' => '2002-11-14 23:59:32+00',<BR>
'Name' => 'dba-request',<BR>
'LastUpdated' => '2004-01-09 21:39:18+00',<BR>
'Creator' => '192'<BR>
};<BR>
Couldn't load principal to grant them CommentOnTicket on queue<BR>
$VAR1 = {<BR>
'PrincipalType' => 'Group',<BR>
'Role' => 'Owner',<BR>
'Name' => 'CommentOnTicket'<BR>
};<BR>
[Fri Jun 18 00:51:48 2004] [crit]: 1<BR>
(/usr/local/rt3/lib/RT/ACE_Overlay.pm:884)<BR>
[Fri Jun 18 00:51:48 2004] [crit]: Can't load a principal for id<BR>
(/usr/local/rt3/lib/RT/ACE_Overlay.pm:885)<BR>
Couldn't load principal to grant them CreateTicket on queue<BR>
$VAR1 = {<BR>
'PrincipalType' => 'Group',<BR>
'Role' => 'Owner',<BR>
'Name' => 'CreateTicket'<BR>
};<BR>
[Fri Jun 18 00:51:48 2004] [crit]: 1<BR>
(/usr/local/rt3/lib/RT/ACE_Overlay.pm:884)<BR>
[Fri Jun 18 00:51:48 2004] [crit]: Can't load a principal for id<BR>
(/usr/local/rt3/lib/RT/ACE_Overlay.pm:885)<BR>
Couldn't load principal to grant them ReplyToTicket on queue<BR>
$VAR1 = {<BR>
'PrincipalType' => 'Group',<BR>
'Role' => 'Owner',<BR>
'Name' => 'ReplyToTicket'<BR>
};<BR>
<BR>
<BR>
Thanks!<BR>
<BR>
--<BR>
Rob Joost<BR>
Unix Administrator<BR>
<BR>
KnowledgeNet<BR>
14624 N. Scottsdale Road, #300<BR>
Scottsdale, AZ 85254<BR>
Phone: (480) 315-4841<BR>
Cell: (602) 920-6113<BR>
Email: rob.joost@knowledgenet.com<BR>
Web: <<A HREF="http://www.knowledgenet.com/">http://www.knowledgenet.com/</A>><BR>
<BR>
Why KnowledgeNet? Listen and learn from top customers -- Cisco, US<BR>
Postal Service, and EMC, to name a few!<BR>
<<A HREF="http://www.knowledgenet.com/onlineevents/">http://www.knowledgenet.com/onlineevents/</A>><BR>
<BR>
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.<BR>
<BR>
<BR>
<BR>
<BR>
</FONT>
</P>
</BODY>
</HTML>