Apache::DBI and mod_ssl problems

[Yann Ramin <at...@atrustrivalie.eu.org>]

Hi,

I know what you're thinking, yet another mod_ssl problem :)

Anyway, I'm trying to run a test (and limited production) server using 
mod_perl.  I have a great and wonderful mod_perl site working, complete with 
Apache::Registry/Apache::Request scripts working (all loaded objects).

My scripts access a PostgreSQL database.  When I moved my mod_perl 
configuration to two virtual servers (one ssl on port 443, one not on port 
80), somehow Apache::DBI kept connections open but was not reusing them, and 
over 10 or so requests, PostgreSQL would start refusing connections (and 
mod_perl occasionaly complained that postgres killed its connection without 
its disconnect?) 

Below is an example of my setup.

I had one Location perl handler aliased to two places.

PerlRequire /usr/local/apache/conf/startup.pl
PerlModule Apache::StatINC
PerlModule Apache::DBI
 
<Location /dvf>
SetHandler perl-script
PerlHandler Apache::Registry
Options ExecCGI
allow from all
PerlSendHeader Off
PerlInitHandler Apache::StatINC
</Location>
 
<VirtualHost _default_:80>
 
ServerName www.dvfootage.com
DocumentRoot /usr/local/dvf/static_html
 
Alias /dvf "/usr/local/dvf/web"
Alias /images "/usr/local/dvf/images"
Alias /mov_img "/usr/local/dvf/mov_img"
 
</VirtualHost>
 
<IfDefine SSL>
 
<VirtualHost _default_:443>
 
#  General setup for the virtual host
DocumentRoot "/usr/local/dvf/static_html" 
ServerName www.dvfootage.com
ServerAdmin atrus@www.dvfootage.com
ErrorLog /usr/local/apache/logs/error_log
TransferLog /usr/local/apache/logs/access_log
 
Alias /dvf "/usr/local/dvf/web_ssl"
Alias /images "/usr/local/dvf/images"
Alias /mov_img "/usr/local/dvf/mov_img"
 
 
SSLEngine on
 

< ssl stuff here >

</VirtualHost>
 
</IfDefine> 



Any ideas?
-- 

--------------------------------------------------------------------
Yann Ramin			atrus@atrustrivalie.eu.org
Atrus Trivalie Productions	www.redshift.com/~yramin
AIM				oddatrus
Marina, CA			http://profiles.yahoo.com/theatrus

IRM Developer                   Network Toaster Developer
SNTS Developer                  KLevel Developer
Electronics Hobbyist		person who loves toys

Build a man a fire, and he's warm for a day.
Set a man on fire, and he'll be warm for the rest of his life.

"I'm prepared for all emergencies but totally unprepared for everyday
life." 
--------------------------------------------------------------------