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" <[EMAIL PROTECTED]> To: "Oscar Gomez" <[EMAIL PROTECTED]> 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:[EMAIL PROTECTED] > 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" <[EMAIL PROTECTED]> > To: "Oscar Gomez" <[EMAIL PROTECTED]> > Sent: Fri, 21 Jul 2006 10:34:40 -0600 > Subject: RE: (Fwd) dbd-oracle-1.16 > > > Operating System > > > > -----Original Message----- > > From: Oscar Gomez [mailto:[EMAIL PROTECTED] > > 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" <[EMAIL PROTECTED]> > > To: "Oscar Gomez" <[EMAIL PROTECTED]>, <dbi-users@perl.org> > > 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:[EMAIL PROTECTED] > > > 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" <[EMAIL PROTECTED]> > > > To: "Oscar Gomez" <[EMAIL PROTECTED]>, <dbi-users@perl.org> > > > 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:[EMAIL PROTECTED] > > > > 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" <[EMAIL PROTECTED]> > > > > To: "Tim Bunce" <[EMAIL PROTECTED]>, <dbi-users@perl.org> > > > > 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:[EMAIL PROTECTED] > > > > > Sent: Wednesday, July 19, 2006 11:45 PM > > > > > To: dbi-users@perl.org > > > > > Cc: [EMAIL PROTECTED] > > > > > Subject: (Fwd) dbd-oracle-1.16 > > > > > > > > > > ----- Forwarded message from Oscar Gomez <[EMAIL PROTECTED]> > ----- > > > > > > > > > > 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 > > > > <[EMAIL PROTECTED]> > > > > > To: Tim Bunce <[EMAIL PROTECTED]> > > > > > 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 <[EMAIL PROTECTED]> > > > > > To: "Garrett, Philip (MAN-Corporate)" > <[EMAIL PROTECTED]> > > > > > 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</available_drivers>. + +Added in DBI 1.49. + =item > > > > > C<installed_versions> > > > > > > > > > > > > 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 -------