[rt-users] oracle setup

[Craig Stevenson]

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 at lists.bestpractical.com
>[mailto:rt-users-bounces at lists.bestpractical.com] On Behalf Of Jesse
>Vincent
>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
>>    
>>
>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 at nsuok.edu | 918-456-5511x5955
|| Northeastern State University
|| 601 N. Grand | Tahlequah, Oklahoma 74464-2399

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20051026/fd770ee3/attachment.htm>