Re: Apache::DBI

2002-02-12 Thread Martin Haase-Thomas
(doesApache::DBI overload the DBI methods?) No, it doesn't. It uses Apache and DBI. Did you install the package via the "Makefile.PL" stanza? Maybe you should just install it another time. On the other hand, Apache::DBI doesn't export anything. Try calling it with the package name explicitly.

Re: Apache::DBI

2002-02-12 Thread Marty J. Rogers
I had tried that, with the same result. (does Apache::DBI overload the DBI methods?) Full error is as follows. Again, any help is _highly_ appreciated. Marty [error] Can't locate object method "connect_on_init" via package "Apache::DBI" at /etc/httpd/conf/startup.pl line 28. Compilation failed

Re: Apache::DBI

2002-02-11 Thread Martin Haase-Thomas
Marty J. Rogers wrote: >[snip] >>From httpd.conf: > >PerlModule Apache::DBI CGI DBD::mysql \ >Apache::AuthenDBI >PerlRequire /path/to/startup.pl > >Alias /perl/ /path/to/perl >PerlModule Apache::Registry > >SetHandler perl-script >PerlHandler Apache::Registry >Options ExecCGI >allow from all >P

Re: Apache::DBI

2002-02-06 Thread clayton cottingham
"Stathy G. Touloumis" wrote: > > > I'm not sure what you mean, really, but perhaps you mean > > dbi_connect_method? > > Did you mean specifying this argument like so ? > > DBI->connect( $driver, $u, $p, { dbi_connect_method=> 'connect' } ); > > I will see if this is what I am looking for. Tha

Re: Apache::DBI

2002-02-06 Thread Geoffrey Young
"Stathy G. Touloumis" wrote: > > > I'm not sure what you mean, really, but perhaps you mean > > dbi_connect_method? > > Did you mean specifying this argument like so ? > > DBI->connect( $driver, $u, $p, { dbi_connect_method=> 'connect' } ); yes, you never call Apache::DBI->connect() directly.

RE: Apache::DBI

2002-02-06 Thread Stathy G. Touloumis
> I'm not sure what you mean, really, but perhaps you mean > dbi_connect_method? Did you mean specifying this argument like so ? DBI->connect( $driver, $u, $p, { dbi_connect_method=> 'connect' } ); I will see if this is what I am looking for. Thanks for the reference : )

RE: Apache::DBI

