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

Tue Oct 3 19:30:09 EDT 2006

I forgot, I also moved suexec out of the way because I think it strips
off some environmental variables. Move it out of the way and restart
Apache. 

mv suexec suexec.DIST

-kosta

From: Bill Brown [mailto:whb at westpeak.com] 
Sent: Tuesday, October 03, 2006 6:04 PM
To: Kosta Lekas; rt-users at lists.bestpractical.com
Subject: RE: [rt-users] RHEL4 Apache, FastCGI or Mod_Perl both return
Unable LoadDBIx::SearchBuilder Handle for 'Oracle'

The ld.so.conf is as follows:

include ld.so.conf.d/*.conf

/usr/lib

/u01/app/oracle/product/10.2.0/lib

When I do a ldconfig  I get the following back

ldconfig: File /u01/app/oracle/product/10.2.0/lib/libordim10.soO is
empty, not checked.

ldconfig: /u01/app/oracle/product/10.2.0/lib/libexpat.so.0 is not a
symbolic link

If I do an ldconfig -v I can see 

libclntsh.so.10.1 -> libclntsh.so.10.1

But when I start apache I still get the same messages.

Bill

________________________________

From: Kosta Lekas [mailto:KLekas at foxriver.com] 
Sent: Tuesday, October 03, 2006 3:03 PM
To: Bill Brown; rt-users at lists.bestpractical.com
Subject: RE: [rt-users] RHEL4 Apache, FastCGI or Mod_Perl both return
Unable LoadDBIx::SearchBuilder Handle for 'Oracle'

I had the same problem, I added $ORACLE_HOME/lib to my ld.so.conf and it
fixed the problem. 

Kosta Lekas

Fox River Financial Resources

630.482.7142 - office

630.885.9355 - mobile

630.232.6074 - fax

________________________________

From: rt-users-bounces at lists.bestpractical.com
[mailto:rt-users-bounces at lists.bestpractical.com] On Behalf Of Bill
Brown
Sent: Tuesday, October 03, 2006 11:11 AM
To: rt-users at lists.bestpractical.com
Subject: [rt-users] RHEL4 Apache, FastCGI or Mod_Perl both return Unable
LoadDBIx::SearchBuilder Handle for 'Oracle'

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/73161c37/attachment.htm>