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,
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’
|>~ };
|>
|>______________________________________________
|>The rt-users Archives
-----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,
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-----