2002-02-06 Thread Stathy G. Touloumis
> dbi_connect_method? > > from man DBI: > > The "dbi_connect_method" attribute can be used to specify which driver > method should be called to establish > the connection. The only useful values are 'connect', > 'connect_cached', or some specialized case like > 'Apache::DBI::connect' (which is aut

Re: Apache::DBI

2002-02-06 Thread Geoffrey Young
"Stathy G. Touloumis" wrote: > > I thought I saw a posting on how to retrieve an independent database handle > from Apache::DBI using a certain method call (instead of from the shared > $dbh for the child). Does anyone know where this documentation may reside > (If it is possible). I'm not sur

RE: Apache::DBI usage

2001-11-15 Thread Geoffrey Young
> -Original Message- > From: Andrei A. Voropaev [mailto:[EMAIL PROTECTED]] > Sent: Thursday, November 15, 2001 6:44 AM > To: [EMAIL PROTECTED] > Subject: Apache::DBI usage > > > Hi! > > Apache::DBI is great module of course because it makes things > transparent. But > it also makes t

Re: apache::dbi vs mysql relay

2001-10-17 Thread Rob Nagler
> What I don't understand is why they separate the listener and database > connection daemons if you always need one of each to do anything. Probably for scalability. The database engines are doing the work and the sooner they can free themselves up (due to a slow client, for example), the bett

Re: apache::dbi vs mysql relay

2001-10-17 Thread Perrin Harkins
> On http://www.firstworks.com/sqlrelay/programming/perldbd.html it says: > > "For the duration of the session, the client stays connected to a > database connection daemon. While one client is connected, no other > client can connect. Care should be taken to minimize the length of a > session." >

Re: apache::dbi vs mysql relay

2001-10-17 Thread Stas Bekman
Perrin Harkins wrote: >>Are there any benchmark comparisons between apache::dbi and mysql >> > relay? > > I've never heard of this "mysql relay" before. A Google search found > this: > http://www.firstworks.com/sqlrelay.html > > Is that it? Looks interesting! On http://www.firstworks.com/sql

Re: apache::dbi vs mysql relay

2001-10-11 Thread Perrin Harkins
> Are there any benchmark comparisons between apache::dbi and mysql relay? I've never heard of this "mysql relay" before. A Google search found this: http://www.firstworks.com/sqlrelay.html Is that it? Looks interesting! > We're planning on having four sql servers, one of them will do all of

AW: Re: Apache::DBI

2001-10-03 Thread Markus Linke
Hi, No, we use Solaris 8. Cheers, Markus -- Original Nachricht -- >Are you using redhat 7.1? > >Tor. > >Markus Linke wrote: > >> Hi, >> >> we have a problem with Apache::DBI ... after activating it in httpd.conf >> the server-start fails when using Apache::DBI. >> >> The installation of mod_pe

Re: Apache::DBI

2001-10-02 Thread Joshua Chamas
Markus Linke wrote: > > /usr/local/apache/bin:> apachectl configtest > Syntax error on line 1235 of /usr/local/apache/conf/httpd.conf: > Can't load > '/usr/local/lib/perl5/site_perl/5.6.1/sun4-solaris/auto/DBI/DBI.so' for > module DBI: ld.so.1: /usr/local/apache/bin/httpd: fatal: relocation > err

Re: Apache::DBI

2001-10-02 Thread victor
Are you using redhat 7.1? Tor. Markus Linke wrote: > Hi, > > we have a problem with Apache::DBI ... after activating it in httpd.conf > the server-start fails when using Apache::DBI. > > The installation of mod_perl and mod_ssl brought up no error messages. > > Perl itself works fine > Perl DBI

Re: Apache::DBI Segmentation fault

2001-09-10 Thread Hans Juergen von Lengerke
Hi, I actually got this to work now. The segfault happens when I load Apache::Registry before Apache::DBI. However, I have used the eg/startup.pl from the Apache::DBI distribution and that has Apache::Registry loaded before Apache::DBI... Maybe this is a bug? My httpd.conf Perl* relevant parts:

Re: Apache::DBI Segmentation fault

2001-09-10 Thread Perrin Harkins
> I am getting a segmentation fault on configtest when using Apache::DBI > (using the startup.pl example in Apache::DBI Distribution). When trying > to start the server I get no error messages but the server isn't > running afterwards Do you know that your DBI works without Apache::DBI? It would

Re: Apache::DBI Segmentation fault

2001-09-10 Thread Hans Juergen von Lengerke
Uh, sorry forgot to post Database and perl -V... Database is Informix. Summary of my perl5 (5.0 patchlevel 5 subversion 3) configuration: Platform: osname=linux, osvers=2.2.13, archname=i586-linux uname='linux benjy 2.2.13 #4 mon aug 16 11:18:11 mest 1999 i686 unknown ' hint=recomm

Re: Apache::DBI Oracle LOB problem

2001-08-28 Thread Steven Schmidt
This problem was fixed by upgrading Oracle to 8.1.7 -Steve Robert Landrum wrote: > At 2:15 AM +0100 8/2/01, Tim Bunce wrote: > >On Mon, Jul 30, 2001 at 04:57:09PM -0400, Steven Schmidt wrote: > >> The following problem came up in porting EnsEMBL to Oracle: > >> > >> Level 9 DBI trace: > >>

Re: Apache::DBI

2001-08-22 Thread Jim Smith
On Wed, Aug 22, 2001 at 12:34:11PM -0700, Rasoul Hajikhani wrote: > I am a bit confused! Can Apache::DBI handle db calls through proxies? > -r It should be able to handle anything DBI handles. Just `use' it before `use'ing any other DBI modules and you shouldn't have to change any of your code,

[OT]Re: Apache::DBI

2001-08-16 Thread Mithun Bhattacharya
This is the last time I am replying on this topic to the list it has gone way OT. But I would like to clarify. CPAN doesnt exactly force you to upgrade everything on the planet but yes some modules depend on features available in other modules only after a certain version number. Yes as has been d

Re: Apache::DBI

2001-08-15 Thread will trillich
On Sat, Aug 04, 2001 at 09:32:43PM +0530, Mithun Bhattacharya wrote: > Shakes his head and hopes you will someday get enlightened as to the > purpose of CPAN. > > > > CPAN is great for red hat users (for example) who don't mind breaking things let's not condescend too quickly -- when yo

RE: Apache::DBI in startup.pl generating error

2001-08-04 Thread Geoffrey Young
> -Original Message- > From: Rob Bloodgood [mailto:[EMAIL PROTECTED]] > Sent: Thursday, August 02, 2001 2:31 PM > To: Gunther Birznieks > Cc: [EMAIL PROTECTED]; mod_perl > Subject: RE: Apache::DBI in startup.pl generating error [snip] > > Well, it should be

RE: Apache::DBI in startup.pl generating error

2001-08-03 Thread Gunther Birznieks
Rob, how much stuff do you have in startup.pl? So nothing else is dependent on Apache.pm modules? To some degree, because Apache::DBI affects all the Perl interpreters in a very config-type of way (as opposed to just preloading modules) I like the idea of it being in PerlModule as it allows so

RE: Apache::DBI in startup.pl generating error

2001-08-03 Thread Rob Bloodgood
> Alternatively, you can remove > > use Apache; > > from Apache::DBI and then you can test it perflectly fine from the > command-line, you just won't be able to use connect_on_init() > which is the > only reason Apache::DBI seems to load Apache.pm (Apache.pm is > causing your > problem not Apache:

RE: Apache::DBI in startup.pl generating error

2001-08-03 Thread Geoffrey Young
> -Original Message- > From: Rob Bloodgood [mailto:[EMAIL PROTECTED]] > Sent: Thursday, August 02, 2001 9:18 PM > To: Geoffrey Young > Cc: mod_perl > Subject: RE: Apache::DBI in startup.pl generating error > > basically, it's a bad programming practice n

RE: Apache::DBI in startup.pl generating error

2001-08-03 Thread Geoffrey Young
>Except that (and I have to check this to be ABSOLUTELY shure but) >PerlModule >Apache::DBI happens first, THEN startup.pl. only if you code it the way you did below, which isn't terribly portable. see http://perl.apache.org/guide/perl.html#use_require_do_INC_and basically, it's a bad programm

Re: Apache::DBI in startup.pl generating error

2001-08-02 Thread Gunther Birznieks
Alternatively, you can remove use Apache; from Apache::DBI and then you can test it perflectly fine from the command-line, you just won't be able to use connect_on_init() which is the only reason Apache::DBI seems to load Apache.pm (Apache.pm is causing your problem not Apache::DBI). At 10:2

RE: Apache::DBI in startup.pl generating error

2001-08-02 Thread Rob Bloodgood
> > > > Well, it should be documented "somewhere in the guide", or > > > > presumable in > > > > Apache::DBI.pod, that one should *only* > > > > > > > > PerlModule Apache::DBI > > > > > > > > Since it's pointless in startup.pl (right?). > > > > > > I think you need to think that one through a bit

RE: Apache::DBI in startup.pl generating error

2001-08-02 Thread Rob Bloodgood
> only if you code it the way you did below, which isn't terribly portable. > see http://perl.apache.org/guide/perl.html#use_require_do_INC_and Ahem, PerlModule is a wrapper around the perl builtin require(). One presumes that perl knows where it lives if perl can successfully require() it. Esp

Re: Apache::DBI Oracle LOB problem

2001-08-02 Thread Robert Landrum
At 2:15 AM +0100 8/2/01, Tim Bunce wrote: >On Mon, Jul 30, 2001 at 04:57:09PM -0400, Steven Schmidt wrote: >> The following problem came up in porting EnsEMBL to Oracle: >> >> Level 9 DBI trace: >> OCIStmtExecute(62c0ec,6363d0,62c310,0,0,0,0,0)=SUCCESS >> OCIAttrGet(6363d0,4,ffbeebea,0,10,

Re: Apache::DBI in startup.pl generating error

2001-08-02 Thread Stas Bekman
On Thu, 2 Aug 2001 [EMAIL PROTECTED] wrote: > Thanks to all (esp Stas) for helping me with the 'make test' error > involving CGI.pm. Here is the next issue: > use Apache::DBI (); > When I run "perl -c startup.pl", I get the following error. I get NO > error when I comment out the 'use Apache:

Re: Apache::DBI Oracle LOB problem

2001-08-01 Thread Perrin Harkins
> Mmm, haven't seen it, but we use LONG instead of CLOB as the datatype > for the sequence. Is there any reason to use CLOB, and does using LONG > make the problem disappear? Oracle doesn't want you to use LONG anymore. It's deprecated. Questions for Steven: Have you followed all the documentat

Re: Apache::DBI

2001-07-29 Thread will trillich
On Thu, Jul 26, 2001 at 07:48:14AM -0600, Castellon, Francisco wrote: > Does anyone know if Apache::DBI is included with mod_perl? if not > could someone tell me where i could get it from? if you're using DEBIAN, you find it like this: $ dpkg -S Apache::DBI libapache-dbi-perl: /usr

Re: Apache::DBI

2001-07-26 Thread Ken Y. Clark
On Thu, 26 Jul 2001, Castellon, Francisco wrote: > Date: Thu, 26 Jul 2001 07:48:14 -0600 > From: "Castellon, Francisco" <[EMAIL PROTECTED]> > To: [EMAIL PROTECTED] > Subject: Apache::DBI > > Does anyone know if Apache::DBI is included with mod_perl? if not > could someone tell me where i co

Re: Apache::DBI / DBD::Oracle error

2001-06-16 Thread Mark Vandenbroeck
Hi all, There seems to be some confusion and even incorrectness in this trail. Let's get some things straight : There is nothing wrong with NLS_LANG. In fact, it is extremely useful in an international setting. Your value is fine. ORA_NLS33 is obsolete in 8.1.7 and should not be set Failure

Re: Apache::DBI / DBD::Oracle error

2001-06-16 Thread Ronald J Kimball
On Mon, Jun 11, 2001 at 04:15:15PM -0700, Eric Kolve wrote: > I recently upgraded to DBI 1.18 + DBD::Oracle 1.07 and upon restarts > with mod_perl, I get the following error: > > DBD::Oracle::db rollback failed: Error while trying to retrieve text for > error ORA-03113 (DBD ERROR: OCITransRollbac

Re: Apache::DBI / DBD::Oracle error

2001-06-12 Thread Ged Haywood
Hi there, On Tue, 12 Jun 2001, Mark Vandenbroeck wrote: > There seems to be some confusion and even incorrectness in this trail. Let's get > some things straight : Thanks for setting me straight! 73, Ged.

Re: Apache::DBI / DBD::Oracle error

2001-06-12 Thread Ged Haywood
Hi again, On Tue, 12 Jun 2001, Eric Kolve wrote: > Yes, I have NLS_LANG set to AMERICAN_AMERICA.WE8ISO8859P1. I seemed to get on better by removing NLS_LANG and ORA_NLS33 from my environment altogether. > BTW, I am also using the latest oracle client libs (8.17) if this > makes any difference;

Re: Apache::DBI / DBD::Oracle error

2001-06-12 Thread Eric Kolve
Yes, I have NLS_LANG set to AMERICAN_AMERICA.WE8ISO8859P1. BTW, I am also using the latest oracle client libs (8.17) if this makes any difference; as well, I am using perl 5.005. --eric Ged Haywood wrote: > > Hi there, > > On Mon, 11 Jun 2001, Eric Kolve wrote: > > > I recently upgraded to DB

Re: Apache::DBI / DBD::Oracle error

2001-06-11 Thread Ged Haywood
Hi there, On Mon, 11 Jun 2001, Eric Kolve wrote: > I recently upgraded to DBI 1.18 + DBD::Oracle 1.07 and upon restarts > with mod_perl, I get the following error: > > DBD::Oracle::db rollback failed: Error while trying to retrieve text for > error ORA-03113 (DBD ERROR: OCITransRollback) at > /

Re: Apache::DBI missing methods?!

2001-05-16 Thread Issac Goldstand
> > Hi, > > I've just joined the list looking for an answer to this. A couple of > others have posted the same problem but I couldn't find any answers. > > I'm running RH6.2 with standard Apache, perl and mod_perl rpms. I'm > hitting a brick wall if I include a 'PerlModule Apache::DBI' line in > h

RE: Apache::DBI missing methods?!

2001-05-15 Thread Geoffrey Young
> > just DBI. try > > PerlModule DBI > PerlModule Apache::DBI yuk, of course that's backwards... PerlModule Apache::DBI PerlModule DBI sorry... --Geoff

RE: Apache::DBI missing methods?!

2001-05-15 Thread Geoffrey Young
> -Original Message- > From: James Croft [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, May 15, 2001 8:23 AM > To: Stas Bekman > Cc: [EMAIL PROTECTED] > Subject: Re: Apache::DBI missing methods?! > > > On Tue, 15 May 2001, Stas Bekman wrote: > > >

Re: Apache::DBI missing methods?!

2001-05-15 Thread James Croft
On Tue, 15 May 2001, Stas Bekman wrote: > > Can't locate object method "module" via package "Apache" at > > /usr/lib/perl5/site_perl/5.005/Apache/DBI.pm line 202. BEGIN > > failed--compilation aborted at ./test.pl line 4. > > > > Which must be what's frying httpd. > > > > Does anyone know what's

Re: Apache::DBI missing methods?!

2001-05-15 Thread Tim Gardner
I don't know if there is a downside (perhaps I can't use status?), but when I commented out the 'Apache::Status->menu_item( ...' section, it seemed to work ok. Tim >On Tue, 15 May 2001, James Croft wrote: > >> >> Hi, >> >> I've just joined the list looking for an answer to this. A couple of

Re: Apache::DBI missing methods?!

2001-05-15 Thread Stas Bekman
On Tue, 15 May 2001, James Croft wrote: > > Hi, > > I've just joined the list looking for an answer to this. A couple of > others have posted the same problem but I couldn't find any answers. > > I'm running RH6.2 with standard Apache, perl and mod_perl rpms. I'm > hitting a brick wall if I inclu

Re: Apache::DBI problem

2001-05-05 Thread Edmund Mergl
"Grigoriy G. Vovk" wrote: > > Here are my files: > > httpd.conf - > > Alias /perl/ "/usr/local/www/perl/" > PerlModule Apache::DBI > PerlRequire /usr/local/www/startup.pl > PerlModule Apache::Registry > PerlModule Apache::DBI > PerlSetEnv PERLDB_OPTS

Re: Apache::DBI + persistent connections

2001-05-04 Thread Andrew Ho
Wayne, WI>It is my understanding that when the app is running WI>and I look at the status under MySQL, that I should WI>see only one connection. However, what I see is plenty WI>of connections, as many as there were before I added WI>Apache::DBI to the mix. Apache is a forking server. There are

Re: Apache::DBI + persistent connections

2001-05-04 Thread Jules
- Original Message - From: "Wayne Izatt" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, May 04, 2001 3:17 PM Subject: Apache::DBI + persistent connections > Which leads me to think that "persistent" means that, > if a single script makes multiple connect requests > (with the s

Re: Apache::DBI->forcibly_disconnect?

2001-04-05 Thread Tim Bunce
On Thu, Apr 05, 2001 at 05:00:40PM -0400, Daniel wrote: > Has anybody attempted to modify Apache::DBI to force a handle to disconnect? > > eg. $dbh->forcibly_disconnect; Fetch the latest -> read the docs -> if not found -> implement yourself -> send a patch -> help save the world. Tim.

RE: Apache::DBI::connect problem, please help

2001-02-21 Thread Brad Howerter
9 PM > To: Geoffrey Young; 'Brad Howerter'; '[EMAIL PROTECTED]' > Subject: RE: Apache::DBI::connect problem, please help > > > You have to put Apache::DBI before any of the DBI's > you are using in httpd.conf file. > > In your cgi programs use only "

RE: Apache::DBI::connect problem, please help

2001-02-20 Thread Arun Theeban
-Arun --- Geoffrey Young <[EMAIL PROTECTED]> wrote: > > > > -Original Message- > > From: Brad Howerter [mailto:[EMAIL PROTECTED]] > > Sent: Tuesday, February 20, 2001 12:57 PM > > To: '[EMAIL PROTECTED]' > > Subject: RE: Apache::DBI::connect p

RE: Apache::DBI::connect problem, please help

2001-02-20 Thread Geoffrey Young
> -Original Message- > From: Brad Howerter [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, February 20, 2001 12:57 PM > To: '[EMAIL PROTECTED]' > Subject: RE: Apache::DBI::connect problem, please help > [snip] > So Apache/DBI.pm must be installed incorrectl

RE: Apache::DBI::connect problem, please help

2001-02-20 Thread Geoffrey Young
> -Original Message- > From: Brad Howerter [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, February 20, 2001 12:42 PM > To: ''[EMAIL PROTECTED]' ' > Subject: RE: Apache::DBI::connect problem, please help > > > > > > From: Geoffrey Yo

RE: Apache::DBI::connect problem, please help

2001-02-20 Thread Brad Howerter
> > > From: Geoffrey Young [mailto:[EMAIL PROTECTED]] > > > you need both, DBI and Apache::DBI, with DBI loaded first... > > > > I tried this, but I still get the same error. > > sorry, I gave you bad information - Apache::DBI needs to be > loaded first... > it was late :) That's okay- I've t

RE: Apache::DBI::connect problem, please help

2001-02-20 Thread Brad Howerter
> From: Geoffrey Young [mailto:[EMAIL PROTECTED]] > you need both, DBI and Apache::DBI, with DBI loaded first... I tried this, but I still get the same error. > > see the Apache::DBI manpage for more detail That man page is the same as the DBI manpage- it doesn't include any modperl specific

RE: Apache::DBI::connect problem, please help

2001-02-19 Thread Geoffrey Young
you need both, DBI and Apache::DBI, with DBI loaded first... see the Apache::DBI manpage for more detail HTH --Geoff -Original Message- From: Brad Howerter To: '[EMAIL PROTECTED]' Sent: 2/19/01 6:54 PM Subject: Apache::DBI::connect problem, please help I'm getting this error: [error]

Re: Apache::DBI type functionality but per-request

2001-01-15 Thread Perrin Harkins
On Mon, 15 Jan 2001, Vivek Khera wrote: > I tend to write my apps in a modular fashion, so that each module > connects to the database and fetches its data and then disconnects. > Often, a program will require data from several modules resulting in a > lot of wasted connect/disconnect ops. Apache

Re: Apache::DBI problem and writting a perl module!!!

2001-01-11 Thread Stas Bekman
On Thu, 11 Jan 2001, R. K . Mallah wrote: > Stas , I do not face the problem anymore and Apache::DBI is loading > without any problem. But i remember of facing problem at one point of time. > may be with some older version. Ok > Could u please explain me what does Apache->module do and where i

Re: Apache::DBI problem and writting a perl module!!!

2001-01-10 Thread R. K . Mallah
Stas , I do not face the problem anymore and Apache::DBI is loading without any problem. But i remember of facing problem at one point of time. may be with some older version. Could u please explain me  what does Apache->module do and where is it defined ? and Edmar could you please post the exac

Re: Apache::DBI keeps re-connecting!

2001-01-10 Thread Edmund Mergl
Foskett Roger wrote: > > Hi, when using Apache::DBI, it keeps re-connecting even though the database > and user is the same: > > I am using ApacheDBI-0.87, DBD-Oracle-1.06, DBI-1.14, perl5.6.0 on an 8.1.5 > Oracle database (perl -v & -V further below) > > My httpd.conf is setup as: > PerlModul

Re: Apache::DBI problem and writting a perl module!!!

2001-01-10 Thread Stas Bekman
On Wed, 10 Jan 2001, R. K . Mallah wrote: > I faced the same problem and had posted similar email > but I found an workaround that is there in the posting. > > > > I get following error when i do > > perl -e 'use Apache::Status;use Apache::D

Re: Apache::DBI and deleting temporary tables (Sybase ASE)

2001-01-10 Thread Stas Bekman
On Wed, 10 Jan 2001, Alexander Farber (EED) wrote: > Hi, > > I have read > http://perl.apache.org/guide/debug.html#Handling_the_User_pressed_Stop_ > but still don't know the best solution for my problem: > > I would like to port a bigger CGI-script to mod_perl. > This script uses DBD::Sybase and

Re: Apache::DBI and deleting temporary tables (Sybase ASE)

2001-01-10 Thread Michael Peppler
Alexander Farber (EED) writes: > So what is the best way to handle it? I could add > > drop table #temp1 > drop table #temp2 > > to the SQL statements of my script, but what happens if > the user presses STOP or the script times out? Should I > move this SQL-code to $r->register_clea

Re: Apache::DBI problem and writting a perl module!!!

2001-01-10 Thread R. K . Mallah
 I faced the same problem and had  posted  similar email but I found an workaround that is there in the posting.   I get following error when i do perl -e 'use Apache::Status;use Apache::DBI' Can't locate object method "module" via package "Apa

Re: Apache::DBI and altered packages

2000-12-22 Thread jared still
Geoff, I'm going to make a non-technical suggestion: You need to have change control implemented so that packages in your database are not changing during business hours. If you are 24x7, then you need to schedule an outage, and notify your customers of scheduled downtime. This is more of a

RE: Apache::DBI and altered packages

2000-12-22 Thread Paul G. Weiss
2000 12:03 PM > To: 'Perrin Harkins'; [EMAIL PROTECTED] > Cc: [EMAIL PROTECTED] > Subject: RE: Apache::DBI and altered packages > > > > > > -Original Message- > > From: Perrin Harkins [mailto:[EMAIL PROTECTED]] > > Sent: Friday, Decembe

RE: Apache::DBI and altered packages

2000-12-22 Thread Geoffrey Young
> -Original Message- > From: Perrin Harkins [mailto:[EMAIL PROTECTED]] > Sent: Friday, December 22, 2000 11:55 AM > To: Geoffrey Young; [EMAIL PROTECTED] > Cc: [EMAIL PROTECTED] > Subject: Re: Apache::DBI and altered packages > > > > If you change the

RE: Apache::DBI and altered packages

2000-12-22 Thread Geoffrey Young
> -Original Message- > From: jared still [mailto:[EMAIL PROTECTED]] > Sent: Friday, December 22, 2000 11:52 AM > To: Geoffrey Young > Cc: '[EMAIL PROTECTED]'; [EMAIL PROTECTED] > Subject: Re: Apache::DBI and altered packages > > > > > Ge

Re: Apache::DBI and altered packages

2000-12-22 Thread Perrin Harkins
> my Oracle gurus here tell me that whenever a package changes any open > connections will get this error. Since the connection itself ok (just not > the stuff I need to use) the only solution currently available seems to be > $r->child_terminate() so that at least that child doesn't barf every t

Re: Apache::DBI and transactions

2000-12-14 Thread Stas Bekman
On Thu, 14 Dec 2000, Chris Nokleberg wrote: > In case your script makes some db changes "by accident"--if you don't do > an explicit rollback or commit at the end, the uncommitted changes will > hang around, and the next request may end up committing those changes > unwittingly. I rollback at bot

Re: Apache::DBI and transactions

2000-12-14 Thread Bruce W. Hoylman
> "Stas" == Stas Bekman <[EMAIL PROTECTED]> writes: Stas> In general it is good practice to perform an explicit commit Stas> or rollback at the end of every script. In order to avoid Stas> inconsistencies in the database in case C is Stas> I and the script finishes without an

Re: Apache::DBI and transactions

2000-12-14 Thread Chris Nokleberg
In case your script makes some db changes "by accident"--if you don't do an explicit rollback or commit at the end, the uncommitted changes will hang around, and the next request may end up committing those changes unwittingly. I rollback at both the beginning and the end of all requests, just to

Re: Apache::DBI and transactions

2000-12-14 Thread Michael Peppler
Stas Bekman writes: > > I was in the process of updating the Apache::DBI section of the guide with > the notes from the latest version of this package, and there is a new > section about Transactions. Since I use mysql, it doesn't have > transactions so I cannot it's not absolutely clear to

Re: Apache::DBI problem and writting a perl module!!!

2000-12-03 Thread Perrin Harkins
Edmar Edilton da Silva wrote: > I still didn't solve the problem of the Apache::DBI. It can not be > loaded into the apache's startup.pl file because happens a error during > the starting of the apache, the child processes are not created. For > using the Apache::DBI I had to add the "use Apac

Re: Apache::DBI

2000-11-13 Thread G.W. Haywood
Hi there, On Mon, 13 Nov 2000, Jon Molin wrote: > I'm considering using Apache::DBI but before I'd want to benchmark > to see if I gain anything. To do this I just made a script that > connects/disconnects 10 times. You'd better read the Guide. http://perl.apache.org/guide The whole point is

Re: Apache::DBI problem

2000-09-12 Thread Perrin Harkins
On Tue, 12 Sep 2000, Evelin Halling wrote: > I am using Apache::DBI for user authentication and it works just fine > with one exception, it does not kill the sql backend server process > starting up during authentication, so after some time postgres is > running out of allowed backend server proce

Re: Apache::DBI Wisdom Sought

2000-08-31 Thread Chris Winters
* Mark D Wolinski ([EMAIL PROTECTED]) [000831 11:24]: > Hi all, > > You'll pardon me a little, I hope for this message does tend to lap over out > of ModPerl, but if it'll make you feel at ease, I shall only expect wisdom > on the modperl side. > > I run a service of free message boards where u

RE: Apache::DBI and Oracle problem

2000-08-22 Thread Robert Jenks
Title: RE: Apache::DBI and Oracle problem We had this same exact problem.   Same as you we were also doing $sth->finish() on each statement handle and we also even tried "undef $sth" after the finish().  None of these things worked.  In our case we were using "$dbh->{Ra

RE: Apache::DBI using 'reauthenticate' instead of caching

2000-08-11 Thread Geoffrey Young
very interesting.  I might suggest a config option to toggle the functionality within Apache::DBI instead of a new module entirely.  Or maybe including it as another module within the Apache::DBI distribution. I don't know how everyone else feels, but all the stuff in the Apache:: namespace

Re: apache::DBI

2000-07-04 Thread David Hodgkinson
Kristopher Lalletti <[EMAIL PROTECTED]> writes: > Okay, so if it seems that Redhat 6.1/6.2 Apache & mod_perl is broken.. > Anyone have a good guide/website to get apache & mod_perl compiled > properly? http://perl.apache.org/guide/install.html#Installing_mod_perl_in_10_Minute > I've been readi

RE: apache::DBI

2000-07-03 Thread Kristopher Lalletti
load, but it dies, because I'm unable to telnet on port 80 and there are no logs of the crash). Help? -Original Message- From: Guo Bin [mailto:[EMAIL PROTECTED]] Sent: July 2, 2000 9:18 PM To: Christopher Suarez; [EMAIL PROTECTED] Subject: Re: apache::DBI Though not using rh 6.2, my

Re: apache::DBI

2000-07-02 Thread Guo Bin
Though not using rh 6.2, my experience on 6.1 was the same --- apache will crash whenever use Apache::DBI is included in httpd.conf. I'm now using manually compiled apache and modperl and they are working fine. Hope this will also work for 6.2. On small glitch, Apache::Status cannot show Apache::

Re: Apache::DBI

2000-06-26 Thread David Mitchell
> But I run apache I get: > utechnology# ./apachectl start > defined(@array) is deprecated at > /usr/local/lib/perl5/site_perl/5.6.0/Apache/DBI.pm line 135. > (Maybe you should just omit the defined()?) > ./apachectl start: httpd started Perl 5.6.0 has introduced a new warning when it see

RE: Apache::DBI

2000-06-21 Thread Perrin Harkins
On Wed, 21 Jun 2000, Eric Jain wrote: > > > Is it be possible to modify Apache::DBI in sich a way that only > > > database connections specified in a PerlRequired startup.pl with > > > Apache::DBI->connect_on_init(...) are stored and all subsequent > > > DBI->connect(...) connections are properly

RE: Apache::DBI

2000-06-21 Thread Eric Jain
> > Is it be possible to modify Apache::DBI in sich a way that only > > database connections specified in a PerlRequired startup.pl with > > Apache::DBI->connect_on_init(...) are stored and all subsequent > > DBI->connect(...) connections are properly established > (if no matching > > stored conne

RE: Apache::DBI

2000-06-21 Thread Geoffrey Young
> -Original Message- > From: Eric Jain [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, June 21, 2000 1:30 PM > To: Mod_Perl > Subject: Apache::DBI > > > Is it be possible to modify Apache::DBI in sich a way that only > database connections specified in a PerlRequired startup.pl with > Apac

Re: Apache::DBI strategy/philosophy

2000-06-17 Thread Perrin Harkins
John M Vinopal wrote: > For programmer ease you probally want to connect inside a module, and for > mod_perl speed you want to preload that module. But you can't do both AND > connect once at the start. Mod_perl insists that dbh connections must not > be made in the parent and then used in the c

Re: Apache::DBI strategy/philosophy

2000-06-16 Thread John M Vinopal
Part of the problem I've had is transitioning a cgi application onto mod_perl and keeping performance up on both platforms until a switch can be made. So I've done some comparisons of the various dbh schemes. Comments and corrections very welcome. I'm wary of connect_cached() under mod_perl but

Re: Apache::DBI broken?

2000-06-16 Thread Randal L. Schwartz
> "Perrin" == Perrin Harkins <[EMAIL PROTECTED]> writes: Perrin> Make sure you're loading it before DBI, including any scripts that use Perrin> DBI. Try putting "PerlModule Apache::DBI" right up at the top of your Perrin> httpd.conf and see if that fixes things. I'm hoping that some future

RE: Apache::DBI broken?

2000-06-16 Thread Ian Mahuron
It was PHP4. A rebuild fixed it. Thanks guys! > -Original Message- > From: Ian Mahuron [mailto:[EMAIL PROTECTED]] > Sent: Friday, June 16, 2000 01:50 PM > To: Edmund Mergl > Cc: Mailing List, mod_perl > Subject: RE: Apache::DBI broken? > > > > Everything

RE: Apache::DBI broken?

2000-06-16 Thread Ian Mahuron
TED] [mailto:[EMAIL PROTECTED]]On Behalf Of > Edmund Mergl > Sent: Friday, June 16, 2000 01:31 PM > To: Ian Mahuron > Cc: Mailing List, mod_perl > Subject: Re: Apache::DBI broken? > > > Ian Mahuron wrote: > > > > I've been searching through the mailing list

RE: Apache::DBI broken?

2000-06-16 Thread Vivek Khera
> "IM" == Ian Mahuron <[EMAIL PROTECTED]> writes: IM> php4 *is* in the mix! I installed it just so we could use phpMyAdmin (neat IM> MySQL web client). Can you ellaborate on this (URL, docs, etc)?? Is there IM> a patch for php4 or should I jump back to php3? by default, when you build php

RE: Apache::DBI broken?

2000-06-16 Thread indrek siitan
Hi, > php4 *is* in the mix! I installed it just so we could use > phpMyAdmin (neat MySQL web client). Can you ellaborate on this > (URL, docs, etc)?? Is there a patch for php4 or should I jump > back to php3? you just need to compile PHP4 with --with-mysql=/path/to/your/mysql. if you use ju

RE: Apache::DBI broken?

2000-06-16 Thread Ian Mahuron
TECTED]] > Sent: Friday, June 16, 2000 01:17 PM > To: Ian Mahuron; [EMAIL PROTECTED] > Subject: RE: Apache::DBI broken? > > > Hi, > > > System is: > > FreeBSD 4.0 > > Apache 1.3.12 > > perl 5.005_03 > > mod_perl 1.24 > > DBI 1.14 > > Apache::D

RE: Apache::DBI broken?

2000-06-16 Thread indrek siitan
Hi, > System is: > FreeBSD 4.0 > Apache 1.3.12 > perl 5.005_03 > mod_perl 1.24 > DBI 1.14 > Apache::DBI 0.87 are you sure you don't have PHP4 in this mix? if you have compiled PHP4 with its internal support for MySQL, it will conflict with mod_perl. Rgds, Tfr --==< [EMAIL PROTECTED] >==< M

Re: Apache::DBI broken?

2000-06-16 Thread Edmund Mergl
Ian Mahuron wrote: > > I've been searching through the mailing list and have seen several people > with the same problem I'm experiencing. Yet I've seen no solid answers to > this problem... so maybe I'll try again. > > System is: > FreeBSD 4.0 > Apache 1.3.12 > perl 5.005_03 > mod_perl 1.24 >

Re: Apache::DBI broken?

2000-06-16 Thread Casey Bristow
I had similar problems. In startup.pl, where you are calling 'use Apache::DBI;', do you call 'use DBI;' following the call to Apache::DBI ? When I included that in startup.pl.. it started behaving better.. my $0.02 -Casey On Fri, 16 Jun 2000, Ian Mahuron wrote: > > I've been searching t

<    1   2   3   >