date:20040813

MP2: Second easy question: DB connection pooling

2004-08-13 Thread Tim Howell

I've seen conflicting information in docs, websites, lists archives,
etc.  Is there currently a way to do database connection pooling with
mod_perl2?  I have tried using Apache::DBI with a use statement in my
startup.pl but that doesn't seem to work.  Using PerlModule Apache::DBI
in my httpd.conf doesn't help either.  Do I need to turn on mod_perl1
compatibility mode and then use Apache::DBI in the startup script?  Is
there something else entirely?  =)

An example or pointer to further information would be appreciated.

--TWH

--
Report problems: http://perl.apache.org/bugs/
Mail list info: http://perl.apache.org/maillist/modperl.html
List etiquette: http://perl.apache.org/maillist/email-etiquette.html

strange apache restart problem

2004-08-13 Thread Konstantin Yotov

Hello! :)

I've compile apache_1.3.31 with mod_perl-1.29 :
perl Makefile.PL DO_HTTPD=1 USE_APACI=1
APACHE_PREFIX=/home/httpd EVERYTHING=1
Everything is ok and scripts run perfect, but when I
upload new script or modify existing one and run
"apachectl restart" i recieve
/home/httpd/bin/apachectl restart: httpd restarted,
but the old script is loaded!!! Only if I do
"apachectl stop" and then "apachectl start" the new
script is loaded.
Please give me some advice.
I try it on Suse,RedHat and Fedora with the same
success. What I do wrong.

Kosyo



__
Do you Yahoo!?
New and Improved Yahoo! Mail - Send 10MB messages!
http://promotions.yahoo.com/new_mail 

-- 
Report problems: http://perl.apache.org/bugs/
Mail list info: http://perl.apache.org/maillist/modperl.html
List etiquette: http://perl.apache.org/maillist/email-etiquette.html

write results of subrequest to file

2004-08-13 Thread MJW Lambrichs


I want to publish the result of a dynamic request to a file. So within a handler I 
create a subrequest that gives me the result of the dynamic request.

Something like:
$sub = $r->lookup_uri("$page?id=$id");

Now I want to get the results of this request and stream it into a file. Would using 
Apache::File be a possibillity? The main handler will continue and print if the write 
has been successfull. 

Cheers,
Marc

-- 
Report problems: http://perl.apache.org/bugs/
Mail list info: http://perl.apache.org/maillist/modperl.html
List etiquette: http://perl.apache.org/maillist/email-etiquette.html

Re: write results of subrequest to file

2004-08-13 Thread Geoffrey Young

MJW Lambrichs wrote:
> I want to publish the result of a dynamic request to a file. So within a
> handler I create a subrequest that gives me the result of the dynamic
> request.
> 
> Something like: $sub = $r->lookup_uri("$page?id=$id");
> 
> Now I want to get the results of this request and stream it into a file.

you can't do that with mod_perl 1.0 - you can $sub->run() but that result
goes right to the client.

basically, you need to issue a full request to the server using lwp or some
similar tool.  see the discussion in recipe 5.7 in the mod_perl developer's
cookbook, including this code

  http://www.modperlcookbook.org/code/ch05/Cookbook/SubRequestContent.pm

which is probably overly complex for simple needs but includes the LWP and
uri-manipulating code you would want.

HTH

--Geoff

-- 
Report problems: http://perl.apache.org/bugs/
Mail list info: http://perl.apache.org/maillist/modperl.html
List etiquette: http://perl.apache.org/maillist/email-etiquette.html

Re: write results of subrequest to file

2004-08-13 Thread Perrin Harkins

On Fri, 2004-08-13 at 11:06, Geoffrey Young wrote:
> you can't do that with mod_perl 1.0 - you can $sub->run() but that result
> goes right to the client.

For comparison, how would you do this in mp2?  With a filter?

- Perrin


-- 
Report problems: http://perl.apache.org/bugs/
Mail list info: http://perl.apache.org/maillist/modperl.html
List etiquette: http://perl.apache.org/maillist/email-etiquette.html

RE: Modperl and Distance Education

2004-08-13 Thread Todd Cranston-Cuebas

Looks like PHP has quite a lock on this market. Many
of the online collaborative systems are PHP/mysql based. Top open-source
contenders in this market would be:
Moodle (moodle.org)
ATutor (atutor.ca)
Ilias (www.ilias.uni-koeln.de/ios/index-e.html)
Note that these are collaborative learning management
systems attempted to go head-to-head with commercial LMS's. I'm sure that there
are some that are perl-based, but these are getting a lot of attention and
they're all PHP-based.
Todd

