RT2 to RT3 upgrade soon

Soon I will be migrating to RHEL4 on the box we use to host our RT2
implementation. At that time, I am also going to the latest RT3
release. We use MySQL as the db. Any words of wisdom, or more
preferably, point me to a howto or some notes of similar install
procedure?

Thanks,
Tim

Tim Suter wrote:

Soon I will be migrating to RHEL4 on the box we use to host our RT2
implementation. At that time, I am also going to the latest RT3
release. We use MySQL as the db. Any words of wisdom, or more
preferably, point me to a howto or some notes of similar install
procedure?

First thing to do is search the list, as this has been documented
extensively.
http://www.gossamer-threads.com/lists/rt/

Drew Barnes
Applications Analyst
Raymond Walters College
University of Cincinnati

I have used RT on mysql for a bit, but I am looking to migrate to
PG for some other projects, and I figured it would be better if I could
run one server, rather than two.
I am using debian packages:

RT: 3.4.1-2
Postgresql: 7.4.7-3

When I run the rt-setup-database script, it has trouble creating 

the system user, _BootstrapCreate:
“Couldn’t create a Principal on new user create. Strange things are afoot
at the circle K”

I saw one person with this error who was using Oracle, but have 

not seen other solutions in the archives.

Any advice?

Thanks.

I have used RT on mysql for a bit, but I am looking to migrate to
PG for some other projects, and I figured it would be better if I could
run one server, rather than two.
I am using debian packages:

RT: 3.4.1-2
Postgresql: 7.4.7-3

When I run the rt-setup-database script, it has trouble creating
the system user, _BootstrapCreate:
“Couldn’t create a Principal on new user create. Strange things are afoot
at the circle K”

I saw one person with this error who was using Oracle, but have
not seen other solutions in the archives.

They’re there. I had it on Pg as well. Your DBD::Pg is 1.40, which
won’t work. 1.41 might, 1.32 definitely will. Either upgrade or
downgrade. If you’re already running 1.41, let us know, cause that
means they haven’t fixed it yet.

Switch out the module, zap the databases, and restart the install.

Cheers,
– jra
Jay R. Ashworth jra@baylink.com
Designer Baylink RFC 2100
Ashworth & Associates The Things I Think '87 e24
St Petersburg FL USA http://baylink.pitas.com +1 727 647 1274

  If you can read this... thank a system administrator.  Or two.  --me

Yeah, I saw that about 1.40. I am pretty sure that I have 1.32.
Am I looking in the right place:
/usr/lib/perl5/DBD/Pg.pm, line 15:

$DBD::Pg::VERSION = ‘1.32’;On Tue, 12 Apr 2005, Jay R. Ashworth wrote:

They’re there. I had it on Pg as well. Your DBD::Pg is 1.40, which
won’t work. 1.41 might, 1.32 definitely will. Either upgrade or
downgrade. If you’re already running 1.41, let us know, cause that
means they haven’t fixed it yet.

Switch out the module, zap the databases, and restart the install.

Yeah, I saw that about 1.40. I am pretty sure that I have 1.32.
Am I looking in the right place:
/usr/lib/perl5/DBD/Pg.pm, line 15:

$DBD::Pg::VERSION = ‘1.32’;

I’d check to see if there’s some other DBD::Pg on your perl path
above that…

Cheers,
– jra
Jay R. Ashworth jra@baylink.com
Designer Baylink RFC 2100
Ashworth & Associates The Things I Think '87 e24
St Petersburg FL USA http://baylink.pitas.com +1 727 647 1274

  If you can read this... thank a system administrator.  Or two.  --me

/usr/lib/perl5/DBD/Pg.pm, line 15:
$DBD::Pg::VERSION = ‘1.32’;

I’d check to see if there’s some other DBD::Pg on your perl path
above that…

Ah, good thought.  The only other Pg.pm on the system is

/usr/share/perl5/Pg.pm, but I am thinking that is not related. Yes?
Version 2.0.2

/usr/lib/perl5/DBD/Pg.pm, line 15:
$DBD::Pg::VERSION = ‘1.32’;

I’d check to see if there’s some other DBD::Pg on your perl path
above that…

