Authentication Nightmare
Can anyone help me with this really irritating problem. I have written a cgi script that is fired up from a ErrorDocument 403 that redirects a user to a logon screen if they attempt to enter a secure area. I then have a perl module that authenticates the entered username and password against a table in an Oracle Database through DBI/DBD. Once I have authenticated the user I need to allow them to view the particular URL the were originally requesting. Getting the URL isn't a problem but redirecting them is. I have asked this question before and the main advise given was to use the cookie based authentication in the Eagle book but the problem is that this has also got to work for WAP phones.. Ian FrawleySoftware DevelopmentAcquist[EMAIL PROTECTED]0161 222 2400
Re: Authentication Nightmare
Hi Asaf I am actually using a .pm file. I call it like this from httpd.conf: Location /securearea order deny,allow deny from all ErrorDocument 403 /cgi-bin/accessdenied.cgi /Location The ErrorDocument then loads a page called logon.html which kicks off my authentication .pm like this Files logon.html AuthName "Relm" AuthType Basic PerlAuthenHandler Auth require valid-user /Files I know my pm works but I don't know how to redirect to the requested URL Thank Ian - Original Message - From: Asaf Klibansky To: Ian Frawley ; [EMAIL PROTECTED] Sent: Monday, October 16, 2000 4:51 AM Subject: Re: Authentication Nightmare Why not use a .pm file that will include an athentication module.. i call mine weblogin.pm in each secure template just add on top something like: === use weblogin; weblogin::authenticate(); === this will call the authenticate module to run and if the user failed login it will just display a login screen and exit(); good luck! :) asaf - Original Message - From: Ian Frawley To: [EMAIL PROTECTED] Sent: Monday, October 16, 2000 5:41 PM Subject: Authentication Nightmare Can anyone help me with this really irritating problem. I have written a cgi script that is fired up from a ErrorDocument 403 that redirects a user to a logon screen if they attempt to enter a secure area. I then have a perl module that authenticates the entered username and password against a table in an Oracle Database through DBI/DBD. Once I have authenticated the user I need to allow them to view the particular URL the were originally requesting. Getting the URL isn't a problem but redirecting them is. I have asked this question before and the main advise given was to use the cookie based authentication in the Eagle book but the problem is that this has also got to work for WAP phones.. Ian FrawleySoftware DevelopmentAcquist[EMAIL PROTECTED]0161 222 2400
Re: Authentication Nightmare
Is it simply the "Location" http directive that you need? print "Location: http://www.yourdomain.com/path/to/filename.html\n\n"; For this to work, you must not have printed an html header already, such as "Content-type: text/html\n\n" (or the equivalent in cgi.pm). This is the basic redirect mechanism in http. Ron At 10:41 AM 10/16/00 -0500, Ian Frawley wrote: Can anyone help me with this really irritating problem. I have written a cgi script that is fired up from a ErrorDocument 403 that redirects a user to a logon screen if they attempt to enter a secure area. I then have a perl module that authenticates the entered username and password against a table in an Oracle Database through DBI/DBD. Once I have authenticated the user I need to allow them to view the particular URL the were originally requesting. Getting the URL isn't a problem but redirecting them is. I have asked this question before and the main advise given was to use the cookie based authentication in the Eagle book but the problem is that this has also got to work for WAP phones.. Ian Frawley Software Development Acquist mailto:[EMAIL PROTECTED]>[EMAIL PROTECTED] 0161 222 2400
RE: can't build with 1.3.14 apache?
-Original Message- From: Rick Myers [mailto:[EMAIL PROTECTED]] Sent: Saturday, October 14, 2000 10:21 PM To: [EMAIL PROTECTED] Subject: Re: can't build with 1.3.14 apache? On Oct 14, 2000 at 12:06:29 -0700, [EMAIL PROTECTED] twiddled the keys to say: Try the patch to apache-1.3.14/src/include/httpd.h below. Worked for me. I had the same problem last night. As it turned out, the current cvs modperl version fixed it. (Hint: It's in Makefile.PL) for the record... from Changes for 1.24_02: support version parsing of 1.3.13-dev's httpd.h this change is in 1.24_01, which can be found on CPAN... HTH --Geoff Hello again bleeding edge. :) Rick Myers[EMAIL PROTECTED] The Feynman Problem 1) Write down the problem. Solving Algorithm 2) Think real hard. 3) Write down the answer.
[DIGEST] mod_perl digest 10/8/2000
-- mod_perl digest October 8, 2000 - October 14, 2000 -- Recent happenings in the mod_perl world... Features o mod_perl status o cvs development o module announcements o mailing list highlights o news o links mod_perl status o mod_perl - stable: 1.24_01 (released October 10, 2000) [1] - development: 1.24_02-dev [2] o Apache - stable: 1.3.14 (released October 13, 2000) [3] - development: 1.3.15-dev [4] o Perl - stable: 5.6 (released March 23, 2000) [5] - development: 5.7 [6] cvs development o fix bug in $r-args that treats ?0 as the empty string instead of zero (part of 1.24_01 release) [7] o new Apache::test::static_modules() method [8] module announcements o mod_perl 1.24_01 was officially released this week, bringing with it many, many fixes [9]. Some noteworthy ones are: - proper support for determining version of Apache 1.3.13 - fix for memory leak in DIR_MERGE sections for anyone using Apache::ModuleConfig - $r-content does not hang the server if called more than once - PerlSetupEnv Off now merges properly o Apache::ProxyStuff 0.08 - adding headers and footers to content proxied from other web servers by "stuffing" the header and footer into their correct places in the content [10] mailing list highlights o Users of RedHat 7.0 are reporting various problems [11] [12] o Using XML::Parser with mod_perl requires compiling Apache with RULE_EXPAT=no [13] [14] o There was a rather lengthy discussion on the merits of using an RDBMS system versus flat files [15] o Yet another database connection pooling discussion [16] o Some changes may be coming for ActivePerl users of Apache::ASP for retrieving individual items from the query string [17] o Users wishing to upgrade their Apache to 1.3.14 may have to upgrade mod_perl to 1.24_01 to be able to make mod_perl without patching Makefile.PL or httpd.h [18] news o Apache 1.3.14 was released this week [19]. New features of note: - If ServerConfigFile, AccessConfig, or ResourceConfig are directories Apache will parse all the files in that directory - Security bug fix in mod_rewrite that could allow access to the entire filesystem - NameVirtualHost directive can now take "*" as an argument, which will match connections to any address that isn't configured with a more specific vhost directive - AddType and AddEncoding now have corresponding RemoveType and RemoveEncoding directives - More Windows and NetWare patches than you can shake a stick at see Changes [20] for a full list of new features and bug fixes links o The Apache/Perl Integration Project [21] o mod_perl documentation [22] o mod_perl modules on CPAN [23] o mod_perl homepage [24] o mod_perl list archives [25] [26] happy mod_perling... --Geoff [EMAIL PROTECTED] -- [1] http://perl.apache.org/dist/ [2] http://perl.apache.org/from-cvs/modperl/ [3] http://www.apache.org/dist/ [4] http://dev.apache.org/from-cvs/apache-1.3/ [5] http://www.perl.com/pub/language/info/software.html#stable [6] http://www.perl.com/pub/language/info/software.html#devel [7] http://archive.covalent.net/modperl-cvs/2000/10/0010.xml [8] http://marc.theaimsgroup.com/?l=apache-modperl-cvsm=97145767909785w=2 [9] http://forum.swarthmore.edu/epigone/modperl/prorclaxlou [10] http://forum.swarthmore.edu/epigone/modperl/snangstoifrimp [11] http://forum.swarthmore.edu/epigone/modperl/skeldahmox [12] http://forum.swarthmore.edu/epigone/modperl/ziljeldsmul [13] http://forum.swarthmore.edu/epigone/modperl/grehchandfree [14] http://forum.swarthmore.edu/epigone/modperl/kehveekhex [15] http://forum.swarthmore.edu/epigone/modperl/whalthixgrol [16] http://forum.swarthmore.edu/epigone/modperl/smergalny [17] http://forum.swarthmore.edu/epigone/modperl/whoigontha [18] http://forum.swarthmore.edu/epigone/modperl/chilstilshar [19] http://www.apacheweek.com/issues/00-10-13 [20] http://www.apache.org/dist/CHANGES_1.3 [21] http://perl.apache.org [22] http://perl.apache.org/#docs [23] http://www.perl.com/CPAN-local/modules/by-module/Apache/ [24] http://www.modperl.com [25] http://forum.swarthmore.edu/epigone/modperl/ [26] http://archive.covalent.net/mod
Apache error
Hi friends, Someone out there could tell me how can I fix the following Apache error: HTTP/1.1 500 Internal Server Error Date: Mon, 16 Oct 2000 15:02:20 GMT Server: Apache/1.3.6 (Unix) mod_perl/1.21 Last-Modified: Thu, 16 Mar 2000 11:05:19 GMT ETag: "84c8-536-38d0bfef" Accept-Ranges: bytes Content-Length: 1334 Connection: close Content-Type: text/html Thank you in advance. Ben __ Do You Yahoo!? Yahoo! Messenger - Talk while you surf! It's FREE. http://im.yahoo.com/
Re: Apache error
Kader Ben wrote: Someone out there could tell me how can I fix the following Apache error: HTTP/1.1 500 Internal Server Error Date: Mon, 16 Oct 2000 15:02:20 GMT Is there anything to see in the error_log?
Re: Apache error
Thanks fro your prompt replies. I found just the following message error (in errors log): [Mon Oct 16 10:20:13 2000] [warn] (22)Invalid argument: setsockopt: (TCP_NODELAY) Ben --- "Alexander Farber (EED)" [EMAIL PROTECTED] wrote: Kader Ben wrote: Someone out there could tell me how can I fix the following Apache error: HTTP/1.1 500 Internal Server Error Date: Mon, 16 Oct 2000 15:02:20 GMT Is there anything to see in the error_log? __ Do You Yahoo!? Yahoo! Messenger - Talk while you surf! It's FREE. http://im.yahoo.com/
Code Reuse (newbie question)
Basically I'm a bit stumped by how perl lets us reuse code snippets. I
can't seem to bend modules to what I need to do exactly:
I'm using Apache and mod_perl. Each perl script will produce a dynamic web
page. Now, with each script I need to recover the session variables I'm
saving (using Apache:Session:File) and also verify account name and
password:
#
use vars qw(%session);
eval { tie %session, 'Apache::Session::File', $authid, { Directory =
'/tmp/sessions' } };
if ($@) { print redirect("LOGIN.pl?CAUSE=FailedSessionTie"); exit; }
if (time() $session{expire_time}) { print
redirect("LOGIN.pl?CAUSE=TIMED_OUT"); exit; }
$session{expire_time} = time() + SURVEYDESIGN::survey_expire();
#
Basically this chuck of code that I want to replicate across scripts is
going to grow/shrink/change rapidly in the coming weeks as I toy with the
project.
My problem seems to be that I can not include/inherit a chunk of text, but
rather need to place code in a separate package for reuse. But I don't see
how that allows me to recover sessions and setup variables in the main
package.
Any input (or a redirection to a good FAQ) would be very welcome! Thanks.
Daniel Hutchison
Target Analysis Group
mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED]
617.583.8411
Re: Apache error
Oops! During the last week end there are a lot of messages like this: [Sat Oct 14 17:31:47 2000] [error] Out of memory during "large" request for 2101248 bytes at /opt/perl5/lib/site_perl/5.005/sun4-solaris/DBD/Oracle.pm line 262. Ben -- --- Kader Ben [EMAIL PROTECTED] wrote: Thanks fro your prompt replies. I found just the following message error (in errors log): [Mon Oct 16 10:20:13 2000] [warn] (22)Invalid argument: setsockopt: (TCP_NODELAY) Ben --- "Alexander Farber (EED)" [EMAIL PROTECTED] wrote: Kader Ben wrote: Someone out there could tell me how can I fix the following Apache error: HTTP/1.1 500 Internal Server Error Date: Mon, 16 Oct 2000 15:02:20 GMT Is there anything to see in the error_log? __ Do You Yahoo!? Yahoo! Messenger - Talk while you surf! It's FREE. http://im.yahoo.com/ __ Do You Yahoo!? Yahoo! Messenger - Talk while you surf! It's FREE. http://im.yahoo.com/
Help:analysis of PerlModule Apache::Registry
hi friends, i am a newcomer to modperl and have managed to start running it with apache on linux.. but now when it comes to coding i find that my previos cgi scripts are running under modperl in the same way. As i understand.there is some improvement in speed since now the perl interpretor is a part of apache. but in addition. how do i start writing perl so as to take advantage of modperl better..?? Plus can anyone explain to me the semantics/usage of the following in my httpd.conf and how i can change it to suit me better. PerlModule Apache::Registry Location /perl SetHandler perl-script PerlHandler Apache::Registry Options ExecCGI allow from all PerlSendHeader On /Location Thanks, in advance. Samir _ Get Your Free Email At, http://www.rediffmail.com For fabulous shopping deals visit: http://www.rediff.co.in/shopping/index.html
DBI/PostgreSQL/MySQL mod_perl intermittent problem
Hi, I've been having a problem using any Database with mod_perl. This problem has persisted across two separate platforms. I found it initially whilst working on one contract, and it has popped up again on a new contract. Firstly, the initial setup. I was using DBI with MySQL - and I had some scripts written up as modules. I had a simple main script which called these modules - so it was easy to set up an environment where one script defined handler for mod_perl, and the other was a standard #!/usr/bin/perl CGI script. I configured Apache/mod_perl so that through one location, the usual CGI script got run, and the other location ran through mod_perl. When running under the mod_perl location, DB calls would intermittently fail or succeed, with no variables that I could discern dictating when either would happen. However, the application ran 100% through the #!/usr/bin/perl CGI method. At the time, I gave up and just used #!/usr/bin/perl. I'm now on this new contract, and it's happening again. There's a session system going on, so that's where it shows itself first. The guys here are using Embperl, so there's no simple dual-script option. I switched on trace for the DBI module and couldn't find anything new from it. I might persist in this way as there are a lot of debug options. Thing is, this time the database is PostgreSQL. It's possible that this problem is only appearing when numerous calls are made to the server - as some people are using the Embperl written pages to input data, and they don't experience any problems. But me, when I'm clicking around, hitting reload again again, I get up it up on off. I've done searches through Altavista/Google and Northern Light - and searches through Geocrawler on this mailing list. I haven't been able to find anyone else sharing these problems - which is real strange to me 'cause these problems have persisted across completely different projects. I should probably note that I've used Apache::DBI on and off to see if it makes any difference. Maybe it's PostgreSQL settings? I'll try increasing logging options and stuff. But any help someone can offer now would be greatly appreciated. Thanks for your time, Rajit
mod_proxy heavy server problems
Hi, I looked through the archives and get get a definitive answer on this so I feel I need to make this post. Hope someone can help. I'm running perl5.6, mod_proxy on apache 1.3.12 on osf 4.0F. I start heavy server and everything is fine but after a certain amount of time I start getting "200 0" in the access log and browser displays "document contains no data". It appears as thought a httpd process gets dorked and can't send the data to stdout. killing the pid relieves the symptoms until the next httpd process does the same. It seems that the frequency of the dorked process increases as the load on the server increases. I have MaxRequestsPerChild =100 in an attempt to kill the process before it gets dorked but the # of requests it takes to get the process in that state varies. Any help would be greatly appreciated. Thanks, Gerry Loon begin:vcard n:Loon;Gerry tel;fax:401 331-3842 tel;work:401 455-4019 x-mozilla-html:FALSE url:http://www.ams.org org:American Mathematical Society;Electronic Product Development adr:;;201 Charles St.;Providence;RI;02904; version:2.1 email;internet:[EMAIL PROTECTED] title:Sr. Programmer/Analyst fn:Gerry Loon end:vcard
ht_time vs. strftime
Hi All,
Can anyone tell me why these are not equivalent? Shouldn't strftime know
that the time returned from gmtime() is GMT? I'm trying to create a
library that'll use ht_time when $ENV{MOD_PERL} is true, ans strftime
otherwise. But they need to be consistent!
use Apache::Util 'ht_time';
my $t = ht_time;
print "$t\n"; # prints "Mon, 16 Oct 2000 20:33:42 GMT"
use POSIX 'strftime';
my $a = strftime("%a, %d %b %Y %T %Z", gmtime);
print "$a\n"; # prints Mon, 16 Oct 2000 21:33:42 PDT
Thanks!
David
--
David E. Wheeler
Software Engineer
Salon Internet ICQ: 15726394
[EMAIL PROTECTED] AIM: dwTheory
Re: ht_time vs. strftime
On Mon, 16 Oct 2000, David E. Wheeler wrote:
Hi All,
Can anyone tell me why these are not equivalent? Shouldn't strftime know
that the time returned from gmtime() is GMT? I'm trying to create a
library that'll use ht_time when $ENV{MOD_PERL} is true, ans strftime
otherwise. But they need to be consistent!
use Apache::Util 'ht_time';
my $t = ht_time;
print "$t\n"; # prints "Mon, 16 Oct 2000 20:33:42 GMT"
use POSIX 'strftime';
my $a = strftime("%a, %d %b %Y %T %Z", gmtime);
print "$a\n"; # prints Mon, 16 Oct 2000 21:33:42 PDT
Sadly gmtime doesn't return any component indicating the timezone. Of
course why not print out GMT instead of %Z?
Alternatively, why not use Time::Object? It implements strftime without
the overhead of POSIX.pm, and does it in XS too.
--
Matt/
/||** Director and CTO **
//||** AxKit.com Ltd ** ** XML Application Serving **
// ||** http://axkit.org ** ** XSLT, XPathScript, XSP **
// \\| // ** Personal Web Site: http://sergeant.org/ **
\\//
//\\
// \\
Re: ht_time vs. strftime
Matt Sergeant wrote:
Sadly gmtime doesn't return any component indicating the timezone. Of
course why not print out GMT instead of %Z?
Because it won't always be GMT.
Alternatively, why not use Time::Object? It implements strftime without
the overhead of POSIX.pm, and does it in XS too.
Does it know Time Zones? Here's what I've got so far. The idea is to get
$format_date to work correctly everywhere.
BEGIN {
if ($ENV{MOD_PERL}) {
use Apache::Util;
$format_date = \Apache::Util::ht_time;
} else {
use POSIX;
$format_date = sub {
POSIX::strftime($_[1] || "%a, %d %b %Y %T %Z", $_[0] ?
localtime($_[0]) : gmtime);
};
}
}
Thanks,
David
--
David E. Wheeler Phone: (415) 645-9365
Software Engineer Fax: (415) 645-9204
Salon Internet ICQ: 15726394
[EMAIL PROTECTED] AIM: dwTheory
[patch] Apache::SizeLimit
under 'Warn On' Apache::SizeLimit prints:
Use of uninitialized value.
because post_connection() expects a return status from the callback
function. This patch fixes this:
(I'm not sure whether OK, is the right status, maybe DECLINED is the best)
--- Apache/SizeLimit.pm.origMon Oct 16 22:48:18 2000
+++ Apache/SizeLimit.pm Mon Oct 16 22:55:21 2000
@@ -172,9 +172,9 @@
sub exit_if_too_big {
my $r = shift;
-return if ($REQUEST_COUNT++ $CHECK_EVERY_N_REQUESTS);
+return OK if ($REQUEST_COUNT++ $CHECK_EVERY_N_REQUESTS);
$REQUEST_COUNT = 1;
-if (defined($MAX_PROCESS_SIZE)) {
+if ($MAX_PROCESS_SIZE) {
my $size = $HOW_BIG_IS_IT();
if ($size $MAX_PROCESS_SIZE) {
# I have no idea if this will work on anything but UNIX
@@ -188,6 +188,7 @@
} else {
error_log("you didn't set
\$Apache::SizeLimit::MAX_PROCESS_SIZE");
}
+return OK;
}
# setmax can be called from within a CGI/Registry script to tell the
httpd
I've the same problem in Apache::GTopLimit -- will fix it.
_
Stas Bekman JAm_pH -- Just Another mod_perl Hacker
http://stason.org/ mod_perl Guide http://perl.apache.org/guide
mailto:[EMAIL PROTECTED] http://apachetoday.com http://jazzvalley.com
http://singlesheaven.com http://perlmonth.com perl.org apache.org
Re: ht_time vs. strftime
On Mon, 16 Oct 2000, David E. Wheeler wrote:
Matt Sergeant wrote:
Sadly gmtime doesn't return any component indicating the timezone. Of
course why not print out GMT instead of %Z?
Because it won't always be GMT.
I'm confused. Why are you using gmtime then?
Alternatively, why not use Time::Object? It implements strftime without
the overhead of POSIX.pm, and does it in XS too.
Does it know Time Zones?
It just does strftime, so you can do what you've got below without loading
POSIX. Plus its OO so it makes more sense (IMHO).
Here's what I've got so far. The idea is to get
$format_date to work correctly everywhere.
BEGIN {
if ($ENV{MOD_PERL}) {
use Apache::Util;
$format_date = \Apache::Util::ht_time;
} else {
use POSIX;
$format_date = sub {
POSIX::strftime($_[1] || "%a, %d %b %Y %T %Z", $_[0] ?
localtime($_[0]) : gmtime);
};
I'm not sure I understand the correctness of this. Shouldn't it be:
gmtime($_[0] || time)
or
localtime($_[0] || time)
??
--
Matt/
/||** Director and CTO **
//||** AxKit.com Ltd ** ** XML Application Serving **
// ||** http://axkit.org ** ** XSLT, XPathScript, XSP **
// \\| // ** Personal Web Site: http://sergeant.org/ **
\\//
//\\
// \\
Re: ht_time vs. strftime
Matt Sergeant wrote:
On Mon, 16 Oct 2000, David E. Wheeler wrote:
I'm confused. Why are you using gmtime then?
Because if no time is supplied, I want it to default to GMT. I'm setting
up an app in which the database will store date/time in GMT only, but
will serve it out to users in their own local timezones. So sometimes
it'll be GMT and sometimes it won't.
Does it know Time Zones?
It just does strftime, so you can do what you've got below without loading
POSIX. Plus its OO so it makes more sense (IMHO).
So %Z still won't work properly when I use gmtime.
I'm not sure I understand the correctness of this. Shouldn't it be:
gmtime($_[0] || time)
or
localtime($_[0] || time)
No, because if no time is supplied, I want UTC. If a time is supplied, I
want no alteration to that time (gmtime would correct it). The goal is
to get it to act exactly as ht_time does. Maybe this:
BEGIN {
if ($ENV{MOD_PERL}) {
use Apache::Util;
$format_date = \Apache::Util::ht_time;
} else {
use POSIX;
$format_date = sub {
POSIX::strftime($_[1] || $_[0] ? "%a, %d %b %Y %T %Z" :
"%a, %d %b %Y %T GMT", $_[0] ? localtime($_[0]) :
(gmtime)[0..7]);
};
}
}
Which also corrects for the one hour difference between them (why would
gmtime() ever return true for daylight savings??? It does!
D
--
David E. Wheeler
Software Engineer
Salon Internet ICQ: 15726394
[EMAIL PROTECTED] AIM: dwTheory
Finding the value of KeepAlive
Hi, If I add this line to my httpd.conf file, BrowserMatchNoCase mac nokeepalive will it turn off keepalive ONLY for Macs? And how can I tell if it is working? I've tried using the dir_config method of the request object, but can't seem to tell whether keepalive is on or off. Thank You, Dana C. Chandler III
Re: DBI/PostgreSQL/MySQL mod_perl intermittent problem
- Original Message - From: "Rajit Singh" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, October 16, 2000 8:58 AM Subject: DBI/PostgreSQL/MySQL mod_perl intermittent problem I should probably note that I've used Apache::DBI on and off to see if it makes any difference. Did it? One possibility, especially with Apache::DBI is that you are exceeding the maximum number of connections the database is configured to allow. With MySQL you can use 'mysqladmin status' or 'mysqladmin processlist' to see the number of backends and what they are doing. With PostgreSQL you may have to use ps and count the postgres processes. Les Mikesell [EMAIL PROTECTED]
new win32 mod_perl ppm version
Hi, There's a new mod_perl ppm package available for Win32 ActivePerl that can be installed via ppm install http://theoryx5.uwinnipeg.ca/ppmpackages/mod_perl.ppd This also fetches the required ApacheModulePerl.dll. This was compiled against apache_1.3.14, and the latest cvs mod_perl sources were used. The previous mod_perl ppd, compiled against apache_1.3.12, is still available as mod_perl-apache_1.3.12.ppd at the above location. Note that ApacheModulePerl.dll compiled under apache_1.3.12 isn't compatible with apache_1.3.14, so if one upgrades apache, one must upgrade the mod_perl binary and ApacheModulePerl.dll as well. best regards, randy kobes
Re: DBI/PostgreSQL/MySQL mod_perl intermittent problem
Hi, I've been having a problem using any Database with mod_perl. This problem has persisted across two separate platforms. I found it initially whilst working on one contract, and it has popped up again on a new contract. Which version of mod_perl you are using? Is mod_perl compiled as DSO? if Yes make sure you have at least mod_perl 1.22! Any errors in the logfiles? Gerald - Gerald Richterecos electronic communication services gmbh Internetconnect * Webserver/-design/-datenbanken * Consulting Post: Tulpenstrasse 5 D-55276 Dienheim b. Mainz E-Mail: [EMAIL PROTECTED] Voice:+49 6133 925151 WWW:http://www.ecos.de Fax: +49 6133 925152 - Firstly, the initial setup. I was using DBI with MySQL - and I had some scripts written up as modules. I had a simple main script which called these modules - so it was easy to set up an environment where one script defined handler for mod_perl, and the other was a standard #!/usr/bin/perl CGI script. I configured Apache/mod_perl so that through one location, the usual CGI script got run, and the other location ran through mod_perl. When running under the mod_perl location, DB calls would intermittently fail or succeed, with no variables that I could discern dictating when either would happen. However, the application ran 100% through the #!/usr/bin/perl CGI method. At the time, I gave up and just used #!/usr/bin/perl. I'm now on this new contract, and it's happening again. There's a session system going on, so that's where it shows itself first. The guys here are using Embperl, so there's no simple dual-script option. I switched on trace for the DBI module and couldn't find anything new from it. I might persist in this way as there are a lot of debug options. Thing is, this time the database is PostgreSQL. It's possible that this problem is only appearing when numerous calls are made to the server - as some people are using the Embperl written pages to input data, and they don't experience any problems. But me, when I'm clicking around, hitting reload again again, I get up it up on off. I've done searches through Altavista/Google and Northern Light - and searches through Geocrawler on this mailing list. I haven't been able to find anyone else sharing these problems - which is real strange to me 'cause these problems have persisted across completely different projects. I should probably note that I've used Apache::DBI on and off to see if it makes any difference. Maybe it's PostgreSQL settings? I'll try increasing logging options and stuff. But any help someone can offer now would be greatly appreciated. Thanks for your time, Rajit
