[rt-users] RHEL4 Apache, FastCGI or Mod_Perl both return Unable Load DBIx::SearchBuilder Handle for 'Oracle'

[Bill Brown]

Have been working getting RT 3.6.1 running in RHEL4 Apache using
FASTCGI.

 

Getting the following in /var/log/httpd/error_log

 

[Unable to load DBIx::SearchBuilder database handle for 'Oracle'.

Perhaps you've picked an invalid database type or spelled it
incorrectly.

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

Compilation failed in require at
/usr/lib/perl5/site_perl/5.8.5/DBIx/SearchBuilder/Handle/Oracle.pm line
6.

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.

BEGIN failed--compilation aborted at (eval 195) line 1.\nCompilation
failed in require at /usr/local/rt/lib/RT.pm line 172.

 

Have gone over and over http://wiki.bestpractical.com
<http://wiki.bestpractical.com/>  ,
http://gossamer-threads.com/lists/rt/ , http://www.google.com ,
http://lists.bestpractical.com/cgi-bin/htsearch, cpan forums even bought
the book!

 

I can successfully:

Make testdeps comes with no issues.

Make initialize-database for oracle.  The database schema was added to
the Oracle database without a hitch.

Start the /usr/local/rt/bin/standalone_httpd  and go to
http://localmachine <http://localmachine/>  the rt main screen comes up
and can login with root and password.

 

I have tried the following:

 

Adding environment LD_LIBRARY_PATH, ORACLE_HOME, ORACLE_BASE variables
to /usr/sbin/apachectl and /etc/init.d/httpd

Adding environment variables into LD_LIBRARY_PATH, ORACLE_HOME,
ORACLE_BASE  /etc/httpd/conf/httpd.conf

Re-installed DBIx::SearchBuilder, DBI, DBD::Oracle

 

RT 3.6.1 running in RHEL4 Apache using mod_perl 2.0.

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.  

 

Getting the following in /var/log/httpd/error_log with mod_perl 2.0

 

[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

 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' 

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

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

/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/

SearchBuilder/Handle/Oracle.pm line 6.\nCompilation failed in require at
(eval 195) line 1.\nBEGIN failed--compilation aborted at (eval 195) line

 1.\nCompilation failed in require at /usr/local/rt/lib/RT.pm line
172.\n

 

Any pointers would be great.  I am out of testing ideas.

 

TIA (Thanks In advance)

 

Bill

 

 

 

 

 

 

 

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