[rt-users] oracle setup

Myers, Adam AMyers at abacus-us.com
Wed Oct 26 10:58:08 EDT 2005


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 at lists.bestpractical.com
[mailto:rt-users-bounces at lists.bestpractical.com] On Behalf Of Jesse
Sent: Wednesday, October 26, 2005 7:15 AM
To: Craig Stevenson
Cc: rt-users at 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
> 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?

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

More information about the rt-users mailing list