[rt-users] RT 3.4.2 and Oracle 10g backend

[Erwin Pasia]

Hi Steve,
 
Im having same problem with Oracle, were you able to make a workaround. Btw, below is the setting under my RT_SiteConfig.pm. Would really appreciate some help Thanks.
 
 
Set($DatabaseType , 'Oracle');
Set($DatabaseHost   , 'localhost');
Set($DatabaseRTHost , 'localhost');
Set($DatabasePort , '1521');
Set($DatabaseUser , 'test2');
Set($DatabasePassword , 'tyson1');
Set($DatabaseName , 'host=localhost; sid=RTDV2');
$ENV{TWO_TASK}="LIVE";
 
 
Erwin
 
 
.................................................................................
 
 
I'm having troubles getting RT 3.4.2 fully installed with an Oracle 10g 
database. Here's the software I'm using:

RT 3.4.2
SuSE Linux 9
DBD::Oracle 1.1.6
Oracle client 10.1.0.3 <http://10.1.0.3>
Oracle 10g on a remote system

make test-deps checks ok out. The RT software itself installs fine and is 
working with fastcgi; the web site loads without any problems. The problem 
I'm having is with the make initialize-database part. Here are the details:

Create rt user with this command:

create user rt identified by rt default tablespace rt_d1 temporary
tablespace temp;
grant resource, connect, query rewrite to rt;

Then I run make initialize-database:

# make initialize-database
/usr/bin/perl //opt/rt3/sbin/rt-setup-database --action init --dba rt 
--prompt-for-dba-password
In order to create or update your RT database,this script needs to connect 
to your Oracle instance on oracle.site.com <http://oracle.site.com> as rt.
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.
...skipped as rt is not rt or we're working with Oracle.
Now populating database schema.
Creating database schema.
Done setting up database schema.
Now inserting 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...[Thu Jun 30 09:31:20 2005] [warning]: DBD::Oracle::st 
execute failed: ORA-00600: internal error code, arguments: [kpofdr-long], 
[], [], [], [], [], [], [] (DBD ERROR: error possibly near <*> indicator at 
char 15 in 'SELECT * FROM <*>Principals WHERE id = :p1') [for Statement 
"SELECT * FROM Principals WHERE id = ?" with ParamValues: :p1='1'] at 
/usr/lib/perl5/site_perl/5.8.3/DBIx/SearchBuilder/Handle.pm line 480.
(/opt/rt3/lib/RT.pm:277)
[Thu Jun 30 09:31:20 2005] [warning]: RT::Handle=HASH(0x8cba890) couldn't 
execute the query 'SELECT * FROM Principals WHERE id = ?' at 
/usr/lib/perl5/site_perl/5.8.3/DBIx/SearchBuilder/Handle.pm line 494.
(/opt/rt3/lib/RT.pm:277)
[Thu Jun 30 09:31:20 2005] [warning]: Use of uninitialized value in hash 
element at /usr/lib/perl5/site_perl/5.8.3/Cache/Simple/TimedExpiry.pm line 
96.
(/opt/rt3/lib/RT.pm:277)
[Thu Jun 30 09:31:20 2005] [warning]: Use of uninitialized value in 
concatenation (.) or string at /opt/rt3/lib/RT/Principal_Overlay.pm line 
127.
(/opt/rt3/lib/RT.pm:277)
[Thu Jun 30 09:31:20 2005] [crit]: Found a principal () that was neither a 
user nor a group (/opt/rt3/lib/RT/Principal_Overlay.pm:127)
[Thu Jun 30 09:31:20 2005] [crit]: Can't call method "Id" on an undefined 
value at /opt/rt3/lib/RT/Group_Overlay.pm line 573.
(/opt/rt3/lib/RT.pm:285)
make: *** [initialize-database] Error 255
-----

Thoughts? All the tables seem to be created, including the Principals table, 
but there are no rows. 

Steve

 


__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 
__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20050804/569c4e6e/attachment.htm>