We're a'goin back to the Circle K, agin, boys

Jay_R_Ashworth · March 2, 2005, 9:54pm

I’m attempting my first RT install, and things aren’t coming along well.

I’m running SuSE 9.2, and PostGreSQL 7.4(.2, I think).

I’m also running Apache 2 and ModPerl 2.0.0RC4, but I haven’t even started having
problems with that yet.

I’ve succeeded in getting all my deps made, and make install, and I’m at the make
initialize-database stage of the game.

And, as so many people apparently did a few releases ago, I’m seeing this in the
make output:

======================8<====================
/usr/bin/perl //appl/rt341/sbin/rt-setup-database --action init --dba root
–prompt-for-dba-password
In order to create or update your RT database,this script needs to connect to your
Pg instance on localhost as root.
Please specify that user’s database password below. If the user has no database
password, just press return.

Password:
Now creating a database for RT.
Creating Pg database rt3.
Now populating database schema.
Creating database schema.
Done setting up database schema.
Now inserting database ACLs
Done setting up database ACLs.
Now inserting RT core system objects
Checking for existing system user…not found. This appears to be a new
installation.
Creating system user…[Sat Mar 5 14:49:53 2005] [crit]: Couldn’t create a
Principal on new user create. Strange things are afoot at the circle K
(/appl/rt341/lib/RT/User_Overlay.pm:479)
Could not create user
make: *** [initialize-database] Error 1
======================8<====================

Oh, my perl is 5.8.5. I did create the rt group in linux by hand, and did not
create a user in Linux or the DBMS. My DBMS superuser is root, and has both
capabilities (createuser and createdb).

Any pointers to help debug this would be greatly appreciated.

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 adminstrator.  Or two.  --me

Jay_R_Ashworth · March 3, 2005, 1:35am

I’m attempting my first RT install, and things aren’t coming along well.

I’m running SuSE 9.2, and PostGreSQL 7.4(.2, I think).
[ … ]
And, as so many people apparently did a few releases ago, I’m seeing this in the
make output:

======================8<====================
/usr/bin/perl //appl/rt341/sbin/rt-setup-database --action init --dba root
–prompt-for-dba-password
[ … ]
Checking for existing system user…not found. This appears to be a new
installation.
Creating system user…[Sat Mar 5 14:49:53 2005] [crit]: Couldn’t create a
Principal on new user create. Strange things are afoot at the circle K
(/appl/rt341/lib/RT/User_Overlay.pm:479)
Could not create user
make: *** [initialize-database] Error 1
======================8<====================

======================8<====================
Mar 5 13:30:04 studebaker RT: DBD::Pg::st execute failed: ERROR: column “disab
led” is of type integer but expression is of type character varying HINT: You w
ill need to rewrite or cast the expression. (/appl/rt341/lib/RT.pm:277)
Mar 5 13:30:04 studebaker RT: RT::Handle=HASH(0x914eca0) couldn’t execute the q
uery ‘INSERT INTO Principals (PrincipalType, Disabled, ObjectId) VALUES (?, ?, ?
)’ at /usr/lib/perl5/site_perl/5.8.5/DBIx/SearchBuilder/Handle.pm line 494. (/a
ppl/rt341/lib/RT.pm:277)
Mar 5 13:30:04 studebaker RT: Use of uninitialized value in hash element at /us
r/lib/perl5/site_perl/5.8.5/Cache/Simple/TimedExpiry.pm line 96. (/appl/rt341/l
ib/RT.pm:277)
Mar 5 13:30:04 studebaker RT: DBD::Pg::st execute failed: ERROR: current trans
action is aborted, commands ignored until end of transaction block (/appl/rt341
/lib/RT.pm:277)
Mar 5 13:30:04 studebaker RT: RT::Handle=HASH(0x914eca0) couldn’t execute the q
uery 'UPDATE Principals SET ObjectId=? WHERE id=? ’ at /usr/lib/perl5/site_perl/
5.8.5/DBIx/SearchBuilder/Handle.pm line 494. (/appl/rt341/lib/RT.pm:277)
Mar 5 13:30:04 studebaker RT: Couldn’t create a Principal on new user create. S
trange things are afoot at the circle K (/appl/rt341/lib/RT/User_Overlay.pm:479)
======================8<====================

Hopefully, this will be a glaring neon sign to someone (is this a lack-of-
automatic-casting problem, like bit so much other software written for My
that would run on Pg 7.2 but not on 7.3?).

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 adminstrator.  Or two.  --me

Jay_R_Ashworth · March 3, 2005, 3:09am

Hopefully, this will be a glaring neon sign to someone (is this a lack-of-
automatic-casting problem, like bit so much other software written for My
that would run on Pg 7.2 but not on 7.3?).

Some plinking with the boys on IRC suggests that DBD::Pg 1.40 breaks
auto-casting where 1.32 did not. Off to figure out how to downgrade a
CPAN module.

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 adminstrator.  Or two.  --me

Jay_R_Ashworth · March 3, 2005, 3:00pm

Hopefully, this will be a glaring neon sign to someone (is this a lack-of-
automatic-casting problem, like bit so much other software written for My
that would run on Pg 7.2 but not on 7.3?).

Some plinking with the boys on IRC suggests that DBD::Pg 1.40 breaks
auto-casting where 1.32 did not. Off to figure out how to downgrade a
CPAN module.

And I did figure out how to force in the older DBD::Pg. I then had to
copy my DBI.pm north a couple of directories into my path (and this
hack may be why though RT thinks it’s generating pages in a third of a
second, I’m taking 5 seconds to get them – or it may be the loop out
and back in through a Netgear router [they hate that]), but in any
event, It Is Working now.

Appropriate notes added to the wiki; More When I Don’t Know More™.

Thanks to Jesse and a couple others for the help on IRC last night.

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 adminstrator.  Or two.  --me