<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
Not a bad idea, I'll give that a shot.<br>
<br>
Erik<br>
<br>
Paul Lindner wrote:
<blockquote cite="mid:20070823235652.GA19189@inuus.com" type="cite">
<pre wrap="">Perhaps you want to try using the MySQL DBI auto reconnect feature?
$dbh->{mysql_auto_reconnect} = 1
Or add ;auto_reconnect=1 to your DSN?
I'm not an expert, but I think that might do what you want..
On Thu, Aug 23, 2007 at 04:51:36PM -0700, Erik Osterman wrote:
</pre>
<blockquote type="cite">
<pre wrap="">Anytime our database server gets restarted or when the djabberd server
has remained idle for an extended period of time (usually when we all go
home from work), the database connection to MySQL dies.
DBD::mysql::db selectrow_array failed: MySQL server has gone away at
/usr/src/djabberd/trunk/DJabberd/../DJabberd-Authen-MySQL/lib/DJabberd/Authen/MySQL.pm
line 131.
ERROR DJabberd.Connection.ClientIn 1605 disconnected
DJabberd::Connection::ClientIn=ARRAY(0x9e03fbc) because: DBD::mysql::db
selectrow_array failed: MySQL server has gone away at
/usr/src/djabberd/trunk/DJabberd/../DJabberd-Authen-MySQL/lib/DJabberd/Authen/MySQL.pm
line 131.
Aside from removing the timeout limits in the my.cnf (which only
addresses the latter issue), is there something I can do to prevent this
from happening?
Best,
Erik
</pre>
</blockquote>
<pre wrap=""><!---->
</pre>
</blockquote>
<br>
</body>
</html>