MP2 - DBI Problem only under mod_perl: OCIEnvNlsCreate (check ORACLE_HOME and NLS settings)

Hi,

I am struggling with a (simple?) DBI problem under MP2
on Fedora Core 3. A script that uses Oracle-DBI works
under regular CGI but fails under MP2 with the
following error:

ERROR OCIEnvNlsCreate (check ORACLE_HOME and NLS
settings etc.)

My test script dumps out the environment varables and
then attempts to connect to the Oracle server. Other
than the DBI/Oracle error and a few extra MP2-specific
variable that MP2 creates, the output of the script is
identical on the CGI and MP2 versions.

I've tried setting every standard Oracle environment
variable in both httpd.conf (even using both SetEnv
and PerlSetEnv) and in the script itself (NLS_LANG,
ORACLE_HOME, LD_LIBRARY_PATH, ORACLE_SID). What am I
missing? I don't beleive it is a permissions problem
as I've tried running the httpd server as User oracle,
with no difference.

I know this isn't a DBI mail group, but the probem
only occurs under MP2 so I think it is more of an
environment/setup problem. It is a new system, so
everything is installed fresh (all apache/modperl
stuff added after FC3 install).

httpd: 2.0.54
MP2: 2.0.1
Fedora Core 3: 2.6.12-1.1376_FC3
Oracle: 10g Release 2 (10.2.0)
DBI - 1.48
DBD::Oracle 1.16

Thanks, Tom




______________________________________________________
Click here to donate to the Hurricane Katrina relief effort.
http://store.yahoo.com/redcross-donate3/