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 <[EMAIL PROTECTED]> 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/
