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
.
But when I do it from my mod_perl app, it sometimes jumps by two. I know the sequence will advance even if there's an error, but I'm not getting any error messages back from DBI.
Has anyone else run across something like this? I know this is kind of off topic, but it maybe related to mod_perl's
happen. If two processes incremented the
sequence at the same time, what would the function return, the value
for that connection's insert, or the value of the other session?
Especially when I added Apache::DBI to the mix where db connections appear
to be pooled and shared. This way I know I'm getting
esn't
call execute on the insert handle with the new row data
then call the select by name handle to get the id that was used to create new row.
all of my execute statements have "or die $DBI::errstr;" tacked on the end to catch any errors.
[EMAIL PROTECTED] wrote:
Do you have any
Hello all,
I know from a DBI perspective, when using PostgreSQL, if I create a temporary
database table it will automatically go *poof* and be deleted when the
database connection is closed (or when the transaction is finished...I can't
remember which). Anyway, what will happen if code
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
On Tue, 22 Jul 2003 14:15:41 -0700
Michael A Nachbaur [EMAIL PROTECTED] wrote:
Hello all,
I know from a DBI perspective, when using PostgreSQL, if I create a
temporary database table it will automatically go *poof* and be
deleted when the database connection is closed (or when
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
for this feature.
If the physical connection is still there, would the database server
do a rollback?
- ask
ps. yes, your DBI::Pool work is great. Thank you. :-)
--
ask bjoern hansen, http://www.askbjoernhansen.com/ !try; do();
of the constraints of
sharing Perl datastructures and underlying C structs.
ps. yes, your DBI::Pool work is great. Thank you. :-)
My pleasure. Thanks for the kind words. It's quite challenging, though you
stop getting excited about segfaults and ddd (gdb frontend) is nowadays my
best friend
, 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.
, the DSO mod_perl works fine except when I preload DBI.
I'm _quite_ confused. I'd really like the DSO method to work, as then I
wouldn't have to modify the OpenBSD source tree (any more than I
normally
do, anyway). Does anyone have suggestions?
This sounds kind of similar to some
On Wed, Feb 26, 2003 at 01:09:46AM -0500, Dan Brosemer wrote:
Here's the thread to date:
http://marc.theaimsgroup.com/?l=apache-modperlm=104586287823510w=2
helo;
I am seeing problems with mod_perl in OpenBSD 3.2
chroot env. This has me twiddling my thumbs after tailing my
error_log:)
On Wed, Feb 26, 2003 at 11:45:32AM -0700, [EMAIL PROTECTED] wrote:
On Wed, Feb 26, 2003 at 01:09:46AM -0500, Dan Brosemer wrote:
Here's the thread to date:
http://marc.theaimsgroup.com/?l=apache-modperlm=104586287823510w=2
helo;
I am seeing problems with mod_perl in OpenBSD 3.2
chroot
On Wed, Feb 26, 2003 at 02:05:24PM -0500, Dan Brosemer wrote:
This is not the problem I'm seeing at all. You'll note from this thread
http://monkey.org/openbsd/archive/misc/0302/msg01943.html
that I see this same problem when using the sources from apache.org (no
chroot available to be a
when I preload DBI.
I'm _quite_ confused. I'd really like the DSO method to work, as then I
wouldn't have to modify the OpenBSD source tree (any more than I normally
do, anyway). Does anyone have suggestions?
Even pointers for where in the code to look would be much appreciated.
TIA.
-Dan
On Fri, 21 Feb 2003, Dan Brosemer wrote:
Hi. I'm new here, and hoping someone can help me. I've installed the
latest -current version of OpenBSD, and loaded mod_perl as a DSO. That gets
me Apache 1.3.27, Perl 5.8.0, and mod_perl 1.27.
[...]
These are taken using DBD::mysql. I'd be happy
when you installed it?
When I 'make test', Msql-Mysql-modules-1.2219 reports:
All tests successful, 1 test and 14 subtests skipped.
Since my test program runs fine outside of a webserver, or in mod_perl when
DBI isn't preloaded, I'm not surprised.
Wouldn't that imply that the problem is in DBI's
Hi Dan,
i had a similar problem with DBI. Did you reinstall (recompile) the
DBI module after you installed Perl 5.80 from a previous Perl version (and
maybe all DBD drivers)?
Helmut
--On Friday, February 21, 2003 16:28:19 -0500 Dan Brosemer
[EMAIL PROTECTED] wrote:
Hi. I'm new here
On Sun, Feb 23, 2003 at 04:26:51PM +0100, Dr. Helmut Zeilinger wrote:
Hi Dan,
i had a similar problem with DBI. Did you reinstall (recompile) the
DBI module after you installed Perl 5.80 from a previous Perl version (and
maybe all DBD drivers)?
No. This was a fresh install of OpenBSD 3.3
Hi. I'm new here, and hoping someone can help me. I've installed the
latest -current version of OpenBSD, and loaded mod_perl as a DSO. That gets
me Apache 1.3.27, Perl 5.8.0, and mod_perl 1.27.
Apache starts fine, but when I try to access any script that does
DBI-connect(...), it generates
This is the last piece in my implementation. If anyone can help with how to
debug this or what is wrong with my configuration, I'd really appreciate it!
I'm trying DBI::Auth against a Postgresql database for authentication. It's
not working. My postgres debug log shows no activity as well
[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
I'm trying DBI::Auth against a Postgresql database for authentication. It's
not working. My postgres debug log shows no activity as well as this error
regarding my configuration. I don't know how to debug this. Anyone able to
help?
Error Log from Apache shows:
[Tue Feb 18 16:13:53 2003
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
Has anyone any information on success/horror stories for using DBI in apache config
files. I have a number of
PerlModule Library::Module
Location '/Module'
SetHandler Perl-Script
PerlHandler Library::Module
/Location
Type configs.
I can very easily extract this information from
in a simple
text file, or you could use mod_macro. I'm sure it would work to put
them in DBI (although you'd better close that connection before Apache
forks!), but then you have a bunch of config data that can only be
changed by messing with SQL and can no longer be easilly viewed, diffed,
versioned
, 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
, you are using 1.x on NT. With 1.x, all requests are handled
serially on NT, which explains the behavior you're getting. It's
actually not related to DBI at all.
See http://perl.apache.org/docs/1.0/os/win32/multithread.html for the
full story.
- Perrin
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
Should I expect DBI to work with mod_perl2? I have a simple script that
just connects to a MySQL database and reports success or faiure. When I
run it from cgi-bin as a regular CGI script, it succeeds. When I put it in
my mod_perl script directory, it runs, but fails to connect. My mod_perl
Daryl Lee wrote:
Should I expect DBI to work with mod_perl2? I have a simple script that
just connects to a MySQL database and reports success or faiure. When I
run it from cgi-bin as a regular CGI script, it succeeds. When I put it in
my mod_perl script directory, it runs, but fails
: [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
Randy -
Thank you, I owe you lunch.
I thought I checked all relevant module versions, but your
msg spurred me to check again: DBI 1.28 was on production while
DBI 1.30 was on test! 1.30 WORKS! 1.28 DOESN'T WORK.
All is well - I am one happy camper ;)
Aloha = Beau.
-Original Message
1 - 100 of 856 matches
Mail list logo
