[rt-users] rt2.0.15 PostgreSQL to rt3.4.0 MySQL

Millard, Matt Millard.Matt at principal.com
Thu Feb 3 14:25:27 EST 2005


One last reply, hopefully.  Import is working with tickets dumped using 1.23 not 1.21.  Ran into another problem with max_allowed_packet error on MySQL, but I think I've got that worked out by editting my.cnf.

Matt

-----Original Message-----
From: rt-users-bounces at lists.bestpractical.com
[mailto:rt-users-bounces at lists.bestpractical.com]On Behalf Of Millard,
Matt
Sent: Thursday, February 03, 2005 10:55 AM
To: rt-users at lists.bestpractical.com
Subject: RE: [rt-users] rt2.0.15 PostgreSQL to rt3.4.0 MySQL


To reply to myself with an update on what I've tried...

I've also tried installing 3.2.2 and running the dumpfile-to-rt3 again with the same results.
I did notice that the original dump that I'm trying to load was done using rt2-to-rt3-1.21 and not 1.23 that I'm trying to use to load it.  I'm redumping with 1.23 to see if that makes a difference.

Matt

-----Original Message-----
From: rt-users-bounces at lists.bestpractical.com
[mailto:rt-users-bounces at lists.bestpractical.com]On Behalf Of Millard,
Matt
Sent: Wednesday, February 02, 2005 3:27 PM
To: rt-users at lists.bestpractical.com
Subject: [rt-users] rt2.0.15 PostgreSQL to rt3.4.0 MySQL


Trying to go from rt2.0.15 PostgreSQL to rt3.4.0 MySQL and I'm getting some errors when I try and load the dump created by rt2-to-dumpfile with dumpfile-to-rt3.  Any ideas as to what's going on?

Original Server: rt2.0.15, Red Hat Linux 7.3, Perl 5.6.1, Postgresql 7.2.4 (Dual PII-266MHz, 190MB memory, 8000 tickets)
New Server: rt3.4.0, Red Hat Enterprise Linux, Perl 5.8.6, MySQL 4.1.9 (Dual Xeon 3.4GHz, 4GB memory)

[root at ul174 rt2-to-rt3-1.23]# ./dumpfile-to-rt-3.0 /rt
Use of uninitialized value in concatenation (.) or string at /rt/rt3.4/etc/RT_SiteConfig.pm line 56.
Use of uninitialized value in concatenation (.) or string at /rt/rt3.4/etc/RT_SiteConfig.pm line 60.
Importing users
uCreating user joe.blow at principal.com
.uCreating user joe.blow at prinicpal.com
.
.
.
Importing groups
grrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrfffffqqqqqqqqqqImporting ticketsImporting links
l[Wed Feb  2 21:11:57 2005] [crit]: RT::Ticket=HASH(0x9ef3bfc) tried to load a bogus ticket: 34
 (/rt/rt3.4/lib/RT/Ticket_Overlay.pm:257)
l[Wed Feb  2 21:11:57 2005] [crit]: RT::Ticket=HASH(0x9ef5dd8) tried to load a bogus ticket: 254
 (/rt/rt3.4/lib/RT/Ticket_Overlay.pm:257)
l[Wed Feb  2 21:11:57 2005] [crit]: RT::Ticket=HASH(0x9ee0954) tried to load a bogus ticket: 385
 (/rt/rt3.4/lib/RT/Ticket_Overlay.pm:257)
l[Wed Feb  2 21:11:57 2005] [crit]: RT::Ticket=HASH(0x9eeb324) tried to load a bogus ticket: 385
 (/rt/rt3.4/lib/RT/Ticket_Overlay.pm:257)
l[Wed Feb  2 21:11:57 2005] [crit]: RT::Ticket=HASH(0x9ef5e38) tried to load a bogus ticket: 386
 (/rt/rt3.4/lib/RT/Ticket_Overlay.pm:257)
l[Wed Feb  2 21:11:57 2005] [crit]: RT::Ticket=HASH(0x9eed4a8) tried to load a bogus ticket: 386
 (/rt/rt3.4/lib/RT/Ticket_Overlay.pm:257)
