-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
"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
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
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
On Sun, 16 Apr 2000, Jochen Wiedmann wrote:
Btw, Doug, as I see the sigpipe thing: What do you recommend for the
DBD::mysql driver? (Remember the "MySQL morning bug"?) Should we
enable or disable SIGPIPE?
apache no longer catches SIGPIPE as of 1.3.6, so it may not be an issue
anymore if
Drew Degentesh wrote:
Below is a backtrace of my segfault received on DBI-Connect (sorry but my
perl and apache binaries are stripped)... you can see that mysql_close is
being called with a null argument, rather than mysql_real_connect as
indicated in some of the other backtraces reported
through APXS)
mysql Ver 9.36 Distrib 3.22.27 (from distribution)
perl 5.005_03 (from distribution)
Msql-Mysql-modules-1.2211 (compiled form source, retreived from CPAN)
DBI-1.13 (compiled form source, retreived from CPAN)
None of which are sporting any modifications
On Tue, 11 Apr 2000, Doug MacEachern wrote:
On Tue, 4 Apr 2000 [EMAIL PROTECTED] wrote:
I've been seeing the same segfault-on-connect problem with Apache 1.2.12
+ mod_perl 1.22 + DBI 1.13 + Msql-Mysql-modules 1.2211. The segfault is
due to a null first argument being passed
this seems to becoming quite a common problem, i wonder if Jochen can shed
some light?
On Tue, 4 Apr 2000 [EMAIL PROTECTED] wrote:
I've been seeing the same segfault-on-connect problem with Apache 1.2.12
+ mod_perl 1.22 + DBI 1.13 + Msql-Mysql-modules 1.2211. The segfault is
due to a null
Hi,
after some browsing of the [EMAIL PROTECTED] archives, I see now that my
AuthDBI problem is the same as this thread (Segfault on DBI-Connect). I
tried the workaround suggested by wil (*sock=0 before mysql_init(sock)) to
no avail.
Here's a backtrace from gdb httpd -X. Has any headway been
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
.
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
:
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
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
Right, I had the exact same problem. Took me almost 1 day to solve.
I'm using apache 1.3.12 / mod_perl 1.22 / DBI 1.13 / Msql-Mysql-modules 1.22.11
Under normal CGI environment everything works fine but when run with mod_perl
it just segfaults.
As Richard mentioned it's due to a NULL MySQL
We seem to be dancing around the DBI-connect segfault problem with MySQL
DBI drivers. Maybe someone here who reads other relevant lists could for-
ward our traffic and see if we can create some synergy there.
Our basic story is that, with Apache 1.3.12 and mod_perl 1.22 (with DBI
version 1.13
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
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
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
From: James G Smith [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
CC: Valter Mazzola [EMAIL PROTECTED], Doug MacEachern
[EMAIL PROTECTED]
Subject: Re: Segfault on DBI-Connect
Date: Mon, 03 Apr 2000 00:13:14 -0500
Doug MacEachern [EMAIL PROTECTED] wrote:
On Sat, 1 Apr
All..
I am new to mod_perl so, please forgive me if this questions sounds
stupid..
I have successfully installed mod_perl 1.22 and Apache 1.3.12 under
BSD/OS BSDI 3.1 And able to run normal cgi script... But problem occurs
while I am trying to run script with DBI..
I have successfully
I've been seeing the same segfault-on-connect problem with Apache 1.2.12
+ mod_perl 1.22 + DBI 1.13 + Msql-Mysql-modules 1.2211. The segfault is
due to a null first argument being passed to mysql_real_connect().
Running Apache with a -X argument yields the following backtrace when my
mod_perl
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
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
On Sat, 1 Apr 2000, Valter Mazzola wrote:
i've a mod_perl script that connect to a mysql db, but sometimes it segfault
on DBI-connect. i'm using Apache::Registry Apache::DBI for persistend db
connection, use strict and the script it's a package. i've read the docs but
probably i'm
Doug MacEachern [EMAIL PROTECTED] wrote:
On Sat, 1 Apr 2000, Valter Mazzola wrote:
i've a mod_perl script that connect to a mysql db, but sometimes it segfault
on DBI-connect. i'm using Apache::Registry Apache::DBI for persistend db
connection, use strict and the script it's a package
i've a mod_perl script that connect to a mysql db, but sometimes it segfault
on DBI-connect. i'm using Apache::Registry Apache::DBI for persistend db
connection, use strict and the script it's a package. i've read the docs but
probably i'm missing something.
The persistent DBI connection
On Thu, 30 Mar 2000 [EMAIL PROTECTED] wrote:
Hi,
I'm trying to use Apache::Session::DBI. I got the hang of it and
started using it but I get the following error:
[Thu Mar 30 04:41:41 2000] [error] Can't call method "store" on
unblessed reference at lib/web/webmaster.p
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
On Wed, 29 Mar 2000, Jerome MOUREAUX wrote:
Hi All,
I experience a trouble with Perl script using DBI running under Mod_perl
and Registry
If you have an idea from where the problem may come
Here is the error :
DBI-connect failed: ORA-12154: TNS:could not resolve service name
"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
.
-d.
Jerome MOUREAUX said...
Hi All,
I experience a trouble with Perl script using DBI running under Mod_perl
and Registry
If you have an idea from where the problem may come
Here is the error :
DBI-connect failed: ORA-12154: TNS:could not resolve service name (DBD
this problem. I never had any problem
with DBI
in other command line perl scripts as well as in traditionnal perl CGI
scripts so I
think there is something linked to Registry ???
Regards
Jerome
At 10:33 AM 29-03-00 -0800, Jeffrey W. Baker wrote:
On Wed, 29 Mar 2000, Jerome MOUREAUX wrote:
Hi
script using DBI running under Mod_perl
and Registry
If you have an idea from where the problem may come
Here is the error :
DBI-connect failed: ORA-12154: TNS:could not resolve service name (DBD:
login f
ailed) at /disc1/sherpa_a/indicators2/perl/activity/toto.pl line 5
,
I experience a trouble with Perl script using DBI running under Mod_perl
and Registry
If you have an idea from where the problem may come
Here is the error :
DBI-connect failed: ORA-12154: TNS:could not resolve service name (DBD:
login f
On Wed, 29 Mar 2000, Jerome MOUREAUX wrote:
Alias /indicators2/perl "/disc1/sherpa_a/indicators2/perl"
[...]
PerlSetEnv ORACLE_HOME /disc1/sherpa/oracle
Do you really have a /disc1/sherpa directory and a /disc1/sherpa_a
directory?
- Perrin
A final effort... From the command line it works. Perhaps your ORACLE_USERID,
etc. is already set?
Within your Registry script, that's probably not the case unless you've
explicitly told it otherwise.
So let's change your DSN around a bit:
my $dbh = DBI-connect('dbi:Oracle:', 'indic
Write a small registry script to print %ENV and confirm ORACLE_HOME is set to
/disc1/sherpa/oracle.
In your shell,
# cat eof/tmp/test.sh
\$ORACLE_HOME/bin/tnsping YourTNSAlias
eof
# su - nobody -c 'env ORACLE_HOME=/path/to/oracle sh /tmp/test.sh'
John
[EMAIL PROTECTED]
On Wed, 29 Mar 2000, Jerome MOUREAUX wrote:
My scripts run well if I launch it from the command line.
Have you tried running them from the command line as the user who the
webserver runs as? There may be something in your user environment that
allows them to work which is not set up for this
when I was trying to
figure out what happen) otherwise it would mean that SID are insensitive when
running the script from command line and sensitive when running from Apache !
[...]
Here is the error :
DBI-connect failed: ORA-12154: TNS:could not resolve service name (DBD:
login f
hello people
me again with the Apache::DBI and apache problems
the scenario - a very basic install of redhat 6.1
downloaded mod_perl 1.21
apache-1.3.11
from cpan
Apache::DBI v0.87
DBI v1.13
DBD::mysql v2.0218
Hello all,
I am a relative newbie at debugging DBI related problems. I am using
the following tracing:
PerlSetEnv DBI_TRACE "1=/tmp/dbitrace.log"
My problem is that although I can trace to lines of code in a package we
have written,
I don't understand what I can do because I d
I just set up mod_perl_.1.21 with apache_1.3.11 andperl 5.005_03. When
trying to start the httpd server, my httpd.conf is calling a
perlstartup.pl script where I get the following error. I looked in the
file itself and says when finding that error it means an install error
with DBI. I
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
Hi,
I just set up mod_perl_.1.21 with apache_1.3.11 andperl 5.005_03. When
trying to start the httpd server, my httpd.conf is calling a
perlstartup.pl script where I get the following error. I looked in the
file itself and says when finding that error it means an install error
with DBI. I
Hi all,
I've been trying cache DBI database handles using IPC::Shareable and
IPC::Cache(based on ShareLite) without much luck. This is not necessarily
a mod-perl problem, but I figured someone on this list must have tried
this already.
With either module, I get the following error message
having two processes trying to use the same handle at the same time.
In other words, there's a lot of work to be done to do this using shared
memory, and not all the libraries would even support it. I'm not completely
sure any of them would.
DBI::Proxy works by having a single process do all
Hello,
I am trying to create a library (.pm file) of DBI functions for use in my
MOD_PERL scripts, but am not totally clear on how to use exporter (do I
absolutely NEED to use exporter?, or can I just "use" the .pm library?)
Is the following correct?
The TEST.
I am trying to create a library (.pm file) of DBI functions for use in my
MOD_PERL scripts, but am not totally clear on how to use exporter (do I
absolutely NEED to use exporter?, or can I just "use" the .pm library?)
Is the following correct?
This has nothing to do with mod_pe
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
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
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
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
/ 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
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
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 mysql connection,why?
I did set the
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
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
Reading Mike Miller's great site on MySQL
(http://www.savebaseball.com/mysql/), I tried a link about the Perl 5 DBI
(http://www.hermetica.com/technologia/DBI) but it seems dead. Anyone know
how to get to the docs there? ( Apologies, I know this isn't specifically
on mod_perl, but I'm having
jiminy [EMAIL PROTECTED] writes:
PS - this is my first time to post here. Most mailing lists I've seen have
as the reply-to the address of the list, however this one doesn't seem to
have that feature, so that when I just reply to a message, it does to the
poster, not the list. Am I perceiving
Hello,
On Wed, 19 Jan 2000, Kip Cranford wrote:
I don't suppose it could be as simple as having a full disk? What does
"df -k" report...
I'm afraid not, no. Plenty of space is left on the drives.
Regards,
Mark.
--
Mark Jewiss
Knowledge Matters Limited
http://www.knowledge.com
Hello,
I'm trying to run a simple script using Apache::Session for the first
time, and am having a few problems. Can't see anything relating to this in
the documentation or the archives, so here goes...
Whenever I run a script, everything works until I try to create a new
session id, where I
On Fri, 14 Jan 2000, Cere M. Davis wrote:
I have found the weirdest problem with (I think) DBD::Ingres,
DBI::trace() and Apache::DBI when the DBI::trace level is set to 1 or 0.
I get an error in the Apache error_logs that says:
unitialized value at
/uns/mind/usr/local/perl5/lib
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
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
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
"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
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
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
[
::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_
Hi there,
For the last 2 months, I've been using Apache::Session::DBI on a Solaris 2.6
box (with the semaphorelocker nsems value set to 16) to store session
information on a busy web site. Unfortunately, things seem to have gone
awry, specifically with the tie:
tie %SESSION, 'Apache::Session
On Sun, Jan 02, 2000 at 01:48:58AM -0600, Ed Loehr wrote:
My apache children are seg faulting due to some combination of
DBI usage and the cookie-based authentication/authorization
[...]
child seg faults. If I comment out all DBI references in the
Hm, are you connecting to your database
Edmund Mergl wrote:
On Sun, Jan 02, 2000 at 01:48:58AM -0600, Ed Loehr wrote:
My apache children are seg faulting due to some combination of
DBI usage and the cookie-based authentication/authorization
[...]
child seg faults. If I comment out all DBI references in the
Hm
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
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
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
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
On Dec 17, 2:06pm, Tim Bunce wrote:
Also I believe that the excellent TemplateToolkit now has a DBI plugin.
Indeed it has. Simon Matthews is the author but I don't think he's
posted it to CPAN yet. Hopefully this email will remind him. The
latest version he sent me earlier this week seems
Here's a message from SAM explaining where to find the module.
A
--- Forwarded mail from [EMAIL PROTECTED]
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED], [EMAIL PROTECTED]
Subject: Template-Plugin-DBI 0.09
Date: Mon, 20 Dec 1999 15:21:23 -
I have release an updated
"Mark" == Mark D Landry [EMAIL PROTECTED] writes:
Mark # Schwartzstein-Bunce Transform
Mark print table({-border=undef},
Mark caption('TableName'),
Mark Tr(map(th($_), @{$sth-{NAME}})),
Mark map(Tr(td($_)), @{$sth-fetchall_arrayref()}),
Mark );
This code is
HTML::Embperl page using DBI/DBD::pg.
Please could you give me an advice where to start debugging?!
Thanx!!!
Volker
--
EMail: Volker Hess [EMAIL PROTECTED]
Uni-GH Siegen . Medienzentrum
57068 Siegen
MZ: http://www.avmz.uni-siegen.de/
/Bilder/archiv/img.cgi line 38.
Doesn't it print the reason for the failure? Is your code looking like:
man DBI:
$dbh = DBI-connect($data_source, $username, $password)
|| die $DBI::errstr;
I mean, do you use $DBI::errstr?
It can be a permission problem, your
Thanx Stas,
Doesn't it print the reason for the failure? Is your code looking like:
man DBI:
$dbh = DBI-connect($data_source, $username, $password)
|| die $DBI::errstr;
I mean, do you use $DBI::errstr?
It can be a permission problem, your script
hello, all
Given the following situation what is more efficient:
-I have 10 id numbers I want to query on numbers 1,2,3,4,5,6,7,8,9,10
respectively. However, this list is not fixed and could be any number of
ids up to 20.
-Is it faster to create a global variable with a prepared sql statement
Alex Menendez wrote:
hello, all
Given the following situation what is more efficient:
-I have 10 id numbers I want to query on numbers 1,2,3,4,5,6,7,8,9,10
respectively. However, this list is not fixed and could be any number of
ids up to 20.
-Is it faster to create a global
On Thu, 9 Dec 1999, Alex Menendez wrote:
hello, all
Given the following situation what is more efficient:
-I have 10 id numbers I want to query on numbers 1,2,3,4,5,6,7,8,9,10
respectively. However, this list is not fixed and could be any number of
ids up to 20.
-Is it faster to
Hi there,
On Mon, 29 Nov 1999, Tim Bunce wrote:
I'd like to see a mode added to DBI::ProxyServer whereby a single
server process serviced multiple clients in a round-robin manner.
Obviously in this mode there's a risk of slow queries cloging up
(blocking) the proxy, but for many
On Mon, 29 Nov 1999, Tim Bunce wrote:
Ignoring 'thread' (unsafe for production use) and 'debug' modes, the
normal 'fork' mode means that each client gets a seperate ProxyServer
process. And because of that, clients have no way to share connections
with each other.
Is that necessarily the
established by the parent process.
But mixing a connection pool with fork mode ought work for some
of the DBI drivers.
Thanks for pointing that out. Does that mean you're volunteering? :-)
Tim.
On Mon, Nov 29, 1999 at 01:19:53PM -0800, Randal L. Schwartz wrote:
[watch the followups... this is going to both the modperl
and the DBI list...]
"Ed" == Ed Park [EMAIL PROTECTED] writes:
Ed each creates a network connection to DBI::ProxyServer, which
Ed creates a few
it? How
rude! Or does it have some other mechanism I'm not aware of?
But mixing a connection pool with fork mode ought work for some
of the DBI drivers.
Thanks for pointing that out. Does that mean you're volunteering? :-)
I'm willing to take a look at it... I've never played with DBD::Proxy
for those of you who haven't used HTML::Embperl $udat{location} is
session data
sub db_connect {
my $pd = shift;
if ($pd-{change}) { db_disconnect };
if ($pd-{change} || !$dbh) {
$dbh=DBI-connect(
"dbi:mysql:$pd-{database}", 'user', 'password', {
PrintError = 1,
}",
change = 1, } );
# for those of you who haven't used HTML::Embperl $udat{location} is
session data
sub db_connect {
my $pd = shift;
if ($pd-{change}) { db_disconnect };
if ($pd-{change} || !$dbh) {
$dbh=DBI-connect(
"dbi:mysql:$pd-{database}", 'user', 'password
db_connect {
my $pd = shift;
if ($pd-{change}) { db_disconnect($pd-{database}) };
if ($pd-{change} || !$dbh{$pd-{database}}) {
$dbh{$pd-{database}}=DBI-connect(
"dbi:mysql:$pd-{database}", 'user', 'password', {
PrintError = 1,
RaiseError = 1,
}
hi list,
I'm running Embperl on my ISPs webserver, and when I execute the
following code (from the sample included with Embperl):
===
$DSN = 'dbi:mysql:mlanghoff' ;
$table = 'registros' ;
use DBI ;
# connect to database
$dbh = DBI-connect($DSN, 'mlanghoff', 'ml123') or die "C
On Wed, 24 Nov 1999, Martin A. Langhoff wrote:
Wow! 41 words and not a single colon|comma|period|semicolon :)
Congrats. :-)
Is there a list of possible reasons to explain why a DBI connect to
a mysql server (apache and mysqld running on the same host) fails if
called from mod_perl
at data.cgi line 18
At data.cgi line 18 you find :
my $dbh = DBI-connect("$dsn, $dbuser")
or die "Kan inte koppla upp mig: $DBI::errstr\n";
That's just simple DBI::mysql connection.
Please HELP!!! ;^ )
Jarek
jarek wrote:
Hi!
I donno what's going on I have newly upgradet my mod_perl , I have just
succesfully installed new perl modules with CPAN eshell, and tried to
find Dynaloader.pm but with no result.
It looks like you have THE DBD::mysql installation problem. This is
documented in
On Thu, 11 Nov 1999, Rex Staples wrote:
I am trying to port a mod_perl app written to interface an oracle database to
an app interfacing a MS SQL Server database. Anyone know where I can get a SQL
Server driver manager for Solaris x86?
This isn't a mod_perl question. Try kicking whoever made
This is also not a mod_perl question.
depending on where your DBD::Oracle is installed you can get away with certain
liberties in the Oracle library department.
Nonetheless, you should continue your inquiry on a DBI related list.
Thank you,
Ed
701 - 800 of 856 matches
Mail list logo