RT 3.4.2 and Oracle 10g backend

RT Users
1

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

2

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

Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around