<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=Content-Type content="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 12 (filtered medium)">
<style>
<!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:vt100;
panose-1:0 0 0 0 0 0 0 0 0 0;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.Section1
{page:Section1;}
-->
</style>
<!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang=EN-US link=blue vlink=purple>
<div class=Section1>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>Sal- It has to do with Apache and your CGI handler not knowing
the oracle parameters. We use Fast CGI on Redhat connecting to a remote Oracle
servers. I had to add the following lines to my httpd.conf file:<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'># RT STUFF FOR APACHE<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>SetEnv LD_LIBRARY_PATH
/u01/app/oracle/product/10.2.0/client_1/lib<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>SetEnv ORACLE_HOME /u01/app/oracle/product/10.2.0/client_1<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>SetEnv ORACLE_SID rt<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>SetEnv TWO_TASK rt<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>(change above variables to your implementation)<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>In Httpd conf I also had to change the initialization string for
Fastcgi, this is the line in my config.<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>FastCgiServer /opt/rt3/bin/mason_handler.fcgi -idle-timeout 120
-processes 4 -initial-env
LD_LIBRARY_PATH=/u01/app/oracle/product/10.2.0/client_1/lib -initial-env
ORACLE_HOME=/u01/app/oracle/product/10.2.0/client1 -initial-env ORACLE_SID=rt
-initial-env TWO_TASK=rt<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>Some of this might be a bit excessive but I was trying
everything and spent a ton of time on the fastcgi and apache websites trying to
figure this out. Once this was all completed I was successful in getting DBI
Searchbuilder working. This took about a 12 hours of research and trial and
error on my part, and I’ve meant to go back and put this information in
the wiki but haven’t had a chance. <o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'> Justin Brodley<o:p></o:p></span></p>
<div>
<div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in'>
<p class=MsoNormal><b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>From:</span></b><span
style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'> rt-users-bounces@lists.bestpractical.com
[mailto:rt-users-bounces@lists.bestpractical.com] <b>On Behalf Of </b>Baytalskiy,
Sal<br>
<b>Sent:</b> Wednesday, May 16, 2007 9:49 PM<br>
<b>To:</b> rt-users@lists.bestpractical.com<br>
<b>Subject:</b> [rt-users] Desperately ned Oracle help<o:p></o:p></span></p>
</div>
</div>
<p class=MsoNormal><o:p> </o:p></p>
<div>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"vt100","serif"'>Hey
everyone!</span><o:p></o:p></p>
</div>
<div>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"vt100","serif"'>As
ive already mentioned - i'm being forced to use Oracle for my RT 3.6.3
instance.</span><o:p></o:p></p>
</div>
<div>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"vt100","serif"'>Well,
today i finally got an Oracle 10g instance up and loaded the schema.Oracle file
into it.</span><o:p></o:p></p>
</div>
<div>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"vt100","serif"'>Did
the ./configure for RT(./configure --prefix=/usr/local/rt3_ora
--with-db-type=Oracle --with-db-host=clorad1.example.com --with-db-port=1521
--with-db-rt-host=localhost --with-db-dba=rtusr --with-db-database=clorad1
--with-db-rt-user=rtusr --with-db-rt-pass=***** )</span><o:p></o:p></p>
</div>
<div>
<p class=MsoNormal> <o:p></o:p></p>
</div>
<div>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"vt100","serif"'>Everything
was ok.</span><o:p></o:p></p>
</div>
<div>
<p class=MsoNormal> <o:p></o:p></p>
</div>
<div>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"vt100","serif"'>While
doing make initialize-database i got this error: Unable to load
DBIx::SearchBuilder database handle for 'Oracle'.</span><o:p></o:p></p>
</div>
<div>
<p class=MsoNormal> <o:p></o:p></p>
</div>
<div>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"vt100","serif"'>Realized
that i don't have DBD::Oracle installed, so i downloaded that from CPAN and
installed that.</span><o:p></o:p></p>
</div>
<div>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"vt100","serif"'>There
were errors during the install and i found a workaround to delete -xarch=v9
from the Makefile. After that install finished.</span><o:p></o:p></p>
</div>
<div>
<p class=MsoNormal> <o:p></o:p></p>
</div>
<div>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"vt100","serif"'>Then
i followed the Wiki and commented out</span> <span style='font-size:10.0pt;
font-family:"vt100","serif"'>the insert_schema() method call.</span><o:p></o:p></p>
</div>
<div>
<p class=MsoNormal> <o:p></o:p></p>
</div>
<div>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"vt100","serif"'>But
i'm still getting errors trying to init the DB.</span><o:p></o:p></p>
</div>
<div>
<p class=MsoNormal> <o:p></o:p></p>
</div>
<div>
<p class=MsoNormal> <o:p></o:p></p>
</div>
<div>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"vt100","serif"'>Test
suggested by the Wiki (TWO_TASK=FOO perl -MDBI -le
'DBI->connect("DBI:Oracle:", "rt3", "rt3")')
seems to be successful. Or at least it doesn't give any errors.</span><o:p></o:p></p>
</div>
<div>
<p class=MsoNormal> <o:p></o:p></p>
</div>
<div>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"vt100","serif"'>This
is the error i get while doing make initialize-database :</span><o:p></o:p></p>
</div>
<div>
<p class=MsoNormal> <o:p></o:p></p>
</div>
<div>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"vt100","serif"'>DSN
component 'CLORAD1' is not in 'name=value' format at
/usr/perl5/site_perl/5.8.4/sun4-solaris-64int/DBI.pm line 627<br>
DBI connect('CLORAD1;port=1521','rtusr',...) failed: Can't connect using this
syntax without specifying a HOST and one of SID INSTANCE_NAME SERVER
SERVICE_NAME at //usr/local/rt3_ora/sbin/rt-setup-database line 103<br>
Failed to connect to dbi:Oracle:CLORAD1;port=1521 as rtusr: Can't connect using
this syntax without specifying a HOST and one of SID INSTANCE_NAME SERVER
SERVICE_NAME at //usr/local/rt3_ora/sbin/rt-setup-database line 103,
<STDIN> line 1.<br>
make: *** [initialize-database] Error 255</span><o:p></o:p></p>
</div>
<div>
<p class=MsoNormal> <o:p></o:p></p>
</div>
<div>
<p class=MsoNormal> <o:p></o:p></p>
</div>
<div>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"vt100","serif"'>PLEASE
HELP !!!</span><o:p></o:p></p>
</div>
<div>
<p class=MsoNormal> <o:p></o:p></p>
</div>
<div>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"vt100","serif"'>Thanks
in advance,</span><o:p></o:p></p>
</div>
<div>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"vt100","serif"'>Sal.</span><o:p></o:p></p>
</div>
</div>
</body>
</html>