I try to install DBI in my apache 1.3.9 and modperl 1.21 which I got the
message like:
esip 305# perl Makefile.PL
Writing Makefile for Apache::DBI
esip 306# make
Manifying blib/man3/Apache::DBI.3
Manifying blib/man3/Apache::AuthDBI.3
esip 307# make install
Skipping /usr/freeware/lib/perl5
I'm not sure exactly what you problem is, but I would venture to guess that
DBI is not installed?
Apache::DBI is different than DBI, thus you must have
Apache::DBI
DBI
DBD::database of choice (DBD::Oracle for you)
on your machine to take advantance of Apache::DBI
Anyway, if you already have
On Mon, 8 Nov 1999, Vivek Khera wrote:
"JV" == Jearanai Vongsaard [EMAIL PROTECTED] writes:
JV I try to install DBI in my apache 1.3.9 and modperl 1.21 which I got the
JV message like:
You installed the Apache::DBI module, but forgot to install the DBI
module itself. You al
"JV" == Jearanai Vongsaard [EMAIL PROTECTED] writes:
JV Thanks for your help. Now I am installing DBD::Oracle. BUt I still have a
JV question "What do you mean about the DBI module itself?" Does it mean
JV Apache::DBI?
No, it means DBI. Just plain DBI. Where you get D
Stephane Benoit wrote:
To do it yourself wich is probably the best way (no confilct with
existing perl etc...) :
* please forgive name errors (like tarballs and dir names) as I'm
writting from what i remeber when i did it *
[...steps to a apache-mod_ssl with static mod_perl...]
this is
to the database.
The questions I have mostly pertain to database connection caching. There
seem to be three different modules that all purport to cache the database
connection: DBI itself (using connect_cached), Apache::DBI, and DBD::Proxy.
What are folks out there using for the connection pooling
to the database.
The questions I have mostly pertain to database connection caching. There
seem to be three different modules that all purport to cache the database
connection: DBI itself (using connect_cached), Apache::DBI, and
DBD::Proxy.
Apache::DBI caches the database handle, while
Dear folks,
I am installing and setting up a RH 6.1 system with (quoting
/var/log/httpd/error_log):
Apache/1.3.9 (Unix) mod_ssl/2.4.6 OpenSSL/0.9.4 mod_perl/1.21 configured
When I put use Apache::DBI (); into my startup.pl, or PerlModule
Apache::DBI into my perl.conf, then httpd stops
Jeffrey Baker [EMAIL PROTECTED] writes:
That's what the driver handle's ping method is for.
if (!$dbh-ping) { reconnect; }
I suppose I could do a ping before every page, but really that's only a kludgy
work-around. Really I would want to do this before every single query, and the
right way
Tim Bunce [EMAIL PROTECTED] writes:
Has anyone experienced a situation where a process (httpd for example)
can't reconnect to Oracle after a "shutdown abort"?
Tim.
As far as I can tell we never get a clean reconnection after any sort of
connection problem. I don't even think it takes a
I'm making a first attempt to run a working Perl CGI run under mod_perl.
It uses perl dbi successfully under CGI. When invoking the script under
mod_perl, I get the following error:
[Tue Nov 2 11:49:43 1999] [error] Can't load
'/usr/lib/perl5/site_perl/5.005/i386-linux/auto/DBI/DBI.so
I'm making a first attempt to run a working Perl CGI run under mod_perl.
It uses perl dbi successfully under CGI. When invoking the script under
mod_perl, I get the following error:
[Tue Nov 2 11:49:43 1999] [error] Can't load
'/usr/lib/perl5/site_perl/5.005/i386-linux/auto/DBI/DBI.so
:[EMAIL PROTECTED]]
Sent: Tuesday, November 02, 1999 4:39 AM
To: Tim Bunce
Cc: mod-perl Mailing List; DBI Users Mailing List
Subject: Re: Failing to reconnect after Oracle "shutdown abort"
(Apache::DBI)
Tim Bunce [EMAIL PROTECTED] writes:
Has anyone experienced a situa
be a user script error. The old database handle was being
reused, rather than the new one returned from a fresh call to
DBI-connect after the shutdown and restart.
I'd be interested in seeing a DBI trace file (level 2) from anyone else
who thinks they have this problem. Please send me
kind of project you are building and how the problem is
manifested? We are doing web stuff with Apache, mod_perl, and DBI.
-jwb
Greg Stark wrote:
*** From dbi-users - To unsubscribe, see the end of this message. ***
*** DBI Home Page - http://www.symbolstone.org/technology/perl/DBI/ ***
Tim Bunce [EMAIL PROTECTED] writes:
On Mon, Nov 01, 1999 at 09:01:48PM +, Tim Bunce wrote:
Has anyone
Has anyone experienced a situation where a process (httpd for example)
can't reconnect to Oracle after a "shutdown abort"?
Tim.
Tim,
We have that problem here at the U. We always have to restart the server.
If there is some other way to fix this or some notification to the process
I would greatly appreciate it.
-tom
P.S. We use Apache/mod_perl/DBI
At 09:01 PM 11/1/1999 +, Tim Bunce wrote:
Has anyone experienced
Hi ,
I have a perl script which connects to the
oracle database. I want to know if i can lock the
script. i.e even if there are many requests to the
server for the same script there will be no
concurrency update problems.
Also how i implement commit rollbacks in a script.
thanks for help in
Greg Stark wrote:
*** From dbi-users - To unsubscribe, see the end of this message. ***
*** DBI Home Page - http://www.symbolstone.org/technology/perl/DBI/ ***
Tim Bunce [EMAIL PROTECTED] writes:
On Mon, Oct 18, 1999 at 07:08:09AM -0700, Michael Peppler wrote:
Tim Bunce writes
Greg Stark writes:
Michael Peppler [EMAIL PROTECTED] writes:
Greg Stark wrote:
Actually not - Sybase creates a temporary stored proc for each prepared
statement, so it's equivalent to using stored procedures.
Heh neat, is that DBD::Sybase or the server that's doing that?
#define PERL_STARTUP_DONE_CHECK 1
Thanks Gerald, this worked like a charm! And thanks to everyone else for
the input on this one. It really helped ALOT!
Great :-)
Now all I have to do is rebuild perl with USE_THREADS. I had someone else
play with getting mod_perl setup under NT
Hopefully you have a startup script you use to load various modules
into the server memory. If so, could you add the following to it:
BEGIN {
$ENV{DBI_TRACE} = 2;
}
This will cause DBI and Apache::DBI (as the case may be) to put a LOT
of information into the error file. This might
try setting trace to level 6 for greater detail...
BTW, you can also separate the trace output from your error_log via
DBI-trace(6,"/path/to/trace.log");
from within your handler or script.
Are you using the latest drivers?
--Geoff
-Original Message-
From: Dan Mahoney [S
try setting trace to level 6 for greater detail...
BTW, you can also separate the trace output from your error_log via
DBI-trace(6,"/path/to/trace.log");
from within your handler or script.
Cool, I did that - thanks for the pointer! Of course,
the output is even more mysterious
well, it looks like you are using Apache::DBI? Did you try disabling that?
also, not that it matters for this problem, but setting RaiseError will keep
you from needing all those ||die things:
$dbh = DBI-connect("dbi:mysql:database=news", "user", "pass&
Now all I have to do is rebuild perl with USE_THREADS. I had someone else
play with getting mod_perl setup under NT and i don't think that they did
it quite right. It seems like I only have one interpreter thread that is
being shared by all the different apache child threads. Does this
Alex Menendez [EMAIL PROTECTED] wrote:
this destroy routine is definitely a problem (may or may not be the cause
of the error though) apache::dbi over-rides the dbi connect method in
order to check an internal hash of cached db handles so that an existing
connection can be returned rather than
On Tue, 26 Oct 1999, Gerald Richter wrote:
I have been digging around in the FAQ and archives for information about
people running mod_perl on a windows box and also using Apache::DBI, but
have come up with nothing. I am under the impression that it is not
going to work becase
I've got a weird problem here involving DBI under
mod_perl.
I have a simple Perl script that works from the
command line:
-
#!/usr/local/bin/perl
use strict;
use DBI;
my ($dbh, $sth, $f, $head) = undef;
$dbh = DBI-connect
Dan Mahoney [EMAIL PROTECTED] wrote:
I've got a weird problem here involving DBI under
mod_perl.
[snip]
Hopefully you have a startup script you use to load various modules
into the server memory. If so, could you add the following to it:
BEGIN {
$ENV{DBI_TRACE} = 2;
}
This will cause DBI
On Tue, 26 Oct 1999, Tim Bunce wrote:
Can't locate object method "trace_msg" via package "DBI" at
C:\Perl\site\5.00503\lib/DBI.pm line 311.
END failed--cleanup aborted.
That's a known bug that was fixed in DBI 1.10 (I believe).
Just FYI, I had the
I have been digging around in the FAQ and archives for information about
people running mod_perl on a windows box and also using Apache::DBI, but
have come up with nothing. I am under the impression that it is not
going to work becase whenever I try to load up the Apache::DBI module
apache
I have been digging around in the FAQ and archives for information about
people running mod_perl on a windows box and also using Apache::DBI, but
have come up with nothing. I am under the impression that it is not
going to work becase whenever I try to load up the Apache::DBI module
apache
However, at the time of that test, I was using:
DBI 1.13
ApacheDBI 0.85
ModPerl 1.21
Apache 1.3.9
Perl 5.005_03 built for MSWin32-x86
I still have that machine, and I will willingly re-do the tests if
anybody wishes to join the discussion.
I have
DBI 1.08
Apache::DBI 0.81
mod_perl
Anyone having this problem can also fix it by adding this line to the top
of the END block (around line 311):
return unless defined DBI::trace_msg; # return unless bootstrap'd ok
If this works, it seems to be the easiest solution.
Thank you Tim.
Victor.
On Tue, Oct 26, 1999 at 03:57:09PM +0200, Gerald Richter wrote:
However, at the time of that test, I was using:
DBI 1.13
ApacheDBI 0.85
ModPerl 1.21
Apache 1.3.9
Perl 5.005_03 built for MSWin32-x86
I still have that machine, and I will willingly re-do the tests if
anybody
On Tue, Oct 26, 1999 at 11:59:07AM +0200, Victor Zamouline wrote:
I have been digging around in the FAQ and archives for information about
people running mod_perl on a windows box and also using Apache::DBI, but
have come up with nothing. I am under the impression that it is not
going
Hi mod_perlers,
I have been digging around in the FAQ and archives for information about
people running mod_perl on a windows box and also using Apache::DBI, but
have come up with nothing. I am under the impression that it is not
going to work becase whenever I try to load up the Apache::DBI
On Mon, Oct 18, 1999 at 07:08:09AM -0700, Michael Peppler wrote:
Tim Bunce writes:
On Fri, Oct 15, 1999 at 11:42:29AM +0100, Matt Sergeant wrote:
On Fri, 15 Oct 1999, Perrin Harkins wrote:
On Thu, 14 Oct 1999, Jeffrey Baker wrote:
Zero optimization: 41.67 requests/second
Hi all,
I'm trying out Apache::Session for the first time, with this bit of code
adapted from the manual:
#!/usr/bin/perl -w
use strict;
#use Apache::Session::File;
use Apache::Session::DBI;
my %session;
#make a fresh session for a first-time visitor
#tie %session, "Apache::Session:
On Fri, 15 Oct 1999, Perrin Harkins wrote:
On Thu, 14 Oct 1999, Jeffrey Baker wrote:
Zero optimization: 41.67 requests/second
Stage 1 (persistent connections): 140.17 requests/second
Stage 2 (bound parameters): 139.20 requests/second
Stage 3 (persistent statement handles): 251.13
application performance with DBI
On Thu, 14 Oct 1999, Jeffrey Baker wrote:
Zero optimization: 41.67 requests/second
Stage 1 (persistent connections): 140.17 requests/second
Stage 2 (bound parameters): 139.20 requests/second
Stage 3 (persistent statement handles): 251.13 requests
On Thu, Oct 14, 1999 at 05:53:15PM -0700, Perrin Harkins wrote:
On Thu, 14 Oct 1999, Jeffrey Baker wrote:
Zero optimization: 41.67 requests/second
Stage 1 (persistent connections): 140.17 requests/second
Stage 2 (bound parameters): 139.20 requests/second
Stage 3 (persistent statement
On Thu, 14 Oct 1999, Jeffrey Baker wrote:
Zero optimization: 41.67 requests/second
Stage 1 (persistent connections): 140.17 requests/second
Stage 2 (bound parameters): 139.20 requests/second
Stage 3 (persistent statement handles): 251.13 requests/second
I know you said you don't like it
Perrin Harkins wrote:
On Thu, 14 Oct 1999, Jeffrey Baker wrote:
Zero optimization: 41.67 requests/second
Stage 1 (persistent connections): 140.17 requests/second
Stage 2 (bound parameters): 139.20 requests/second
Stage 3 (persistent statement handles): 251.13 requests/second
I know
"Jeffrey W. Baker" wrote:
Perrin Harkins wrote:
On Thu, 14 Oct 1999, Jeffrey Baker wrote:
Zero optimization: 41.67 requests/second
Stage 1 (persistent connections): 140.17 requests/second
Stage 2 (bound parameters): 139.20 requests/second
Stage 3 (persistent statement handles):
On Thu, 14 Oct 1999, Perrin Harkins wrote:
Date: Thu, 14 Oct 1999 17:53:15 -0700 (PDT)
From: Perrin Harkins [EMAIL PROTECTED]
To: Jeffrey Baker [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED], [EMAIL PROTECTED], [EMAIL PROTECTED]
Subject: Re: More on web application performance with DBI
On Thu
I included the command "PerlModule Apache::DBI" in my mod_perl Apache
configuration files. Yet, over time there builds up more connection in
mysql than apache processes (only Apache/CGI should be accessing MySQL) and
most processes seem to have very high "Time"s un
Do you really need the persistent connections when using mysql? Since mysql is
so fast to connect, I've just been using regular DBI connection methods. I
have one connection opened per request, and when the request is done, the
connection gets closed. It's fast enough for me, you should do
Viren Jain wrote:
I included the command "PerlModule Apache::DBI" in my mod_perl Apache
configuration files. Yet, over time there builds up more connection in
mysql than apache processes (only Apache/CGI should be accessing MySQL) and
most processes seem to have very hi
Good day.
I have 2 things are not very clear to me.
I'm working with ApacheDBI-0.82.
1) Does Apache::DBI cashing for Apache::AuthenDBI and for regular
DBI-connect by Apache::Registry in same time.
I mean one connection per child for authentification and for
Apache::Registry scripts.
The userid
"Sergey V. Kolychev" wrote:
Good day.
I have 2 things are not very clear to me.
I'm working with ApacheDBI-0.82.
1) Does Apache::DBI cashing for Apache::AuthenDBI and for regular
DBI-connect by Apache::Registry in same time.
I mean one connection per child for authen
I have compiled mod_perl statically and the rest as dso's and i have no more problems
No need to recompile perl unless you want perl threads.
RH61, Apache 1.3.9 / Mod_ssl 246 / Modperl 1.21 / Mod_php 3012
Cheers
Nick Urbanik wrote:
Dear Edmund,
thank you for taking the time to reply.
To do it yourself wich is probably the best way (no confilct with
existing perl etc...) :
* please forgive name errors (like tarballs and dir names) as I'm
writting from what i remeber when i did it *
1 get apache-mod_ssl-1.3.9.2.4.6-0.6.0.src.rpm (from
http://www.modssl.org)
2 get
Apache::DBI caches the database handle, while connect_cached cache the
statement handle, so you could/should use both together.
You're thinking of prepare_cached.
Oops, you are right! Wrote this mail too early in the morning...
Gerald
801 - 856 of 856 matches
Mail list logo