MP2, SOAP::Lite and Oracle

[Juan Natera <ju...@lunarpages.com>]

Hello,

I have a few custom modules that work nicely in a standalone SOAP::Lite
server. After deciding we needed the performance boost of moving it to
mod_perl 2, we have encountered some issues.

I am getting this error in the apache error_log:

DBI connect('','username',...) failed: ERROR OCIEnvNlsCreate (check
ORACLE_HOME and NLS settings etc.) at /usr/lp/lib/AMS/DB.pm line 32

This is in spite of having:

PerlSetVar ORACLE_HOME "/path"
PerlSetVar TWO_TASK "sidname"

In the perl block of the httpd.conf, in fact, dumping %ENV reveals they
are both set to the correct values.

SOAP::Lite is the latest version + patches from Randy Kobes (porting
SOAP::Lite to MP2):

http://groups.yahoo.com/group/soaplite/message/4329

Any clues?

Thanks in advance,

Juan Natera

Re: MP2, SOAP::Lite and Oracle

["Philippe M. Chiasson" <go...@ectoplasm.org>]

Juan Natera wrote:
> Hello,
> 
> I have a few custom modules that work nicely in a standalone SOAP::Lite
> server. After deciding we needed the performance boost of moving it to
> mod_perl 2, we have encountered some issues.
> 
> I am getting this error in the apache error_log:
> 
> DBI connect('','username',...) failed: ERROR OCIEnvNlsCreate (check
> ORACLE_HOME and NLS settings etc.) at /usr/lp/lib/AMS/DB.pm line 32
> 
> This is in spite of having:
> 
> PerlSetVar ORACLE_HOME "/path"
> PerlSetVar TWO_TASK "sidname"

Shouldn't that be :

PerlSetEnv ORACLE_HOME "/path"
PerlSetENV TWO_TASK "sidname"

?
--------------------------------------------------------------------------------
Philippe M. Chiasson m/gozer\@(apache|cpan|ectoplasm)\.org/ GPG KeyID : 88C3A5A5
http://gozer.ectoplasm.org/     F9BF E0C2 480E 7680 1AE5 3631 CB32 A107 88C3A5A5