l[Wed Feb  2 21:11:58 2005] [crit]: RT::Ticket=HASH(0x9eeb39c) tried to load a bogus ticket: 390
 (/rt/rt3.4/lib/RT/Ticket_Overlay.pm:257)
l[Wed Feb  2 21:11:58 2005] [crit]: RT::Ticket=HASH(0x9ee7378) tried to load a bogus ticket: 157
 (/rt/rt3.4/lib/RT/Ticket_Overlay.pm:257)
l[Wed Feb  2 21:11:58 2005] [crit]: RT::Ticket=HASH(0x9ede988) tried to load a bogus ticket: 391
 (/rt/rt3.4/lib/RT/Ticket_Overlay.pm:257)
l[Wed Feb  2 21:11:58 2005] [crit]: RT::Ticket=HASH(0x9ef5dd8) tried to load a bogus ticket: 392
 (/rt/rt3.4/lib/RT/Ticket_Overlay.pm:257)
l[Wed Feb  2 21:11:58 2005] [crit]: RT::Ticket=HASH(0x9ede7f0) tried to load a bogus ticket: 491
 (/rt/rt3.4/lib/RT/Ticket_Overlay.pm:257)
l[Wed Feb  2 21:11:58 2005] [crit]: RT::Ticket=HASH(0x9eed538) tried to load a bogus ticket: 684
 (/rt/rt3.4/lib/RT/Ticket_Overlay.pm:257)
l[Wed Feb  2 21:11:58 2005] [crit]: RT::Ticket=HASH(0x9ef3bfc) tried to load a bogus ticket: 746
 (/rt/rt3.4/lib/RT/Ticket_Overlay.pm:257)
l[Wed Feb  2 21:11:58 2005] [crit]: RT::Ticket=HASH(0x9eef6d0) tried to load a bogus ticket: 777
 (/rt/rt3.4/lib/RT/Ticket_Overlay.pm:257)
l[Wed Feb  2 21:11:58 2005] [crit]: RT::Ticket=HASH(0x9ee72b8) tried to load a bogus ticket: 849
 (/rt/rt3.4/lib/RT/Ticket_Overlay.pm:257)
l[Wed Feb  2 21:11:58 2005] [crit]: RT::Ticket=HASH(0x9ee9444) tried to load a bogus ticket: 850
 (/rt/rt3.4/lib/RT/Ticket_Overlay.pm:257)
l[Wed Feb  2 21:11:58 2005] [crit]: RT::Ticket=HASH(0x9ede988) tried to load a bogus ticket: 899
 (/rt/rt3.4/lib/RT/Ticket_Overlay.pm:257)
l[Wed Feb  2 21:11:58 2005] [crit]: RT::Ticket=HASH(0x9eed490) tried to load a bogus ticket: 926
 (/rt/rt3.4/lib/RT/Ticket_Overlay.pm:257)
l[Wed Feb  2 21:11:59 2005] [crit]: RT::Ticket=HASH(0x9ede9dc) tried to load a bogus ticket: 1017
 (/rt/rt3.4/lib/RT/Ticket_Overlay.pm:257)
l[Wed Feb  2 21:11:59 2005] [crit]: RT::Ticket=HASH(0x9f424c0) tried to load a bogus ticket: 1149
 (/rt/rt3.4/lib/RT/Ticket_Overlay.pm:257)
l[Wed Feb  2 21:11:59 2005] [crit]: RT::Ticket=HASH(0x9eeb150) tried to load a bogus ticket: 1184
 (/rt/rt3.4/lib/RT/Ticket_Overlay.pm:257)
l[Wed Feb  2 21:11:59 2005] [crit]: RT::Ticket=HASH(0x9ede8ec) tried to load a bogus ticket: 1320
 (/rt/rt3.4/lib/RT/Ticket_Overlay.pm:257)
l[Wed Feb  2 21:11:59 2005] [crit]: RT::Ticket=HASH(0x9edea84) tried to load a bogus ticket: 1655
 (/rt/rt3.4/lib/RT/Ticket_Overlay.pm:257)
