Apache::DBI and mod_perl

Hi, please accept my apologies for spamming this list - I need to get mod_perl up and running quickly and will be more quiet in the future. The README of Apache::DBI tells me to configure mod_perl using perl Makefile.PL PERL_CHILD_INIT=1 PERL_AUTHEN=1 PERL_AUTHZ=1 PERL_CLE

Re: Apache::DBI and mod_perl

On Jun 23, 2005, at 5:29 AM, Jan Eden wrote: Hi, please accept my apologies for spamming this list - I need to get mod_perl up and running quickly and will be more quiet in the future. The README of Apache::DBI tells me to configure mod_perl using perl Makefile.PL PERL_CHILD_INIT=1 PERL_

Re: Apache::DBI and mod_perl

On Thu, 2005-06-23 at 11:29 +0200, Jan Eden wrote: > Everything works - but how can I know if Apache::DBI really keeps my > database connection alive? Turn on the debugging for Apache::DBI and check your error_log. See the Apache::DBI docs for instructions. - Perrin

Re: Apache::DBI and mod_perl

Perrin Harkins wrote: > On Thu, 2005-06-23 at 11:29 +0200, Jan Eden wrote: > >>Everything works - but how can I know if Apache::DBI really keeps my >>database connection alive? > > Turn on the debugging for Apache::DBI and check your error_log. See the > Apache::DBI docs for instructions. Alter

Re: Apache::DBI and mod_perl

Philippe M. Chiasson wrote on 23.06.2005: >Perrin Harkins wrote: >>On Thu, 2005-06-23 at 11:29 +0200, Jan Eden wrote: >> >>>Everything works - but how can I know if Apache::DBI really keeps >>>my database connection alive? >> >>Turn on the debugging for Apache::DBI and check your error_log. >>See

Re: Apache::DBI and mod_perl

On Fri, 2005-06-24 at 10:02 +0200, Jan Eden wrote: > What is the overload message supposed to tell me? That you called disconnect but Apache::DBI prevented the handle from being disconnected. The "overload" message is just poorly worded. It should probably say "overridden" or something instead.

Re: Apache::DBI and mod_perl

Perrin Harkins wrote on 24.06.2005: >On Fri, 2005-06-24 at 10:02 +0200, Jan Eden wrote: >>What is the overload message supposed to tell me? > >That you called disconnect but Apache::DBI prevented the handle from >being disconnected. > >The "overload" message is just poorly worded. It should proba

Re: Apache::DBI and mod_perl

On Jun 24, 2005, at 5:43 AM, Jan Eden wrote: Perrin Harkins wrote on 24.06.2005: On Fri, 2005-06-24 at 10:02 +0200, Jan Eden wrote: What is the overload message supposed to tell me? That you called disconnect but Apache::DBI prevented the handle from being disconnected. The "overload" mes

Re: Apache::DBI and mod_perl

From: "Jan Eden" <[EMAIL PROTECTED]> After going through all this, I did an ApacheBench with/without Apache::DBI being used (1000 requests, 10 concurrent), and it turned out that Apache::DBI is actually slowing down delivery from 13 requests/second to 7.78 (on my local test machine). Oh my. --

Re: Apache::DBI and mod_perl

Sean Davis wrote on 24.06.2005: >>After going through all this, I did an ApacheBench with/without >>Apache::DBI being used (1000 requests, 10 concurrent), and it >>turned out that Apache::DBI is actually slowing down delivery from >>13 requests/second to 7.78 (on my local test machine). > >Were an

Re: Apache::DBI and mod_perl

>So the recommendation is to not use Apache::DBI? > That sounds reasonable at this point. I was just wondering why Apache::DBI is effectively slowing down delivery in this setup where a lot of DB requests are involved. Is it because my scripts still contain a $dbh->disconnect() and overriding thi

Re: Apache::DBI and mod_perl

Octavian Rasnita wrote on 24.06.2005: >As far as I know, the scope of Apache::DBI is to keep a permanent >connection with the database, but if the script disconnects after >each request, why using Apache::DBI? Apache::DBI overrides the DBI disconnect method, effectively keeping the connection al

Apache::DBI and mod_perl 2.0.1

Hi, I made a couple of changes to Apache::DBI to allow connect_on_init to work with mod_perl2. Here's the diff if anyone is interested: diff DBI.pm DBI.pm.old 11,12d10 < use constant MP2 => $mod_perl2::VERSION >= 1.99; < 37,44c35,37 < if (MP2) { server->push_han

