Re: Persistent Database connections to Oracle
I have a related question How do I confirm that I indeed have a persistent database connection... I have modified my httpd.conf via PerlRequire "/path/startup.pl" with debuging at level 2...I see the following in my httpd error_log [Thu Sep 13 22:11:34 2001] [notice] Apache/1.3.12 (Unix) (Red Hat/Linux) mod_ssl/2.6.6 OpenSSL/0.9.5a mod_perl/1.24 configured -- resuming normal operations 5653 Apache::DBI PerlChildInitHandler 5654 Apache::DBI PerlChildInitHandler 5655 Apache::DBI PerlChildInitHandler 5656 Apache::DBI PerlChildInitHandler 5660 Apache::DBI PerlChildInitHandler 5658 Apache::DBI PerlChildInitHandler 5657 Apache::DBI PerlChildInitHandler 5659 Apache::DBI PerlChildInitHandler But when I check my sessions on my Informix, I don't see any sessions owned by the owner of the httpd process... By the way, my method of checking my Informix sessions is onstat -g ses Just in case I'm doing this part wrong Stas Bekman wrote: > On Thu, 13 Sep 2001, Flavio D' Amore wrote: > > > Hi! > > > > How can i configure the startup.pl in order to use a global symbol such as > > "$lda = Apache::DBI->connect_on_init(..." including a persistent database > > connection to Oracle that's could be shared by other perl scripts? > > http://perl.apache.org/guide/databases.html > > _ > Stas Bekman JAm_pH -- Just Another mod_perl Hacker > http://stason.org/ mod_perl Guide http://perl.apache.org/guide > mailto:[EMAIL PROTECTED] http://apachetoday.com http://eXtropia.com/ > http://singlesheaven.com http://perl.apache.org http://perlmonth.com/ > > > -- - Medi Montaseri [EMAIL PROTECTED] Unix Distributed Systems EngineerHTTP://www.CyberShell.com CyberShell Engineering -
Re: Persistent Database connections to Oracle
On Thu, 13 Sep 2001, Flavio D' Amore wrote: > Hi! > > How can i configure the startup.pl in order to use a global symbol such as > "$lda = Apache::DBI->connect_on_init(..." including a persistent database > connection to Oracle that's could be shared by other perl scripts? http://perl.apache.org/guide/databases.html _ Stas Bekman JAm_pH -- Just Another mod_perl Hacker http://stason.org/ mod_perl Guide http://perl.apache.org/guide mailto:[EMAIL PROTECTED] http://apachetoday.com http://eXtropia.com/ http://singlesheaven.com http://perl.apache.org http://perlmonth.com/
RFC: Apache::RedirectDBI mod
I put my modified version 0.02 at http://www.xorgate.com/Apache/RedirectDBI The original functionality was kept intact. This version allows a DBI field to contain the URI to redirect the client too, and also provides for external REDIRECT. Let me know what you think. I am willing to take over the model, if that is acceptable. >-Original Message- >From: George Sanderson [mailto:[EMAIL PROTECTED]] >Sent: Thursday, September 13, 2001 12:12 AM >To: Michael Smith; [EMAIL PROTECTED] >Subject: Apache::RedirectDBI mod > > >I needed something close to what Apache::RedirectDBI provided. > >I modified version 0.01 to allow it to get the URI from a DB field and also >to do an external REDIRECT. > >The original functionality of the module should be maintained. > >Let me know if you are interested in looking at the code. >Hi there, > >This is a bit of a blast from the past! I've not looked at it for quite >some time (is it in my name on CPAN?) > >Anyway, very happy to get your changes in to what's on CPAN ... or better >still, hand it over to you. > >Mike > >>http://www.iii.co.uk >Interactive Investor International is a leading UK Internet personal >finance service that provides individuals with the capability to identify, >compare, monitor and buy online a number of financial products and services. > >Interactive Investor Trading Limited, a subsidiary of Interactive Investor >International plc, is regulated by the SFA. > ++ | George Sanderson <[EMAIL PROTECTED]> | http://www.xorgate.com ++
Apache::LogFile
Howdy folks... got a wierd one here, although I bet someone knows what to do about it. I am running Apache 1.3.20, mod_perl 1.26, and mod_ssl (most recent version that works with Apache 1.3.20). The following happens with Perl 5.005_03 and 5.6.1. In my httpd.conf, I have : # mod_perl stuff... # PerlRequire conf/startup.pl PerlFreshRestartOn PerlModule Apache::LogFile PerlLogFile logs/PTW-access.log PTW::access PerlLogFile logs/PTW-error.log PTW::error PerlLogFile logs/PTW-debug.log PTW::debug PerlLogFile logs/PTW-security.log PTW::security SetHandler perl-script PerlHandler PTW::FileFilter So I have FileFilter.pm, which does some things, and is working quite happily. On 4 of my other servers, I have this exact same configuration with Apache 1.3.14 and mod_perl of similar vintage. My problem is that my PerlHandler's (like PTW::FileFilter) cannot write to the log files. I have been using statements like: print PTW::error ("you had a big old error"); For some reason, with the updated config, this no longer works, and my Apache error_log says: Invalid command 'PerlLogFile' perhaps misspelled yadi yada. Any clues why this would be any different in newer versions? Also, I tried changing "PerlModule Apache::LogFile" to "PerlRequire Apache::LogFile", which results in Apache barfing saying that there is no such animal in @INC. I have verified that it is infact in the @INC path, so why can Apache not see it? Lastly, the very odd thing to me, is that something is successfully creating the logs/PTW-access.log etc. If it can create them, how come I cant write to them? Something is screwy, and I clearly do not have a good grasp on what is going on. Can someone please help me a bit? Thanks! -Bryan -- Bryan T. Schmidt Systems/Network Administrator Profitool Inc. [EMAIL PROTECTED]
RE: Pre-announce Apache::ConfigParser
> I swore there was yet a third candidate in this realm, but I > didn't see it on brief inspection. Config::General also parses Apache-style config files, but I don't think it handles Apache specific details like contexts. Michael
Re: DBI connections build up..
> "DJ (David J Radunz)" wrote: > I am having a problem with a module im writing connecting to the > database everytime its run, and not cleaning up the database > connection when its finished. Your script uses an END block to disconnect. If you use Apache::Registry, that will not be run until the server is shut down. With Apache::DBI, you should get one connection per Apache process, and they'll stay open. If you are changing the login parameters (i.e. different user each time), you can't use Apache::DBI because you'll get a huge build-up of connections. - Perrin
Persistent Database connections to Oracle
Hi! How can i configure the startup.pl in order to use a global symbol such as "$lda = Apache::DBI->connect_on_init(..." including a persistent database connection to Oracle that's could be shared by other perl scripts? Thanks a lot best regards --- Fl@vio D' Amore DATAMAT S.p.A. Via Laurentina 760 00143 Rome - Italy DATASIM - Product Support Phone: +39-06-50.27.4350
Re: AxKit and Last-Modified (again)
On Thursday 13 September 2001 16:43, Brian Wheeler wrote: > On Thu, 2001-09-13 at 09:19, Robin Berjon wrote: > > Iirc AxKit 1.4 supports it and that is the smallest $VERSION (not given > > in the CVS string) that I would consider using. If it works on your test > > server, I'd perhaps even recommend using the latest RC for 1.5 (should be > > 1.4_9x), especially if you are going to be doing some XSP. > > After checking, it is 1.4... You're right, my bad. The first version I have that has this feature is 1.4_81. On test boxes here it has proven rather stable, but I haven't put it into production yet. > I did get it to filter using a small module (which just prints) and > Apache::Filter. Seems to work, but its a little gross... Oh, that's nice. I never tried this but I thought I read many times that it couldn't work. -- ___ Robin Berjon <[EMAIL PROTECTED]> -- CTO k n o w s c a p e : // venture knowledge agency www.knowscape.com --- Learn from your parents mistakes - use birth control.
Re: AxKit and Last-Modified (again)
On Thu, 2001-09-13 at 09:19, Robin Berjon wrote: > On Thursday 13 September 2001 16:03, Brian Wheeler wrote: > > I tried Matt & Robin's suggestion of AxOutputTransformer, but apparently > > the version of AxKit I'm running (# $Id: AxKit.pm,v 1.105 2001/06/05 > > 15:10:41 matt Exp $) doesn't support that directive... > > Iirc AxKit 1.4 supports it and that is the smallest $VERSION (not given in > the CVS string) that I would consider using. If it works on your test server, > I'd perhaps even recommend using the latest RC for 1.5 (should be 1.4_9x), > especially if you are going to be doing some XSP. After checking, it is 1.4... Our whole site uses XPathscript, no XSP (yet) :) > > > Any other thoughts? Worst case: could I run all output through a dummy > > filter using Apache::Filter (the same way I'm running Apache::ASP and > > Apache::RegistryFilter scripts which seem to function correctly)? > > IIRC you can't filter the output of AxKit (short of course of using its own > internal filtering support, which is normally more than sufficient). > I did get it to filter using a small module (which just prints) and Apache::Filter. Seems to work, but its a little gross... Brian
Re: AxKit and Last-Modified (again)
On Thursday 13 September 2001 16:03, Brian Wheeler wrote: > I tried Matt & Robin's suggestion of AxOutputTransformer, but apparently > the version of AxKit I'm running (# $Id: AxKit.pm,v 1.105 2001/06/05 > 15:10:41 matt Exp $) doesn't support that directive... Iirc AxKit 1.4 supports it and that is the smallest $VERSION (not given in the CVS string) that I would consider using. If it works on your test server, I'd perhaps even recommend using the latest RC for 1.5 (should be 1.4_9x), especially if you are going to be doing some XSP. > Any other thoughts? Worst case: could I run all output through a dummy > filter using Apache::Filter (the same way I'm running Apache::ASP and > Apache::RegistryFilter scripts which seem to function correctly)? IIRC you can't filter the output of AxKit (short of course of using its own internal filtering support, which is normally more than sufficient). -- ___ Robin Berjon <[EMAIL PROTECTED]> -- CTO k n o w s c a p e : // venture knowledge agency www.knowscape.com --- We've been following your progress with considerable interest, not to say contempt. -- Zaphod Beeblebrox
AxKit and Last-Modified (again)
I tried Matt & Robin's suggestion of AxOutputTransformer, but apparently the version of AxKit I'm running (# $Id: AxKit.pm,v 1.105 2001/06/05 15:10:41 matt Exp $) doesn't support that directive... Any other thoughts? Worst case: could I run all output through a dummy filter using Apache::Filter (the same way I'm running Apache::ASP and Apache::RegistryFilter scripts which seem to function correctly)? Brian
Re: DBI connections build up..
Hi there, On Thu, 13 Sep 2001, DJ (David J Radunz) wrote: > the database connections just keep building up. Read the database section of the Guide: http://perl.apache.org/guide 73, Ged.