Re: MP2 - DBI Problem only under mod_perl: OCIEnvNlsCreate - MOSTLY SOLVED

2005-09-07 Thread Thomas Hilbig
--- Geoffrey Young <[EMAIL PROTECTED]> wrote: > > DBD::Oracle needs these variables when DBD::Oracle > is loaded. which means > they need to be in %ENV _before_ the script that > first use()s DBD::Oracle is > loaded. httpd.conf is generally too late if you > preload your modules via a > startup.

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

2005-09-07 Thread Geoffrey Young
> 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? DBD::Oracle needs these variables when DBD::Oracle is loaded. whi

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

2005-09-07 Thread Thomas Hilbig
--- Perrin Harkins <[EMAIL PROTECTED]> wrote: > > See PerlPassEnv: >http://perl.apache.org/docs/1.0/guide/config.html#PerlSetEnv_and_PerlPassEnv This didn't help, as expected since I already had the PerlSetEnv in my httpd.conf file. PerlSetEnv sets and passes the environment variables; but I did

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

2005-09-07 Thread Thomas Hilbig
--- "Philip M. Gollucci" <[EMAIL PROTECTED]> wrote: > Thomas Hilbig wrote: > > > $ENV{ORACLE_HOME}='/home/oracle/product/10.2.0/db_1'; > > $ENV{'ORACLE_SID'}="tomdb1"; > > > > > $ENV{'LD_LIBRARY_PATH'}="/home/oracle/product/10.2.0/db_1/lib"; > > $ENV{'LD_ASSUME_KERNEL'} = "2.4.1" ; > > $

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