Re: Apache::DBI and mod_perl 2.0.1

Mark A. Downing wrote: Hi, I made a couple of changes to Apache::DBI to allow connect_on_init to work with mod_perl2. Here's the diff if anyone is interested: Thanks for this Mark. (Un)fortunately you've been beat to it and there are "few" more changes to get all of it working with mp2.

Re: Apache::DBI and mod_perl 2.0.1

On Thu, 30 Jun 2005, Philip M. Gollucci wrote: Thanks for this Mark. (Un)fortunately you've been beat to it and there are "few" more changes to get all of it working with mp2. Very nice. Thanks. Can we get that pushed up to CPAN?

Re: Apache::DBI and mod_perl 2.0.1

Mark A. Downing wrote: On Thu, 30 Jun 2005, Philip M. Gollucci wrote: Thanks for this Mark. (Un)fortunately you've been beat to it and there are "few" more changes to get all of it working with mp2. Very nice. Thanks. Can we get that pushed up to CPAN? Umm Talk to Ask B. H. He's be

Re: Apache::DBI and mod_perl 2.0.1

Joshua Hoblitt wrote: On Thu, Jun 30, 2005 at 11:25:26AM -0400, Philip M. Gollucci wrote: Mark A. Downing wrote: On Thu, 30 Jun 2005, Philip M. Gollucci wrote: Thanks for this Mark. (Un)fortunately you've been beat to it and there are "few" more changes to get all of it wor

Re: Apache::DBI and mod_perl 2.0.1

> Joshua Hoblitt wrote: > > >On Thu, Jun 30, 2005 at 11:25:26AM -0400, Philip M. Gollucci wrote: > > > > > >>Mark A. Downing wrote: > >> > >> > >> > >>>On Thu, 30 Jun 2005, Philip M. Gollucci wrote: > >>> > >>> > >>> > Thanks for this Mark. (Un)fortunately you've been beat to it and > ther

Re: Apache::DBI and mod_perl 2.0.1

Vincent Moneymaker wrote: I have a question which I am not sure whether it is loopy or not. In the Apache::DBI module module the variable '$Apache::ServerStarting' is used but I can't find any reference to it on the mod_perl site or elsewhere under /usr/local/lib/perl5 on my FreeBSD box. The m

Re: Apache::DBI and mod_perl 2.0.1

Philip M. Gollucci wrote: Vincent Moneymaker wrote: From Apache::DBI: > if ($Apache::ServerStarting and $Apache::ServerStarting == 1) { >print STDERR "$prefix skipping connection during server startup, read the docu !!\n" if $Apache::DBI::DEBUG > 1; >return $drh->connect(@arg

Re: Apache::DBI and mod_perl 2.0.1

On Thu, Jun 30, 2005 at 11:25:26AM -0400, Philip M. Gollucci wrote: > Mark A. Downing wrote: > > >On Thu, 30 Jun 2005, Philip M. Gollucci wrote: > > > >>Thanks for this Mark. (Un)fortunately you've been beat to it and > >>there are "few" more changes to > >>get all of it working with mp2. > > >

Re: Apache::DBI and mod_perl 2.0.1

On Thu, Jun 30, 2005 at 05:58:29PM -0400, Philip M. Gollucci wrote: > > > http://p6m7g8.net/Apache-DBI > > The 0.97's connect_on_init() works under MP2. > > In fact p6m7g8.net is running it on a backend server. I know, I had already tested it. Perhaps I should have been more specific and said,

Re: Apache::DBI and mod_perl 2.0.1

Philip, I think I've spotted another small Apache/DBI issue that I thought I would run by you. In the 'connect' function inside the DBI.pm module (as opposed to the Apache/DBI.pm) there are somes lines about 12 lines down from the start of the 'connect' function that reads as follows $connec

Re: Apache::DBI and mod_perl 2.0.1

Vincent Moneymaker wrote: Philip, I think I've spotted another small Apache/DBI issue that I thought I would run by you. In the 'connect' function inside the DBI.pm module (as opposed to the Apache/DBI.pm) there are somes lines about 12 lines down from the start of the 'connect' function that

Re: Apache::DBI and mod_perl 2.0.1

Philip G. Gollucci wrote: You are correct in what it does; however, its not an issue as far as I can see. The reason being is that the last arg of connect is the \%attrs hash ref. Its replacing the password with *'s and then showing all SCALAR (aka simple to the lazy programer) parameters :)