DBIx::Searchbuilder issue

RT Users
1

We just got our oracle box working and I’ve gotten RT installed and all
the modules. I had some inititial difficulty with DBD::Oracle but
finally got “make test” to complete without failures. But I’m still
getting the attached errors in my apache logs from DBIx::Searchbuilder.
I searched the mailing list archives and saw mention that this is
normally a problem with DBD::Oracle not being installed correctly. Are
there other reasons I could be getting these errors or should I keep
looking at DBD::Oracle.

I’ve also modified my ld.so.conf and suexec as recommended by person in
the archives with no luck.

Any ideas would be greatly appreciated! This looks to be one of the last
bugs with this environment.

Thanks in advance.

Justin Brodley

DBIx-SearchBuilder Errors.txt (5 KB)

2

Justin Brodley wrote:

We just got our oracle box working and I�ve gotten RT installed and all
the modules. I had some inititial difficulty with DBD::Oracle but
finally got �make test� to complete without failures. But I�m still
getting the attached errors in my apache logs from DBIx::Searchbuilder.
I searched the mailing list archives and saw mention that this is
normally a problem with DBD::Oracle not being installed correctly. Are
there other reasons I could be getting these errors or should I keep
looking at DBD::Oracle.

I�ve also modified my ld.so.conf and suexec as recommended by person in
the archives with no luck.
My guess is that the webserver owner doesn’t know where to find the
Oracle libraries. This usually means that ORACLE_HOME is not set.
One thing you could try is to sudo to your webserver user and see if you
can start sqlplus and connect to Oracle.

Joop

3

So I resolved this issue, but am still having the same string of errors as before.

Is there any good way to test DBD::Oracle in the way the application is trying to make sure its connect as it should?

Justin Brodley
Supervisor of DataCenter Infrastructure
SumTotal Systems, Inc. (Nasdaq: SUMT)
110-110th Ave NE Suite 700
Bellevue, WA 98004
OFFICE +1 425 637 1506
FAX +1 425 455 3071
MOBILE +1 425 753 7033
EMAIL jbrodley@sumtotalsystems.com
MSN justin_brodley

From: Joop van de Wege [mailto:JoopvandeWege@mococo.nl]
Sent: Friday, April 20, 2007 6:09 AM
To: Justin Brodley
Cc: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] DBIx::Searchbuilder issue

Justin Brodley wrote:

We just got our oracle box working and I’ve gotten RT installed and all
the modules. I had some inititial difficulty with DBD::Oracle but
finally got “make test” to complete without failures. But I’m still
getting the attached errors in my apache logs from DBIx::Searchbuilder.
I searched the mailing list archives and saw mention that this is
normally a problem with DBD::Oracle not being installed correctly. Are
there other reasons I could be getting these errors or should I keep
looking at DBD::Oracle.

I’ve also modified my ld.so.conf and suexec as recommended by person in
the archives with no luck.
My guess is that the webserver owner doesn’t know where to find the
Oracle libraries. This usually means that ORACLE_HOME is not set.
One thing you could try is to sudo to your webserver user and see if you
can start sqlplus and connect to Oracle.

Joop

4

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.

Justin Brodley
Supervisor of DataCenter Infrastructure
SumTotal Systems, Inc. (Nasdaq: SUMT)
110-110th Ave NE Suite 700
Bellevue, WA 98004
OFFICE +1 425 637 1506
FAX +1 425 455 3071
MOBILE +1 425 753 7033
EMAIL jbrodley@sumtotalsystems.com
MSN justin_brodley

From: rt-users-bounces@lists.bestpractical.com [mailto:rt-users-bounces@lists.bestpractical.com] On Behalf Of Justin Brodley
Sent: Friday, April 20, 2007 10:37 AM
To: Joop van de Wege
Cc: rt-users@lists.bestpractical.com
Subject: RE: [rt-users] DBIx::Searchbuilder issue

So I resolved this issue, but am still having the same string of errors as before.

Is there any good way to test DBD::Oracle in the way the application is trying to make sure its connect as it should?

Justin Brodley
Supervisor of DataCenter Infrastructure
SumTotal Systems, Inc. (Nasdaq: SUMT)
110-110th Ave NE Suite 700
Bellevue, WA 98004
OFFICE +1 425 637 1506
FAX +1 425 455 3071
MOBILE +1 425 753 7033
EMAIL jbrodley@sumtotalsystems.com
MSN justin_brodley

From: Joop van de Wege [mailto:JoopvandeWege@mococo.nl]
Sent: Friday, April 20, 2007 6:09 AM
To: Justin Brodley
Cc: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] DBIx::Searchbuilder issue

Justin Brodley wrote:

We just got our oracle box working and I’ve gotten RT installed and all
the modules. I had some inititial difficulty with DBD::Oracle but
finally got “make test” to complete without failures. But I’m still
getting the attached errors in my apache logs from DBIx::Searchbuilder.
I searched the mailing list archives and saw mention that this is
normally a problem with DBD::Oracle not being installed correctly. Are
there other reasons I could be getting these errors or should I keep
looking at DBD::Oracle.

I’ve also modified my ld.so.conf and suexec as recommended by person in
the archives with no luck.
My guess is that the webserver owner doesn’t know where to find the
Oracle libraries. This usually means that ORACLE_HOME is not set.
One thing you could try is to sudo to your webserver user and see if you
can start sqlplus and connect to Oracle.

Joop

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

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

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

5

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

6

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@lists.bestpractical.com [mailto:rt-users-bounces@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@bestpractical.com

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