Problems converting rt-2.0.15 to rt-3.0.9 using rt-2-to-rt3

RT Developers
1

I am attempting to convert a database from rt-2-0-15 to rt-3-0-9 using
rt-2-to-rt3-1.23 and getting multiple errors. We are running
mysql-max-4.1.7 under FreeBSD 4.10.

I’m new to RT and haven’t worked with Perl in many years, so feel free
to correct any errors below.

The rt-2.0-to-dumpfile runs fine, but I’m getting errors when I run the
dumpfile-to-rt-3.0 script. I am doing a “make dropdb” and “make
initialize-database” on the RT3 database before every run of
dumpfile-to-rt-3.0.

The first error was in importing users, and seems to have been caused by
“undef” values being sent to SearchBuilder. Around line 222 I found the
following code:

if ($args{'CryptedPassword'} ) {
    $args{'Password'} = $args{'CryptedPassword'};
    delete $args{'CryptedPassword'};
}
elsif ( !$args{'Password'} ) {
    $args{'Password'} = '*NO-PASSWORD*';
}
elsif ( length( $args{'Password'} ) < $RT::MinimumPasswordLength ) {
    return ( 0, $self->loc("Password too short") );
}
else {
    $args{'Password'} = $self->_GeneratePassword($args{'Password'});
}

If CryptedPassword is undefined the first if will fail, setting Password
to “NO-PASSWORD”, but NOT deleting the key for CryptedPassword. I
changed this code to delete the CryptedPassword no matter which branch
is taken, and then to perform the following tests for password length.

if ($args{'CryptedPassword'} ) {
    $args{'Password'} = $args{'CryptedPassword'};
}
elsif ( !$args{'Password'} ) {
    $args{'Password'} = '*NO-PASSWORD*';
}
delete $args{'CryptedPassword'};

This got the user names imported, but now I’m getting the following
errors after creating all the users:

Importing groups
gggrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrr
rrrrrfqF
ailed to create queue for$VAR1 = {
‘LastUpdatedBy’ => undef,
‘Creator’ => undef
};
Couldn’t load principal to grant them AdminKeywordSelects on queue
$VAR1 = {
‘PrincipalType’ => ‘Group’,
‘Role’ => ‘AdminCc’,
‘Name’ => ‘AdminKeywordSelects’
};
Couldn’t load principal to grant them AdminQueue on queue
$VAR1 = {
‘PrincipalType’ => ‘Group’,
‘Role’ => ‘AdminCc’,
‘Name’ => ‘AdminQueue’
};
Couldn’t load principal to grant them CommentOnTicket on queue

I was wondering if anyone else has had similar problems and come up with
a fix or updated rt-2-to-rt3?

Thank you,

David Schmidt
NOC Analyst
Northwest Open Access Network
1-866-662-6380
dschmidt@noanet.net

2

I have done some additional debugging on the error I’m currently
getting:

This got the user names imported, but now I’m getting the following
errors after creating all the users:
Importing groups
gggrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrr
rrrrrfqF
ailed to create queue for$VAR1 = {
‘LastUpdatedBy’ => undef,
‘Creator’ => undef
};

Using the Perl debugger, I traced the “$queue_obj->Create( %{$queue} );”
call on line 246 of dumpfile-to-rt-3.0 and found that the problem was
that the db INSERT failed because there was no value supplied for the
“Name” column.

Where should that Name value be coming from?

David Schmidt
NOC Analyst
Northwest Open Access Network
dschmidt@noanet.net 1-866-662-6380