Upgrade problems 2.0.15 -> 3.2.2

hello,

I’m having a problem upgrading databases from 2.0.15 to 3.2.2. I’m using
the scripts provided in
http://download.bestpractical.com/pub/rt/devel/rt2-to-rt3.tar.gz and the
~ export seems to go fine from 2.0.15. When I try to start the import,
though, the script just spews errors similar to the ones pasted below.
My hunch is that the export didn’t go as well as I thought (although it
did not report any errors…) and I’m missing data somewhere. Can
someone give me a hint?

Thanks,

-=Tom Nail

Setups:

[OLD]
RHEL3 WS Update 4
MySQL 3.23.58
Perl 5.8.0
mod_perl 1.29
Apache 1.3.27
rt-2.0.15

[NEW]
RHEL3 WS Update 4
MySQL 4.1.9
Perl 5.8.6
mod_perl 1.29
Apache 1.3.33
rt-3.2.2

Errors:

<–snip–>
uCreating user Unnamed user 272
.[Wed Feb 9 18:17:27 2005] [error]: Could not create a new user -
(/opt/apps/rt3/lib/RT/User_Overlay.pm:260)
Failed to create user for$VAR1 = {
~ ‘CryptedPassword’ => undef,
~ ‘Name’ => ‘Unnamed user 272’
~ };
uCreating user Unnamed user 4
.[Wed Feb 9 18:17:27 2005] [error]: Could not create a new user -
(/opt/apps/rt3/lib/RT/User_Overlay.pm:260)
Failed to create user for$VAR1 = {
~ ‘CryptedPassword’ => undef,
~ ‘Name’ => ‘Unnamed user 4’
~ };

<–snip–>
Importing groups
rrCouldn’t load principal to grant them CommentOnTicket globally
$VAR1 = {
~ ‘PrincipalType’ => ‘User’,
~ ‘PrincipalId’ => ‘6’,
~ ‘Name’ => ‘CommentOnTicket’
~ };
[Wed Feb 9 18:17:51 2005] [crit]: 1
(/opt/apps/rt3/lib/RT/ACE_Overlay.pm:906)
[Wed Feb 9 18:17:51 2005] [crit]: Can’t load a principal for id
(/opt/apps/rt3/lib/RT/ACE_Overlay.pm:907)
rCouldn’t load principal to grant them CommentOnTicket globally
$VAR1 = {
~ ‘PrincipalType’ => ‘User’,
~ ‘PrincipalId’ => ‘7’,
~ ‘Name’ => ‘CommentOnTicket’
~ };
[Wed Feb 9 18:17:51 2005] [crit]: 1
(/opt/apps/rt3/lib/RT/ACE_Overlay.pm:906)
[Wed Feb 9 18:17:51 2005] [crit]: Can’t load a principal for id
(/opt/apps/rt3/lib/RT/ACE_Overlay.pm:907)
rCouldn’t load principal to grant them CommentOnTicket globally
$VAR1 = {
~ ‘PrincipalType’ => ‘User’,
~ ‘PrincipalId’ => ‘8’,
~ ‘Name’ => ‘CommentOnTicket’
~ };

<–snip–>
Importing tickets…t-1
Couldn’t create ticket HASH(0x92680e4) $VAR1 = {
~ ‘Requestor’ => [
~ ‘blah@blah.com’
~ ],
~ ‘Owner’ => undef,
~ ‘LastUpdatedBy’ => undef,
~ ‘_RecordTransaction’ => ‘0’,
~ ‘id’ => 1,
~ ‘Queue’ => ‘general’,
~ ‘Creator’ => undef
~ };
Couldn’t create trans 1
$VAR1 = {
~ ‘id’ => 1,
~ ‘Creator’ => undef,
~ ‘ActivateScrips’ => ‘0’
~ };

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Well, I just upgraded the Storable.pm version on the old box to 2.13 and
no dice: same errors as before. Do I have to recompile/install
Apache::Session and MLDBM as well?

Thanks again,

  • -=Tom Nail

Gary Holmes wrote:
| I had problems like this. It turned out to be the version of Storable.pm
| on the old box.
|
| HTH,
| Gary
|

