Apache::DBI

2003-08-28 Thread
I can run the following code with DBI but in Apache::DBI. #!/usr/bin/perl -w use DBI; sub connect{ $dbh = DBI->connect("dbi:Pg:dbname=test", "canis",$password); $sth = $dbh->prepare("SELECT clave, denominacion FROM Marca") || die $dbh->errstr; $sth

Re: Apache::DBI

2003-08-28 Thread Michael A Nachbaur
ll md5 or make it IP based: host allall1.2.3.4255.255.255.255 md5 you get the idea. That way, it'll obey the username/password that you supply. On Thursday 28 August 2003 04:28 pm, wrote: > Hello, every body > > I can run the following subroutine in DBI, bu

Apache::DBI

2003-08-28 Thread
Hello, every body I can run the following subroutine in DBI, but Apache::DBI... use DBI; sub connect{ $dbh = DBI->connect("dbi:Pg:dbname=test", "canis","3dsadasz"); $sth = $dbh->prepare("SELECT clave, denominacion FROM Marca")

Re: Apache::DBI not really loading

2003-08-28 Thread brs900
> >I've set Apache::DBI::DEBUG to 2, and I'm not seeing _any_ messages > >(from it) in the error log. Apache::Status lists Apache DBI, but > >lists no database connections. > > A long time ago, one problem used to be that if your connect to > Postgres

Re: Apache::DBI not really loading

2003-08-27 Thread Josh Chamas
[EMAIL PROTECTED] wrote: I've got a case where my DBI connections appear to be timing out and not reconnecting. Google just points to the old timeout problem that should be solved. I've set Apache::DBI::DEBUG to 2, and I'm not seeing _any_ messages (from it) in the error log.

Apache::DBI not really loading

2003-08-27 Thread brs900
I've got a case where my DBI connections appear to be timing out and not reconnecting. Google just points to the old timeout problem that should be solved. I've set Apache::DBI::DEBUG to 2, and I'm not seeing _any_ messages (from it) in the error log. Apache::Status lists Apache

Re: Apache::DBI

2003-08-18 Thread Ken Y. Clark
On Mon, 18 Aug 2003, wrote: > Date: Mon, 18 Aug 2003 16:57:13 -0700 > From: <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Subject: Apache::DBI > > What's the diference between DBI and Apache::DBI? Have you bothered to read the docs at all? http://s

Apache::DBI

2003-08-18 Thread
What's the diference between DBI and Apache::DBI? -- Reporting bugs: http://perl.apache.org/bugs/ Mail list info: http://perl.apache.org/maillist/modperl.html

Re: Trouble getting mod_perl and apache running with Apache::DBI

2003-08-18 Thread Perrin Harkins
On Mon, 2003-08-18 at 11:33, K Old wrote: > My problem was that I was not declaring "PerlModule Apache::DBI" in > httpd.conf BEFORE my "PerlRequire /etc/httpd/conf/startup.pl". Also, I > was doing a "use Apache::DBI" in my startup.pl file, which I sho

Re: Trouble getting mod_perl and apache running with Apache::DBI

2003-08-18 Thread K Old
On Sun, 2003-08-17 at 11:41, Perrin Harkins wrote: > On Fri, 2003-08-15 at 10:34, K Old wrote: > > What's happening is that with "use Apache::DBI" uncommented in either > > the httpd.conf or startup.pl Apache does not start. > > Do you have something in y

Re: Trouble getting mod_perl and apache running with Apache::DBI

2003-08-17 Thread Perrin Harkins
On Fri, 2003-08-15 at 10:34, K Old wrote: > What's happening is that with "use Apache::DBI" uncommented in either > the httpd.conf or startup.pl Apache does not start. Do you have something in your code that connects to a database during startup? That could be a problem. A

Re: Trouble getting mod_perl and apache running with Apache::DBI

2003-08-15 Thread K Old
I left out my version of Perl. I'm using 5.6.1 from RPM. Kevin On Fri, 2003-08-15 at 10:34, K Old wrote: > Hello everyone, > > I've set mod_perl up with Apache::DBI on several servers, both with > mod_perl from RPM's and building it myself, but I am having a horrib

Trouble getting mod_perl and apache running with Apache::DBI

2003-08-15 Thread K Old
Hello everyone, I've set mod_perl up with Apache::DBI on several servers, both with mod_perl from RPM's and building it myself, but I am having a horrible time with a new server I've just built. Go easy, I'm still new at it, though. And I welcome any and all constructive cri

[Patch] Apache::DBI - correctly clean up handles and reset attributes

2003-07-22 Thread Patrick Mulvany
Hi, Over the past few months I have posted a couple of fixes in relation to how Apache::DBI handles are cleaned up. This however is the most complete fix in that it covers the following issues :- TimeOut = 0 : Should always ping even when multiple requests are made in

Re: Apache::DBI and temporary tables

2003-07-22 Thread Frank Wiles
s closed (or when the > transaction is finished...I can't remember which). Anyway, what will > happen if code that takes advantage of this is used in an Apache > Registry script? > > If I do a $dbh->disconnect, I know it will be ignored by Apache::DBI, > but is it smar

Re: Apache::DBI and temporary tables

2003-07-22 Thread Perrin Harkins
On Tue, 2003-07-22 at 17:15, Michael A Nachbaur wrote: > If I do a $dbh->disconnect, I know it will be ignored by Apache::DBI, but is > it smart enough to pass something back to the database server telling it that > it can purge temporary data? No. If you come up with a way to do t

Apache::DBI and temporary tables

2003-07-22 Thread Michael A Nachbaur
that takes advantage of this is used in an Apache Registry script? If I do a $dbh->disconnect, I know it will be ignored by Apache::DBI, but is it smart enough to pass something back to the database server telling it that it can purge temporary data? Thanks. -- /* Michael A. Nachbaur

Re: [mp2] Apache::DBI

2003-07-15 Thread Stas Bekman
Beau E. Cox wrote: Hi - I am running Apache 2.0.47/mod_perl 1.99-dev-10-cvs on SuSE Linux 8.2. I am trying to install and use Apache::DBI. [...] 2) The documentation says to configure mod_perl with: perl Makefile.PL PERL_CHILD_INIT=1 PERL_AUTHEN=1 PERL_AUTHZ=1 PERL_CLEANUP

Re: [mp2] Apache::DBI

2003-07-14 Thread Beau E. Cox
- Original Message - From: "Haroon Rafique" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, July 14, 2003 3:23 AM Subject: Re: [mp2] Apache::DBI > On Yesterday at 10:01pm, BEC=>Beau E. Cox <[EMAIL PROTECTED]> wrote: > > BEC> > B

Re: [mp2] Apache::DBI

2003-07-14 Thread Haroon Rafique
i Beau, I'm using apache 2.0.46, mod_perl 1.9909, perl v5.8.0, Apache::DBI 0.91 on a Gentoo kernel 2.4.20-ck6 without any problems in production. I have had no problems with using connect_on_init either. I have: use Apache::compat (); as my first use statement in my mod_perl startup.pl file

[mp2] Apache::DBI

2003-07-14 Thread Beau E. Cox
Hi - I am running Apache 2.0.47/mod_perl 1.99-dev-10-cvs on SuSE Linux 8.2. I am trying to install and use Apache::DBI. 1) I get this error in make test: is($thread_1, $thread_2, "got the same connection both times"); It seems the I do not get the same connection. 2) The doc

[PATCH] Apache::DBI - AutoCommit => 1 and begin_work (inc example)

2003-06-12 Thread Patrick Mulvany
Hi, Came accross a bug when when trying to reduce creation of handles on a site. Currently Apache::DBI makes the assumption that it AutoCommit => 1 then the handle does not need cleaning up. This is not neccessariliy true as begin_work switches off the AutoCommit for one transaction. Fi

Re: [PATCH] Apache::DBI - AutoCommit => 1 and begin_work

2003-06-10 Thread Stas Bekman
Patrick Mulvany wrote: Hi, Came accross an issue when trying to reduce creation of handles on a site. Currently Apache::DBI makes the assumption that it AutoCommit => 1 then the handle does not need cleaning up. This is not neccessariliy true as begin_work switches of the AutoCommit for

Re: [mp2] win2000 + Apache::DBI + Oracle

2003-06-10 Thread Stas Bekman
Patrick Mulvany wrote: > On Tue, Jun 10, 2003 at 04:27:17PM +1000, Stas Bekman wrote: >> connect_on_init() should probably be not used. > > > connect_on_init() pushs to a list of connection strings to start on child > creation. &childinit should be called as a PerlChildInitHandler (not sure > when

[PATCH] Apache::DBI - AutoCommit => 1 and begin_work

2003-06-10 Thread Patrick Mulvany
Hi, Came accross an issue when trying to reduce creation of handles on a site. Currently Apache::DBI makes the assumption that it AutoCommit => 1 then the handle does not need cleaning up. This is not neccessariliy true as begin_work switches of the AutoCommit for one transaction. To be s

Re: [mp2] win2000 + Apache::DBI + Oracle

2003-06-10 Thread Paul Simon
--- Stas Bekman <[EMAIL PROTECTED]> wrote: > Perrin Harkins wrote: > > On Tue, 2003-06-10 at 01:45, Stas Bekman wrote: > > > >>mp2+winFU => winnt MPM => no forking, only threads > => Apache::DBI is useless > >>there. not only useless, bu

Re: [mp2] win2000 + Apache::DBI + Oracle

2003-06-10 Thread Patrick Mulvany
On Tue, Jun 10, 2003 at 04:27:17PM +1000, Stas Bekman wrote: > Perrin Harkins wrote: > >On Tue, 2003-06-10 at 01:45, Stas Bekman wrote: > > > >>mp2+winFU => winnt MPM => no forking, only threads => Apache::DBI is > >>useless there. not only useless, but

Re: [mp2] win2000 + Apache::DBI + Oracle

2003-06-09 Thread Stas Bekman
Perrin Harkins wrote: On Tue, 2003-06-10 at 01:45, Stas Bekman wrote: mp2+winFU => winnt MPM => no forking, only threads => Apache::DBI is useless there. not only useless, but also wasteful, since it's going to do work that has no added value. But how is this any different

Re: [mp2] win2000 + Apache::DBI + Oracle

2003-06-09 Thread Perrin Harkins
On Tue, 2003-06-10 at 01:45, Stas Bekman wrote: > mp2+winFU => winnt MPM => no forking, only threads => Apache::DBI is useless > there. not only useless, but also wasteful, since it's going to do work that > has no added value. But how is this any different from separate

Re: [mp2] win2000 + Apache::DBI + Oracle

2003-06-09 Thread Stas Bekman
Perrin Harkins wrote: On Mon, 2003-06-09 at 21:02, Stas Bekman wrote: Paul Simon wrote: So, according to the docs, http://perl.apache.org/docs/2.0/user/performance/mpm.html#Work_with_DataBases_under_Threaded_MPM, using Apache::DBI doesn't do anything under mp2+windows2000 ... That'

Re: [mp2] win2000 + Apache::DBI + Oracle

2003-06-09 Thread Perrin Harkins
On Mon, 2003-06-09 at 21:02, Stas Bekman wrote: > Paul Simon wrote: > > So, according to the docs, > > http://perl.apache.org/docs/2.0/user/performance/mpm.html#Work_with_DataBases_under_Threaded_MPM, > > using Apache::DBI doesn't do anything under > > mp2+win

Re: [mp2] win2000 + Apache::DBI + Oracle

2003-06-09 Thread Stas Bekman
Paul Simon wrote: So, according to the docs, http://perl.apache.org/docs/2.0/user/performance/mpm.html#Work_with_DataBases_under_Threaded_MPM, using Apache::DBI doesn't do anything under mp2+windows2000 ... That's correct. Since Apache::DBI does per-process pooling, and apache 2.0 on w

[mp2] win2000 + Apache::DBI + Oracle

2003-06-09 Thread Paul Simon
So, according to the docs, http://perl.apache.org/docs/2.0/user/performance/mpm.html#Work_with_DataBases_under_Threaded_MPM, using Apache::DBI doesn't do anything under mp2+windows2000 ... What is the status of DBI::Pool? These modules deal mainly with persistent database connections. Is

[patch] Apache::DBI can't be made to always ping

2003-06-03 Thread dennis . ingram
We've been having some problems with our Oracle 8.1.5 database on AIX, which has highlighted what looks like a problem with Apache::DBI. To cut a very long story short, due to an Oracle problem database handles are becoming invalid reasonably frequently. In this case, we would expect Apache

Re: [OT] Apache::DBI and Postgres

2003-06-02 Thread valerian
On Wed, May 14, 2003 at 10:48:45AM -0400, Eric Sammer wrote: > Not really a problem (yet), but out of curiousity... > > I'm using Apache::DBI with postgres and while not serving requests, all > the postgres processes are listed as "idle in transaction." Obviously, &

Re: [mp2] Using DBI instead of Apache::DBI

2003-03-13 Thread Stas Bekman
[please keep the threads on the list unless requested otherwise] Georg Botorog wrote: Thanks. But I still have not understood how I avoid to include Apache::DBI in the current version of Apache (2). In mp1, there was an explicit inclusion statement in httpd.conf, which I could leave out. I have

Re: [mp2] Using DBI instead of Apache::DBI

2003-03-11 Thread Stas Bekman
Georg Botorog wrote: Hello, In mod_perl1, using persistent (Apache::DBI) and dedicated, per-user connections (DBI) on the same machine required running two Apache instances, one with Apache::DBI and the other without it. Has anything about that changed in mod_perl2? Moreover, how does Apache2

[mp2] Using DBI instead of Apache::DBI

2003-03-11 Thread Georg Botorog
> Hello, > > In mod_perl1, using persistent (Apache::DBI) and dedicated, per-user > connections (DBI) on the same machine required running two Apache > instances, one with Apache::DBI and the other without it. > > Has anything about that changed in mod_perl2? > > More

Re: Apache::DBI on mp2

2003-03-07 Thread Stas Bekman
parts of $dbh, because of the constraints of sharing Perl datastructures and underlying C structs. Apache::DBI explicitly calls $dbh->rollback (when things are configured so it makes sense). Or maybe I am completely misunderstanding you. All I was saying is, that whatever worked for Apache::

Re: Apache::DBI on mp2

2003-03-07 Thread Ask Bjoern Hansen
t rips off only parts of $dbh, because of the constraints of > sharing Perl datastructures and underlying C structs. Apache::DBI explicitly calls $dbh->rollback (when things are configured so it makes sense). Or maybe I am completely misunderstanding you. > > ps. yes, your DBI::Pool wo

Re: Apache::DBI on mp2

2003-03-07 Thread Stas Bekman
Ask Bjoern Hansen wrote: On Thu, 6 Mar 2003, Stas Bekman wrote: re: rollback, the DBD drivers will perform the normal disconnect(), but without doing the physical disconnect, and normal DESTROY, without destroying the datastructures which maintain the physical connection, so there shouldn't be mu

Re: Apache::DBI on mp2

2003-03-07 Thread Ask Bjoern Hansen
On Thu, 6 Mar 2003, Stas Bekman wrote: > re: rollback, the DBD drivers will perform the normal disconnect(), but > without doing the physical disconnect, and normal DESTROY, without destroying > the datastructures which maintain the physical connection, so there shouldn't > be much to change for t

Re: Apache::DBI on mp2

2003-03-05 Thread Stas Bekman
Perrin Harkins wrote: Stas Bekman wrote: FWIW, we are discussing the internal DBI pooling mechanism at the dbi-dev list and having already a sort-of-working prototype. So hopefully there will be no need for Apache::DBI in the near future, as DBI will be able to handle pooling internally

Re: Apache::DBI on mp2

2003-03-05 Thread Perrin Harkins
Stas Bekman wrote: FWIW, we are discussing the internal DBI pooling mechanism at the dbi-dev list and having already a sort-of-working prototype. So hopefully there will be no need for Apache::DBI in the near future, as DBI will be able to handle pooling internally. However it may take some

Re: Apache::DBI on mp2

2003-03-05 Thread Stas Bekman
Ask Bjoern Hansen wrote: On Wed, 5 Mar 2003, Stas Bekman wrote: Great. I've already committed that patch. Perhaps Ask could load 'Apache::compat' inside Apache::DBI if mp2 is used. Or to use the mp2 API if mp2 is used. That seems like it'll be an easy solution. I th

Re: Apache::DBI on mp2

2003-03-05 Thread Ask Bjoern Hansen
On Wed, 5 Mar 2003, Stas Bekman wrote: > Great. I've already committed that patch. > > Perhaps Ask could load 'Apache::compat' inside Apache::DBI if mp2 is used. Or > to use the mp2 API if mp2 is used. That seems like it'll be an easy solution. I thought loading

Re: Apache::DBI on mp2

2003-03-04 Thread Stas Bekman
Haroon Rafique wrote: On Today at 11:16am, SB=>Stas Bekman <[EMAIL PROTECTED]> wrote: SB> FWIW, we are discussing the internal DBI pooling mechanism at the SB> dbi-dev list and having already a sort-of-working prototype. So SB> hopefully there will be no need for Apache::DBI

Re: Apache::DBI on mp2

2003-03-04 Thread Haroon Rafique
On Today at 11:16am, SB=>Stas Bekman <[EMAIL PROTECTED]> wrote: SB> FWIW, we are discussing the internal DBI pooling mechanism at the SB> dbi-dev list and having already a sort-of-working prototype. So SB> hopefully there will be no need for Apache::DBI in the near future, as SB

Re: Apache::DBI on mp2

2003-03-03 Thread Stas Bekman
FWIW, we are discussing the internal DBI pooling mechanism at the dbi-dev list and having already a sort-of-working prototype. So hopefully there will be no need for Apache::DBI in the near future, as DBI will be able to handle pooling internally. However it may take some time, as the drivers

Apache::DBI on mp2

2003-03-03 Thread Haroon Rafique
My setup is as follows: Apache/2.0.44 (Gentoo/Linux) mod_perl/1.99_08 Perl/v5.8.0 mod_perl was built from CVS. I was interested in getting Apache::DBI to run under mp2. I did read Ask's message at http://marc.theaimsgroup.com/?l=apache-modperl&m=104225578207460&w=2 which l

RE: Apache dies when configure mod_perl for use with Apache::DBI

2003-03-02 Thread Frank Maas
> This is the only error line that appears in the error_log. > [Sun Mar 2 20:10:19 2003] [notice] caught SIGTERM, shutting down > Perhaps it's me, but could you please create a copy-n-paste mail with the (correct) relevant code snippets (httpd.conf, startup.pl, etc.). This might help. Best rega

Re: Apache dies when configure mod_perl for use with Apache::DBI

2003-03-02 Thread Feite Brekeveld
Richard Clarke wrote: As soon as I activate the line identified as 'trouble line', my apache server dies. Can you elaborate on this.. how does it die?, what is the error msg? etc.. (That is assuming it's still a problem after upgrading to latest DBI/Apache::DBI as Stas

Re: Apache dies when configure mod_perl for use with Apache::DBI

2003-03-02 Thread Richard Clarke
> As soon as I activate the line identified as 'trouble line', my apache > server dies. Can you elaborate on this.. how does it die?, what is the error msg? etc.. (That is assuming it's still a problem after upgrading to latest DBI/Apache::DBI as Stas suggested). Ric.

Re: Apache dies when configure mod_perl for use with Apache::DBI

2003-03-02 Thread Stas Bekman
Feite Brekeveld wrote: Richard Clarke wrote: PerlModule Apache::DBI;<<-- trouble line This line belongs in your httpd.conf file. PerlModule is an apache configuration directive, not a perl 'command'. http://perl.apache.org/docs/1.0/g

Re: Apache dies when configure mod_perl for use with Apache::DBI

2003-03-02 Thread Feite Brekeveld
Richard Clarke wrote: PerlModule Apache::DBI;<<-- trouble line This line belongs in your httpd.conf file. PerlModule is an apache configuration directive, not a perl 'command'. http://perl.apache.org/docs/1.0/guide/config.html#PerlModule_and_PerlReq

Re: Apache dies when configure mod_perl for use with Apache::DBI

2003-03-01 Thread Richard Clarke
> PerlModule Apache::DBI;<<-- trouble line This line belongs in your httpd.conf file. PerlModule is an apache configuration directive, not a perl 'command'. http://perl.apache.org/docs/1.0/guide/config.html#PerlModule_and_PerlRequire _Directives Ric.

Apache dies when configure mod_perl for use with Apache::DBI

2003-03-01 Thread Feite Brekeveld
Hi, I'm trying to configure mod_perl for use with persistent database connections with Apache::DBI RedHat 7.3 Apache 1.3.23 mod_perl 1.26 I've configured the following 'startup.pl' file: - #!/usr/bin/perl BEGIN { use Apach

Re: Apache::DBI and mod_perl 2

2003-02-18 Thread Kyle Oppenheim
[EMAIL PROTECTED] wrote: > Any plans to make Apache::FakeRequest work well enough to make this > possible? [EMAIL PROTECTED] wrote: > As for mod_perl 1.0, I'm not sure, but if you can make it useful > that would be cool. A while back Andrew Ho posted his script, apr, that is similar to Apache::Fa

Re: Apache::DBI and mod_perl 2

2003-02-17 Thread Stas Bekman
[EMAIL PROTECTED] wrote: Any plans to make Apache::FakeRequest work well enough to make this possible? There are plans. Here is an entry from modperl-2.0/todo/api.txt: Apache::FakeRequest: since APR can be used outside of httpd, and we can alloc request_rec and similar structures, it should be

RE: Apache::DBI and mod_perl 2

2003-02-17 Thread wsheldah
Any plans to make Apache::FakeRequest work well enough to make this possible? "Chris Faust" <[EMAIL PROTECTED]> on 02/17/2003 07:44:09 AM To:"Stas Bekman" <[EMAIL PROTECTED]> cc:"Dr. Helmut Zeilinger" <[EMAIL PROTECTED]>, "Modpe

RE: Apache::DBI and mod_perl 2

2003-02-17 Thread Chris Faust
>> Also remember, that you can't test modules that require mod_perl >> to run from >> the command line. You'd have the same result with mod_perl 1.0 >> Thanks, I didn't know that at all as I test all my modules that way and have never had a problem.. Of course most are not mod_perl specific. -Ch

Re: Apache::DBI and mod_perl 2

2003-02-16 Thread Stas Bekman
Chris Faust wrote: Hey Helmut, Yes, I'm sure its Apache::DBI - when I try to check for it directly via "perl -MModule::Name", I get the error.. Where is a copy paste from the command line. [chrisf@web1 chrisf]$ perl -MApache::DBI -e 0 Can't locate Apache/Constants.pm in

RE: Apache::DBI and mod_perl 2

2003-02-14 Thread Chris Faust
t; To: Chris Faust >> Cc: Modperl >> Subject: RE: Apache::DBI and mod_perl 2 >> >> >> On Fri, 14 Feb 2003, Chris Faust wrote: >> >> > Maybe that is the problem? >> > >> > I'm using 0.89 which is the newest from CPAN and that shows

RE: Apache::DBI and mod_perl 2

2003-02-14 Thread Nick Tonkin
On Fri, 14 Feb 2003, Chris Faust wrote: > Maybe that is the problem? > > I'm using 0.89 which is the newest from CPAN and that shows Jun 18.. > Is there a later version available? You can always search the archives of this list at http://marc.theaimsgroup.com/?l=apache-modperl&r=1&w=2 The mess

RE: Apache::DBI and mod_perl 2

2003-02-14 Thread Chris Faust
gt;> To: Chris Faust >> Cc: Modperl >> Subject: Re: Apache::DBI and mod_perl 2 >> >> >> >> >> Do you have the latest Apache::DBI ? Ask made a new one a couple of weeks >> ago to run with mp2. >> >> >> On Fri, 14 Feb 2003, Chris Fa

RE: Apache::DBI and mod_perl 2

2003-02-14 Thread Chris Faust
Hey Helmut, Yes, I'm sure its Apache::DBI - when I try to check for it directly via "perl -MModule::Name", I get the error.. Where is a copy paste from the command line. [chrisf@web1 chrisf]$ perl -MApache::DBI -e 0 Can't locate Apache/Constants.pm in @INC (@INC contains:

Re: Apache::DBI and mod_perl 2

2003-02-14 Thread Nick Tonkin
Do you have the latest Apache::DBI ? Ask made a new one a couple of weeks ago to run with mp2. On Fri, 14 Feb 2003, Chris Faust wrote: > Hi, > > My problem seems like one that would be well documented, but I can't find > anything in any of the docs and even goggle gr

Re: Apache::DBI and mod_perl 2

2003-02-14 Thread Dr. Helmut Zeilinger
Hi Chris, are you shure that is is the Apache::DBI, that needs the Apache::Constants or is it another module? For me Apache::DBI loads without problems (2.044/1.9908/5.8) even without the "use compat();" compatibility layer. Helmut --On Friday, February 14, 2003 09:00:31 -0500 C

Apache::DBI and mod_perl 2

2003-02-14 Thread Chris Faust
Hi, My problem seems like one that would be well documented, but I can't find anything in any of the docs and even goggle groups only had one message and the solution didn't relate. Anyway, I've updated to RedHat 8.0 and Apache 2.0.44 with Mod_Perl 1.99.08 and if I try to us

Re: [mp2] Connection pool with Apache::DBI and Oracle

2003-01-27 Thread Perrin Harkins
Georg Botorog wrote: Actuallly, I had no idea I am using mp2. I have downloaded some time ago a bundle with Perl, Apache, etc. (for NT), and I'm still using it today. Ah, okay NT is another key piece of information. Sorry, I don't use apache on NT so I thought that was a mp2 directive. So, yo

Re: [mp2] Connection pool with Apache::DBI and Oracle

2003-01-27 Thread Perrin Harkins
ously. However, Oracle has only one session for the job. Each thread has its own Perl interpreter and each one of those will have a persistent DBI connection when using Apache::DBI. Nothing is shared between threads unless you explicitly make it shared. There is currently no way to share DBI ha

RE: Connection pool with Apache::DBI and Oracle

2003-01-27 Thread Georg Botorog
nt: Friday, January 24, 2003 7:30 PM > To: Georg Botorog > Cc: [EMAIL PROTECTED] > Subject: Re: Connection pool with Apache::DBI and Oracle > > Georg Botorog wrote: > > More precisely, I am using Apache::DBI to create and cache the > > connection to the DB. As

Re: Connection pool with Apache::DBI and Oracle

2003-01-24 Thread Perrin Harkins
Georg Botorog wrote: More precisely, I am using Apache::DBI to create and cache the connection to the DB. As this connection uses a single Oracle session, it is obvious that it becomes a bottleneck. Apache::DBI uses one connection per process. There is no bottleneck there. Each process only

Connection pool with Apache::DBI and Oracle

2003-01-24 Thread Georg Botorog
Hi, I would like to know if there is a module that implements a pool of connections to an Oracle database. More precisely, I am using Apache::DBI to create and cache the connection to the DB. As this connection uses a single Oracle session, it is obvious that it becomes a bottleneck. On the

RE: [ANNOUNCE] Apache::DBI 0.90_02

2003-01-11 Thread Ask Bjoern Hansen
On Fri, 10 Jan 2003, Beau E. Cox wrote: > I had heard moving A:DBI to 2 was going to be very difficult! > I've been waiting... As Stas said, it really wasn't. You might even have been able to with Apache::compat; I did not try. The harder part is to make the database handles shared across a poo

Re: [ANNOUNCE] Apache::DBI 0.90_02

2003-01-11 Thread Stas Bekman
has a pool per proc/thread, no sharing. But you still benefit from the per-process cache just as in mod_perl 1.0. [...] 0.90_02 January 10, 2003 - Changes to make Apache::DBI load and function under mod_perl 2.0. _

RE: [ANNOUNCE] Apache::DBI 0.90_02

2003-01-11 Thread Beau E. Cox
CTED] Subject: [ANNOUNCE] Apache::DBI 0.90_02 Last night I spent a bit of time making a proper test for Apache::DBI and make it work without Apache.pm. Just now I made it work with mod_perl 2.0. I have only tested that very briefly. Until it hits your CPAN mirror, get it from: http://develooper.co

[ANNOUNCE] Apache::DBI 0.90_02

2003-01-10 Thread Ask Bjoern Hansen
Last night I spent a bit of time making a proper test for Apache::DBI and make it work without Apache.pm. Just now I made it work with mod_perl 2.0. I have only tested that very briefly. Until it hits your CPAN mirror, get it from: http://develooper.com/code/Apache::DBI/ Or from CVS

Re: Apache::DBI

2003-01-07 Thread Randy Kobes
On Mon, 6 Jan 2003, Paul Simon wrote: > --- Randy Kobes <[EMAIL PROTECTED]> wrote: > > > Are you using the latest versions of DBI and > > DBD::ODBC? > > If not, does an upgrade help? > > Those modules are - whatever was bundled with your > first, warmly supplied :), Perl 5.8 + apache2 package >

Re: Apache::DBI

2003-01-06 Thread Perrin Harkins
Paul Simon wrote: I wasn't sure if Apache::DBI was screwing with ORACLE, especially with persistent connections... The Apache::DBI code is really short and easy to read. Basically, it just doesn't close connections when you call disconnect. It also does automatic rollbacks at

Re: Apache::DBI

2003-01-06 Thread Paul Simon
--- Randy Kobes <[EMAIL PROTECTED]> wrote: > On Thu, 2 Jan 2003, Paul Simon wrote: > > > Hi all > > > > I have a feeling this may be [OT], "take it to the > DBI > > list..." But I'm hoping to eliminate as much as > > possible any susp

Re: Apache::DBI

2003-01-02 Thread Randy Kobes
On Thu, 2 Jan 2003, Paul Simon wrote: > Hi all > > I have a feeling this may be [OT], "take it to the DBI > list..." But I'm hoping to eliminate as much as > possible any suspicion that Apache::DBI/mod_perl is > causing my headache. I'm trying to push th

RE: Apache::DBI

2003-01-02 Thread Beau E. Cox
Hi Paul - It is my understanding that Apache::DBI is not yet implemented for Apache2/mod_perl2. I had to comment out my references to it in the startup script and/or the configuration file. Take a look at: http://beaucox.com/mason/mason-with-apmp2-mini-HOWTO.htm for further info. Aloha

Apache::DBI

2003-01-02 Thread Paul Simon
Hi all I have a feeling this may be [OT], "take it to the DBI list..." But I'm hoping to eliminate as much as possible any suspicion that Apache::DBI/mod_perl is causing my headache. I'm trying to push this platform at work ;) If anyone can shed some light on this then I&#x

Apache::DBI and db proxies

2002-11-25 Thread Rasoul Hajikhani
Folks, is there any benefit in using Apache::DBI when all db calls ought to go through db proxies? Thanks in advance -r

RE: Apache::DBI seg fault

2002-11-21 Thread Beau E. Cox
Message- From: Randy Kobes [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 21, 2002 4:57 AM To: Beau E. Cox Cc: Modperl Subject: Re: Apache::DBI seg fault On Wed, 20 Nov 2002, Beau E. Cox wrote: > I am using Apache::DBI on my test server - all OK. > > When I try to use it on my pro

Re: Apache::DBI seg fault

2002-11-21 Thread Randy Kobes
On Wed, 20 Nov 2002, Beau E. Cox wrote: > I am using Apache::DBI on my test server - all OK. > > When I try to use it on my production server, I get the > following-> stdout: > Shutting down httpd..done > Starting httpd [ PERL ] > Syntax OK > stderr: > /etc/

Apache::DBI seg fault

2002-11-20 Thread Beau E. Cox
Hi - I am using Apache::DBI on my test server - all OK. When I try to use it on my production server, I get the following-> stdout: Shutting down httpd..done Starting httpd [ PERL ] Syntax OK stderr: /etc/init.d/apache: line 206: 18040 Segmentation fault $HTTPD_BIN $INET6 -t -f /

Re: AW: Apache::DBI and password security

2002-11-15 Thread James G Smith
=?iso-8859-1?Q?=22Fa=DFhauer=2C_Wolfgang=2C_FCI3=22?= <[EMAIL PROTECTED] ads.net> wrote: >>>Hi, >>> >>>I want to build a database application based on mod_perl and Apache::DBI. >>>The goal of Apache::DBI is to get persistent database connections using >

Re: AW: Apache::DBI and password security

2002-11-15 Thread Matthew Byng-Maddick
On Fri, Nov 15, 2002 at 12:52:13PM +, Rafiq Ismail (ADMIN) wrote: > $Apache::PARANOID::dbiPassword > = $bfish->decrypt($encryptedPassword); > then whenever you want your password you access > $Apache::PARANOID::dbiPassword. > Hmm. I think that the guy who wrote Blowfish_PP would cu

Re: AW: Apache::DBI and password security

2002-11-15 Thread Rafiq Ismail (ADMIN)
On Fri, 15 Nov 2002, [iso-8859-1] "Faßhauer, Wolfgang, FCI3" wrote: >>Hmm. I think that the guy who wrote Blowfish_PP would cut my > danglies off >>for that one. > >This is an interesting idea. Cutting my danglies off? hmm. Sounds painful. >Many thanks to you, Rafiq! s'ok, although I wouldn't

AW: Apache::DBI and password security

2002-11-15 Thread "Faßhauer, Wolfgang, FCI3"
>>Yes, that's our plan, too. But the risk still remains that someone will get a look to the script. I think, there is a golden rule: Never put clear text passwords in files. Those files are stored in archives by backup for example. There maybe a lot >>of people (sysadmin, developer, ...) c

Re: AW: Apache::DBI and password security

2002-11-15 Thread Rafiq Ismail (ADMIN)
On Fri, 15 Nov 2002, [iso-8859-1] "Faßhauer, Wolfgang, FCI3" wrote: > > Have you thought of running your webserver as some 'www' user? You can > > then make your scripts readonly by a 'dev' group which the www user and > > the developes are members of. > >CORRECT: > >'readonly' should be 'only rea

AW: Apache::DBI and password security

2002-11-15 Thread "Faßhauer, Wolfgang, FCI3"
>>Hi, >> >>I want to build a database application based on mod_perl and Apache::DBI. >>The goal of Apache::DBI is to get persistent database connections using only >>one database user because of resource limits. The problem I see is that the >>password for

Re: Apache::DBI and password security

2002-11-15 Thread Rafiq Ismail (ADMIN)
On Fri, 15 Nov 2002, Rafiq Ismail (ADMIN) wrote: > On Fri, 15 Nov 2002, [iso-8859-1] "Faßhauer, Wolfgang, FCI3" wrote: > > one database user because of resource limits. The problem I see is that the > > password for connecting to the database is clear readable in the perl > > script. > > Does anyb

Re: Apache::DBI and password security

2002-11-15 Thread Rafiq Ismail (ADMIN)
On Fri, 15 Nov 2002, [iso-8859-1] "Faßhauer, Wolfgang, FCI3" wrote: > one database user because of resource limits. The problem I see is that the > password for connecting to the database is clear readable in the perl > script. > Does anybody know how to hide that password? Have you thought of run

Apache::DBI and password security

2002-11-15 Thread "Faßhauer, Wolfgang, FCI3"
Hi, I want to build a database application based on mod_perl and Apache::DBI. The goal of Apache::DBI is to get persistent database connections using only one database user because of resource limits. The problem I see is that the password for connecting to the database is clear readable in the

Re: When using Apache::DBI...

2002-11-05 Thread Perrin Harkins
Clinton Gormley wrote: Am I correct in this: Apache::DBI can only really do its stuff when you perform a DBI->connect, so by calling $dbh = DBI->connect(..) during PerlChildInit and then never trying to reconnect, you are defeating the purpose of using Apache::DBI. That's right.

When using Apache::DBI...

2002-11-05 Thread Clinton Gormley
Am I correct in this: Apache::DBI can only really do its stuff when you perform a DBI->connect, so by calling $dbh = DBI->connect(..) during PerlChildInit and then never trying to reconnect, you are defeating the purpose of using Apache::DBI. To expand on this, when Apache::DBI interc

POD re-written for Apache::DBI

2002-11-03 Thread Lee Goddard
I just read the POD for Apache::DBI, and then rewrote it. Hope no-one is offended, that no meaning is lost, and that the revision is worth looking at and perhaps including on CPAN. Cheers lee (now offlist) =head1 NAME Apache::DBI - Initiate a persistent database connection =head1 SYNOPSIS

  1   2   3   4   5   6   >