Package: bandersnatch
Severity: important
Tags: patch
Bandersnatch stops logging presence changes if your mysql server
wait_timeout is shorter than the longest inactivity of your jabber
users as a whole (ie. if there is no data from jabber to bandersnatch
for a duration longer than your mysql wait_timeout variable).
This occurs because mysql_auto_reconnect in DBD::mysql defaults to off.
The attached patch to the bandersnatch perl script fixes this by turning
mysql_auto_reconnect on.
-- System Information:
Debian Release: 4.0
APT prefers stable
APT policy: (500, 'stable')
Architecture: i386 (i686)
Shell: /bin/sh linked to /bin/bash
Kernel: Linux 2.6.18-4-686
Locale: LANG=, LC_CTYPE=en_CA.iso8859-1 (charmap=ISO-8859-1)
--- bandersnatch 2007-06-01 13:47:42.000000000 -0600
+++ /usr/sbin/bandersnatch 2007-06-01 13:47:35.000000000 -0600
@@ -874,6 +874,8 @@
return 0;
}
+ $dbh->{mysql_auto_reconnect} = 1;
+
$dbh->trace(2) if (($config{debug}->{level} > 0) && defined($dbh));
return 1;
}
