On Wed, Apr 7, 2010 at 1:45 AM, Martin Evans <[email protected]> wrote: > Perl Diety wrote: >> We're trying to run a Perl program to connect to an Oracle 10 instance, on a >> RH box. From the xterm it runs fine- connects, R/W, everything is ducky. no >> issues whatsoever. >> >> Then we tried it from a browser (apache server) and it's been a nightmare >> for days. After hours of research and trials, we finally managed to get past >> the "Cannot load Oracle.so"errors by modifying the ld conf file in /etc., >> rebuilding the DBI, etc. > > Did you really set AND export ORACLE_HOME or LD_LIBRARY_PATH such that > Apache children see them? I can't remember what the syntax in the > httpd.conf file is now (SetEnv perhaps) as I no longer use Apache but > you used to have to explicitly tell Apache which env vars to allow.
One other thing you may check on top of what Martin said is that Apache-from-source Apache includes a file called 'envvars' in the $APACHE/bin directory. This file is sourced from 'apachectl', and sets up the Apache run-time environment variables and whatnot. Not all distros use/package this file, so you may not have it, but it's there if you compile from source and use 'apachectl' to start/stop/restart Apache. Thanks, Brian
