[rt-users] DBIx::Searchbuilder issue

[Justin Brodley]

Thanks for the information. I actually resolved this issue on Friday by putting the oracle home entries into the httpd.conf file and making sure fastcgi also was receiving the oracle home entries. Once I got this resolved I was able to connect and everything has been going well so far. 

Justin Brodley  

-----Original Message-----
From: rt-users-bounces at lists.bestpractical.com [mailto:rt-users-bounces at lists.bestpractical.com] On Behalf Of Kevin Falcone
Sent: Monday, April 23, 2007 5:08 AM
To: RT User List
Subject: Re: [rt-users] DBIx::Searchbuilder issue


On Apr 20, 2007, at 1:42 PM, Justin Brodley wrote:

> I have ran this code TWO_TASK=FOO perl -MDBI -le 'DBI->connect 
> ("DBI:Oracle:", "rt3", "rt3")' and have received no error back,  
> which I assume "no error" is good news.

Hi Justin

Are you running this piece of code as the user RT runs as?
The last time I saw errors like this, the apache user wasn't able
to read some of the shared Oracle libraries because one of the
directories in the path lacked world executable bits.

You may find it helpful to check
ldd /usr/lib/perl5/site_perl/5.8.5/i386-linux-thread-multi/auto/DBD/ 
Oracle/Oracle.so
as the web user, and make sure that user can see all
the linked libs.  This assumes you've set ORACLE_HOME or TWO_TASK
in the RT config files of course.

-kevin

_______________________________________________
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sales at bestpractical.com


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com