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
