On Tue, Feb 8, 2011 at 6:26 PM, Max Pinton wrote:
> I checked $dbh->{mysql_auto_reconnect} and, as per the docs, it's 1 in a
> mod_perl script and 0 otherwise. Is there another place to look? It seems
> like something I'd really want to have on.
Recommended practice is to turn this off. If it's
On Tue, Feb 8, 2011 at 16:26, Max Pinton wrote:
> On Feb 8, 2011, at 7:36 AM, Perrin Harkins wrote:
>> That doesn't explain all of your errors though. I'm guessing that
>> you're opening a connection during startup and forking with it. You
>> need to find that. Look for things that might open a
On Feb 8, 2011, at 7:36 AM, Perrin Harkins wrote:
I'm just curious why it used to work. It seems like DBI would
reconnect a $dbh closure if it timed out.
One thing that might have changed is your database configuration.
MySQL is often configured to automatically reconnect.
I checked $dbh->{my
On Sun, Feb 6, 2011 at 4:44 PM, Max Pinton wrote:
> Did earlier versions of Perl/mod_perl/DBI/Apache::DBI handle closures
> differently?
No, not at all. This is a core Perl thing.
> I'm just curious why it used to work. It seems like DBI would
> reconnect a $dbh closure if it timed out.
One th
On Feb 6, 2011, at 8:20 AM, Perrin Harkins wrote:
Are you running the worker MPM? Apache::DBI will do the right thing
with prefork MPM, but I don't think it will work with threads.
Nope, prefork:
# apache2 -V
Server version: Apache/2.2.16 (Debian)
Server built: Nov 14 2010 18:14:55
Server's
Hi Max,
On Sat, Feb 5, 2011 at 10:01 PM, Max Pinton wrote:
> But the issue I'm asking about today is with DBI (1.612) and Apache::DBI
> (1.08). In my old configuration they worked fine, but after the upgrade I
> started seeing tons of errors like this:
>
> DBD::mysql::st execute failed: Commands
Hello mod_perlers,
I recently updated my server, which was running Debian Sarge, and
migrated from mod_perl 1 to 2, among many other upgrades. It wasn't a
smooth process, but I suppose skipping three major OS versions I
shouldn't have expected it to be.
But the issue I'm asking about toda
Am Dienstag 03 August 2004 16:16 schrieb Tom Schindl:
> Ask has already stated that he's going to include it in his next
> release, I have already filed a doc-patch at rt.cpan.org
>
Good to know, Unfortunely I have started it also, currently I have no internet
at work ;-)
diff -Nur a/DBI.pm b/D
Ask has already stated that he's going to include it in his next
release, I have already filed a doc-patch at rt.cpan.org
Tom
Stas Bekman wrote:
Boris Zentner wrote:
Hi,
Am Mittwoch 28 Juli 2004 12:20 schrieb Tom Schindl:
Boris Zentner wrote:
[...]
# bypass Apache::DBI
$dbh = DBI->connect($data
Boris Zentner wrote:
Hi,
Am Mittwoch 28 Juli 2004 12:20 schrieb Tom Schindl:
Boris Zentner wrote:
[...]
# bypass Apache::DBI
$dbh = DBI->connect($data_source, $username, $password, {
dbi_connect_method => 'connect' }) || die;
I knew there is such a parameter, but couldn't remember it. So I took a
Hi,
Am Mittwoch 28 Juli 2004 12:20 schrieb Tom Schindl:
> Boris Zentner wrote:
[...]
> > # bypass Apache::DBI
> > $dbh = DBI->connect($data_source, $username, $password, {
> > dbi_connect_method => 'connect' }) || die;
>
> I knew there is such a parameter, but couldn't remember it. So I took a
Boris Zentner wrote:
Am Mittwoch 28 Juli 2004 06:36 schrieb Chris Ochs:
We have our own application server built on mod perl and the template
toolkit. Most of the application specific sql queries all run as a single
user which is great for Apache::DBI. Every end user also has 3-4 tables
they can
We have our own application server built on mod perl and the template
toolkit. Most of the application specific sql queries all run as a single
user which is great for Apache::DBI. Every end user also has 3-4 tables
they can query (using the template toolkit DBI plugin) using their own
username,
Am Mittwoch 28 Juli 2004 06:36 schrieb Chris Ochs:
> We have our own application server built on mod perl and the template
> toolkit. Most of the application specific sql queries all run as a single
> user which is great for Apache::DBI. Every end user also has 3-4 tables
> they can query (using
We have our own application server built on mod perl and the template
toolkit. Most of the application specific sql queries all run as a single
user which is great for Apache::DBI. Every end user also has 3-4 tables
they can query (using the template toolkit DBI plugin) using their own
username,
[ Please keep it on the list... ]
On Fri, 2004-05-14 at 09:36, Alex McLintock wrote:
> sometimes at random my mod_perl/DBI/DBD::Mysql connections fail at
> the execute stage resulting in an error something like "fetch failed
> because of no execute" failure.
>
> Does this sound like the same pr
You didn't specify which Database server you're using. If it's mysql you need to be cautious of the 'ping' method used by Apache::DBI to check if a connection is stale or not. the DBD::mysql ping method always returns a 'true' string e.g. "0 but true" rather than a 1 or a 0.
I believe the latest
Thanks, Guys,
I ended up installing Apache::DBI from CPAN and it is under /home/dssweb/local-perl/lib/site_perl/5.8.3. I was mistaken that Apache::DBI would come with apache.
Event though it was, for some reason it didn't get installed.
Anyways, it is working now.
Cheers, Isarin
Perrin
On Wed, 2004-05-12 at 14:32, I S wrote:
> Sorry for being unclear. I mean Apache subdirectory
> under site_perl directory. I can seee Registry.pm
> under .../site_perl/5.8.3/sun4-solaris/Apache
> directory. (Apache::Registry) I would expect DBI in
> the same directory but it is not there.
That'
I S wrote:
Sorry for being unclear. I mean Apache subdirectory
under site_perl directory. I can seee Registry.pm
under .../site_perl/5.8.3/sun4-solaris/Apache
directory. (Apache::Registry) I would expect DBI in
the same directory but it is not there. I figured
that out after it gave me an erro
> Apache::DBI comes with mod_perl, and you should see
> it in your site_perl directory. It is a pure perl
> module, so it would not be under an i386
> directory (or whatever your architecture is). If
> you can do PerlModule Apache::DBI in your program
> without failure, it means that it is ther
On Wed, 2004-05-12 at 12:15, I S wrote:
> a) I don't understand why the database sometimes gets
> dropped. It happens randomly but frequently.
>
> could not prepare: Database disconnected at
> /dssweb/httpd/cgi-bin/feeds/viewReport line 157.
Usually this is caused by an inactivity timeout on you
I S wrote:
Hi all,
I have some questions with DBI.
a) I don't understand why the database sometimes gets
dropped. It happens randomly but frequently.
could not prepare: Database disconnected at
/dssweb/httpd/cgi-bin/feeds/viewReport line 157.
b) I built mod_perl and apache with EVERYTHING=1.
Hi all,
I have some questions with DBI.
a) I don't understand why the database sometimes gets
dropped. It happens randomly but frequently.
could not prepare: Database disconnected at
/dssweb/httpd/cgi-bin/feeds/viewReport line 157.
b) I built mod_perl and apache with EVERYTHING=1.
Should I
24 matches
Mail list logo
