Geoffrey Young wrote:
>
>>
>> people have problems with the Oracle DBD driver and 'SetHandler
>> perl-script' See http://mathforum.org/epigone/modperl/lumfrahku
>>
>
>
> sorry, but I don't have the old thread in my inbox, so I can't reply to it.
> when you chose to print out ORACLE_HOME from Oracle.pm you were actually
> looking in the wrong place. DBD::Oracle requires that ORACLE_HOME (and
> any other stuff like NSL_LANG stuff) be in %ENV when DBD::Oracle is
> compiled (read: first use()d or loaded on demand by DBI.pm).
But Atsushi and the other guy with this problem were able to have this
working under 'SetHandler modperl' that's the weird part, that makes me
wonder why?
> so, you need to make sure that wherever that load happens %ENV is
> properly set.
>
> I'm not sure what's possible now with mod_perl 2.0 wrt startup.pl and
> <Perl> blocks, but you might want to do something like put that BEGIN
> block in your startup.pl instead, followed by
>
> use DBD::Oracle;
> use DBI;
>
> or play with the profile for root, nobody, /etc/profile etc to make sure
> that $ENV{ORACLE_HOME} and friends get populated properly.
>
> you also might want to remove the NSL stuff for the moment and see if
> you can get things working without it. IIRC there was some stuff on the
> DBI users list (a _very_ long time ago) where NSL in %ENV was the issue,
> so maybe boiling down stuff will help you locate the problem (and help
> us see what is required on the mod_perl side in order to fix things).
>
> HTH
>
> --Geoff
>
--
__________________________________________________________________
Stas Bekman JAm_pH ------> Just Another mod_perl Hacker
http://stason.org/ mod_perl Guide ---> http://perl.apache.org
mailto:[EMAIL PROTECTED] http://use.perl.org http://apacheweek.com
http://modperlbook.org http://apache.org http://ticketmaster.com
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
