Re: failed: ERROR OCIEnvNlsCreate. Check (everything)

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