|>Setups:
|>
|>[OLD]
|>RHEL3 WS Update 4
|>MySQL 3.23.58
|>Perl 5.8.0
|>mod_perl 1.29
|>Apache 1.3.27
|>rt-2.0.15
|>
|>[NEW]
|>RHEL3 WS Update 4
|>MySQL 4.1.9
|>Perl 5.8.6
|>mod_perl 1.29
|>Apache 1.3.33
|>rt-3.2.2
|>
|>Errors:
|>
|><–snip–>
|>uCreating user Unnamed user 272
|>.[Wed Feb 9 18:17:27 2005] [error]: Could not create a new user -
|>(/opt/apps/rt3/lib/RT/User_Overlay.pm:260)
|>Failed to create user for$VAR1 = {
|>~ ‘CryptedPassword’ => undef,
|>~ ‘Name’ => ‘Unnamed user 272’
|>~ };
|>uCreating user Unnamed user 4
|>.[Wed Feb 9 18:17:27 2005] [error]: Could not create a new user -
|>(/opt/apps/rt3/lib/RT/User_Overlay.pm:260)
|>Failed to create user for$VAR1 = {
|>~ ‘CryptedPassword’ => undef,
|>~ ‘Name’ => ‘Unnamed user 4’
|>~ };
|>
|><–snip–>
|>Importing groups
|>rrCouldn’t load principal to grant them CommentOnTicket globally
|>$VAR1 = {
|>~ ‘PrincipalType’ => ‘User’,
|>~ ‘PrincipalId’ => ‘6’,
|>~ ‘Name’ => ‘CommentOnTicket’
|>~ };
|>[Wed Feb 9 18:17:51 2005] [crit]: 1
|>(/opt/apps/rt3/lib/RT/ACE_Overlay.pm:906)
|>[Wed Feb 9 18:17:51 2005] [crit]: Can’t load a principal for id
|>(/opt/apps/rt3/lib/RT/ACE_Overlay.pm:907)
|>rCouldn’t load principal to grant them CommentOnTicket globally
|>$VAR1 = {
|>~ ‘PrincipalType’ => ‘User’,
|>~ ‘PrincipalId’ => ‘7’,
|>~ ‘Name’ => ‘CommentOnTicket’
|>~ };
|>[Wed Feb 9 18:17:51 2005] [crit]: 1
|>(/opt/apps/rt3/lib/RT/ACE_Overlay.pm:906)
|>[Wed Feb 9 18:17:51 2005] [crit]: Can’t load a principal for id
|>(/opt/apps/rt3/lib/RT/ACE_Overlay.pm:907)
|>rCouldn’t load principal to grant them CommentOnTicket globally
|>$VAR1 = {
|>~ ‘PrincipalType’ => ‘User’,
|>~ ‘PrincipalId’ => ‘8’,
|>~ ‘Name’ => ‘CommentOnTicket’
|>~ };
|>
|><–snip–>
|>Importing tickets…t-1
|>Couldn’t create ticket HASH(0x92680e4) $VAR1 = {
|>~ ‘Requestor’ => [
|>~ ‘blah@blah.com’
|>~ ],
|>~ ‘Owner’ => undef,
|>~ ‘LastUpdatedBy’ => undef,
|>~ 'RecordTransaction’ => ‘0’,
|>~ ‘id’ => 1,
|>~ ‘Queue’ => ‘general’,
|>~ ‘Creator’ => undef
|>~ };
|>Couldn’t create trans 1
|>$VAR1 = {
|>~ ‘id’ => 1,
|>~ ‘Creator’ => undef,
|>~ ‘ActivateScrips’ => ‘0’
|>~ };
|>
|>
______________________________________________
|>http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.1 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFCC5H31zsLRjt/NQ0RAgoWAJ4k1MUSdDbSxSrHuJNyqM91R2rHhgCeKrEY
T6gxZOJabnyqd0HTrDXI3oY=
=j4hP
-----END PGP SIGNATURE-----

|# Well, I just upgraded the Storable.pm version on the old box to 2.13 and
|# no dice: same errors as before. Do I have to recompile/install
|# Apache::Session and MLDBM as well?
|#
|# |><–snip–>
|# |>uCreating user Unnamed user 272
|# |>.[Wed Feb 9 18:17:27 2005] [error]: Could not create a new user -
|# |>(/opt/apps/rt3/lib/RT/User_Overlay.pm:260)
|# |>Failed to create user for$VAR1 = {
|# |>~ ‘CryptedPassword’ => undef,
|# |>~ ‘Name’ => ‘Unnamed user 272’
|# |>~ };

I had the same problem you are. At one time I updated
DBIx::SearchBuilder to the latest. When attempting to do the
rt2-to-dump, I got totally empty user entries in the dump file…

      'User' => [
                  {
                    'id' => '2524'
                  },
                  {
                    'id' => '1977'
                  },
                  {
                    'id' => '1482'
                  },
etc, etc

This resulted in the same errors you are seeing.

Backing down DBIx::SearchBuilder in the rt2 installation solved
the rt2-to-dump problem. I had to back down to 0.60 from 1.19
Tim Rosmus trosmus@nwnexus.net
Postmaster / USENET / DNS
Northwest Nexus Inc.

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Tim,

thanks for the help!! Downgrading DBIx-SearchBuilder to 0.61 fixed
everything on the export and it’s all running smoothly on the 3.2.2
instance. I think this is also related to the thread “rt2_to_rt3 only
exports userid numbers no user details?” so maybe a fix (or even a
warning note?) to the import/export scripts is in the works.

thanks again,

  • -=Tom Nail

Tim Rosmus wrote:
| On Thu, 10 Feb 2005, Thomas Nail wrote:
|
| |# Well, I just upgraded the Storable.pm version on the old box to
2.13 and
| |# no dice: same errors as before. Do I have to recompile/install
| |# Apache::Session and MLDBM as well?
| |#
| |# |><–snip–>
| |# |>uCreating user Unnamed user 272
| |# |>.[Wed Feb 9 18:17:27 2005] [error]: Could not create a new user -
| |# |>(/opt/apps/rt3/lib/RT/User_Overlay.pm:260)
| |# |>Failed to create user for$VAR1 = {
| |# |>~ ‘CryptedPassword’ => undef,
| |# |>~ ‘Name’ => ‘Unnamed user 272’
| |# |>~ };
|
| I had the same problem you are. At one time I updated
| DBIx::SearchBuilder to the latest. When attempting to do the
| rt2-to-dump, I got totally empty user entries in the dump file…
|
| ‘User’ => [
| {
| ‘id’ => ‘2524’
| },
| {
| ‘id’ => ‘1977’
| },
| {
| ‘id’ => ‘1482’
| },
| etc, etc
|
| This resulted in the same errors you are seeing.
|
| Backing down DBIx::SearchBuilder in the rt2 installation solved
| the rt2-to-dump problem. I had to back down to 0.60 from 1.19
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.1 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFCC7Fv1zsLRjt/NQ0RAgutAJ42dTaPsLM6VNjEl+lfXJdtqjVl6wCggJ2V
HUr1tm1wZTIGwf2AbIGNwjU=
=2Xwq
-----END PGP SIGNATURE-----