Ah, good thought. The only other Pg.pm on the system is
/usr/share/perl5/Pg.pm, but I am thinking that is not related. Yes?
Version 2.0.2

Not with that version number.

You may have to post the full backtrace, then; this may be something
different. Which Pg; did we ask?

Cheers,
– jra
Jay R. Ashworth jra@baylink.com
Designer Baylink RFC 2100
Ashworth & Associates The Things I Think '87 e24
St Petersburg FL USA http://baylink.pitas.com +1 727 647 1274

  If you can read this... thank a system administrator.  Or two.  --me

You may have to post the full backtrace, then; this may be something
different. Which Pg; did we ask?

7.4.7-3

I only know enough perl to be dangerous. What do I need to do to get a
backtrace?

You may have to post the full backtrace, then; this may be something
different. Which Pg; did we ask?

7.4.7-3

I only know enough perl to be dangerous. What do I need to do to get a
backtrace?

Hmmm… I thought one came out with that error…

No?

Cheers,
– jra
Jay R. Ashworth jra@baylink.com
Designer Baylink RFC 2100
Ashworth & Associates The Things I Think '87 e24
St Petersburg FL USA http://baylink.pitas.com +1 727 647 1274

  If you can read this... thank a system administrator.  Or two.  --me

You may have to post the full backtrace, then; this may be something
different. Which Pg; did we ask?

7.4.7-3

I only know enough perl to be dangerous. What do I need to do to get a
backtrace?

Hmmm… I thought one came out with that error…

Ah. I might not have included the whole error before. This is all I get.
I think you are probably hoping for more.

[Wed Apr 13 11:01:33 2005] [crit]:
Couldn’t create a Principal on new user create.
Strange things are afoot at the circle K
(/usr/share/request-tracker3.4/lib/RT/User_Overlay.pm:479)

You may have to post the full backtrace, then; this may be something
different. Which Pg; did we ask?
Hmmm… I thought one came out with that error…

Ah, there is a bit more in the syslog.

Apr 13 07:01:33 orange RT: DBD::Pg::st execute failed: ERROR: column
"PrincipalType" of relation “principals” does not
exist at /usr/share/perl5/DBIx/SearchBuilder/Handle.pm line 480.
(/usr/share/request-tracker3.4/lib/RT.pm:277)

Apr 13 07:01:33 orange RT: DBD::Pg::st execute failed: ERROR: current
transaction is aborted, commands ignored until end
of transaction block at /usr/share/perl5/DBIx/SearchBuilder/Handle.pm line
480. (/usr/share/request-tracker3.4/lib/RT.pm:277)

Apr 13 07:01:33 orange RT: RT::Handle=HASH(0x8cf9f7c) couldn’t execute the
query ‘INSERT INTO Principals
(“PrincipalType”, “Disabled”, “ObjectId”) VALUES (?, ?, ?)’ at
/usr/share/perl5/DBIx/SearchBuilder/Handle.pm line 494.
(/usr/share/request-tracker3.4/lib/RT.pm:277)

Apr 13 07:01:33 orange RT: Use of uninitialized value in hash element at
/usr/share/perl5/Cache/Simple/TimedExpiry.pm
line 84. (/usr/share/request-tracker3.4/lib/RT.pm:277)

Apr 13 07:01:33 orange RT: RT::Handle=HASH(0x8cf9f7c) couldn’t execute the
query 'UPDATE “Principals” SET “ObjectId”=?
WHERE “id”=? ’ at /usr/share/perl5/DBIx/SearchBuilder/Handle.pm line 494.
(/usr/share/request-tracker3.4/lib/RT.pm:277)

Apr 13 07:01:33 orange RT: Couldn’t create a Principal on new user create.
Strange things are afoot at the circle K
(/usr/share/request-tracker3.4/lib/RT/User_Overlay.pm:479)

You may have to post the full backtrace, then; this may be something
different. Which Pg; did we ask?

7.4.7-3

I only know enough perl to be dangerous. What do I need to do to get a
backtrace?

Hmmm… I thought one came out with that error…

Ah. I might not have included the whole error before. This is all I get.
I think you are probably hoping for more.

