I use prefork mpm
The connection string in a startup script of each site is
Apache::DBI->connect_on_init("dbi:Oracle:SID", "login1", "pass1",{
PrintError => 0,AutoCommit => 0 });
I change only login and password for different sites. So 5 different
connection strings
Interesting thing - raising
>> Apache::DBI will cache connections on a per-connection-string basis,
>> once in
>> each child process. so, if each connection to a database is made using a
>> different username each will be cached and you'll end up with
>> users*processes number of cached connections in total.
>>
> The probl
Geoffrey Young wrote:
Am I doing something wrong? Can Apache::DBI hold several handlers for
one httpd process? I suspect that user connects to different processes
and the handler (dbname/username/pass) do not always match.
Apache::DBI will cache connections on a per-connection-string basi
> "gb" == gb <[EMAIL PROTECTED]> writes:
gb> Each site has a startup script with
gb> Apache::DBI->connect_on_init
This may be your problem. If the connection string is identical,
Apache::DBI caches it as "the same connection". But if you then
do something unique per virthost in your connec
> Am I doing something wrong? Can Apache::DBI hold several handlers for
> one httpd process? I suspect that user connects to different processes
> and the handler (dbname/username/pass) do not always match.
Apache::DBI will cache connections on a per-connection-string basis, once in
each child pr
Hi all!
A have some problems with using apache::dbi and name virtual hosts.
I have four sites, each having its own login into database.
All of them listen to one ip using NameVirtualHost directive
Each site has a startup script with
Apache::DBI->connect_on_init
It seems to me that apache::dbi is