Oracle setup

Hi:

I have been working for a few days on getting RT installed on my system.

My system: redhat, oracle 10g, latest perl, and latest apache

The install scripts seem to balk on the oracle stuff.
— I would appreciate any pointers incorporating Oracle to play with RT —

I can drop and schema using sqlplus. I cannot run the rt-setup-database
on ‘acl’ or ‘insert’ option options. I can do partial inserts of the
tables.
I have not been able to insert a few of the tables. I have been running
the perl debugger on rt-setup-database to try and see my way through it.
I can be more detailed here in another message.

As far the the gui goes: I have not been able to get the 'Preferences’
button to appear next to the ‘| Logout’ toggle.

At the moment I would really appreciate andy general RT/Oracle
information. I would also like some insight into the missing
’Preferences’ option.

Thanks for the help.

Craig Stevenson
|| stevensc@nsuok.edu | 918-456-5511x5955
|| Northeastern State University
|| 601 N. Grand | Tahlequah, Oklahoma 74464-2399

Hi:

I have been working for a few days on getting RT installed on my system.

My system: redhat, oracle 10g, latest perl, and latest apache

The install scripts seem to balk on the oracle stuff.
— I would appreciate any pointers incorporating Oracle to play with RT —

I can drop and schema using sqlplus. I cannot run the rt-setup-database
on ‘acl’ or ‘insert’ option options. I can do partial inserts of the
tables.

How does setting up the tables fail? What happens if you create the
tables by hand?

Craig,

I am running Oracle 9g. What I did was use the Oracle.schema file to
create the database. Then followed the instruction in the Oracle.README
file (all provided in the RT package). Then run the configure command
with all the options for your database (make sure to use
–with-db-type=Oracle). When running ‘initialize-database’, I commented
out line 136 that calls insert_schema() since I already created the
schema. The database should be initialized fine. The command I used for
this is: $ /pathto/rt/sbin/rt-setup-database --action init --dba
password --prompt-for-dba-password.

As for seeing ‘Preferences’ on the GUI, make sure the group of people
you want to have this option has the right ‘ModifySelf’. That will
toggle the ‘Preferences’ link.

** AdamFrom: rt-users-bounces@lists.bestpractical.com
[mailto:rt-users-bounces@lists.bestpractical.com] On Behalf Of Jesse
Vincent
Sent: Wednesday, October 26, 2005 7:15 AM
To: Craig Stevenson
Cc: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] oracle setup

Hi:

I have been working for a few days on getting RT installed on my
system.

My system: redhat, oracle 10g, latest perl, and latest apache

The install scripts seem to balk on the oracle stuff.
— I would appreciate any pointers incorporating Oracle to play with
RT —

I can drop and schema using sqlplus. I cannot run the
rt-setup-database on ‘acl’ or ‘insert’ option options. I can do
partial inserts of the tables.

How does setting up the tables fail? What happens if you create the
tables by hand?
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Be sure to check out the RT Wiki at http://wiki.bestpractical.com

Buy your copy of our new book, RT Essentials, today!

Download a free sample chapter from http://rtbook.bestpractical.com

Jesse:

I have done this by hand. I am missing some data for the ACL table.

The ObjectType and PrincipalType columns are being required to be
set… There is nothing in ‘initialdata’ that indicates what those
columns should be set to.

Thanks!

Jesse Vincent wrote:

Hi:

I have been working for a few days on getting RT installed on my system.

My system: redhat, oracle 10g, latest perl, and latest apache

The install scripts seem to balk on the oracle stuff.
— I would appreciate any pointers incorporating Oracle to play with RT —

I can drop and schema using sqlplus. I cannot run the rt-setup-database
on ‘acl’ or ‘insert’ option options. I can do partial inserts of the
tables.

How does setting up the tables fail? What happens if you create the
tables by hand?

Craig Stevenson
|| stevensc@nsuok.edu | 918-456-5511x5955
|| Northeastern State University
|| 601 N. Grand | Tahlequah, Oklahoma 74464-2399

Thanks to both Jesse and Adam:

The one line comment worked great. I have the preferences tab and all
my tables built out of the box.

Thanks again!

Myers, Adam wrote:

Craig,