From: Alfred Vahau
[mailto:[EMAIL PROTECTED] Sent: Thursday, August 12, 2004 4:46
PMTo: ModperlSubject: Modperl and Distance
Education
Hi,Are there any major distance education sites powered by
modperl technology?I work for a University with 7 campuses scattered
around the country. Provision of distanceeducation through online access
to teaching material and academic transcripts are among the longterm goals
of the university.I find it challenging to develop a site to meet the
university's requirements. It has been proposedthat I consider Java or PHP
applications to develop the site to include online directory for allstaff
and students connected to the university. However, I am confident that I can
meet the sameobjectives using modperl technology. Somewhere I think I can
use Bricolage or Mason and I amwondering whether these are appropriate
technologies to consider. Or are there other applications ofmodperl
relating to delivery of distance education that I am not aware
of.Coming from a traditional Unix background in connection with
academic research, I turned to Perl in2000 to survive in an environment
dominated by Windows operating system. I continue to work on myown Breeze Project for which an
early account was posted on the Oreilly site in 2002. Since then I
havebeen following developments and have tested modperl and apache on
trial basis.Any pointers to help in broadening my options would be
highly appreciated.Many thanks in advance,Alfred
VahauDirectorInformation Technology ServicesUniversity of Papua
New GuineaInformation Resources
Centre

Re: strange apache restart problem

2004-08-13 Thread Perrin Harkins

On Fri, 2004-08-13 at 07:14, Konstantin Yotov wrote:
> Everything is ok and scripts run perfect, but when I
> upload new script or modify existing one and run
> "apachectl restart" i recieve
> /home/httpd/bin/apachectl restart: httpd restarted,
> but the old script is loaded!!! Only if I do
> "apachectl stop" and then "apachectl start" the new
> script is loaded.

That's normal.  The restart command from apachectl just sends a SIGHUP
to the server, which does not shut down and restart the perl
interpreter.  You have to stop the server and restart it to do that. 
You can use PerlFreshRestart if you want to, but I don't recommend it.

Please check the docs for more info on this.

- Perrin

-- 
Report problems: http://perl.apache.org/bugs/
Mail list info: http://perl.apache.org/maillist/modperl.html
List etiquette: http://perl.apache.org/maillist/email-etiquette.html

Re: MP2: Second easy question: DB connection pooling

2004-08-13 Thread Perrin Harkins

On Thu, 2004-08-12 at 14:05, Tim Howell wrote:
> Is there currently a way to do database connection pooling with
> mod_perl2?

No.

> I have tried using Apache::DBI with a use statement in my
> startup.pl but that doesn't seem to work.

It should.  Make sure it comes before anything that uses DBI.

> Do I need to turn on mod_perl1
> compatibility mode and then use Apache::DBI in the startup script?

No, it should work exactly the same as it does on mp1.

- Perrin



-- 
Report problems: http://perl.apache.org/bugs/
Mail list info: http://perl.apache.org/maillist/modperl.html
List etiquette: http://perl.apache.org/maillist/email-etiquette.html

Re: write results of subrequest to file

2004-08-13 Thread Geoffrey Young

Perrin Harkins wrote:
> On Fri, 2004-08-13 at 11:06, Geoffrey Young wrote:
> 
>>you can't do that with mod_perl 1.0 - you can $sub->run() but that result
>>goes right to the client.
> 
> 
> For comparison, how would you do this in mp2?  With a filter?

pretty much.  I believe that subrequests in apache2 have the same
limitations as before wrt calling run().  but if the main reason you want to
capture a subrequest is to post-process dynamic content then you can simply
insert an output filter to do that for you, as that is what they were
designed for.

--Geoff

-- 
Report problems: http://perl.apache.org/bugs/
Mail list info: http://perl.apache.org/maillist/modperl.html
List etiquette: http://perl.apache.org/maillist/email-etiquette.html

Apache::DBI and DBIx::*

2004-08-13 Thread John Siracusa

What does a DBIx::* module have to do in order to correctly call
Apache::DBI's no-op version of disconnect() when running under mod_perl with
Apache::DBI?

Below is an example that illustrates a bug I found when using a particular
DBIx:: module.

---
package MyTest;

use strict;
use Apache::DBI;
use DBIx::ContextualFetch;

sub handler
{
  my($r) = shift;

  my $dbh = DBI->connect('dbi:...', 'myuser', 'mypass',
 { RootClass => 'DBIx::ContextualFetch' });

  $r->send_http_header('text/plain');

  $dbh->do('...any valid sql...') ?
print 'OK' : print 'Failed';

  $dbh->disconnect; # This calls the wrong disconnect()!

  return 200;
}

1;
---

Run it under httpd -X to further isolate the problem and you'll see that the
first request works, but all subsequent requests fail.  This happens because
the disconnect() call actually calls the "real" disconnect method instead of
the Apache::DBI implementation, which is a no-op.  On the next request,
Apache::DBI happily provides what is now a disconnected $dbh.  Any attempt
to use that $dbh fails, obviously.

If you enable Apache::DBI's debugging output ($Apache::DBI::DEBUG = 1),
you'll see that the correct connect() method is called.  That is, only one
connection is made and then re-used.

So, getting back to my original question, who is at fault here?  Is this an
Apache::DBI bug, a DBIx::ContextualFetch bug, or something else?

One easy "fix" is to add a disconnect() method to DBIx::ContextualFetch that
detects when Apache::DBI is in use.  Example:

sub DBIx::ContextualFetch::disconnect
{
  if($ENV{'MOD_PERL'} && $Apache::DBI::VERSION)
  {
# Do nothing when Apache::DBI is in use
return 1;
  }
  
  shift->SUPER::disconnect(@_);
}

But isn't Apache::DBI supposed to be "transparent" and do all this stuff for
me?  Or are all bets off when using a DBIx module?  If so, what is a DBIx
author supposed to do to be a "good Apache::DBI citizen"?

-John



-- 
Report problems: http://perl.apache.org/bugs/
Mail list info: http://perl.apache.org/maillist/modperl.html
List etiquette: http://perl.apache.org/maillist/email-etiquette.html

36 matches

Mail list logo