Re: Apache::Test not finding global config file
On Wed, Aug 31, 2005 at 06:19:10PM -0400, Geoffrey Young wrote: > if you can do me the favor of trying a few different configuration scenarios > (including 1.3, non-apxs, /usr/local/apache, etc) and making sure nothing > breaks, that would be great. the box where my matrix used to live had a > hard drive failure, so I'm slowly rebuilding it as I find the time. Besides testing under Apache2, I've tested with /usr/local/apache (this was an Apache1 server and was non-apxs). That's all I have at my disposal. > I've been thinking a bit about this and I think the attached is a better > patch. basically, I think A-T goes through a lot of effort to separate the > current filesystem configuration from the hard-coded stuff in httpd in an > effort to make it easy to roll up an httpd install, move it someplace else, > and still have A-T be able to create a worthy configuration. using > HTTPD_ROOT like that kinda breaks all of that for people expecting the > current behavior, so I'd rather use it as a last-ditch effort than off the > bat. > > can you give it a whirl? I removed your original patch and added this one then tested it under the two systems above. Looks good. Thanks, William -- Knowmad Services Inc. http://www.knowmad.com
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/
Reverse proxy
Hi everybody!
I have a simple reverse proxy question that might be slightly off topic
and I apologise for that!
Do you have to run 2 instances of apache when you want to profit from
the reverse proxy configuration?
Or is it enough to have 2 different Virtual Server running?
Thanks
Denis
Here is my config:
### Frontend
DocumentRoot /home/vservers/mymon/
ServerName frontend.test.at
RewriteEngine On
RewriteCond %{REQUEST_URI} ^(.*)[^\.js]$ ### match anything except .js
files
RewriteRule /(.*?)$ http://127.0.0.1:8330/$1 [P]
Options FollowSymLinks ExecCGI Includes
AddHandler cgi-script .cgi
AddHandler cgi-script .pl
### Backend Server with mod_perl
DocumentRoot /home/vservers/knowledge_base/
ServerName backend.test.at
Options FollowSymLinks ExecCGI Includes
PerlResponseHandler ModPerl::Registry
AddHandler perl-script .pl
Re: MP2 - DBI Problem only under mod_perl: OCIEnvNlsCreate (check ORACLE_HOME and NLS settings)
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) DBI - 1.48 DBD::Oracle 1.16 How about the script and related config or a scaled down script? -- END What doesn't kill us can only make us stronger. Nothing is impossible. Philip M. Gollucci ([EMAIL PROTECTED]) 301.254.5198 Consultant / http://p6m7g8.net/Resume/ Senior Developer / Liquidity Services, Inc. http://www.liquidityservicesinc.com http://www.liquidation.com http://www.uksurplus.com http://www.govliquidation.com http://www.gowholesale.com
Re: Reverse proxy
On Tue, 2005-09-06 at 16:37 +0200, Denis Banovic wrote: > Do you have to run 2 instances of apache when you want to profit from > the reverse proxy configuration? > Or is it enough to have 2 different Virtual Server running? Two separate instances with mod_perl 1 or mod_perl 2 in prefork MPM. It may be possible to set up pooling of interpreters to get a similar benefit without multiple servers when using mod_perl 2 with threads, but I haven't tried this. - Perrin
Re: a faster html::template?
On Mon, 2005-09-05 at 06:42 -0700, Praveen Ray wrote: > XSLT transforms are VERY fast Compared to what? Certainly not compared to HTML::Template. - Perrin
Re: a faster html::template?
On Fri, 2005-09-02 at 10:53 +0800, Foo Ji-Haw wrote: > I'm a happy user of HTML::Template on my mp2 setup. But when it comes > to performance, I notice that to populate a loop of some 1500 records, > the system takes 2-3 seconds on my P4 2GHz machine. Populating the loop happens before running HTML::Template. Are you saying that your code to set up the data is too slow, or that running HTML::Template after setting up the data is too slow? > I tried to load the template with 'cache=>1', but the performance > improvement is not much. It makes a big difference in the actual template processing speed. It will not make any difference in the speed of setting up your data though. - Perrin
Re: Reverse proxy
On Sep 6, 2005, at 11:33 AM, Perrin Harkins wrote: Two separate instances with mod_perl 1 or mod_perl 2 in prefork MPM. It may be possible to set up pooling of interpreters to get a similar benefit without multiple servers when using mod_perl 2 with threads, but I haven't tried this. To elaborate: The benefit of the proxy setup is that you have a stripped down 'vanilla' apache serving static files and proxying to a tricked out mod_perl apache, which uses considerably more memory per process. By running the proxy, vanilla apache serves static files super fast and essentially serves mp2 content off of the proxied server as static. the mp2 server only has to work on generating dynamic content and is more often available to do that then if it were constantly using a connection to server static files. if you run both off of a virtualhost, then you're just having an apache configuration proxying to itself (which should be slower than either using 2 different apaches or just using a virtual host without proxy) You don't need to use apache as a the proxy though - you could use squid or lighttpd There's a really good discussion of this in Practical mod_perl By Stas Bekman, Eric Cholet
Re: MP2 - DBI Problem only under mod_perl: OCIEnvNlsCreate (check ORACLE_HOME and NLS settings)
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 ORACLE_HOME and NLS > settings etc.) This has always turned out to be either not exporting environment variables correctly or permissions problems for me. Double-check your permissions by trying to read the required Oracle files as user "nobody." If you post your config file, someone may be able to spot the problem. - Perrin
Re: MP2 - DBI Problem only under mod_perl: OCIEnvNlsCreate (check ORACLE_HOME and NLS settings)
--- 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 with the > > following error: > > > > ERROR OCIEnvNlsCreate (check ORACLE_HOME and NLS > > settings etc.) > > This has always turned out to be either not exporting > environment > variables correctly or permissions problems for me. > Double-check your > permissions by trying to read the required Oracle files > as user > "nobody." If you post your config file, someone may be > able to spot the > problem. > You can try something like : PerlSetVar ORACLE_HOME /home/oracle/oracle10g or something similar instead of relying upon ORACLE_HOME getting exported from the startup shell. - Praveen __ Click here to donate to the Hurricane Katrina relief effort. http://store.yahoo.com/redcross-donate3/
mod_perl for Koha Library System
Hi all, I'm in the process of testing Koha (http://koha.org) with mod_perl and I'm running into a couple of snags. I get the following errors in the logs: [Tue Sep 06 13:42:09 2005] [error] [client 192.168.2.111] malformed header from script. Bad header=22994: circulation.pl, referer: /cgi-bin/koha/circ/circulation.pl [Tue Sep 06 13:42:09 2005] [warn] /cgi-bin/koha/circ/circulation.pl did not send an HTTP header The result is that '22994' is printed at the top-left of the circulation page. Also, I've noticed that several flags/statuses aren't updated when mod_perl is enabled. I'm not sure if this is a related problem or not. I was helped by phred on IRC who pointed me to the assbackwards method: http://perl.apache.org/docs/2.0/api/Apache2/RequestRec.html#C_assbackwards_ However, It's unclear to me how to implement this in Koha (or even if I'm headed in the right direction). Every script in Koha calls output_html_with_http_headers which takes three arguments: ($query, $cookie, $html). Here's a link to the module that contains that sub: http://cvs.sourceforge.net/viewcvs.py/koha/koha/C4/Interface/CGI/Output.pm?rev=1.2&view=markup Anyone have any suggestion for how to troubleshoot this? Thanks, -- Joshua Ferraro VENDOR SERVICES FOR OPEN-SOURCE SOFTWARE President, Technology migration, training, maintenance, support LibLimeFeaturing Koha Open-Source ILS [EMAIL PROTECTED] |Full Demos at http://liblime.com/koha |1(888)KohaILS
Re: mod_perl for Koha Library System
[Tue Sep 06 13:42:09 2005] [error] [client 192.168.2.111] malformed header from script. Bad header=22994: circulation.pl, referer: /cgi-bin/koha/circ/circulation.pl [Tue Sep 06 13:42:09 2005] [warn] /cgi-bin/koha/circ/circulation.pl did not send an HTTP header I assume this is running under ModPerl::Registry or similiar. I believe you'll want to add http://perl.apache.org/docs/2.0/user/porting/compat.html#C_PerlSendHeader_ aka ... PerlOptions +ParseHeaders Also, be sure that a header _IS_ getting sent. -- END What doesn't kill us can only make us stronger. Nothing is impossible. Philip M. Gollucci ([EMAIL PROTECTED]) 301.254.5198 Consultant / http://p6m7g8.net/Resume/ Senior Developer / Liquidity Services, Inc. http://www.liquidityservicesinc.com http://www.liquidation.com http://www.uksurplus.com http://www.govliquidation.com http://www.gowholesale.com
Re: mod_perl for Koha Library System
Hi Philip,
Thanks for the speedy response. I belive I've got +ParseHeaders
turned on already. How do I check if a header's getting sent (note
that the log message complains that one isn't:
[Tue Sep 06 14:51:59 2005] [error] [client 192.168.3.50] malformed header from
script. Bad header=31583: circulation.pl, referer:
/cgi-bin/koha/circ/circulation.pl
[Tue Sep 06 14:51:59 2005] [warn] /cgi-bin/koha/circ/circulation.pl did not
send an HTTP header
Here's the relevant lines from my apache .conf files (both in
conf.d dir):
koha-httpd.conf :
...snip...
# mod_perl mode
SetHandler perl-script
PerlResponseHandler ModPerl::Registry
PerlOptions +ParseHeaders
Options +ExecCGI
...snip...
--
perl.conf :
LoadModule perl_module modules/mod_perl.so
PerlWarn On
PerlRequire "/build/mod_perl/mod_perl-startup.pl"
---
/build/mod_perl/mod_perl-startup.pl looks like this:
if ( ! {MOD_PERL}) { die "GATEWAY_INTERFACE not Perl!"; }
# see also: http://perl.apache.org/docs/2.0/user/porting/compat.html
use Apache2 ();
# use lib qw(/srv/www/perl-lib);
use lib qw(/build/koha/ /usr/lib/perl5/5.8.3 );
# enable if the mod_perl 1.0 compatibility is needed
use Apache::compat ();
use ModPerl::Util (); #for CORE::GLOBAL::exit
use Apache::RequestRec ();
use Apache::RequestIO ();
use Apache::RequestUtil ();
use Apache::ServerRec ();
use Apache::ServerUtil ();
use Apache::Connection ();
use Apache::Log ();
use APR::Table ();
use ModPerl::Registry ();
use Apache::Const -compile => ':common';
use APR::Const -compile => ':common';
1;
Re: mod_perl for Koha Library System
Joshua Ferraro wrote: turned on already. How do I check if a header's getting sent The easiest is just telnet localhost 80 GET /path HTTP/1.0\n\n And look use Apache2 (); Ew... your mp2 is way old. You should update, http://perl.apache.org/docs/2.0/rename.html -- END What doesn't kill us can only make us stronger. Nothing is impossible. Philip M. Gollucci ([EMAIL PROTECTED]) 301.254.5198 Consultant / http://p6m7g8.net/Resume/ Senior Developer / Liquidity Services, Inc. http://www.liquidityservicesinc.com http://www.liquidation.com http://www.uksurplus.com http://www.govliquidation.com http://www.gowholesale.com
Re: mod_perl for Koha Library System
On Tue, Sep 06, 2005 at 03:09:21PM -0400, Philip M. Gollucci wrote: > Joshua Ferraro wrote: > >turned on already. How do I check if a header's getting sent > The easiest is just telnet localhost 80 > GET /path HTTP/1.0\n\n > And look Hmm ... unfortunately this won't work as there's a whole authentication framework to get past ... any other suggestions? ;-) > >use Apache2 (); > Ew... your mp2 is way old. You should update, my OS package management system reports that I'm running mod_perl 1.99_16-3 (running Fedora Core 3). What's the best way to run a newer version of mod_perl under Fedora Core 3? Should I install from source? Thanks, -- Joshua Ferraro VENDOR SERVICES FOR OPEN-SOURCE SOFTWARE President, Technology migration, training, maintenance, support LibLimeFeaturing Koha Open-Source ILS [EMAIL PROTECTED] |Full Demos at http://liblime.com/koha |1(888)KohaILS
Re: mod_perl for Koha Library System
Joshua Ferraro wrote: Hmm ... unfortunately this won't work as there's a whole authentication framework to get past ... any other suggestions? ;-) You might try LWP or just looking through the code. my OS package management system reports that I'm running mod_perl 1.99_16-3 (running Fedora Core 3). What's the best way to run a newer version of mod_perl under Fedora Core 3? Should I install from source? Probably, You did read that link right, you'll have to modify code when you update. -- END What doesn't kill us can only make us stronger. Nothing is impossible. Philip M. Gollucci ([EMAIL PROTECTED]) 301.254.5198 Consultant / http://p6m7g8.net/Resume/ Senior Developer / Liquidity Services, Inc. http://www.liquidityservicesinc.com http://www.liquidation.com http://www.uksurplus.com http://www.govliquidation.com http://www.gowholesale.com
Re: mod_perl for Koha Library System
On Tue, Sep 06, 2005 at 03:43:55PM -0400, Philip M. Gollucci wrote: > Probably, You did read that link right, you'll have to modify code when you > update. Yep I read the link. However, I think the only code I'll need to change will be the mod_perl_startup.pl that I call from my conf file (as well as some lines in the conf file) as I didn't really add any mod_perl specific code to Koha. Does this sound right? Thanks, -- Joshua Ferraro VENDOR SERVICES FOR OPEN-SOURCE SOFTWARE President, Technology migration, training, maintenance, support LibLimeFeaturing Koha Open-Source ILS [EMAIL PROTECTED] |Full Demos at http://liblime.com/koha |1(888)KohaILS
Re: mod_perl for Koha Library System
Joshua Ferraro wrote: Yep I read the link. However, I think the only code I'll need to change will be the mod_perl_startup.pl that I call from my conf file (as well as some lines in the conf file) as I didn't really add any mod_perl specific code to Koha. Does this sound right? Very possibly yes. -- END What doesn't kill us can only make us stronger. Nothing is impossible. Philip M. Gollucci ([EMAIL PROTECTED]) 301.254.5198 Consultant / http://p6m7g8.net/Resume/ Senior Developer / Liquidity Services, Inc. http://www.liquidityservicesinc.com http://www.liquidation.com http://www.uksurplus.com http://www.govliquidation.com http://www.gowholesale.com
Re: mod_perl for Koha Library System
On Tue, 2005-09-06 at 12:40 -0700, Joshua Ferraro wrote: > > GET /path HTTP/1.0\n\n > > And look > Hmm ... unfortunately this won't work as there's a whole > authentication framework to get past ... Unless you're using SSL, it will work fine. You'd have to learn what to type in though. It's easier to use GET (a tool that comes with LWP), or lynx with --dump-headers. There's also a Firefox plugin that will show the headers. Your problem sounds like an issue I recall others having with numbers showing up in the middle of requests when using HTTP 1.1. I think using the latest mod_perl may fix it, but you might like to look in the mail archives too. I believe Geoff Young was the one who identified the problem last time. - Perrin
Re: mod_perl for Koha Library System
Perrin et al, Thanks for the help thusfar. I upgraded MP2 to 2.0.1 from source. I'm still getting the same problems with statuses not working and header errors. Here's a snip from the log: [Tue Sep 06 17:10:12 2005] [error] [client 192.168.2.59] malformed header from script. Bad header=40069: circulation.pl, referer: /cgi-bin/koha/circ/circulation.pl [Tue Sep 06 17:10:12 2005] [warn] /cgi-bin/koha/circ/circulation.pl did not send an HTTP header [Tue Sep 06 17:10:34 2005] [error] [client 192.168.2.59] malformed header from script. Bad header=40069TYPE html PUBLIC "-//W3C/: circulation.pl, referer: /cgi-bin/koha/circ/circulation.pl [Tue Sep 06 17:10:34 2005] [warn] /cgi-bin/koha/circ/circulation.pl did not send an HTTP header I'll hunt down Geoff's emails and check the headers again, though I suspect that the problem is Koha-related rather than a problem with mod_perl. Thanks, -- Joshua Ferraro VENDOR SERVICES FOR OPEN-SOURCE SOFTWARE President, Technology migration, training, maintenance, support LibLimeFeaturing Koha Open-Source ILS [EMAIL PROTECTED] |Full Demos at http://liblime.com/koha |1(888)KohaILS
Re: mod_perl for Koha Library System
Joshua Ferraro wrote: I'll hunt down Geoff's emails and check the headers again, though I suspect that the problem is Koha-related rather than a problem with mod_perl. If thats indeed the problem, you could always add print "Content-Type: text/html\n\n"; near the top of that cgi. -- END What doesn't kill us can only make us stronger. Nothing is impossible. Philip M. Gollucci ([EMAIL PROTECTED]) 301.254.5198 Consultant / http://p6m7g8.net/Resume/ Senior Developer / Liquidity Services, Inc. http://www.liquidityservicesinc.com http://www.liquidation.com http://www.uksurplus.com http://www.govliquidation.com http://www.gowholesale.com
Re: [PATCH] Apache2::SizeLimit + Linux::Smaps
Torsten Foertsch wrote: Hi, this patch introduces $Apache2::SizeLimit::USE_SMAPS which is 1 by default. If /proc/PID/smaps are not available Apache::SizeLimit resets it to 0 itself. It can be reset by the user if he prefers using /proc/PID/statm before the first size check. If $USE_SMAPS is 1 /proc/PID/smaps are used. Otherwise the old /proc/PID/statm is used. Committed with some style tweaks. Thanks! -- END What doesn't kill us can only make us stronger. Nothing is impossible. Philip M. Gollucci ([EMAIL PROTECTED]) 301.254.5198 Consultant / http://p6m7g8.net/Resume/ Senior Developer / Liquidity Services, Inc. http://www.liquidityservicesinc.com http://www.liquidation.com http://www.uksurplus.com http://www.govliquidation.com http://www.gowholesale.com
Re: MP2 - DBI Problem only under mod_perl: OCIEnvNlsCreate (check ORACLE_HOME and NLS settings)
--- 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 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.)
> >
> > This has always turned out to be either not
> exporting
> > environment
> > variables correctly or permissions problems for
> me.
> > Double-check your
> > permissions by trying to read the required Oracle
> files
> > as user
> > "nobody." If you post your config file, someone
> may be
> > able to spot the
> > problem.
> >
>
> You can try something like :
>
> PerlSetVar ORACLE_HOME /home/oracle/oracle10g
>
> or something similar instead of relying upon
> ORACLE_HOME
> getting exported from the startup shell.
>
> - Praveen
>
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 getting passed to DBI
under mod_perl.
As you can see, in httpd.conf and the cgi script
itself I am trying everything to set the ORACLE_HOME
environment variables. However, in the dbitrace.log
file, it appears nothing has worked. The same script
works under a normal CGI (no mp2) and the dbitrace.log
file shows a healthy set of environment variables.
This looks so simple; why aren't my environment
variables kept under mp2?
Thanks, Tom
httpd.conf (snip)===
LoadModule perl_module modules/mod_perl.so
SetEnv "NLS_LANG" "AMERICAN_AMERICA.UTF8"
PerlSetEnv "NLS_LANG" "AMERICAN_AMERICA.UTF8"
SetEnv ORACLE_HOME
"/home/oracle/product/10.2.0/db_1"
PerlSetEnv ORACLE_HOME
"/home/oracle/product/10.2.0/db_1"
SetEnv LD_LIBRARY_PATH
/home/oracle/product/10.2.0/db_1/lib
PerlSetEnv LD_LIBRARY_PATH
/home/oracle/product/10.2.0/db_1/lib
SetEnv ORACLE_SID tomdb1
PerlSetEnv ORACLE_SID tomdb1
ScriptAlias /cgi-bin/ "/usr/local/apache2/cgi-bin/"
SetHandler perl-script
PerlResponseHandler ModPerl::Registry
PerlOptions +ParseHeaders
Options +ExecCGI
AllowOverride None
Order allow,deny
Allow from all
tomdb1test.pl (CGI script) =
#!/usr/bin/perl
use DBI ;
use strict ;
my ($dbh) ;
$|=1 ;
# This is a CGI script. Debugging problem with modperl
$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'}= "AMERICAN_AMERICA.UTF8" ;
$ENV{'TNS_ADMIN'}= "/home/oracle" ;
# unlink '/tmp/dbitrace.log' if -e
'/tmp/dbitrace.log' ;
DBI->trace( 16, '/tmp/dbitrace.log' ) ;
print "Content-type: text/plain\n\n";
# Print out the Environment and @INC
my $lineCount = 1 ;
foreach my $var (sort(keys(%ENV))) {
my $val = $ENV{$var};
$val =~ s|\n|\\n|g;
$val =~ s|"|\\"|g;
print "[$lineCount] ${var}=\"${val}\"\n";
$lineCount++ ;
}
print "[EMAIL PROTECTED] = ", join("\n ", @INC), "\n" ;
# Log into Oracle
eval {
$dbh =
DBI->connect("dbi:Oracle:host=redhat;sid=tomdb1;port=1521",
'scott', 'tiger') || die "Database Connect Failed: $@
\n $DBI::errstr\n";
} ;
if($@) {
print "Connection to Oracle Failed: $@ \n";
} else {
print "Connection to Oracle Successful\n" ;
$dbh->disconnect;
}
dbitrace.log ==
Environment variables:
LANG=C
TERM=xterm
PATH=/sbin:/usr/sbin:/bin:/usr/bin:/usr/X11R6/bin
PWD=/
SHLVL=1
_=/sbin/initlog
OCINlsEnvironmentVariableGet(1,0,93,0,2)=SUCCESS
OCINlsEnvironmentVariableGet(1,0,94,0,2)=SUCCESS
OCINlsEnvCreate(9361cd4,3,0,0,0,0,0,0,1,1)=ERROR
DESTROY for DBI::db=HASH(0x91ba654) ignored -
handle not initialised
__
Click here to donate to the Hurricane Katrina relief effort.
http://store.yahoo.com/redcross-donate3/
Re: MP2 - DBI Problem only under mod_perl: OCIEnvNlsCreate (check ORACLE_HOME and NLS settings)
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'}= "AMERICAN_AMERICA.UTF8" ;
$ENV{'TNS_ADMIN'}= "/home/oracle" ;
Have you tried adding these to the startup files of the httpd and/or oracle
user?
You don't have any Apache::DBI or connect_on_init() happening right ?
--
END
What doesn't kill us can only make us stronger.
Nothing is impossible.
Philip M. Gollucci ([EMAIL PROTECTED]) 301.254.5198
Consultant / http://p6m7g8.net/Resume/
Senior Developer / Liquidity Services, Inc.
http://www.liquidityservicesinc.com
http://www.liquidation.com
http://www.uksurplus.com
http://www.govliquidation.com
http://www.gowholesale.com