[Wed Apr 13 11:01:33 2005] [crit]:
Couldn’t create a Principal on new user create.
Strange things are afoot at the circle K
(/usr/share/request-tracker3.4/lib/RT/User_Overlay.pm:479)

I was, in fact, hoping for more; I thought I’d gotten more when I had
the problem. Hmmm… Well, I’m rapidly approaching “out of my depth”;
I’d thought there was a debug level setting in RT_Config, but I don’t
see it there.

Anyone else?

Cheers,
– jra
Jay R. Ashworth jra@baylink.com
Designer Baylink RFC 2100
Ashworth & Associates The Things I Think '87 e24
St Petersburg FL USA http://baylink.pitas.com +1 727 647 1274

  If you can read this... thank a system administrator.  Or two.  --me

You may have to post the full backtrace, then; this may be something
different. Which Pg; did we ask?
Hmmm… I thought one came out with that error…

Ah, there is a bit more in the syslog.

Aha! (It’s a Spenser thing)

I knew there was more somewhere.

Apr 13 07:01:33 orange RT: DBD::Pg::st execute failed: ERROR: column
"PrincipalType" of relation “principals” does not
exist at /usr/share/perl5/DBIx/SearchBuilder/Handle.pm line 480.
(/usr/share/request-tracker3.4/lib/RT.pm:277)

What version is your SearchBuilder?

Apr 13 07:01:33 orange RT: DBD::Pg::st execute failed: ERROR: current
transaction is aborted, commands ignored until end
of transaction block at /usr/share/perl5/DBIx/SearchBuilder/Handle.pm line
480. (/usr/share/request-tracker3.4/lib/RT.pm:277)

And for that matter, what’s your perl’s @INC?

Cheers,
– jra
Jay R. Ashworth jra@baylink.com
Designer Baylink RFC 2100
Ashworth & Associates The Things I Think '87 e24
St Petersburg FL USA http://baylink.pitas.com +1 727 647 1274

  If you can read this... thank a system administrator.  Or two.  --me

What version is your SearchBuilder?
And for that matter, what’s your perl’s @INC?

I think the “please send me your configuration” bit you’re looking for
is:

http://your.rt.server/Admin/Tools/Configuration.html

Ah. I might not have included the whole error before. This is all I get.
I think you are probably hoping for more.

[Wed Apr 13 11:01:33 2005] [crit]:
Couldn’t create a Principal on new user create.
Strange things are afoot at the circle K
(/usr/share/request-tracker3.4/lib/RT/User_Overlay.pm:479)

This means you’re running DBD::Pg 1.40 or DBIx::SearchBuilder 1.24.
Going up one rev on either/both should solve it.

What version is your SearchBuilder?
And for that matter, what’s your perl’s @INC?

I think the “please send me your configuration” bit you’re looking for
is:

http://your.rt.server/Admin/Tools/Configuration.html

I’d forgotten that I saw that in there. It doesn’t dump @INC, though,
at least on my install.

Cheers,
– jra
Jay R. Ashworth jra@baylink.com
Designer Baylink RFC 2100
Ashworth & Associates The Things I Think '87 e24
St Petersburg FL USA http://baylink.pitas.com +1 727 647 1274

  If you can read this... thank a system administrator.  Or two.  --me

I’d forgotten that I saw that in there. It doesn’t dump @INC, though,
at least on my install.

Patches welcome.

Couldn’t create a Principal on new user create.
Strange things are afoot at the circle K
(/usr/share/request-tracker3.4/lib/RT/User_Overlay.pm:479)

This means you’re running DBD::Pg 1.40 or DBIx::SearchBuilder 1.24.
Going up one rev on either/both should solve it.

SearchBuilder was at 1.24, 1.25 fixes it, as you said.
Thanks!

I’d forgotten that I saw that in there. It doesn’t dump @INC, though,
at least on my install.

Patches welcome.

I hope to get to that state, Real Soon Now.

Cheers,
– jr ‘:-)’ a
Jay R. Ashworth jra@baylink.com
Designer Baylink RFC 2100
Ashworth & Associates The Things I Think '87 e24
St Petersburg FL USA http://baylink.pitas.com +1 727 647 1274

  If you can read this... thank a system administrator.  Or two.  --me