2005-09-07 Thread Perrin Harkins
On Tue, 2005-09-06 at 20:01 -0700, Thomas Hilbig wrote: > It does not appear to be a permissions problem (I've > run the httpd as User oracle), but turning on DBI > tracing the problem does look like an environment > variable problem. The ORACLE_HOME and other > environment variables are not gettin

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

2005-09-06 Thread Philip M. Gollucci
Thomas Hilbig wrote: $ENV{ORACLE_HOME}='/home/oracle/product/10.2.0/db_1'; $ENV{'ORACLE_SID'}="tomdb1"; $ENV{'LD_LIBRARY_PATH'}="/home/oracle/product/10.2.0/db_1/lib"; $ENV{'LD_ASSUME_KERNEL'} = "2.4.1" ; $ENV{'LD_PRELOAD'} = "/usr/lib/libInternalSymbols.so" ; $ENV{'NLS_LANG'}= "AMERI

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

2005-09-06 Thread Thomas Hilbig
--- Praveen Ray <[EMAIL PROTECTED]> wrote: > --- Perrin Harkins <[EMAIL PROTECTED]> wrote: > > > On Tue, 2005-09-06 at 06:23 -0700, Thomas Hilbig > wrote: > > > I am struggling with a (simple?) DBI problem > under MP2 > > > on Fedora Core 3. A

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

2005-09-06 Thread Praveen Ray
--- Perrin Harkins <[EMAIL PROTECTED]> wrote: > On Tue, 2005-09-06 at 06:23 -0700, Thomas Hilbig wrote: > > 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 w

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

2005-09-06 Thread Perrin Harkins
On Tue, 2005-09-06 at 06:23 -0700, Thomas Hilbig wrote: > 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 O

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

2005-09-06 Thread Philip M. Gollucci
Thomas Hilbig wrote: 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: httpd: 2.0.54 MP2: 2.0.1 Fedora Core 3: 2.6.12-1.1376_FC3 Oracle: 10g Release 2 (10.2.0

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

2005-09-06 Thread Thomas Hilbig
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

Re: Nasty ENV-Setting on Freebsd [was Re: DBI problem]

2005-07-07 Thread Philip M. Gollucci
Tom Schindl wrote: So if one of the free-bsd maintainers is reading this list it would be nice if: a) /etc/profile is patched and PERL5LIB is removed or set to a meaningful value which doesn't hurt anyone. b) before starting apache resetting the PERL5LIB on FBSD 6-current cat /etc/profile

Nasty ENV-Setting on Freebsd [was Re: DBI problem]

2005-07-07 Thread Tom Schindl
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Just to close this thread a give a solution to users running into the same problem: What was the problem: - - Because one of the entries in the INC-Path was "/usr/local/lib/perl5/site_perl/5.8.7/mach/Bundle" at a very early positio

Re: DBI problem

2005-07-07 Thread Tom Schindl
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Tom Schindl schrieb: > Niklas Saers schrieb: > >>>Forgot to post to the list. A little thing I forgot in the private > > > [...] > > >>>Include: >>>/my/include/modperl;/usr/local/lib/perl5/site_perl/5.8.7/mach/Bundle;/usr/local/lib/perl5/site_per

Re: DBI problem

2005-07-07 Thread Tom Schindl
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Niklas Saers schrieb: > Hi again, Tom, > no problem running it as a CGI: > > Include: > /usr/local/lib/perl5/site_perl/5.8.7/mach;/usr/local/lib/perl5/site_perl/5.8.7;/usr/local/lib/perl5/site_perl;/usr/local/lib/perl5/5.8.7/BSDPAN;/usr/local/lib/per

Re: DBI problem

2005-07-07 Thread Tom Schindl
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Niklas Saers schrieb: > Forgot to post to the list. A little thing I forgot in the private [...] > Include: > /my/include/modperl;/usr/local/lib/perl5/site_perl/5.8.7/mach/Bundle;/usr/local/lib/perl5/site_perl/5.8.7/mach;/usr/local/lib/perl5/site_pe

Re: DBI problem

2005-07-07 Thread Niklas Saers
Hi again, Tom, no problem running it as a CGI: Include: /usr/local/lib/perl5/site_perl/5.8.7/mach;/usr/local/lib/perl5/site_perl/5.8.7;/usr/local/lib/perl5/site_perl;/usr/local/lib/perl5/5.8.7/BSDPAN;/usr/local/lib/perl5/5.8.7/mach;/usr/local/lib/perl5/5.8.7;. Loaded Libs: warnings/register.pm;C

Re: DBI problem

2005-07-07 Thread Tom Schindl
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Niklas Saers schrieb: > Forgot to post to the list. A little thing I forgot in the private [...] > Its worth noting that $DBI::VERSION doesn't print anything. That's really really strange. > /usr/local/lib/perl5/site_perl/5.8.7/mach is in my path bu

Re: DBI problem

2005-07-07 Thread Niklas Saers
Forgot to post to the list. A little thing I forgot in the private mail, adding "PerlModule Apache::DBI DBD::Mysql" in my httpd.conf gave me the following warning: [error] Can't locate object method "require_version" via package "DBI" (perhaps you forgot to load "DBI"?) at /usr/local/lib/perl5/sit

Re: DBI problem

2005-07-07 Thread Tom Schindl
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Niklas Saers schrieb: > Hi guys, > thank you very much for helping out. :-) > > John, I have installed the modules and the script runs when running it > as a CGI. What I don't know is if the driver has been installed for > mod_perl as I don't know how

Re: DBI problem

2005-07-07 Thread Niklas Saers
l::Registry PerlOptions +ParseHeaders What is startup.pl and where should it be located? Adding that gives: [error] Can't load Perl file: startup.pl for server www.ab.no:80, exiting... Adding that PerlSwitches statement didn't solve the DBI problem. Adding the line in C2 didn't either. Cheers Nik

Re: DBI problem

2005-07-07 Thread Tom Schindl
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, Too few input to help you: a) Show us your config? Are you running it as an Registry-Script? b) What version of mod_perl are you using? c) Modify include path with: 1. In httpd.conf(see http://perl.apache.org/docs/2.0/user/config/config.html):

RE: DBI problem

2005-07-06 Thread David Christensen
Niklas Saers wrote: > ... The perl script below works fine as a CGI from Apache. But when > running it through mod_perl, I get: > [error] Can't locate object method "connect" via package "DBI" > (perhaps you forgot to load "DBI"?) at /home/ab1/test5.pl line 5.\n > ... > use DBI(); > print "Content-

DBI problem

2005-07-06 Thread Niklas Saers
Dear All, I'm trying out mod_perl and I've been running into problem. The perl script below works fine as a CGI from Apache. But when running it through mod_perl, I get: [error] Can't locate object method "connect" via package "DBI" (perhaps you forgot to load "DBI"?) at /home/ab1/test5.pl line 5.