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)
|| die $dbh-errstr;
$sth-execute() || die $sth
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, but Apache::DBI...
use DBI;
sub connect
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-execute() || die $sth-errstr;
while(my $row
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 was idle for too long ( 8 hours ) the connection would
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 DBI, but lists
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 your code that connects to a database during
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 shouldn't
have done.
Sorry, that is not correct. It's
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
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://search.cpan.org/author/TIMB/DBI-1.37/DBI.pm
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. Also, what's the point
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 criticism for my config
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 horrible
time with a new server I've
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 [EMAIL
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 that, you can add
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 smart enough to pass something back to the database server
telling
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
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
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 documentation
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.
Further down the script, I have:
use Apache::DBI;
DBI
- 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
BECShould I use 'connect' in my startup.pl?
BEC
BEC Have
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.
First
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 processes really? Each
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 from separate
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 also wasteful, since it's going to
do work that has
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 MP2
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
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
winFU, runs
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's correct. Since Apache
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's correct
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::DBI
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,
the DBI connect statements
[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
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 know it has
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
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 this
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
, 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 work is great. Thank you. :-)
My pleasure
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::DBI
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
Apache::compat would have global
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 thought loading
Apache
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
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
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 DBI will be able
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 in the near future, as
SB
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-modperlm=104225578207460w=2
which leads me to my question
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
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_PerlRequire
_Directives
Ric
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/guide/config.html
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.
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 suggested).
Ric
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
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 Apache ();
use lib '/etc
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.
[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
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.
-Chris
[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
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 @INC (@INC contains:
/usr
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 use Apache::DBI I
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 Chris Faust
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 groups only had one message
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:
/usr/lib/perl5/5.8.0
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 Faust wrote:
Hi,
My problem seems like one that would be well documented, but I
can't find
anything in any of the docs
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-modperlr=1w=2
The message
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 Jun 18..
Is there a later version available?
You can always search the archives of this list at
http
, 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 this connection uses a single Oracle
session
. 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 handles
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,
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
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
: [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.com/code/Apache
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.
__
Stas
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 pool
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
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
on theoryx5.
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 the end
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'd be very appreciative
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 = Beau
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 this platform
at work ;) If anyone can shed some
Folks,
is there any benefit in using Apache::DBI when all db calls ought to go
through db proxies?
Thanks in advance
-r
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/init.d/apache: line 206: 18040 Segmentation
-
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 production server, I get
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 /etc
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 running
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 anybody know
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
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 readable' by
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, ...)
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 implement
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 cut my
=?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
only
one database user because of resource limits
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 intercepts
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.
To expand
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
Hi there,
On Thu, 17 Oct 2002, John Cameron wrote:
I am finding that the number of open number of database connections I have
open at one time is varying wildly.
Then, Suddenly, the number of connctions jumps up to 50 or more! Sometimes
this falls back to below 20, but sometimes this
of
Apache::DBI. However, you should only have one per httpd process.
Does anyone have any tips on how to, at this point, go about detecting
where the handle leak might be (which I'm presuming is the problem)?
http://perl.apache.org/docs/1.0/guide/databases.html#Debugging_Apache__DBI
should
On Wed, 16 Oct 2002, Kirk Bowe wrote:
my $dbh = DBI-connect (dbi:Pg:dbname=hello, postgres, foo);
my %orig = ();
my @attrs = qw(AutoCommit RaiseError);
$orig{$_} = $dbh-{$_} for @attrs;
$dbh-{AutoCommit} = 0; $dbh-{RaiseError} = 1;
When I later do the $dbh-commit, it fails with this
20, but sometimes this keeps climbing. Server load
hits over 50 (99.9% taken by mysql) and the system grinds to a halt.
Since I am using Apache::DBI, I thought there was meant to be 20 db
connections always, and no more or less.
I am pretty sure that we are always disconnecting our database
Hi,
I am learning lots of new things, but still working on the problem itself.
It seems to be the case that even when I am running under ./httpd -X
I have trouble getting the search query to get stuck. If I do something
from the mysql monitor like set an order on hold directly with a query,
that if I make the dbh accessible
via an object, usually together with Apache::DBI in the background, I can
often do clean up stuff, such as closing the handle (incase Apache::DBI
isn't in place with a particular invokation of the package), last system
logging updates/inserts, or whatever the job
On 15 Oct 2002 at 7:12, Eric Frazier wrote:
I am learning lots of new things, but still working on the problem itself.
It seems to be the case that even when I am running under ./httpd -X I have
trouble getting the search query to get stuck. If I do something from the
mysql monitor like set
1 - 100 of 498 matches
Mail list logo
