MigrateBugzillaToRT

**************************
 * Bugzilla RT migration
 * Javier Garcia
 * Snow Valley
 * javier(dot)garcia(at)snowvalley(dot)com
 * 24/04/2009
 **************************
 
 Environment:
 - OS: Debian Etch 2.6.18-6-486
 - RT version: 3.8.2
 - MySQL version: 5.0.32-Debian_7etch8-log
 
 
 
 I.  Download and untar migration files
 -----------------------------------
 tar -xvzf bugzilla-rt-convert.tar.gz
 
 
 
 II.  Read README file
 -----------------------------------
 Please, pay attention to the README file inside bugzilla-rt-convert folder
 
 
 
 III.  Replace initial data file
 -----------------------------------
 The original /opt/rt3/etc/initialdata file on RT3.8 has no  groups  information. We have  to  insert this
 information in our DB in order to avoid future issues loading tickets and queues.
 
 @Groups = (
     { Name        => '',
       Type        => 'Everyone',
       Domain      => 'SystemInternal',
       Instance    => '',
       Description => 'Pseudogroup for internal use',
       InsideTransaction => undef,
     },
     { Type        => 'Privileged',
       Domain      => 'SystemInternal',
       Instance    => '',
       Name        => '',
       Description => 'Pseudogroup for internal use',
       InsideTransaction => undef,
     },
     { Name        => '',
       Type        => 'Unprivileged',
       Domain      => 'SystemInternal',
       Instance    => '',
       Description => 'Pseudogroup for internal use',
       InsideTransaction => undef,
     },
     { Name        => '',
       Type        => 'Owner',
       Domain      => 'RT::System-Role',
       Instance    => '',
       Description => 'SystemRolegroup for internal use',
       InsideTransaction => undef,
     },
     { Name        => '',
       Type        => 'Requestor',
       Domain      => 'RT::System-Role',
       Instance    => '',
       Description => 'SystemRolegroup for internal use',
       InsideTransaction => undef,
     },
     { Name        => '',       Type        => 'Cc',
       Domain      => 'RT::System-Role',
       Instance    => '',
       Description => 'SystemRolegroup for internal use',
       InsideTransaction => undef,
     },
     { Name        => '',
       Type        => 'AdminCc',
       Domain      => 'RT::System-Role',
       Instance    => '',
       Description => 'Pseudogroup for internal use',
       InsideTransaction => undef,
     },
 );
 
 
 
 IV.  print_prod.pl
 -----------------------------------
 This script loads tickets information from bugzilla in a file. There are issues in some of the loaded data, as
 lots of creation date fields contain the string ‘now()’ instead of a valid date. The best way to fix this is to
 replace the following lines in the script:
 
  ### sub print_prod
    my $created = 'now()';
    ...
    print "\t  Description\t=> $desc,\n";
        print "\t  Created\t=> $created,\n";
 
 With these ones (NOTE: we are adding a random created date. Some people will need to modify this as they have to
 use the current date and time. Perl provides lots of time functions for this):
 
  ### sub print_prod
   my $created = 'now()';
  ...
   print "\t  Description\t=> $desc,\n";
  #
  ### ADDED TO AVOID now() DATES WHICH CAUSE LOADING ERRORS ON RT
   if ($created eq 'now()') {
   print "\t  Created\t=> '2009-04-22 11:00:00',\n";
  }else {
   print "\t  Created\t=> $created,\n";
  }
 
 
 
 V.  print_bugs.pl
 -----------------------------------
 This  script  loads bugs  information  from bugzilla  in a  file. We are  in  the  same  situation again, as
 there a lots of corrupted data. The best way to fix this is to replace the following lines in the script:
 
  ### sub print_bugs
  my $created = 'now()';
  ...
  print "\t  Type\t=> 'ticket',\n";
  print "\t  Created\t=> $created,\n";
 
 With these ones (NOTE: we are adding a random created date. Some people will need to modify this as they have to
 use the current date and time. Perl provides lots of time functions for this):
 
  ### sub print_bugs
  my $created = 'now()';
  ...
  print "\t  Type\t=> 'ticket',\n";
  #
  ### ADDED TO AVOID now() DATES WHICH CAUSE LOADING ERRORS ON RT
   if ($created eq 'now()') {
   print "\t  Created\t=> '2009-04-22 11:00:00',\n";
  }else {
   print "\t  Created\t=> $created,\n";
  }
 
 
 
 VI.  migrate.sh
 -----------------------------------
 Modify create_user function adding a line for the DB  initialization. This initialization  is needed as ‘Nobody’
 and ‘System’ users are not automatically added by the original script.
 
  create_user(){
   passwd=$1
         perl $setup --action drop --dba root --dba-password $passwd
   # We have to initialize the DB, as we need to insert Nobody and
   # System users, which are required and the original script doesn't
   # carry this out
         perl $setup --action init --dba root --dba-password $passwd
 
         # don't insert scrip here
         perl bugimport --action init --dba root --dba-password $passwd
        perl print_users_groups.pl $passwd > data.pl
         perl $setup --action insert --datafile ./data.pl --dba root --dba-password $passwd
         perl insert_ids_map.pl $passwd
  }
 
 
 
 VII.  Stop emailing
 -----------------------------------
 In order to avoid thousands of emails to be sent automatically, every time a new ticket is created, we have to
 stop our mail client
 
 
 
 VIII.  Run migration script
 -----------------------------------
 The best way to run the script is redirecting the standard error (which contains also Perl warning
 and informational messages) to a file
 sh migrate.sh 2> output
 
 
 
 IX.  Delete queued emails
 -----------------------------------
 Before restarting the email client we have to delete all the queued emails:
  rm -f /var/spool/mqueue/* /var/spool/mqueue-client/*
 
 NOTE: If there are too much pending emails, rm won’t work and you will need to use the following command instead:
 
  cd /var/spool/mqueue
  find . -name '*' -print0 | xargs -0 rm
  cd /var/spool/mqueue-client
  find . -name '*' -print0 | xargs -0 rm
 
 
 
 X.  Restart email client
 -----------------------------------