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

Nope, that failed, too. I'm not even trying to use a persistent connection

At this point I believe it's a bug in apache, mod_perl or DBD::Oracle, or some unholy partial bug in all three that's combining to make my life miserable. 

I've been advised to recompile DBD::Oracle with -rpath in the LDFLAGS section of the Makefile, but I'm unable to find any references to this, do I need to specify the path with this flag or not?


On Oct 22, 2013, at 11:06 AM, Richie <[email protected]> wrote:

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

-- 
Bruce Johnson
University of Arizona
College of Pharmacy
Information Technology Group

Institutions do not have opinions, merely customs