Re: Apache::DBI + DBD::Multiplex

2005-11-23 Thread Philippe M. Chiasson
Philip M. Gollucci wrote: > Philippe M. Chiasson wrote: > >> Philip M. Gollucci wrote: >> 2 possible avenues to investigate: - Look at changing Apache::DBI to not use the ref as part of the dsn cache key, but use the contents of the array something along the lines of :

Re: Apache::DBI + DBD::Multiplex

2005-11-23 Thread Philippe M. Chiasson
Perrin Harkins wrote: > Philippe M. Chiasson wrote: > >> +my $Idx; >> +{ >> +local $Data::Dumper::Indent = 0; >> +local $Data::Dumper::Terse = 1; >> +$Idx = Dumper([EMAIL PROTECTED]); > > This may also be significantly slower than what it's replacing, and > since t

Debugging code which deploys DBI: no logfile, no trace. What's a cause?

2005-11-23 Thread Plymouth Rock
http://perl.apache.org/docs/1.0/guide/databases.html#Debugging_code_which_de ploys_DBI PerlSetEnv DBI_TRACE "3=/tmp/dbitrace.log" PerlModule Apache::DBI I tried mod_perl scripts accessed to DB and SELECTed some data. But logfile still doesn't appear. The order and placement the directives ar

Re: Apache::DBI + DBD::Multiplex

2005-11-23 Thread Perrin Harkins
Philippe M. Chiasson wrote: +my $Idx; +{ +local $Data::Dumper::Indent = 0; +local $Data::Dumper::Terse = 1; +$Idx = Dumper([EMAIL PROTECTED]); This may also be significantly slower than what it's replacing, and since this is just calculating a cache key, people

Re: Apache::DBI + DBD::Multiplex

2005-11-23 Thread Philip M. Gollucci
Philippe M. Chiasson wrote: Philip M. Gollucci wrote: 2 possible avenues to investigate: - Look at changing Apache::DBI to not use the ref as part of the dsn cache key, but use the contents of the array something along the lines of : $Key = Dumper([EMAIL PROTECTED]); If you do patch Apa

Re: Apache::DBI + DBD::Multiplex

2005-11-23 Thread Pierre Smolarek
Carl Johnstone wrote: The subroutine will only be defined once at file load time so the reference to it won't change. Thinking about it, depending where you define the @dsns variable I suggested won't necessarily work that much better. You need to make sure it's declared in a namespace where it

Re: Apache::DBI + DBD::Multiplex

2005-11-23 Thread Pierre Smolarek
Carl Johnstone wrote: Have you copied the example code from DBD::Multiplex? %attr = ( 'mx_dsns' => [$dsn1, $dsn2, $dsn3, $dsn4], 'mx_master_id' => 'dbaaa1', 'mx_connect_mode' => 'ignore_errors', 'mx_exit_mode' => 'first_success', 'mx_error_proc' => \&M

Re: Apache::DBI + DBD::Multiplex

2005-11-23 Thread Philippe M. Chiasson
Philip M. Gollucci wrote: >> 2 possible avenues to investigate: >> - Look at changing Apache::DBI to not use the ref as part of the dsn >> cache key, but use the contents of the array >>something along the lines of : >> $Key = Dumper([EMAIL PROTECTED]); > > > If you do patch Apache::DBI,

Re: Apache::DBI + DBD::Multiplex

2005-11-23 Thread Philip M. Gollucci
2 possible avenues to investigate: - Look at changing Apache::DBI to not use the ref as part of the dsn cache key, but use the contents of the array something along the lines of : $Key = Dumper([EMAIL PROTECTED]); If you do patch Apache::DBI, please post the diff, maybe we could add an

Re: Apache::DBI + DBD::Multiplex

2005-11-23 Thread Perrin Harkins
On Wed, 2005-11-23 at 13:15 -0700, Pierre Smolarek wrote: > I'm not completly up to scratch when or how Apache::DBI does its magic, > either within the connect call of my DBI handle or within Multiplex's > (as multiplex does a similar thing to Apache::DBI in redirecting the > connect request).

Re: Apache::DBI + DBD::Multiplex

2005-11-23 Thread Pierre Smolarek
Philippe M. Chiasson wrote: 2 possible avenues to investigate: - Change your code to not use an array-ref as mx_dsns argument but some string (comma delimited, etc) - Look at changing Apache::DBI to not use the ref as part of the dsn cache key, but use the contents of the array something a

Re: Apache::DBI + DBD::Multiplex

2005-11-23 Thread Philippe M. Chiasson
Pierre Smolarek wrote: > Perrin Harkins wrote: > >> There is a debug setting described in the Apache::DBI documentation >> which will tell you this. >> >> - Perrin >> > > I've attached about 2 seconds of debug output. From what i can gather, > its constantly creating new connections on what appea

Re: Apache::DBI + DBD::Multiplex

2005-11-23 Thread Pierre Smolarek
Perrin Harkins wrote: Sounds likely, but I have no idea how DBD::Multiplex uses that or if it can be safely ignored when connecting. Have you tried contacting the author of DBD::Multiplex for help? No one here seems to be using it. - Perrin Not yet. Are there any other recomendations on

Re: Apache::DBI + DBD::Multiplex

2005-11-23 Thread Perrin Harkins
On Wed, 2005-11-23 at 10:32 -0700, Pierre Smolarek wrote: > The only difference i see is mx_dsns=ARRAY(0xa56e918). So my layman > guess is that the arrayref of db servers set within the DBD::Multiplex > dsn is at a different address each time and therefore the cache sees a > unique dsn? Sounds

Re: [mp2] Apache::VMonitor ap_scoreboard_image doesn't exist

2005-11-23 Thread Francesc Guasch
En/na Malcolm J Harwood ha escrit: > On Tuesday 22 November 2005 10:52 am, Francesc Guasch wrote: > > I'm trying to use Apache::Monitor with mod_perl2, but > There seems to be something wrong with your apache build then. It's claiming > it does not have scoreboard support. I changed httpd.c

Re: [mp2] Apache::VMonitor ap_scoreboard_image doesn't exist

2005-11-23 Thread Malcolm J Harwood
On Tuesday 22 November 2005 10:52 am, Francesc Guasch wrote: > >>I'm trying to use Apache::Monitor with mod_perl2, but > >>it fails to load it. I changed some code because it > >>didn't detected it was running inside mod_perl2 ,but > >>I'm unable to fix it more. > > > > Does "make test" give you a

mp2 broken connection detection

2005-11-23 Thread Malcolm J Harwood
The cookbook (recipe 4.9) claims that $c->aborted is only true after you've actually sent data to the client and flushed the buffers. For testing if the client is still connected, it recommends doing something like: $c = Apache->request->connection; return if ($c->aborted);

Re: mod_perl: How pass variables (objects) from page to page?

2005-11-23 Thread John Doe
Jeremy Nixon am Dienstag, 15. November 2005 23.16: > John Doe <[EMAIL PROTECTED]> wrote: > > Hope it's not a stupid question, but are you sure %d_cache survives a > > request? Maybe I'm totally misunderstanding something but I thought > > after the point > > > > } end lexical scope > > > > %d_cac

Re: postprocessing html+php code generated by a mod_perl system beforeto send it to browser

2005-11-23 Thread Nikolay Ananiev
"Edgard Pineda" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Hello, > I need some hints on this problem: I have a code in mod_perl that > generate a html page with some php code (), but before to > send this data to the browser I would like the mod_php processed the > code first. H