Re: Apache::DBI and NameVirtualHost

2005-10-27 Thread gb
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

Re: Apache::DBI and NameVirtualHost

2005-10-27 Thread Geoffrey Young
>> 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

Re: Apache::DBI and NameVirtualHost

2005-10-27 Thread gb
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

Re: Apache::DBI and NameVirtualHost

2005-10-26 Thread Randal L. Schwartz
> "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

Re: Apache::DBI and NameVirtualHost

2005-10-26 Thread Geoffrey Young
> 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

Apache::DBI and NameVirtualHost

2005-10-26 Thread gb
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