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 <listm...@triad.rr.com> 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" <carl.fu...@mlb.com> wrote: >>> >> > -- Bruce Johnson University of Arizona College of Pharmacy Information Technology Group Institutions do not have opinions, merely customs
