<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
<title></title>
</head>
<body bgcolor="#ffffff" text="#000000">
Thanks to both Jesse and Adam:<br>
<br>
The one line comment worked great. I have the preferences tab and all
my tables built out of the box.<br>
<br>
Thanks again!<br>
<br>
Myers, Adam wrote:<br>
<blockquote
cite="mid205D20196806AE41A9D8A9E982659E27013BB9BC@THN-EXCLS2.dc1.doubleclick.corp"
type="cite">
<pre wrap="">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: <a class="moz-txt-link-abbreviated" href="mailto:rt-users-bounces@lists.bestpractical.com">rt-users-bounces@lists.bestpractical.com</a>
[<a class="moz-txt-link-freetext" href="mailto:rt-users-bounces@lists.bestpractical.com">mailto:rt-users-bounces@lists.bestpractical.com</a>] On Behalf Of Jesse
Vincent
Sent: Wednesday, October 26, 2005 7:15 AM
To: Craig Stevenson
Cc: <a class="moz-txt-link-abbreviated" href="mailto:rt-users@lists.bestpractical.com">rt-users@lists.bestpractical.com</a>
Subject: Re: [rt-users] oracle setup
On Tue, Oct 25, 2005 at 05:10:11PM -0500, Craig Stevenson wrote:
</pre>
<blockquote type="cite">
<pre wrap="">Hi:
I have been working for a few days on getting RT installed on my
</pre>
</blockquote>
<pre wrap=""><!---->system.
</pre>
<blockquote type="cite">
<pre wrap="">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.
</pre>
</blockquote>
<pre wrap=""><!---->
How does setting up the tables fail? What happens if you create the
tables by hand?
_______________________________________________
<a class="moz-txt-link-freetext" href="http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users">http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users</a>
Be sure to check out the RT Wiki at <a class="moz-txt-link-freetext" href="http://wiki.bestpractical.com">http://wiki.bestpractical.com</a>
Buy your copy of our new book, RT Essentials, today!
Download a free sample chapter from <a class="moz-txt-link-freetext" href="http://rtbook.bestpractical.com">http://rtbook.bestpractical.com</a>
_______________________________________________
<a class="moz-txt-link-freetext" href="http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users">http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users</a>
Be sure to check out the RT Wiki at <a class="moz-txt-link-freetext" href="http://wiki.bestpractical.com">http://wiki.bestpractical.com</a>
Buy your copy of our new book, RT Essentials, today!
Download a free sample chapter from <a class="moz-txt-link-freetext" href="http://rtbook.bestpractical.com">http://rtbook.bestpractical.com</a>
</pre>
</blockquote>
<br>
<br>
<pre class="moz-signature" cols="72">--
Craig Stevenson
|| <a class="moz-txt-link-abbreviated" href="mailto:stevensc@nsuok.edu">stevensc@nsuok.edu</a> | 918-456-5511x5955
|| Northeastern State University
|| 601 N. Grand | Tahlequah, Oklahoma 74464-2399</pre>
</body>
</html>