<html>
<head>
<meta http-equiv=Content-Type content="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 11 (filtered)">
<style>
<!--
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:purple;
text-decoration:underline;}
span.EmailStyle17
{font-family:Arial;
color:windowtext;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.25in 1.0in 1.25in;}
div.Section1
{page:Section1;}
-->
</style>
</head>
<body lang=EN-US link=blue vlink=purple>
<div class=Section1>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Have been working getting RT 3.6.1 running in RHEL4 Apache
using FASTCGI.</span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'> </span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Getting the following in /var/log/httpd/error_log</span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'> </span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>[Unable to load DBIx::SearchBuilder database handle for
'Oracle'.</span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Perhaps you've picked an invalid database type or spelled it
incorrectly.</span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Can't load '/usr/lib/perl5/site_perl/5.8.5/i386-linux-thread-multi/auto/DBD/Oracle/Oracle.so'
for module DBD::Oracle: libclntsh.so.10.1: cannot open shared object file: No
such file or directory at /usr/lib/perl5/5.8.5/i386-linux-thread-multi/DynaLoader.pm
line 230. at /usr/lib/perl5/site_perl/5.8.5/DBIx/SearchBuilder/Handle/Oracle.pm
line 6</span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Compilation failed in require at
/usr/lib/perl5/site_perl/5.8.5/DBIx/SearchBuilder/Handle/Oracle.pm line 6.</span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>BEGIN failed--compilation aborted at
/usr/lib/perl5/site_perl/5.8.5/DBIx/SearchBuilder/Handle/Oracle.pm line
6.\nCompilation failed in require at (eval 195) line 1.</span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>BEGIN failed--compilation aborted at (eval 195) line
1.\nCompilation failed in require at /usr/local/rt/lib/RT.pm line 172.</span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'> </span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Have gone over and over <a
href="http://wiki.bestpractical.com/">http://wiki.bestpractical.com</a> , http://gossamer-threads.com/lists/rt/
, http://www.google.com ,</span></font> <font size=2 face=Arial><span
style='font-size:10.0pt;font-family:Arial'><a
href="http://lists.bestpractical.com/cgi-bin/htsearch">http://lists.bestpractical.com/cgi-bin/htsearch</a>,
cpan forums even bought the book!</span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'> </span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>I can successfully:</span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Make testdeps comes with no issues.</span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Make initialize-database for oracle. The database
schema was added to the Oracle database without a hitch.</span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Start the /usr/local/rt/bin/standalone_httpd and go to
<a href="http://localmachine/">http://localmachine</a> the rt main screen comes
up and can login with root and password.</span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'> </span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>I have tried the following:</span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'> </span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Adding environment LD_LIBRARY_PATH, ORACLE_HOME, ORACLE_BASE
variables to /usr/sbin/apachectl and /etc/init.d/httpd</span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Adding environment variables into LD_LIBRARY_PATH,
ORACLE_HOME, ORACLE_BASE /etc/httpd/conf/httpd.conf</span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Re-installed DBIx::SearchBuilder, DBI, DBD::Oracle</span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'> </span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>RT 3.6.1 running in RHEL4 Apache using mod_perl 2.0.</span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Tried setting up mod_perl 2.0 Installed perl-5.8.8-2.el4s1.i386.rpm
and mod_perl-2.1.0.2-4.el4s1.2.i386.rpm to see if that will work. </span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'> </span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Getting the following in /var/log/httpd/error_log with
mod_perl 2.0</span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'> </span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>[Tue Oct 03 09:42:18 2006] [error] [client 10.x.x.x] Unable
to load DBIx::SearchBuilder database handle for 'Oracle'.\nPerhaps you've
picked an</span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'> invalid database type or spelled it
incorrectly.\nCan't load
'/usr/lib/perl5/site_perl/5.8.8/i386-linux-thread-multi/auto/DBD/Oracle/Oracle.so'
</span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>for module DBD::Oracle: libclntsh.so.10.1: cannot open
shared object file: No such file or directory at /usr/lib/perl5/5.8.8/i386-linux-thread-mu</span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>lti/DynaLoader.pm line 230.\n at
/usr/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle/Oracle.pm line
6\nCompilation failed in require at /usr</span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle/Oracle.pm
line 6.\nBEGIN failed--compilation aborted at
/usr/lib/perl5/site_perl/5.8.8/DBIx/</span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>SearchBuilder/Handle/Oracle.pm line 6.\nCompilation failed
in require at (eval 195) line 1.\nBEGIN failed--compilation aborted at (eval
195) line</span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'> 1.\nCompilation failed in require at /usr/local/rt/lib/RT.pm
line 172.\n</span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'> </span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Any pointers would be great. I am out of testing
ideas.</span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'> </span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>TIA (Thanks In advance)</span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'> </span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Bill</span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'> </span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'> </span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'> </span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'> </span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'> </span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'> </span></font></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'> </span></font></p>
</div>
</body>
</html>