Re: Apache::DBI

2000-05-22 Thread Perrin Harkins
must use them in? Apache::DBI installed without a hitch, are there other pitfalls of which I should be aware? Yes, the Apache::DBI docs explain that you must load it before any other DBI-related modules. - Perrin

Re: DBD::Oracle Apache::DBI

2000-05-22 Thread Amy
/Apache::DBI environment everything seems fine. Once the db connection is in this state, it's useless until the server gets a restart. My connect strings look good and agree, I put Stas' ping method in the DBD::Oracle::db package, set a low timeout, called Oracle (they don't want to hear about

RE: :Oracle Apache::DBI

2000-05-22 Thread Ed Park
, this happens _very_ rarely. Hope this helps, Ed -Original Message- From: Ian Kallen [mailto:[EMAIL PROTECTED]] Sent: Monday, May 22, 2000 9:37 PM To: [EMAIL PROTECTED] Subject: DBD::Oracle Apache::DBI I've done everything I can think of to shore up any DB connection flakiness but I'm

Re: DBD::Oracle Apache::DBI

2000-05-22 Thread Paul Lindner
a problem under mod_perl, outside of the mod_perl/Apache::DBI environment everything seems fine. Once the db connection is in this state, it's useless until the server gets a restart. My connect strings look good and agree, I put Stas' ping method in the DBD::Oracle::db package, set a low

Re: Q: DBMS update framework for use within Apache::DBI?

2000-05-20 Thread w trillich
"Bruce W. Hoylman" wrote: "Gunther" == Gunther Birznieks [EMAIL PROTECTED] writes: Gunther This first criteria seems a tad odd to me. What business Gunther scenario is there for this? The framework is to support an intranet time tracking application. The business rules of the

Re: Q: DBMS update framework for use within Apache::DBI?

2000-05-18 Thread Gunther Birznieks
At 12:16 PM 5/17/00 -0600, Bruce W. Hoylman wrote: Ciao! I am searching for the makings of a framework built around or within mod_perl/Apache::DBI that supports the consistent update of a record within a database. Primarily I am wanting to ensure read/write integrity between database accesses

Re: Q: DBMS update framework for use within Apache::DBI?

2000-05-18 Thread Bruce W. Hoylman
the client requesting the period. If there is no default time record available, then a 0-hour time record is presented for modification/submission (also an insert). Gunther An application which implements #2 and is accelerated when Gunther used with mod_perl (Apache::Registry) and A

Confusion on Apache::DBI

2000-05-18 Thread Niral Trivedi
All, Sorry if this question sounds stupid.. but I am new to mod_perl and Apache::DBI.. I have successfully installed Apache Server 1.3.12 and mod_perl 1.24 and Apache::DBI 0.87 on Solaris 2.7. And I have tested all successfully... But confusion arised when I created a startup.pl file and tried

RE: Confusion on Apache::DBI

2000-05-18 Thread Geoffrey Young
-Original Message- From: Niral Trivedi [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 18, 2000 1:11 PM To: '[EMAIL PROTECTED]' Subject: Confusion on Apache::DBI All, Sorry if this question sounds stupid.. but I am new to mod_perl and Apache::DBI.. I have successfully

Re: Confusion on Apache::DBI

2000-05-18 Thread Niral Trivedi
Thanks Geoff, You were right... I was using "DBI:mysql:DBNAME::localhost" as connect string in startup file whereas "DBI:mysql:DBNAME" in my mod_perl script.. I have changed that and it worked... Now, another question.. As we agreed, we can have as many db handle available as server processes

RE: Confusion on Apache::DBI

2000-05-18 Thread Geoffrey Young
-Original Message- From: Niral Trivedi [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 18, 2000 3:15 PM To: Geoffrey Young Cc: '[EMAIL PROTECTED]' Subject: Re: Confusion on Apache::DBI Thanks Geoff, You were right... I was using "DBI:mysql:DBNAME::localhost"

RE: Confusion on Apache::DBI

2000-05-18 Thread Geoffrey Young
-Original Message- From: Niral Trivedi [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 18, 2000 3:57 PM To: Geoffrey Young Cc: '[EMAIL PROTECTED]' Subject: Re: Confusion on Apache::DBI Geoff, I know, once child dies, db handle goes out of scope and DBI cleans up

Re: Confusion on Apache::DBI

2000-05-18 Thread Perrin Harkins
On Thu, 18 May 2000, Niral Trivedi wrote: Now, with Apache::DBI, we'll have one DBI handle per child process during the server startup. Now, let's say one child has started its processing and hasn't served any request yet. Now, first request comes in and it will look for DB handle, which

Re: Confusion on Apache::DBI

2000-05-18 Thread Niral Trivedi
I understood now... Thank you all for your responses.. Niral Perrin Harkins wrote: On Thu, 18 May 2000, Niral Trivedi wrote: Now, with Apache::DBI, we'll have one DBI handle per child process during the server startup. Now, let's say one child has started its processing and hasn't

RE: Apache::DBI and autocommit

2000-05-17 Thread Geoffrey Young
-Original Message- From: Perrin Harkins [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 16, 2000 10:32 PM To: William Deegan Cc: [EMAIL PROTECTED] Subject: Re: Apache::DBI and autocommit On Tue, 16 May 2000, William Deegan wrote: If autocommit is not set and a script exits

Re: Apache::DBI and autocommit

2000-05-17 Thread Matt Sergeant
On Tue, 16 May 2000, William Deegan wrote: Greetings, from the various perldocs and web pages I understand the following to be true. If autocommit is not set and a script exits the transaction will be rolled back. The question I have is when the database handle is re-used will the

Q: DBMS update framework for use within Apache::DBI?

2000-05-17 Thread Bruce W. Hoylman
Ciao! I am searching for the makings of a framework built around or within mod_perl/Apache::DBI that supports the consistent update of a record within a database. Primarily I am wanting to ensure read/write integrity between database accesses by the web client, meaning I wish to ensure

Re: Apache::DBI-connect_on_init in BEGIN?

2000-05-16 Thread Doug MacEachern
On Sun, 14 May 2000, svante [iso-8859-1] sörmark wrote: hi all, what i'd like to do is "pre-initialize" my DBI connections from whithin my PerlHandler's BEGIN block. something like this: BEGIN { if ( Apache-dir_config('CONNECT_ON_INIT') { A

Re: Apache::DBI-connect_on_init in BEGIN?

2000-05-16 Thread svante sörmark
Doug MacEachern wrote: connect_on_init was written to be a PerlChildInitHandler, it doesn't make sense to use it anywhere else. ok, that would accomplish pretty much the same thing i guess. the problem is i can't seem to find a way to get configration variables from httpd.conf inside a

Re: Apache::DBI-connect_on_init in BEGIN?

2000-05-16 Thread Doug MacEachern
the problem is i can't seem to find a way to get configration variables from httpd.conf inside a BEGIN or a PerlChildInitHandler. i set the variables with PerlSetVar inside Location ... sections. use Apache-server-dir_config as eric already suggested to you. you'll have to move the

Apache::DBI and autocommit

2000-05-16 Thread William Deegan
Greetings, from the various perldocs and web pages I understand the following to be true. If autocommit is not set and a script exits the transaction will be rolled back. The question I have is when the database handle is re-used will the autocommit still be unset if the script that set it

Re: Apache::DBI and autocommit

2000-05-16 Thread Perrin Harkins
On Tue, 16 May 2000, William Deegan wrote: If autocommit is not set and a script exits the transaction will be rolled back. The question I have is when the database handle is re-used will the autocommit still be unset if the script that set it errors out? Yes, Apache::DBI doesn't touch

Re: Apache::DBI-connect_on_init in BEGIN?

2000-05-14 Thread Jeff Beard
mark wrote: yeah, i know about startup.pl, and i have been using it until now, but the goal here was to avoid having to put the same configuration in two different files :). Jeff Beard wrote: Checkout the sample startup.pl that comes with Apache::DBI. --Jeff At 05:08 PM 5/14/00, svante sör

Re: Apache::DBI-connect_on_init in BEGIN?

2000-05-14 Thread svante sörmark
yeah, i know about startup.pl, and i have been using it until now, but the goal here was to avoid having to put the same configuration in two different files :). Jeff Beard wrote: Checkout the sample startup.pl that comes with Apache::DBI. --Jeff At 05:08 PM 5/14/00, svante sörmark

Apache::DBI-connect_on_init in BEGIN?

2000-05-14 Thread svante sörmark
hi all, what i'd like to do is "pre-initialize" my DBI connections from whithin my PerlHandler's BEGIN block. something like this: BEGIN { if ( Apache-dir_config('CONNECT_ON_INIT') { Apache::DBI-connect_on_init(Apache-dir_config('DBI_INFO'); } } but

Apache::DBI with Sybase - What's wrong?

2000-05-12 Thread Graf, Chris
It seems that once processes start getting reused, I wind up with a ton of DB error messages in my error_log. They seem to start like this: ct_cmd_alloc failed at /usr/local/lib/perl5/site_perl/5.005/sun4-solaris/DBD/Sybase.pm line 159. DBD::Sybase::db ping failed: OpenClient message: LAYER =

Re: Apache::DBI with Sybase - What's wrong?

2000-05-12 Thread Michael Peppler
ping failed: OpenClient message: LAYER = (5) ORIGIN = (3) SEVERITY = (5) NUMBER = (6) Message String: ct_cancel(): network packet layer: internal net library error: Net-Library operation terminated due to disconnect I'm not familiar with Apache::DBI, so I don't know exactly in what situation

RE: Apache::DBI with Sybase - What's wrong?

2000-05-12 Thread Graf, Chris
Thanks Michael. If anyone can explain a little better what Apache::DBI and mod_perl are doing, or should be doing at this point, that may be helpful. I have been testing a little more and found that no errors will appear unless I am actually doing something with the connections. If I just

Re: Apache::DBI with Sybase - What's wrong?

2000-05-12 Thread Manfred Dehnkamp
"Graf, Chris" schrieb: Thanks Michael. If anyone can explain a little better what Apache::DBI and mod_perl are doing, or should be doing at this point, that may be helpful. I have been testing a little more and found that no errors will appear unless I am actually doing

Apache::DBI

2000-05-03 Thread Jim Serio
I'm not sure if this is even a problem but it's always been on my mind. I use Apache::DBI and I have a general module that handles db connections for my scripts. Here's the relevant portion: my $DBH ||= DBI-connect("...") It basically accepts a hash ref to the dbconfig and opens a

Re: Apache::DBI

2000-05-03 Thread Stas Bekman
On Wed, 3 May 2000, Jim Serio wrote: I'm not sure if this is even a problem but it's always been on my mind. I use Apache::DBI and I have a general module that handles db connections for my scripts. Here's the relevant portion: my $DBH ||= DBI-connect("...") It basically acce

Re: Apache::DBI

2000-05-03 Thread Jim Serio
Are you sure it's not: Opening connections with different parameters http://perl.apache.org/guide/databases.html#Opening_connections_with_differe Oops. I forgot I had two seperate db accesses on this particular page and running with $Apache::DBI::DEBUG = 1 clued me in. So am I correct

RE: Apache::DBI

2000-05-03 Thread Geoffrey Young
-Original Message- From: Jim Serio [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 03, 2000 10:02 AM To: [EMAIL PROTECTED] Subject: Apache::DBI I'm not sure if this is even a problem but it's always been on my mind. I use Apache::DBI and I have a general module that handles

Re: Apache::DBI disconnect?

2000-04-25 Thread Perrin Harkins
"John S. Evans" wrote: Weird. The whole point of Apache::DBI (or so I understand it) is so that your $dbh stays valid across CGI or Handler calls. That's right. The disconnect call is a no-op when using Apache::DBI. I can only think of two reasons why I get the error message

Re: Apache::DBI disconnect?

2000-04-25 Thread Tom Mornini
On Mon, 24 Apr 2000, John S. Evans wrote: Weird. The whole point of Apache::DBI (or so I understand it) is so that your $dbh stays valid across CGI or Handler calls. Sure. But it does it magically. You're still supposed to call disconnect. That way, your code will also work without Apache

Apache::DBI disconnect?

2000-04-24 Thread John S. Evans
I've been using the Apache::DBI module, and it works great. However, I've noticed that my error_log file has an occasional message that tells me: Database handle destroyed without explicit disconnect at /usr/local/lib/perl5/site_perl/5.005/Apache/DBI.pm line 119. The "offending" li

Re: Deprecated warnings in Apache::DBI

2000-04-10 Thread Ken Williams
I don't have 5.6 to test this, but isn't the warnings pragma lexical and not dynamic now? Which means it's doing the right thing. Also, it's probably right - shouldn't Apache::DBI be changed? Perhaps doing "local $^W;" instead of "no warnings qw(deprecated);" will

RE: Deprecated warnings in Apache::DBI

2000-04-10 Thread Paul G. Weiss
. Any in any case: BEGIN { no warnings qw(deprecated); local $^W=0; use Apache::DBI (); } doesn't suppress the error. -P -Original Message- From: Ken Williams [mailto:[EMAIL PROTECTED]] Sent: Monday, April 10, 2000 8:22 AM To: Paul G. Weiss Cc: '[EMAIL PROTECTED]' Subject: Re

RE: Deprecated warnings in Apache::DBI

2000-04-10 Thread Ken Williams
: BEGIN { no warnings qw(deprecated); local $^W=0; use Apache::DBI (); } doesn't suppress the error. That's kind of surprising. Someone with 5.6 will probably have to sort this out with you, or even better, patch Apache::DBI. As I said earlier, the warning is probably right - using

Re: prepare_cached and Apache::DBI.

2000-04-07 Thread Sean Dague
When attempting to use prepare_cached along with Apache::DBI, it returns this error once it has ran through each of the apache children. [Wed Apr 5 ...] [error] prepare_cached(...) statement handle DBI::st=HASH(0x8296788) is still active at /home/... line ... You should only

Re: Apache::DBI problem..

2000-04-05 Thread Niral Trivedi
Actually I already have MySQL module installed on our machine... Because I am able to run cgi/perl script which uses DBI module.. I mean I am able to run any normal cgi script.. So, I think that suggests that we have all the required module installed on our machine.. Niral Rajesh Kumar Mallah

prepare_cached and Apache::DBI.

2000-04-05 Thread Paul Sullivan
When attempting to use prepare_cached along with Apache::DBI, it returns this error once it has ran through each of the apache children. [Wed Apr 5 ...] [error] prepare_cached(...) statement handle DBI::st=HASH(0x8296788) is still active at /home/... line ... Is prepare_cached

Re: prepare_cached and Apache::DBI.

2000-04-05 Thread Perrin Harkins
On Wed, 5 Apr 2000, Paul Sullivan wrote: When attempting to use prepare_cached along with Apache::DBI, it returns this error once it has ran through each of the apache children. [Wed Apr 5 ...] [error] prepare_cached(...) statement handle DBI::st=HASH(0x8296788) is still active

Apache::DBI problem..

2000-04-04 Thread Niral Trivedi
installed Apache::DBI from CPAN site which is version 0.87 When I am trying to start Apache after installing Apache::DBI, I am getting following errors: -- Syntax error on line 935 of /zen/home/niral/Apache

apache dbi

2000-04-03 Thread Adam Gotheridge
I have installed modperl from redhat62 dist, and the apachedbi .87 module. When I put PerlModule Apache::DBI in httpd.conf, apache doesn't start. Any ideas? mod perl looks cool Embedded Perl version 5.00503 for Apache/1.3.12 (Unix) (Red Hat/Linux) mod_perl/1.21 Thanks

apache dbi solved

2000-04-03 Thread Adam Gotheridge
Solved it by installing from source I have installed modperl from redhat62 dist, and the apachedbi .87 module. When I put PerlModule Apache::DBI in httpd.conf, apache doesn't start. Any ideas? mod perl looks cool Embedded Perl version 5.00503 for Apache/1.3.12 (Unix) (Red Hat/Linux

porting DBI to Apache::DBI

2000-03-29 Thread James Array
Haloo I'm confusing of how to port DBI CGI to Apache::DBI mod_perl with Apache::Registry for the most efficient: if my normal DBI CGI is: use strict; use DBI; my $dbh=DBI-connect("database","login","password",&q

Re: porting DBI to Apache::DBI

2000-03-29 Thread James G Smith
"James Array" [EMAIL PROTECTED] wrote: Haloo I'm confusing of how to port DBI CGI to Apache::DBI mod_perl with Apache::Registry for the most efficient: if my normal DBI CGI is: use strict; use DBI; my $dbh=DBI-connect("database","login","passwor

Apache::DBI woes

2000-02-09 Thread Adam Cassar
Hello All, I have been having numerous problems with Apache::DBI, I have tried using PerlRequire startup.pl with startup.pl containing use Apache::DBI; and also tried PerlModule Apache::DBI; in httpd.conf with only this module loaded but to no success. I can load Apache::Registry fine

Apache::DBI and Sybase

2000-01-28 Thread Vladimir Ivaschenko
Hello. I have a trouble with Apache::DBI and Sybase under mod_perl (Embperl in this case). After some time calls to DBI-connect start to fail with message from CT-Lib - "Net-Library operation terminated due to disconnect". Maybe the ping() method from DBD::Sybase doesn't work? Thanks, Vladimir

Re: Apache::DBI and Sybase

2000-01-28 Thread Vladimir Ivaschenko
0 Andre Landwehr wrote about "Re: Apache::DBI and Sybase": message from CT-Lib - "Net-Library operation terminated due to disconnect". Maybe the ping() method from DBD::Sybase doesn't work? I can't help you with that problem but I can assure you that ping() from D

Re: Apache::DBI and Sybase

2000-01-28 Thread Matt Sergeant
On Fri, 28 Jan 2000, Vladimir Ivaschenko wrote: 0 Andre Landwehr wrote about "Re: Apache::DBI and Sybase": message from CT-Lib - "Net-Library operation terminated due to disconnect". Maybe the ping() method from DBD::Sybase doesn't work? I can't help you with th

Re: Apache::DBI and Sybase

2000-01-28 Thread Michael Peppler
Matt Sergeant writes: On Fri, 28 Jan 2000, Vladimir Ivaschenko wrote: 0 Andre Landwehr wrote about "Re: Apache::DBI and Sybase": message from CT-Lib - "Net-Library operation terminated due to disconnect". Maybe the ping() method from DBD::Sybase doesn't wor

help me under those Apache::DBI log info.

2000-01-27 Thread vinecent hong
/ everything=1 apache conf: Alias /perl//usr/local/apache/share/cgi-bin/ PerlFreshRestartOn PerlRequire /usr/local/apache/share/cgi-bin/include/startup.pl #PerlSetupEnv OFF PerlSendHeader OFF #DBI_TRACE "2=/tmp/dbitrace.log" PerlModule Apache::DBI Loca

RE: help me under those Apache::DBI log info.

2000-01-27 Thread Geoffrey Young
try using DBI-trace(2,"/tmp/dbitrace.log"); $Apache::DBI::DEBUG = 2; in your startup script... Apache::DBI will only reuse $dbh handles when the connect string matches exactly, including all the various options, so make sure your Apache::DBI-connect_on_init and script DBI-connect str

Re: help me under those Apache::DBI log info.

2000-01-27 Thread vinecent hong
DBI-trace stuff and read the log completely.but its too long to copy here.briefly,I find out weird problem in the log,look: -- DBI 1.13-nothread dispatch trace level set to 2 - DBI-Apache::DBI::connect(DBI:mysql:database=uwang;host

RE: help me under those Apache::DBI log info.

2000-01-27 Thread Geoffrey Young
well, I am not a MySQL user (Oracle instead) so I don't understand why 6 connections would be opened for 1 script. However, to make sure we are on the same page... 1) debug in single server mode - I'm sure you realize that Apache::DBI creates one connection per httpd child, not just one

Re: help me under those Apache::DBI log info.

2000-01-27 Thread Stas Bekman
On Thu, 27 Jan 2000, vinecent hong wrote: Thank you,Geoffrey.What you said about using "the same conenct string" I also read from the perl.apache.org/guide.the problem is ,I just click the REFRESH button of the browser to reload the SAME perl script.and everytime I reload it,it create a new

DDL load failure using Apache DBI

2000-01-11 Thread Rich Buckley
Hi, Platform: NT4SP5 Perl: 5_005_02 Apache: 1_3_3 ModPerl modperl-1_16 Can anyone advise on the following problem. In an attempt to use the DBI module to connect to an Oracle database from a modperl script, I get an error (from apache.exe on the server) indicating that the

Re: DDL load failure using Apache DBI

2000-01-11 Thread Jeffrey W. Baker
Rich Buckley wrote: Hi, Platform: NT4SP5 Perl: 5_005_02 Apache: 1_3_3 ModPerl modperl-1_16 Can anyone advise on the following problem. In an attempt to use the DBI module to connect to an Oracle database from a modperl script, I get an error (from apache.exe on the

RE: DDL load failure using Apache DBI

2000-01-11 Thread Rich Buckley
JWB wrote Check your environment's ORACLE_HOME variable. That is set OK, I can run a simple connect to database script from the command line with np. As a hack I moved the offending DLL into a directory on the path that was being searched, this managed to load the DLL ok but complained that

Re: problems with Apache::DBI

2000-01-08 Thread Edmund Mergl
"Cere M. Davis" wrote: I am trying to get the DBI::Ingres stuff to work with Apache::DBI. Once the server tries to open the inital connections through the startup.pl file with the "Apache::DBI-connect_on_init" command it throws an error message like this

Apache::DBI Problem

2000-01-07 Thread Dennis Megarry
This message was sent from Geocrawler.com by "Dennis Megarry" [EMAIL PROTECTED] Be sure to reply to that address. Everything was running fine, i installed mod_perl and ApacheDBI, now, I get errors trying to connect to mySQL, the message showing up in my error_log file is this: httpd: [Thu

problems with Apache::DBI

2000-01-07 Thread Cere M. Davis
I am trying to get the DBI::Ingres stuff to work with Apache::DBI. Once the server tries to open the inital connections through the startup.pl file with the "Apache::DBI-connect_on_init" command it throws an error message like this: 168 Apache::DBI PerlChildInitHandler [

problem with Apache::DBI

2000-01-06 Thread Michael Baxter
::Registry works. But when I try to run one of my old scripts (with the use DBI commented out) all I get is an error msg: [Sun Jan 2 16:29:41 2000] [error] [Sun Jan 2 16:29:41 2000] null: Can't locate object method "connect" via package "Apache::DBI" at /usr/lib/perl5/site_

Apache::DBI time bug?

1999-12-30 Thread Geoffrey Young
Just something minor... I use DBI for both content and log handlers. When using debug level 2 I noticed that the the default perl time method is not precise enough between request phases - that if I could not connect in the PerlHandler phase, Apache::DBI did not ping the database

Re: can't load Apache::DBI in starup.pl file

1999-12-22 Thread Ken Y. Clark
On Tue, 21 Dec 1999, Nancy Lin wrote: Hi - I'm running apache 1.3.9/modperl 1.19/ApacheDBI-0.87/perl5.003 on redhat 6.0 In my startup.pl file, I have the following lines: use Apache::DBI; $Apache::DBI::DEBUG = 2; When I run it w/ the -c option, I get

can't load Apache::DBI in starup.pl file

1999-12-21 Thread Nancy Lin
Hi - I'm running apache 1.3.9/modperl 1.19/ApacheDBI-0.87/perl5.003 on redhat 6.0 In my startup.pl file, I have the following lines: use Apache::DBI; $Apache::DBI::DEBUG = 2; When I run it w/ the -c option, I get the following error message: Can't locate object method

Re: can't load Apache::DBI in starup.pl file

1999-12-21 Thread Farhad Farzaneh
the following lines: use Apache::DBI; $Apache::DBI::DEBUG = 2; When I run it w/ the -c option, I get the following error message: Can't locate object method "module" via package "Apache" at /usr/lib/perl5/site_perl/5.005/Apache/DBI.pm line 2

Re: Apache::DBI crashes apache-mod_ssl-1.3.9.2.4.6

1999-11-06 Thread Christof Damian
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

Apache::DBI crashes apache-mod_ssl-1.3.9.2.4.6

1999-11-03 Thread Nick Urbanik
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

Re: Failing to reconnect after Oracle shutdown abort (Apache::DBI)

1999-11-03 Thread Greg Stark
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

Re: Failing to reconnect after Oracle shutdown abort (Apache::DBI)

1999-11-02 Thread Greg Stark
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

RE: Failing to reconnect after Oracle shutdown abort (Apache::DBI)

1999-11-02 Thread Young, Geoffrey S.
:[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

Re: Failing to reconnect after Oracle shutdown abort (Apache::DBI)

1999-11-02 Thread Tim Bunce
On Mon, Nov 01, 1999 at 09:01:48PM +, Tim Bunce wrote: Has anyone experienced a situation where a process (httpd for example) can't reconnect to Oracle after a "shutdown abort"? Thanks for your replies. The problem reported to me which prompted this email has actually proven to be a user

Re: Failing to reconnect after Oracle shutdown abort (Apache::DBI)

1999-11-02 Thread Jeffrey W. Baker
Greg Stark wrote: 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

Re: Failing to reconnect after Oracle shutdown abort (Apache::DBI)

1999-11-02 Thread Jeffrey Baker
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

Failing to reconnect after Oracle shutdown abort (Apache::DBI)

1999-11-01 Thread Tim Bunce
Has anyone experienced a situation where a process (httpd for example) can't reconnect to Oracle after a "shutdown abort"? Tim.

Re: Failing to reconnect after Oracle shutdown abort (Apache::DBI)

1999-11-01 Thread Tom Law
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

Re: W32 + Apache::DBI ?

1999-10-28 Thread G.Richter
#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

Re: W32 + Apache::DBI ?

1999-10-28 Thread Ian Struble
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

Re: DBI/Apache::DBI under mod_perl

1999-10-27 Thread James G Smith
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

RE: W32 + Apache::DBI ?

1999-10-27 Thread Ian Struble
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

Re: W32 + Apache::DBI ?

1999-10-27 Thread Ian Struble
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 problem in DBI 1.13. It was

Re: W32 + Apache::DBI ?

1999-10-26 Thread Victor Zamouline
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

RE: W32 + Apache::DBI ?

1999-10-26 Thread Gerald Richter
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

RE: W32 + Apache::DBI ?

1999-10-26 Thread Gerald Richter
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

Re: W32 + Apache::DBI ?

1999-10-26 Thread Victor Zamouline
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.

Re: W32 + Apache::DBI ?

1999-10-26 Thread Tim Bunce
wishes to join the discussion. I have DBI 1.08 Apache::DBI 0.81 mod_perl 1.20 Apache 1.3.9 perl 5.005_02 everything build with MSVC 5. and it work when I compile mod_perl with PERL_STARTUP_CHECK_DONE (see my previous mail). Without compiling with PERL_STARTUP_DONE_CHECK, apache exits

Re: W32 + Apache::DBI ?

1999-10-26 Thread Tim Bunce
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

W32 + Apache::DBI ?

1999-10-25 Thread Ian Struble
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

Apache::DBI MySQL

1999-10-13 Thread Viren Jain
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

Re: Apache::DBI MySQL

1999-10-13 Thread Ken Williams
your own tests. I'm not sure why you have too many connections. Sounds pretty odd. [EMAIL PROTECTED] (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

Re: Apache::DBI MySQL

1999-10-13 Thread Perrin Harkins
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

Apache::DBI and Apache::AuthenDBI questions.

1999-10-02 Thread Sergey V. Kolychev
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

Re: Apache::DBI and Apache::AuthenDBI questions.

1999-10-02 Thread Edmund Mergl
"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

Re: Apache::DBI crashes apache-mod_ssl-1.3.9.2.4.6

1999-01-02 Thread Stephane Benoit
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.

Re: Apache::DBI crashes apache-mod_ssl-1.3.9.2.4.6

1999-01-02 Thread Stephane Benoit
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

<    1   2   3   4   5