l[Wed Feb  2 21:11:59 2005] [crit]: RT::Ticket=HASH(0x9eef634) tried to load a bogus ticket: 2092
 (/rt/rt3.4/lib/RT/Ticket_Overlay.pm:257)
l[Wed Feb  2 21:11:59 2005] [crit]: RT::Ticket=HASH(0x9ee0954) tried to load a bogus ticket: 2245
 (/rt/rt3.4/lib/RT/Ticket_Overlay.pm:257)
l[Wed Feb  2 21:11:59 2005] [crit]: RT::Ticket=HASH(0x9eed4c0) tried to load a bogus ticket: 2343
 (/rt/rt3.4/lib/RT/Ticket_Overlay.pm:257)
l[Wed Feb  2 21:11:59 2005] [crit]: RT::Ticket=HASH(0x9ede970) tried to load a bogus ticket: 2353
 (/rt/rt3.4/lib/RT/Ticket_Overlay.pm:257)
l[Wed Feb  2 21:11:59 2005] [crit]: RT::Ticket=HASH(0x9ee72b8) tried to load a bogus ticket: 1684
 (/rt/rt3.4/lib/RT/Ticket_Overlay.pm:257)
l[Wed Feb  2 21:11:59 2005] [crit]: RT::Ticket=HASH(0x9ee9444) tried to load a bogus ticket: 2485
 (/rt/rt3.4/lib/RT/Ticket_Overlay.pm:257)
l[Wed Feb  2 21:11:59 2005] [crit]: RT::Ticket=HASH(0x9ee099c) tried to load a bogus ticket: 2485
 (/rt/rt3.4/lib/RT/Ticket_Overlay.pm:257)
l[Wed Feb  2 21:11:59 2005] [crit]: RT::Ticket=HASH(0x9ee9378) tried to load a bogus ticket: 2732
 (/rt/rt3.4/lib/RT/Ticket_Overlay.pm:257)
l[Wed Feb  2 21:11:59 2005] [crit]: RT::Ticket=HASH(0x9f412c0) tried to load a bogus ticket: 2731
 (/rt/rt3.4/lib/RT/Ticket_Overlay.pm:257)
l[Wed Feb  2 21:12:00 2005] [crit]: RT::Ticket=HASH(0x9ede874) tried to load a bogus ticket: 2728
 (/rt/rt3.4/lib/RT/Ticket_Overlay.pm:257)
l[Wed Feb  2 21:12:00 2005] [crit]: RT::Ticket=HASH(0x9ede97c) tried to load a bogus ticket: 2752
 (/rt/rt3.4/lib/RT/Ticket_Overlay.pm:257)

Could not create scrip: On Correspond Notify Owner With Attach with template Correspondence in queue0 -- $VAR1 = {
          'ScripCondition' => 'On Correspond',
          'ScripAction' => 'Notify Owner With Attach',
          'Queue' => '0',
          'Template' => 'Correspondence',
          'Description' => 'Imported from RT 2.0'
        };

 - may be due to a non-standard template, condition or action

Could not create scrip: On Correspond Notify Requestors, Ccs and AdminCcs With Attach with template Correspondence in queue #0
 - may be due to a non-standard template, condition or action

Could not create scrip: On Create Autoreply To Requestors with template Matt Autoreply in queue #6
 - may be due to a non-standard template, condition or action

Could not create scrip: On Create Autoreply To Requestors with template Midrange Auto Response in queue #7
 - may be due to a non-standard template, condition or action

Could not create scrip: On Owner Change Notify Owner with template Assigned in queue #7
 - may be due to a non-standard template, condition or action

Could not create scrip: On Ticket Pickup Open Ticket with template blank in queue #7
 - may be due to a non-standard template, condition or action

Could not create scrip: On Owner Change Open Ticket with template blank in queue #7
 - may be due to a non-standard template, condition or action

Could not create scrip: On Create Autoreply To Requestors with template Quote  Autoreply in queue #9
 - may be due to a non-standard template, condition or action

