[rt-users] We're a'goin back to the Circle K, agin, boys

[Jay R. Ashworth]

On Wed, Mar 02, 2005 at 04:54:10PM -0500, I wrote:
> 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 at 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