(Fwd) dbd-oracle-1.16

----- Forwarded message from Oscar Gomez -----

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
To: Tim Bunce
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
'/usr/lib/perl5/site_perl/5.8.5/i386-linux-thread-multi/auto /DBD/Oracle/Oracle.so'
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: http://10.0.0.6/cgi-bin/FGI?py6110
[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
To: "Garrett, Philip (MAN-Corporate)"
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
> can use +L. + +Added in DBI 1.49. + =item
C
>
> DBI->installed_versions;
>
> Tim.
------- End of Original Message -------


----- End forwarded message -----

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@pobox.com]=20
Sent: Wednesday, July 19, 2006 11:45 PM
To: dbi-users@perl.org
Cc: ogomez@epq.com.co
Subject: (Fwd) dbd-oracle-1.16

----- Forwarded message from Oscar Gomez -----

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
To: Tim Bunce
Subject: dbd-oracle-1.16
Date: Wed, 19 Jul 2006 16:54:32 -0500
X-OriginatingIP: 10.0.1.50 (ogomez)

Tim=20
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
'/usr/lib/perl5/site_perl/5.8.5/i386-linux-thread-multi/auto /DBD/Oracle/
Oracle.so'
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: http://10.0.0.6/cgi-bin/FGI?py6110
[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
To: "Garrett, Philip (MAN-Corporate)"
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.
> > >=20
> > > If I try and run the following code :
> > >=20
> > > use DBI;
> > > my %drivers =3D DBI->installed_drivers();
> > > foreach (keys( %drivers)) {
> > > print "$_ uses $drivers{$_}\n";
> > > }
> > >=20
> > > Nothing is returned. Yet if I use :
> > >=20
> > > my @drivers =3D DBI->available_drivers();
> > >=20
> > > I get a list of drivers that I can then access with :
> > >=20
> > > @dataSources =3D DBI->data_sources($_);
> > >=20
> > > Am I using DBI->installed_drivers() incorrectly?
> >=20
> > DBI->installed_drivers returns only the drivers that are actually
loaded
> > into the current process. Installed in this case means "installed
into
> > memory."
>=20
> Ah. The docs weren't clear:
>=20
> --- DBI.pm (revision 6618)
> +++ DBI.pm (working copy)
> @@ -2753,10 +2753,15 @@
> =20
> %drivers =3D DBI->installed_drivers();
> =20
> -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=20
> drivers +'installed' (loaded) into the current process. The driver=20
> name does not +include the 'DBD::' prefix.
> =20
> +To get a list of all drivers available in your perl instalation you=20
> can use +L. + +Added in DBI 1.49. + =3Ditem
C
> =20
> DBI->installed_versions;
>=20
> Tim.
------- End of Original Message -------


----- End forwarded message -----

This electronic message transmission is a PRIVATE communication which =
contains
information which may be confidential or privileged. The information is =
intended=20
to be for the use of the individual or entity named above. If you are =
not the=20
intended recipient, please be aware that any disclosure, copying, =
distribution=20
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.

Re: (Fwd) dbd-oracle-1.16

Oh the top of my head I would say you do not have an oracle client to
compile against. or the client you have is lacking some parts. What is you
Oracle cleint you are trying tocompile against?


"Tim Bunce" wrote in message
news:20060720054459.GB8406@timac.local...
> ----- Forwarded message from Oscar Gomez -----
>
> 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
> To: Tim Bunce
> 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
> '/usr/lib/perl5/site_perl/5.8.5/i386-linux-thread-multi/auto /DBD/Oracle/Oracle.so'
> 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: http://10.0.0.6/cgi-bin/FGI?py6110
> [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
> To: "Garrett, Philip (MAN-Corporate)"
> 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
>> can use +L. + +Added in DBI 1.49. + =item
> C
>>
>> DBI->installed_versions;
>>
>> Tim.
> ------- End of Original Message -------
>
>
> ----- End forwarded message -----

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"
To: "Tim Bunce" ,
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@pobox.com]
> Sent: Wednesday, July 19, 2006 11:45 PM
> To: dbi-users@perl.org
> Cc: ogomez@epq.com.co
> Subject: (Fwd) dbd-oracle-1.16
>
> ----- Forwarded message from Oscar Gomez -----
>
> 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

> To: Tim Bunce
> 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
> '/usr/lib/perl5/site_perl/5.8.5/i386-linux-thread-multi/auto /DBD/Oracle/
> Oracle.so'
> 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: http://10.0.0.6/cgi-bin/FGI?py6110
>
> [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
> To: "Garrett, Philip (MAN-Corporate)"
> 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
> > can use +L. + +Added in DBI 1.49. + =item
> C
> >
> > DBI->installed_versions;
> >
> > Tim.
> ------- End of Original Message -------
>
> ----- 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.
------- End of Original Message -------

RE: (Fwd) dbd-oracle-1.16

Ok,
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.

--
Open WebMail Project (http://openwebmail.org)


---------- Original Message -----------
From: "Reidy, Ron"
To: "Oscar Gomez" ,
Sent: Fri, 21 Jul 2006 09:49:48 -0600
Subject: RE: (Fwd) dbd-oracle-1.16

> 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@epq.com.co]
> Sent: Friday, July 21, 2006 9:20 AM
> To: Reidy, Ron; dbi-users@perl.org
> 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"
> To: "Tim Bunce" ,
> 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@pobox.com]
> > Sent: Wednesday, July 19, 2006 11:45 PM
> > To: dbi-users@perl.org
> > Cc: ogomez@epq.com.co
> > Subject: (Fwd) dbd-oracle-1.16
> >
> > ----- Forwarded message from Oscar Gomez -----
> >
> > 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
>
> > To: Tim Bunce
> > 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
> >
> '/usr/lib/perl5/site_perl/5.8.5/i386-linux-thread-multi/auto /DBD/Oracle/
> > Oracle.so'
> > 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:
> http://10.0.0.6/cgi-bin/FGI?py6110
> >
> > [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
> > To: "Garrett, Philip (MAN-Corporate)"
> > 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
>
> > > can use +L. + +Added in DBI 1.49. + =item
> > C
> > >
> > > DBI->installed_versions;
> > >
> > > Tim.
> > ------- End of Original Message -------
> >
> > ----- 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.
> ------- End of Original Message -------
------- End of Original Message -------

RE: (Fwd) dbd-oracle-1.16

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@epq.com.co]=20
Sent: Friday, July 21, 2006 9:20 AM
To: Reidy, Ron; dbi-users@perl.org
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"
To: "Tim Bunce" ,
Sent: Thu, 20 Jul 2006 05:16:06 -0600
Subject: RE: (Fwd) dbd-oracle-1.16

> Oscar,
>=20
> Is Oracle installed? If so, what the permissions on $ORACLE_HOME/lib
> and $ORACLE_HOME/libclntsh.so.8.0?
>=20
> -----Original Message-----
> From: Tim Bunce [mailto:Tim.Bunce@pobox.com]=20
> Sent: Wednesday, July 19, 2006 11:45 PM
> To: dbi-users@perl.org
> Cc: ogomez@epq.com.co
> Subject: (Fwd) dbd-oracle-1.16
>=20
> ----- Forwarded message from Oscar Gomez -----
>=20
> X-Pobox-Antispam: require_ptr/ returned deny: 200.13.228.34 has no=20
> PTR record, or PTR and A records do not match From: Oscar Gomez

> To: Tim Bunce
> Subject: dbd-oracle-1.16
> Date: Wed, 19 Jul 2006 16:54:32 -0500
> X-OriginatingIP: 10.0.1.50 (ogomez)
>=20
> Tim=20
> I have the following error when execute program in apache-cgi-oracle
>=20
> [Wed Jul 19 17:08:18 2006] [error] [client 10.0.1.50]
> install_driver(Oracle)
> failed: 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.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
>=20
> [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
>=20
> [Wed Jul 19 17:08:18 2006] [error] [client 10.0.1.50] Compilation
failed
> in
> require at (eval 1) line 3., referer:
http://10.0.0.6/cgi-bin/FGI?py6110
>=20
> [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
>=20
> perl version 5.8.5
> lunux enterprise ES 4
> DBD-Oracle-1.16
> DBI-1.30
>=20
> Thanks
> --
> Open WebMail Project (http://openwebmail.org)
>=20
> ---------- Original Message -----------
> From: Tim Bunce
> To: "Garrett, Philip (MAN-Corporate)"
> Sent: Wed, 19 Jul 2006 08:37:27 -0700
> Subject: Re: DBI->installed_drivers() usage
>=20
> > 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.
> > > >=20
> > > > If I try and run the following code :
> > > >=20
> > > > use DBI;
> > > > my %drivers =3D DBI->installed_drivers();
> > > > foreach (keys( %drivers)) {
> > > > print "$_ uses $drivers{$_}\n";
> > > > }
> > > >=20
> > > > Nothing is returned. Yet if I use :
> > > >=20
> > > > my @drivers =3D DBI->available_drivers();
> > > >=20
> > > > I get a list of drivers that I can then access with :
> > > >=20
> > > > @dataSources =3D DBI->data_sources($_);
> > > >=20
> > > > Am I using DBI->installed_drivers() incorrectly?
> > >=20
> > > DBI->installed_drivers returns only the drivers that are actually
> loaded
> > > into the current process. Installed in this case means "installed
> into
> > > memory."
> >=20
> > Ah. The docs weren't clear:
> >=20
> > --- DBI.pm (revision 6618)
> > +++ DBI.pm (working copy)
> > @@ -2753,10 +2753,15 @@
> > =20
> > %drivers =3D DBI->installed_drivers();
> > =20
> > -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=20
> > drivers +'installed' (loaded) into the current process. The driver=20
> > name does not +include the 'DBD::' prefix.
> > =20
> > +To get a list of all drivers available in your perl instalation you

> > can use +L. + +Added in DBI 1.49. + =3Ditem
> C
> > =20
> > DBI->installed_versions;
> >=20
> > Tim.
> ------- End of Original Message -------
>=20
> ----- End forwarded message -----
>=20
> This electronic message transmission is a PRIVATE communication=20
> which contains information which may be confidential or privileged.=20
> The information is intended to be for the use of the individual or=20
> entity named above. If you are not the intended recipient, please be=20
> aware that any disclosure, copying, distribution or use of the=20
> contents of this information is prohibited. Please notify the sender=20
> of the delivery error by replying to this message, or notify us by=20
> telephone (877-633-2436, ext. 0), and then delete it from your system.
------- End of Original Message -------

RE: (Fwd) dbd-oracle-1.16

So, the O/S user running the web server cannot execute this? I think
this has been answered before and is available via google. I don't
remember the answer off the top of my head.

-----Original Message-----
From: Oscar Gomez [mailto:ogomez@epq.com.co]=20
Sent: Friday, July 21, 2006 9:46 AM
To: Reidy, Ron; dbi-users@perl.org
Subject: RE: (Fwd) dbd-oracle-1.16

Ok,=20
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.

--
Open WebMail Project (http://openwebmail.org)


---------- Original Message -----------
From: "Reidy, Ron"
To: "Oscar Gomez" ,
Sent: Fri, 21 Jul 2006 09:49:48 -0600
Subject: RE: (Fwd) dbd-oracle-1.16

> Oscar,
>=20
> 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.
>=20
> -----Original Message-----
> From: Oscar Gomez [mailto:ogomez@epq.com.co]=20
> Sent: Friday, July 21, 2006 9:20 AM
> To: Reidy, Ron; dbi-users@perl.org
> Subject: RE: (Fwd) dbd-oracle-1.16
>=20
> Hi Reidy, Thanks
> The permissions are oracle.oinstall
>=20
> --
> Open WebMail Project (http://openwebmail.org)
>=20
> ---------- Original Message -----------
> From: "Reidy, Ron"
> To: "Tim Bunce" ,
> Sent: Thu, 20 Jul 2006 05:16:06 -0600
> Subject: RE: (Fwd) dbd-oracle-1.16
>=20
> > Oscar,
> >=20
> > Is Oracle installed? If so, what the permissions on
$ORACLE_HOME/lib
> > and $ORACLE_HOME/libclntsh.so.8.0?
> >=20
> > -----Original Message-----
> > From: Tim Bunce [mailto:Tim.Bunce@pobox.com]=20
> > Sent: Wednesday, July 19, 2006 11:45 PM
> > To: dbi-users@perl.org
> > Cc: ogomez@epq.com.co
> > Subject: (Fwd) dbd-oracle-1.16
> >=20
> > ----- Forwarded message from Oscar Gomez -----
> >=20
> > X-Pobox-Antispam: require_ptr/ returned deny: 200.13.228.34 has no=20
> > PTR record, or PTR and A records do not match From: Oscar Gomez
>
> > To: Tim Bunce
> > Subject: dbd-oracle-1.16
> > Date: Wed, 19 Jul 2006 16:54:32 -0500
> > X-OriginatingIP: 10.0.1.50 (ogomez)
> >=20
> > Tim=20
> > I have the following error when execute program in apache-cgi-oracle
> >=20
> > [Wed Jul 19 17:08:18 2006] [error] [client 10.0.1.50]
> > install_driver(Oracle)
> > failed: 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.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
> >=20
> > [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
> >=20
> > [Wed Jul 19 17:08:18 2006] [error] [client 10.0.1.50] Compilation
> failed
> > in
> > require at (eval 1) line 3., referer:
> http://10.0.0.6/cgi-bin/FGI?py6110
> >=20
> > [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
> >=20
> > perl version 5.8.5
> > lunux enterprise ES 4
> > DBD-Oracle-1.16
> > DBI-1.30
> >=20
> > Thanks
> > --
> > Open WebMail Project (http://openwebmail.org)
> >=20
> > ---------- Original Message -----------
> > From: Tim Bunce
> > To: "Garrett, Philip (MAN-Corporate)"
> > Sent: Wed, 19 Jul 2006 08:37:27 -0700
> > Subject: Re: DBI->installed_drivers() usage
> >=20
> > > 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.
> > > > >=20
> > > > > If I try and run the following code :
> > > > >=20
> > > > > use DBI;
> > > > > my %drivers =3D DBI->installed_drivers();
> > > > > foreach (keys( %drivers)) {
> > > > > print "$_ uses $drivers{$_}\n";
> > > > > }
> > > > >=20
> > > > > Nothing is returned. Yet if I use :
> > > > >=20
> > > > > my @drivers =3D DBI->available_drivers();
> > > > >=20
> > > > > I get a list of drivers that I can then access with :
> > > > >=20
> > > > > @dataSources =3D DBI->data_sources($_);
> > > > >=20
> > > > > Am I using DBI->installed_drivers() incorrectly?
> > > >=20
> > > > DBI->installed_drivers returns only the drivers that are
actually
> > loaded
> > > > into the current process. Installed in this case means
"installed
> > into
> > > > memory."
> > >=20
> > > Ah. The docs weren't clear:
> > >=20
> > > --- DBI.pm (revision 6618)
> > > +++ DBI.pm (working copy)
> > > @@ -2753,10 +2753,15 @@
> > > =20
> > > %drivers =3D DBI->installed_drivers();
> > > =20
> > > -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=20
> > > drivers +'installed' (loaded) into the current process. The
driver=20
> > > name does not +include the 'DBD::' prefix.
> > > =20
> > > +To get a list of all drivers available in your perl instalation
you
>=20
> > > can use +L. + +Added in DBI 1.49. + =3Ditem
> > C
> > > =20
> > > DBI->installed_versions;
> > >=20
> > > Tim.
> > ------- End of Original Message -------
> >=20
> > ----- End forwarded message -----
> >=20
> > This electronic message transmission is a PRIVATE communication=20
> > which contains information which may be confidential or privileged.=20
> > The information is intended to be for the use of the individual or=20
> > entity named above. If you are not the intended recipient, please be

> > aware that any disclosure, copying, distribution or use of the=20
> > contents of this information is prohibited. Please notify the sender

> > of the delivery error by replying to this message, or notify us by=20
> > telephone (877-633-2436, ext. 0), and then delete it from your
system.
> ------- End of Original Message -------
------- End of Original Message -------

RE: (Fwd) dbd-oracle-1.16

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,
> 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
>=20
> Running the script from the command line connects to the database and
> returns correct results.
>=20
>=20
>> Oscar,
>>=20
>> 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.
>>=20
>> -----Original Message-----
>> From: Oscar Gomez [mailto:ogomez@epq.com.co]
>> Sent: Friday, July 21, 2006 9:20 AM
>> To: Reidy, Ron; dbi-users@perl.org
>> Subject: RE: (Fwd) dbd-oracle-1.16
>>=20
>> Hi Reidy, Thanks
>> The permissions are oracle.oinstall
>>=20
>> --
>> Open WebMail Project (http://openwebmail.org)
>>=20
>> ---------- Original Message -----------
>> From: "Reidy, Ron"
>> To: "Tim Bunce" ,
>> Sent: Thu, 20 Jul 2006 05:16:06 -0600
>> Subject: RE: (Fwd) dbd-oracle-1.16
>>=20
>>> Oscar,
>>>=20
>>> Is Oracle installed? If so, what the permissions on
>>> $ORACLE_HOME/lib and $ORACLE_HOME/libclntsh.so.8.0?
>>>=20
>>> -----Original Message-----
>>> From: Tim Bunce [mailto:Tim.Bunce@pobox.com]
>>> Sent: Wednesday, July 19, 2006 11:45 PM
>>> To: dbi-users@perl.org
>>> Cc: ogomez@epq.com.co
>>> Subject: (Fwd) dbd-oracle-1.16
>>>=20
>>> ----- Forwarded message from Oscar Gomez -----
>>>=20
>>> 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
>>> To: Tim Bunce
>>> Subject: dbd-oracle-1.16
>>> Date: Wed, 19 Jul 2006 16:54:32 -0500
>>> X-OriginatingIP: 10.0.1.50 (ogomez)
>>>=20
>>> Tim
>>> I have the following error when execute program in apache-cgi-oracle
>>>=20
>>> [Wed Jul 19 17:08:18 2006] [error] [client 10.0.1.50]
>>> install_driver(Oracle) failed: Can't load
>>>=20
>>
'/usr/lib/perl5/site_perl/5.8.5/i386-linux-thread-multi/auto /DBD/Oracle/
>>> Oracle.so'
>>> 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
>>>=20
>>> [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
>>>=20
>>> [Wed Jul 19 17:08:18 2006] [error] [client 10.0.1.50] Compilation
>>> failed in require at (eval 1) line 3., referer:
>> http://10.0.0.6/cgi-bin/FGI?py6110
>>>=20
>>> [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
>>>=20
>>> perl version 5.8.5
>>> lunux enterprise ES 4
>>> DBD-Oracle-1.16
>>> DBI-1.30
>>>=20
>>> Thanks
>>> --
>>> Open WebMail Project (http://openwebmail.org)
>>>=20
>>> ---------- Original Message -----------
>>> From: Tim Bunce
>>> To: "Garrett, Philip (MAN-Corporate)"
>>> Sent: Wed, 19 Jul 2006 08:37:27 -0700
>>> Subject: Re: DBI->installed_drivers() usage
>>>=20
>>>> 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.
>>>>>>=20
>>>>>> If I try and run the following code :
>>>>>>=20
>>>>>> use DBI;
>>>>>> my %drivers =3D DBI->installed_drivers();
>>>>>> foreach (keys( %drivers)) {
>>>>>> print "$_ uses $drivers{$_}\n";
>>>>>> }
>>>>>>=20
>>>>>> Nothing is returned. Yet if I use :
>>>>>>=20
>>>>>> my @drivers =3D DBI->available_drivers();
>>>>>>=20
>>>>>> I get a list of drivers that I can then access with :
>>>>>>=20
>>>>>> @dataSources =3D DBI->data_sources($_);
>>>>>>=20
>>>>>> Am I using DBI->installed_drivers() incorrectly?
>>>>>=20
>>>>> DBI->installed_drivers returns only the drivers that are actually
>>>>> loaded into the current process. Installed in this case means
>>>>> "installed into memory."
>>>>=20
>>>> Ah. The docs weren't clear:
>>>>=20
>>>> --- DBI.pm (revision 6618)
>>>> +++ DBI.pm (working copy)
>>>> @@ -2753,10 +2753,15 @@
>>>>=20
>>>> %drivers =3D DBI->installed_drivers();
>>>>=20
>>>> -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.
>>>>=20
>>>> +To get a list of all drivers available in your perl instalation
>>>> you=20
>>=20
>>>> can use +L. + +Added in DBI 1.49. + =3Ditem
>>>> C=20
>>>>=20
>>>> DBI->installed_versions;
>>>>=20
>>>> Tim.
>>> ------- End of Original Message -------
>>>=20
>>> ----- End forwarded message -----
>>>=20
>>> 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.=20
>> ------- End of Original Message -------
> ------- End of Original Message -------

RE: (Fwd) dbd-oracle-1.16

Hi, Reidy
I put the following environment variables in the configuration file httpd.conf:
SetEnv LD_LIBRARY_PATH /opt/local/m01/app/oracle/product/8.17/lib
SetEnv ORACLE_HOME /opt/local/m01/app/oracle/product/8.17/
SetEnv ORACLE_SID epqdb
SetEnv LD_RUN_PATH /opt/local/m01/app/oracle/product/8.17/rdbms/lib

and the problem disappear

many thanks for you help

--
Open WebMail Project (http://openwebmail.org)


---------- Original Message -----------
From: "Reidy, Ron"
To: "Oscar Gomez"
Sent: Fri, 21 Jul 2006 10:56:58 -0600
Subject: RE: (Fwd) dbd-oracle-1.16

> I am not a web programmer, so I cannot address this. I seem to
> recall the preferred place to set these vars is httpd.conf. I do
> not know the vars PassEnv and PerlPassEnv, sorry.
>
> -----Original Message-----
> From: Oscar Gomez [mailto:ogomez@epq.com.co]
> Sent: Friday, July 21, 2006 10:33 AM
> To: Reidy, Ron
> Subject: RE: (Fwd) dbd-oracle-1.16
>
> Reidy
> in google say :
> ORACLE_HOME, LD_LIBRARY_PATH ($ORACLE_HOME/lib), TWO_TASK, and
> > LD_RUN_PATH($ORACLE_HOME/lib:$ORACLE_HOME/rdbms/lib) set in httpd.conf
>
> Have you added PassEnv and PerlPassEnv directives for all of these
> variables?
>
> I have this enviroment variables in the script xxx.pl. is the same ?
>
> thanks
>
> --
> Open WebMail Project (http://openwebmail.org)
>
> ---------- Original Message -----------
> From: "Reidy, Ron"
> To: "Oscar Gomez"
> Sent: Fri, 21 Jul 2006 10:34:40 -0600
> Subject: RE: (Fwd) dbd-oracle-1.16
>
> > Operating System
> >
> > -----Original Message-----
> > From: Oscar Gomez [mailto:ogomez@epq.com.co]
> > Sent: Friday, July 21, 2006 10:03 AM
> > To: Reidy, Ron
> > Subject: RE: (Fwd) dbd-oracle-1.16
> >
> > excuse me,what is O/S
> >
> > thanks
> >
> > --
> > Open WebMail Project (http://openwebmail.org)
> >
> > ---------- Original Message -----------
> > From: "Reidy, Ron"
> > To: "Oscar Gomez" ,
> > Sent: Fri, 21 Jul 2006 10:12:46 -0600
> > Subject: RE: (Fwd) dbd-oracle-1.16
> >
> > > So, the O/S user running the web server cannot execute this? I
> > > think this has been answered before and is available via google. I
> > don't
> > > remember the answer off the top of my head.
> > >
> > > -----Original Message-----
> > > From: Oscar Gomez [mailto:ogomez@epq.com.co]
> > > Sent: Friday, July 21, 2006 9:46 AM
> > > To: Reidy, Ron; dbi-users@perl.org
> > > Subject: RE: (Fwd) dbd-oracle-1.16
> > >
> > > Ok,
> > > 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.
> > >
> > > --
> > > Open WebMail Project (http://openwebmail.org)
> > >
> > > ---------- Original Message -----------
> > > From: "Reidy, Ron"
> > > To: "Oscar Gomez" ,
> > > Sent: Fri, 21 Jul 2006 09:49:48 -0600
> > > Subject: RE: (Fwd) dbd-oracle-1.16
> > >
> > > > 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@epq.com.co]
> > > > Sent: Friday, July 21, 2006 9:20 AM
> > > > To: Reidy, Ron; dbi-users@perl.org
> > > > 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"
> > > > To: "Tim Bunce" ,
> > > > 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@pobox.com]
> > > > > Sent: Wednesday, July 19, 2006 11:45 PM
> > > > > To: dbi-users@perl.org
> > > > > Cc: ogomez@epq.com.co
> > > > > Subject: (Fwd) dbd-oracle-1.16
> > > > >
> > > > > ----- Forwarded message from Oscar Gomez
> -----
> > > > >
> > > > > 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
> > > >
> > > > > To: Tim Bunce
> > > > > 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
> > > > >
> > > >
> > >
> >
> '/usr/lib/perl5/site_perl/5.8.5/i386-linux-thread-multi/auto /DBD/Oracle/
> > > > > Oracle.so'
> > > > > 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:
> > > > http://10.0.0.6/cgi-bin/FGI?py6110
> > > > >
> > > > > [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
> > > > > To: "Garrett, Philip (MAN-Corporate)"
>
> > > > > 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
> > > >
> > > > > > can use +L. + +Added in DBI 1.49. + =item
> > > > > C
> > > > > >
> > > > > > DBI->installed_versions;
> > > > > >
> > > > > > Tim.
> > > > > ------- End of Original Message -------
> > > > >
> > > > > ----- 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.
> > > > ------- End of Original Message -------
> > > ------- End of Original Message -------
> > ------- End of Original Message -------
> ------- End of Original Message -------
------- End of Original Message -------