Could not create scrip: On Create Autoreply To Requestors with template To Do  Reply in queue #10
 - may be due to a non-standard template, condition or action
Couldn't create link  from fsck.com-rt:/ticket/254 to fsck.com-rt:/ticket/270
Couldn't create link  from fsck.com-rt:/ticket/385 to fsck.com-rt:/ticket/57
Couldn't create link  from fsck.com-rt:/ticket/386 to fsck.com-rt:/ticket/57
Couldn't create link  from fsck.com-rt:/ticket/390 to fsck.com-rt:/ticket/57
Couldn't create link  from fsck.com-rt:/ticket/157 to fsck.com-rt:/ticket/390
Couldn't create link  from fsck.com-rt:/ticket/391 to fsck.com-rt:/ticket/57
Couldn't create link  from fsck.com-rt:/ticket/392 to fsck.com-rt:/ticket/57
Couldn't create link  from fsck.com-rt:/ticket/777 to fsck.com-rt:/ticket/391
Couldn't create link  from fsck.com-rt:/ticket/849 to fsck.com-rt:/ticket/392
Couldn't create link  from fsck.com-rt:/ticket/850 to fsck.com-rt:/ticket/385
Couldn't create link  from fsck.com-rt:/ticket/2485 to fsck.com-rt:/ticket/158


-----Message Disclaimer-----

This e-mail message is intended only for the use of the individual or
entity to which it is addressed, and may contain information that is
privileged, confidential and exempt from disclosure under applicable law.
If you are not the intended recipient, any dissemination, distribution or
copying of this communication is strictly prohibited. If you have
received this communication in error, please notify us immediately by
reply email to Connect at principal.com and delete or destroy all copies of
the original message and attachments thereto. Email sent to or from the
Principal Financial Group or any of its member companies may be retained
as required by law or regulation.

Nothing in this message is intended to constitute an Electronic signature
for purposes of the Uniform Electronic Transactions Act (UETA) or the
Electronic Signatures in Global and National Commerce Act ("E-Sign")
unless a specific statement to the contrary is included in this message.
_______________________________________________
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

RT Administrator and Developer training is coming to your town soon! (Boston, San Francisco, Austin, Sydney) Contact training at bestpractical.com for details.

Be sure to check out the RT Wiki at http://wiki.bestpractical.com


-----Message Disclaimer-----

This e-mail message is intended only for the use of the individual or
entity to which it is addressed, and may contain information that is
privileged, confidential and exempt from disclosure under applicable law.
If you are not the intended recipient, any dissemination, distribution or
copying of this communication is strictly prohibited. If you have
received this communication in error, please notify us immediately by
reply email to Connect at principal.com and delete or destroy all copies of
the original message and attachments thereto. Email sent to or from the
Principal Financial Group or any of its member companies may be retained
as required by law or regulation.

Nothing in this message is intended to constitute an Electronic signature
for purposes of the Uniform Electronic Transactions Act (UETA) or the
Electronic Signatures in Global and National Commerce Act ("E-Sign")
unless a specific statement to the contrary is included in this message.
_______________________________________________
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

RT Administrator and Developer training is coming to your town soon! (Boston, San Francisco, Austin, Sydney) Contact training at bestpractical.com for details.

Be sure to check out the RT Wiki at http://wiki.bestpractical.com


-----Message Disclaimer-----

This e-mail message is intended only for the use of the individual or
entity to which it is addressed, and may contain information that is
privileged, confidential and exempt from disclosure under applicable law.
If you are not the intended recipient, any dissemination, distribution or
copying of this communication is strictly prohibited. If you have
received this communication in error, please notify us immediately by
reply email to Connect at principal.com and delete or destroy all copies of
the original message and attachments thereto. Email sent to or from the
Principal Financial Group or any of its member companies may be retained
as required by law or regulation.

Nothing in this message is intended to constitute an Electronic signature
for purposes of the Uniform Electronic Transactions Act (UETA) or the
Electronic Signatures in Global and National Commerce Act ("E-Sign")
unless a specific statement to the contrary is included in this message.



More information about the rt-users mailing list