I am running Oracle 9g. What I did was use the Oracle.schema file to
create the database. Then followed the instruction in the Oracle.README
file (all provided in the RT package). Then run the configure command
with all the options for your database (make sure to use
–with-db-type=Oracle). When running ‘initialize-database’, I commented
out line 136 that calls insert_schema() since I already created the
schema. The database should be initialized fine. The command I used for
this is: $ /pathto/rt/sbin/rt-setup-database --action init --dba
password --prompt-for-dba-password.

As for seeing ‘Preferences’ on the GUI, make sure the group of people
you want to have this option has the right ‘ModifySelf’. That will
toggle the ‘Preferences’ link.

** Adam

-----Original Message-----
From: rt-users-bounces@lists.bestpractical.com
[mailto:rt-users-bounces@lists.bestpractical.com] On Behalf Of Jesse
Vincent
Sent: Wednesday, October 26, 2005 7:15 AM
To: Craig Stevenson
Cc: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] oracle setup

Hi:

I have been working for a few days on getting RT installed on my

system.

My system: redhat, oracle 10g, latest perl, and latest apache

The install scripts seem to balk on the oracle stuff.
— I would appreciate any pointers incorporating Oracle to play with
RT —

I can drop and schema using sqlplus. I cannot run the
rt-setup-database on ‘acl’ or ‘insert’ option options. I can do
partial inserts of the tables.

How does setting up the tables fail? What happens if you create the
tables by hand?


http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Be sure to check out the RT Wiki at http://wiki.bestpractical.com

Buy your copy of our new book, RT Essentials, today!

Download a free sample chapter from http://rtbook.bestpractical.com


http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Be sure to check out the RT Wiki at http://wiki.bestpractical.com

Buy your copy of our new book, RT Essentials, today!

Download a free sample chapter from http://rtbook.bestpractical.com

Craig Stevenson
|| stevensc@nsuok.edu | 918-456-5511x5955
|| Northeastern State University
|| 601 N. Grand | Tahlequah, Oklahoma 74464-2399

Added this email as “Raw Notes” to the bottom of:

http://wiki.bestpractical.com/index.cgi?OracleSetup

Seemed useful to keep it in the same place.

Cheers!

–jOn Wed, 2005-10-26 at 07:58, Myers, Adam wrote:

Craig,

I am running Oracle 9g. What I did was use the Oracle.schema file to
create the database. Then followed the instruction in the Oracle.README
file (all provided in the RT package). Then run the configure command
with all the options for your database (make sure to use
–with-db-type=Oracle). When running ‘initialize-database’, I commented
out line 136 that calls insert_schema() since I already created the
schema. The database should be initialized fine. The command I used for
this is: $ /pathto/rt/sbin/rt-setup-database --action init --dba
password --prompt-for-dba-password.

As for seeing ‘Preferences’ on the GUI, make sure the group of people
you want to have this option has the right ‘ModifySelf’. That will
toggle the ‘Preferences’ link.

** Adam

-----Original Message-----
From: rt-users-bounces@lists.bestpractical.com
[mailto:rt-users-bounces@lists.bestpractical.com] On Behalf Of Jesse
Vincent
Sent: Wednesday, October 26, 2005 7:15 AM
To: Craig Stevenson
Cc: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] oracle setup

On Tue, Oct 25, 2005 at 05:10:11PM -0500, Craig Stevenson wrote:

Hi:

I have been working for a few days on getting RT installed on my
system.

My system: redhat, oracle 10g, latest perl, and latest apache

The install scripts seem to balk on the oracle stuff.
— I would appreciate any pointers incorporating Oracle to play with
RT —

I can drop and schema using sqlplus. I cannot run the
rt-setup-database on ‘acl’ or ‘insert’ option options. I can do
partial inserts of the tables.

How does setting up the tables fail? What happens if you create the
tables by hand?


http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Be sure to check out the RT Wiki at http://wiki.bestpractical.com

Buy your copy of our new book, RT Essentials, today!

Download a free sample chapter from http://rtbook.bestpractical.com


http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Be sure to check out the RT Wiki at http://wiki.bestpractical.com

Buy your copy of our new book, RT Essentials, today!

Download a free sample chapter from http://rtbook.bestpractical.com
Jim Meyer, Geek at Large jmeyer@dreamworksanimation.com