Hi there,
On Thu, 13 Sep 2001, DJ (David J Radunz) wrote:
the database connections just keep building up.
Read the database section of the Guide:
http://perl.apache.org/guide
73,
Ged.
the server is shut down.
With Apache::DBI, you should get one connection per Apache process, and
they'll stay open. If you are changing the login parameters (i.e.
different user each time), you can't use Apache::DBI because you'll get
a huge build-up of connections.
- Perrin
causing mysqld to crash.
Scenario 1:
in the script: (NB: this is not the entire
script.. just snippets to show what im trying to achive).
use strict;
use vars ($dbh);
use
mod_perl;
use DBI;
sub config {
.
$dbh ||=
dbi_connect;
}
sub dbi_connect {
my $an =
$C{'auth_name'}; my
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:
root@ganja:/home/www/server/conf ../bin/apachectl start
../bin
von Lengerke:
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:
root@ganja:/home/www/server/conf ../bin/apachectl
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
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
Hi!
I'm running modperl 1.26 and apache 1.3.20 on a Solaris machine. I added
Apache::DBI and other DBI modules.
I added the following line to the httpd.conf line to use Apache::DBI
PerlModule Apache::DBI
Before any other DBI command as stated on the docs. Here's the error I get
at starting
Syntax error on line 304 of /export/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: /export/apache/bin/httpd: fatal: relocation error:
file /usr/local/lib/perl5/site_perl/5.6.1/sun4-solaris/auto/DBI/DBI.so
This looks like a DBI installation problem, not an Apache::DBI problem.
Does DBI work when you don't use Apache::DBI?
- Perrin
You are right. It gives me the same error when I try to use DBI alone:
[error] Can't load
'/usr/local/lib/perl5/site_perl/5.6.1/sun4-solaris/auto/DBI/DBI.so' for
module
The DBI installation went fine, I used CPAN. DBI version is 1.20. I looked
for the DBI.so and the DBI.pm files and they are in the correct paths.
What may be the problem?
I don't know, but you might have more luck asking about it on the DBI list.
Or you could do some searching on Google
I have a query that executes many many times that I would like to optimize
using placeholders. One of the fields that it will insert into is a 'text'
field and I am having a problem with DBI (or the db) escaping '\n'
characters so when they are inserted into the database they become '\\n' (ie
ryc wrote:
... I am having a problem with DBI (or the db) escaping '\n'
characters so when they are inserted into the database they become '\\n'
(ie a '\' followed by 'n').
Does anyone have advice on how this could be done while still using
placeholders so I dont need to prepare the query
On Sat, Sep 01, 2001 at 02:38:05PM -0500, Mike808 wrote:
ryc wrote:
... I am having a problem with DBI (or the db) escaping '\n'
characters so when they are inserted into the database they become '\\n'
(ie a '\' followed by 'n').
Does anyone have advice on how this could be done while
code
heh.
Thanks everyone,
ryan
Please make sure that you are indeed trying to put a newline into
the database. The string, '\n', is a 2-character string.
The string, \n, is a 1-character string (a newline).
So if your text variable is something like 'hello\nworld',
it's no wonder the DBI
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:
OCIStmtExecute
I am a bit confused! Can Apache::DBI handle db calls through proxies?
-r
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
On Mon, Aug 13, 2001 at 03:33:18PM -, qazi Ahmed wrote:
Hi DBI Gurus,
Even though many lurk here too, you're on the wrong list for DBI help.
I have DBD, DBI, Apache::DBI installed in my machine.
Actually when i try to access the database i am getting the following error.
Try DBI users
DBI works under Apache. Apache::DBI just gives you some performance gains like
persistent connections etc. Get the script working with DBI under Apache and
then start messing with Apache::DBI. Your problem is that you need to print
Content-type: text/html\n\n; before you print anything else. (CGI
I can run this simple script through perl itself, but when I put it in the
cgi-bin and try to run it using mod_perl Perl pops up in windows with an
error. I assume this means I need something like Apache::DBI?... I
originally got Apache in binary form with mod_perl installed and did
startup.pl cannot be run from the command line when it
contains apache server specific modules.
But you can put those (Apache specific) modules in your httpd.conf instead
as
PerlModule Apache::DBI Apache::Status
and avoid compilation warnings in startup.pl.
But you should clearly note
::DBI;
use Apache::DBILogger;
1;
uwb-02-chroot# ./startup.pl
Can't locate object method module via package Apache (perhaps you forgot to load
Apache?) at /usr/local/lib/perl5/site_perl/5.6.1/Apache/DBI.pm line 202.
Compilation failed in require at ./startup.pl line 5.
BEGIN failed--compilation
-freebsd
uwb-02-chroot# cat /usr/local/etc/apache/startup.pl
#!/usr/bin/perl
use Apache;
use Apache::Status;
use Apache::DBI;
use Apache::DBILogger;
1;
uwb-02-chroot# ./startup.pl
Can't locate object method module via package Apache (perhaps you forgot to load
Apache?) at /usr/local/lib
-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 documented somewhere in the guide
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 more :)
I disagree. I *did
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
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
On 02 Aug 2001 14:32:01 -0700, brian moseley wrote:
for the next perl conference i'm writing a do everything
abstraction layer. it will provide a do_stuff routine that
will, out of the box, do your laundry and perform oral sex.
scalable, robust, state of the art technology for
On Thu, Aug 02, 2001 at 02:32:01PM -0700, brian moseley wrote:
for the next perl conference i'm writing a do everything
abstraction layer. it will provide a do_stuff routine that
will, out of the box, do your laundry and perform oral sex.
scalable, robust, state of the art technology for
-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 not to use()
modules in the
code
Stas Bekman wrote:
Maybe the guide should include links to the most mature peristence
abstraction layer projects out there:
- Class::DBI
- Alzabo
- Tangram
- SPOPS
I suppose that could fit into the help.pod. Otherwise it's not directly
related to mod_perl, and the guide has to start shrinking
Robert Landrum wrote:
The guide is a great thing, and removing items from it is risky.
Think of it as refactoring.
On Thursday, August 2, 2001, at 03:00 PM, Robert Landrum wrote:
Sweet...
I was getting kinda tired of my Linux box going down on me.
You must be thinking Windows!
--
-- Tom Mornini
-- ICQ 113526784
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
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::DBI
At 2:32 PM -0700 8/2/01, brian moseley wrote:
for the next perl conference i'm writing a do everything
abstraction layer. it will provide a do_stuff routine that
will, out of the box, do your laundry and perform oral sex.
scalable, robust, state of the art technology for
e-businesses.
Sweet...
guys and gals:
i saw this code snippet
called
Simple DBI Abstraction Class
thought it might be
a good thing to look over
http://perlmonks.org/?node_id=101631
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,62c310
, it requires you to pay better attention to your
httpd.conf than you ought to.
See my above point. Apache::DBI is *made* to be transparent, or at least
semi-. It exists at the server level, and without (much) interaction with
the programmer's dataspace at all. What better place for it than
httpd.conf
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
Even when using Apache::DBI, I still have the same problem - If it times out
once, it won't try again. I set Apache::DBI::DEBUG = 2, and here's the log:
When I first load the page and get the timeout:
197345 Apache::DBI need ping: yes
197345 Apache::DBI new connect
-Original Message-
From: Curtis Hawthorne [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 31, 2001 10:47 AM
To: [EMAIL PROTECTED]
Subject: Re: mod_perl/DBI problem
Even when using Apache::DBI, I still have the same problem -
If it times out
once, it won't try again. I set
[EMAIL PROTECTED]
To: 'Curtis Hawthorne' [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Tuesday, July 31, 2001 10:04 AM
Subject: RE: mod_perl/DBI problem
snip
the way most people handle this is by separating out the connect routine,
wrapping it in an eval, and calling $r-child_terminate if $dbh
-Original Message-
From: Curtis Hawthorne [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 31, 2001 12:24 PM
To: [EMAIL PROTECTED]
Subject: Re: mod_perl/DBI problem
That looks like that will do exactly what I need. I tried it
my code and it
caught the server timeout
-Original Message-
From: Geoffrey Young [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 31, 2001 12:46 PM
To: 'Curtis Hawthorne'; [EMAIL PROTECTED]
Subject: RE: mod_perl/DBI problem
yup, looks like mod_perl doesn't offer that to windows.
well, I don't do windows, but maybe
;
}
sub dothings {
return querydatabase;
}
So, should I rewrite it so that it makes a new connection (but not really
because of Apache::DBI) in each sub, or have the script call a subroutine
that gives it a database handle to pass to each sub, go at it a completely
different way, or am I way off
-Original Message-
From: Curtis Hawthorne [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 31, 2001 3:48 PM
To: Geoffrey Young; [EMAIL PROTECTED]
Subject: Re: mod_perl/DBI problem
Well, that works perfectly, but doesn't do anything :-).
As far as I can tell, because my
gotten around to it :-)
Anyways, much thanks for all your help!
Curtis H.
- Original Message -
From: Geoffrey Young [EMAIL PROTECTED]
To: 'Curtis Hawthorne' [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Tuesday, July 31, 2001 3:14 PM
Subject: RE: mod_perl/DBI problem
snip
hmph, it's been
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
I'm writing a script that will run under mod_perl that uses DBI to connect
to an MS SQL server. The script works fine and mod_perl speeds it up quite
a bit. Every so often, when the script tries to connect to the SQL server,
the connection times out (I think the SQL server's a little slow
Hi there,
On Fri, 27 Jul 2001, Curtis Hawthorne wrote:
So, how can I have it try to connect to the database again if it fails, but
keep the connection persistent if it doesn't?
Have a look in the Guide, there's lots of stuff in there about
Apache::DBI. http://perl.apache.org/guide.
73,
Ged.
Does anyone know if Apache::DBI is included with mod_perl? if not
could someone tell me where i could get it from?
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 could get
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: OCITransRollback
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
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.
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 DBI 1.18
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;
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
/usr
Hi all,
ive just been researching these
a bit and I'm wondering if anyone has good advice/links on how to
link these three Modules together ?
heres what im caught on :
1.is it best to load Apache::DBI at start up of apache and can i load more than
one connection type?
2.is it best to login
On Sunday, June 3, 2001, at 12:28 pm, Clayton Cottingham aka drfrog
wrote:
heres what im caught on :
1.is it best to load Apache::DBI at start up of apache and can i load
more than
one connection type?
yes via PerlModule or a PerlRequire for a startup.pl. My understanding
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
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
httpd.conf
a 'PerlModule Apache::DBI' line in
httpd.conf - Apache starts up but shuts down immediately. I created a test
script that just use's the module and I get the following error
Can't locate object method module via package Apache at
/usr/lib/perl5/site_perl/5.005/Apache/DBI.pm line 202. BEGIN
failed
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
httpd.conf - Apache starts up but shuts down immediately. I created a test
script that just
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 going on? Any
just DBI. try
PerlModule DBI
PerlModule Apache::DBI
yuk, of course that's backwards...
PerlModule Apache::DBI
PerlModule DBI
sorry...
--Geoff
Hi all,
I just updated our development system to some recent versions...
Perl 5.6.0-5.6.1, Apache 1.3.14-1.3.19, mod_perl 1.24_1-1.25, DBI 1.14-1.15,
Filter 1.19-1.23 (+16 others).
Now this is what I get at server startup:
# /opt/apache/bin/apachectl start
startup.pl: starting (0)
/opt/apache
On Sun, 6 May 2001, Rodney Broom wrote:
Hi all,
The other day I installed PHP4 as a DSO. No problem, it works fine. Today I was
adding a Perl handler that needs a DB connection (MySQL). Nothing special, I
used DBI. But at the time of the connection, the handler stops. No error, no
message
On Sun, 6 May 2001, Matt Sergeant wrote:
Hi everyone,
On Sun, 6 May 2001, Rodney Broom wrote:
Hi all,
I may be wrong, but isn't this the issue where you have to compile PHP4
*without* the MySQL libraries. MySQL still works from PHP4, provided you
have the MySQL libs on your machine
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 NonStop=1
Hi all,
The other day I installed PHP4 as a DSO. No problem, it works fine. Today I was
adding a Perl handler that needs a DB connection (MySQL). Nothing special, I
used DBI. But at the time of the connection, the handler stops. No error, no
message, no anything.
- I tried to get a DB handle
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 NonStop=1 LineInfo=/tmp/db.out AutoTrace=1 frame=2
Hi all. I've ploughed through the documentation
regarding persistent db connections under mod_perl,
but I guess I'm not properly understanding just what
is meant by persistent connection.
The scenario I have is a simple CGI script running
under Apache::Registry. I added Apache::DBI to
httpd.conf
- 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 same
Wayne,
WIIt is my understanding that when the app is running
WIand I look at the status under MySQL, that I should
WIsee only one connection. However, what I see is plenty
WIof connections, as many as there were before I added
WIApache::DBI to the mix.
Apache is a forking server. There are x
() properly. But I'm using Apache::DBI, so should I need
to do that?
I would expect to see these messages if your web scripts were
issuing database calls and the httpd processes got killed with
a apachectl stop/start. There might then be aborted connections
at the database end. There is probably
. But I'm using Apache::DBI, so should I need
to do that?
-Philip Mak ([EMAIL PROTECTED])
Brendan McAdams writes:
Unfortunately one of our sysadmins discovered a problem when he was
stress testing the system: If he clicks a link to one of the apps
components several times in succession, sybase's connections start
dying.
An example of sybase errors:
[Fri Apr 6 17:02:50
OpenClient, 11.1.1 patchlevel 8058
Sybase server 11.9.2
It's some rather heavy stored procedures returning large result sets.
Past that, what data do you need?
-Original Message-
SNIP
This is rather strange. Could you give me more information on your
setup? Are you using Sybase's
Unfortunately mySQL would choke about 5 minutes into production for our
application and what we are doing
I need a sybase solution.
luck.
JPS
-Original Message-
From: Brendan McAdams [mailto:[EMAIL PROTECTED]]
Sent: Friday, April 06, 2001 5:22 PM
To: [EMAIL PROTECTED]
Subject: HELP: DBI Issues
Hoping someone can help me; I'm working on rolling out a mod_perl
rewritten release (to push some major performance
d http://www.webzavod.ru
Tel. +7 (8462) 43-93-85 | +7 (8462) 43-93-86
mailto:[EMAIL PROTECTED]
- Original Message -
From: "Tim Bunce" [EMAIL PROTECTED]
To: "Alec Smith" [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Thursday, April 05, 2001 12:24 PM
Subject: Re: Problem with Apa
You would only get that message if AutoCommit was off.
It should not be off for DBD::mysql (since it doesn't yet support
the transaction features of newer versions).
Plus, disconnect doesn't do anything when using Apache::DBI
(by design).
Tim.
On Wed, Apr 04, 2001 at 11:49:17PM -0400, Alec
In my module I've got:
use DBI;
use Apache::DBI;
$db = DBI-connect('DBI:mysql:dbname', 'username', 'password', {RaiseError
= 1, AutoCommit = 1});
and in startup.pl:
use DBI;
use Apache::DBI;
Apache::DBI-connect_on_init('DBI:mysql:dbname', 'username',
'password',{RaiseError = 1, AutoCommit
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.
thanks Geoff, I appreciate your feedback.
is there any bug databse for DBI/DBD on internet where I can serach for of any known
issues with these on HP-UX 11.0 ?
thanks
Arun
--
From: Geoffrey Young[SMTP:[EMAIL PROTECTED]]
Sent: Wednesday, March 28, 2001 05:20
and it looks the same rather I'm in Perl or via Mod_perl. Here is the
result from the print: "dbi:mysql:its,helpman,secret01,HASH(0xaf798b4)"
Looks like it should work, but nothing seems to be returned from the
"return DBI-connect($dsn,$user,$password,$options)" statement.
On Tue, 20 Mar 2001, John Mulkerin wrote:
There is no error message returned, it just goes back to the httpd 403
error screen.
What about in the error log? Have you read the DBI docs on how to get
your error message to print? You should either have RaiseError on or be
checking return codes
O mighty Wizards please help if you can:
I'm trying to use the plain vanilla TicketTool.pm from O'Reilly's mod perl
book, Apache Modules with Perl and C. It uses Tie::DBI to create a hash of
the mysql connection. When I run just the authentication subroutine with
Perl -d "authentica
On Mon, 19 Mar 2001, John Mulkerin wrote:
I'm trying to use the plain vanilla TicketTool.pm from O'Reilly's mod
perl book, Apache Modules with Perl and C. It uses Tie::DBI to create
a hash of the mysql connection. When I run just the authentication
subroutine with Perl -d "authentica
On Thu, 15 Mar 2001, Joern Janoschek wrote:
What makes me scratch my head is the fact that the exit was
placed before the dbi connect call... which leads me to the
conclusion that the exit was simply not executed at all, no
override version or something else. Strange...
Why scratch you head
::DBI: Yes, we did try persistant connections to
avoid heavy connection load on the mysql. BUT it simply didn't
work. Well sort of. Persistant connections were established, but
they never got reused. Until about 7 open connections
resulted in a DB crash. Not nice. Same problem with a
corresponding
need a
fix/solution/workaround soon!
A word on Apache::DBI: Yes, we did try persistant connections to
avoid heavy connection load on the mysql. BUT it simply didn't
work. Well sort of. Persistant connections were established, but
they never got reused. Until about 7 open connections
On Wed, 14 Mar 2001 18:46:31 +, Greg Cope wrote:
There's no reason why Apache::DBI should not work - by the sounds of it
the connections strings may have been different ?
Apache::DBI works in an environment where on user ID is used to connect
to the DB mulitple time. If you use two
Joern Janoschek wrote:
On Wed, 14 Mar 2001 18:46:31 +, Greg Cope wrote:
There's no reason why Apache::DBI should not work - by the sounds of it
the connections strings may have been different ?
Apache::DBI works in an environment where on user ID is used to connect
to the DB
I've been writing a handler on a test box which uses the DBI-connect
method, no problem, only my Perl authoring skills are at fault.
Its based on Slackware 7.1, with Apache 1.3.14, mod_perl 1.24_01, and
mod_ssl 2.7.1. I have DBI 1.14 and msql-mysql 1.2215 with Perl
5.6.0. MySQL version
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 "DBI" not "Apache::DBI"
module.
a simple program woul
Hi all,
on my DB server I have 245 "idle" postmasters process for 130 httpd
persistant DB connections alive.
can anyone give me a clue how to manage this number of
unused/idleschildren and how to have them quickerly deallocated ?
this way, I jumptoo quick on 'too much connection'...
301 - 400 of 856 matches
Mail list logo
