RE: (Fwd) dbd-oracle-1.16
- From: Philip.Garrett@xxxxxxxxxxx (Philip Garrett)
- Date: Fri, 21 Jul 2006 13:58:11 -0400
Do you have root on this box? If so, su to nobody (or whoever your web
server runs as) and try to change into that lib directory. I have a
feeling you'll find a directory somewhere in that tree that won't let
you in.
Once you've fixed the permissions and can enter that directory, your
webserver should be able to, too.
Philip
Oscar Gomez wrote:
Ok,'/usr/lib/perl5/site_perl/5.8.5/i386-linux-thread-multi/auto/DBD/Oracle/
drwxr-xr-x 3 oracle oinstall 4096 Jul 21 10:26
/opt/local/m01/app/oracle/product/8.17/lib/
-rwxr-xr-x 1 oracle oinstall 6352174 Jul 21 10:26
/opt/local/m01/app/oracle/product/8.17/lib/libclntsh.so.8.0
Running the script from the command line connects to the database and
returns correct results.
Oscar,
That information is owner/group id. I am asking about read/execute
permissions for this file. It might be the user who is executing the
Perl script does not have permissions into the $OH directory tree.
-----Original Message-----
From: Oscar Gomez [mailto:ogomez@xxxxxxxxxx]
Sent: Friday, July 21, 2006 9:20 AM
To: Reidy, Ron; dbi-users@xxxxxxxx
Subject: RE: (Fwd) dbd-oracle-1.16
Hi Reidy, Thanks
The permissions are oracle.oinstall
--
Open WebMail Project (http://openwebmail.org)
---------- Original Message -----------
From: "Reidy, Ron" <Ron.Reidy@xxxxxxxxxxxxxxxxxx>
To: "Tim Bunce" <Tim.Bunce@xxxxxxxxx>, <dbi-users@xxxxxxxx>
Sent: Thu, 20 Jul 2006 05:16:06 -0600
Subject: RE: (Fwd) dbd-oracle-1.16
Oscar,
Is Oracle installed? If so, what the permissions on
$ORACLE_HOME/lib and $ORACLE_HOME/libclntsh.so.8.0?
-----Original Message-----
From: Tim Bunce [mailto:Tim.Bunce@xxxxxxxxx]
Sent: Wednesday, July 19, 2006 11:45 PM
To: dbi-users@xxxxxxxx
Cc: ogomez@xxxxxxxxxx
Subject: (Fwd) dbd-oracle-1.16
----- Forwarded message from Oscar Gomez <ogomez@xxxxxxxxxx> -----
X-Pobox-Antispam: require_ptr/ returned deny: 200.13.228.34 has no
PTR record, or PTR and A records do not match From: Oscar Gomez
<ogomez@xxxxxxxxxx> To: Tim Bunce <Tim.Bunce@xxxxxxxxx>
Subject: dbd-oracle-1.16
Date: Wed, 19 Jul 2006 16:54:32 -0500
X-OriginatingIP: 10.0.1.50 (ogomez)
Tim
I have the following error when execute program in apache-cgi-oracle
[Wed Jul 19 17:08:18 2006] [error] [client 10.0.1.50]
install_driver(Oracle) failed: Can't load
------- End of Original Message -------Oracle.so'http://10.0.0.6/cgi-bin/FGI?py6110
for module DBD::Oracle: libclntsh.so.8.0: 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., referer: http://10.0.0.6/cgi-bin/FGI?py6110
[Wed Jul 19 17:08:18 2006] [error] [client 10.0.1.50] at (eval 1)
line 3, referer: http://10.0.0.6/cgi-bin/FGI?py6110
[Wed Jul 19 17:08:18 2006] [error] [client 10.0.1.50] Compilation
failed in require at (eval 1) line 3., referer:
[Wed Jul 19 17:08:18 2006] [error] [client 10.0.1.50] Perhaps a
required shared library or dll isn't installed where expected,
referer: http://10.0.0.6/cgi-bin/FGI?py6110
perl version 5.8.5
lunux enterprise ES 4
DBD-Oracle-1.16
DBI-1.30
Thanks
--
Open WebMail Project (http://openwebmail.org)
---------- Original Message -----------
From: Tim Bunce <Tim.Bunce@xxxxxxxxx>
To: "Garrett, Philip (MAN-Corporate)" <Philip.Garrett@xxxxxxxxxxx>
Sent: Wed, 19 Jul 2006 08:37:27 -0700
Subject: Re: DBI->installed_drivers() usage
On Wed, Jul 19, 2006 at 09:24:53AM -0400, Garrett, Philip (MAN-
Corporate) wrote:
Paul Griffin wrote:
I'm running Win XP with Perl 5.8.8.
If I try and run the following code :
use DBI;
my %drivers = DBI->installed_drivers();
foreach (keys( %drivers)) {
print "$_ uses $drivers{$_}\n";
}
Nothing is returned. Yet if I use :
my @drivers = DBI->available_drivers();
I get a list of drivers that I can then access with :
@dataSources = DBI->data_sources($_);
Am I using DBI->installed_drivers() incorrectly?
DBI->installed_drivers returns only the drivers that are actually
loaded into the current process. Installed in this case means
"installed into memory."
Ah. The docs weren't clear:
--- DBI.pm (revision 6618)
+++ DBI.pm (working copy)
@@ -2753,10 +2753,15 @@
%drivers = DBI->installed_drivers();
-Returns a list of driver name and driver handle pairs for all
-installed drivers. The driver name does not include the 'DBD::'
-prefix. Added in DBI 1.49.
+Returns a list of driver name and driver handle pairs for all
drivers +'installed' (loaded) into the current process. The driver
name does not +include the 'DBD::' prefix.
+To get a list of all drivers available in your perl instalation
you
------- End of Original Message -------can use +L</available_drivers>. + +Added in DBI 1.49. + =item------- End of Original Message -------
C<installed_versions>
DBI->installed_versions;
Tim.
----- End forwarded message -----
This electronic message transmission is a PRIVATE communication
which contains information which may be confidential or privileged.
The information is intended to be for the use of the individual or
entity named above. If you are not the intended recipient, please be
aware that any disclosure, copying, distribution or use of the
contents of this information is prohibited. Please notify the sender
of the delivery error by replying to this message, or notify us by
telephone (877-633-2436, ext. 0), and then delete it from your
system.
.
- Prev by Date: RE: (Fwd) dbd-oracle-1.16
- Next by Date: 'transactions not supported' error
- Previous by thread: RE: (Fwd) dbd-oracle-1.16
- Next by thread: RE: (Fwd) dbd-oracle-1.16
- Index(es):
Relevant Pages
|
