RE: RE: MSQL server has gone away ( Apache::AuthDBI.pm )

[Artero Alain <ar...@ebu.ch>]

Hi,

Could you send me your script so that I can try to write my own workaround.
Is your script integrated within Apache::AuthDBI.pm ?


Thanks
Alain



-----Original Message-----
From: emarkert@netscape.net [mailto:emarkert@netscape.net]
Sent: mercredi, 31. janvier 2001 16:23
To: modperl@apache.org
Subject: Re: RE: MSQL server has gone away ( Apache::AuthDBI.pm )


I ran into a similar problem while using MySQL and Apache::AuthDBI.

I had a remote MySQL server that my apache web server connected to and used
for authentication.  Every so often (no pattern to this) the connection to
MySQL would drop but MySQL would still be functioning properly.  

The only way I was able to detect whether the connection to MySQL was viable
was to write my own script that would attempt to reconnect to MySQL and
attempt to execute an actual query.  Pinging from MySQL => Apache wouldn't
work.

BTW, the symptom that would present itself when the connection dropped was
that apache would max out and NO URL requests would be processed.

Artero Alain <ar...@ebu.ch> wrote:
>
> 
> Is there someone using the combination DBI, AuthDBI and  mSQL ?
> 
> I am wondering whether the "ping method" for msql in DBD::Msql exists
> already.
> 
> 
> PS:Thanks for your answer Daniel.
> 
> Alain


--
===========================================================================
"If you put three drops of poison into a 100 percent pure Java, you get -
Windows. If you put a few drops of Java into Windows, you still have
Windows."
    -- Sun Microsystems CEO, Scott McNealy

__________________________________________________________________
Get your own FREE, personal Netscape Webmail account today at
http://webmail.netscape.com/