Re: Error appears in web log but script runs ok on the command line

Richie <[email protected]>
Newsgroups gmane.comp.lang.perl.modules.dbi.general
Message-ID <[email protected]>
Or what about modding the shell or init scripts that start apache and 
make use of PerlPassEnv
http://perl.apache.org/docs/2.0/user/config/config.html#C_PerlPassEnv_

On 10/22/2013 1:50 PM, Alexander Foken wrote:
> Just a wild guess:
>
> mod_perl sets %ENV, but *AFTER* loading DBD::Oracle, so the XS part of 
> DBD::Oracle won't see the required environment variables. It is 
> possible to manipulate %ENV from inside Perl (this includes mod_perl) 
> and then load DBD::Oracle, or at least it was possible for a long time.
>
> I would try to make mod_perl execute something like the following code 
> as early as possible, even before DBI is loaded:
>
> $ENV{'ORACLE_HOME'}='/some/where';
> # maybe set up other Oracle related environment variables
> require DBD::Oracle; # loads the XS part AFTER setting up the environment
>
>
> Alexander
>
>
> On 21.10.2013 23:36, Bruce Johnson wrote:
>> Nope, built and run with the same path, same install. I installed the 
>> Instant Client Basic and Development packages via the rpms, set up 
>> the proper environment variables, used cpan to install DBI, then 
>> DBD::Oracle and both built without any errors.
>>
>> It's absolutely a mod_perl handler thing, I just don't know where the 
>> problem is. It's acting as though it's ignoring its environment 
>> settings, even though a perl script run by that handler says the 
>> environment is correct.
>>
>>
>> On Oct 21, 2013, at 2:19 PM, "Furst, Carl" <[email protected]> wrote:
>>
>
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.