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:
>>
>