DJabberd does not handle "MySQL server has gone away at"

[Paul Lindner]

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:
> 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

-- 
Paul Lindner        ||||| | | | |  |  |  |   |   |
lindner at inuus.com
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 189 bytes
Desc: not available
Url : http://lists.danga.com/pipermail/djabberd/attachments/20070823/9cd04ad6/attachment.pgp