Bug#491691: gnugk: mysql connection loss

[misi]

Package: gnugk
Version: 2:2.2.6-7
Severity: normal

This patch solved my problem.
I had been detecting database connection loss without this patch.
This is piece of log file where You can see the error. 
This is the error message without the patch
(This ocours after a day or so, until that time, everything is working fine.)


2008/07/06 09:52:06.078 1             RasSrv.cxx(368)   RAS     RRQ
Received
2008/07/06 09:52:06.079 2            sqlauth.cxx(237)   SQLAUTH
SQLAliasAuth('00361002460'): query failed (1) - MySQL server has gone
away
2008/07/06 09:52:06.079 4             gkauth.cxx(1503)  GKAUTH
SQLAliasAuth
auth condition not found for alias '00361002460'
2008/07/06 09:52:06.079 2            sqlauth.cxx(237)   SQLAUTH
SQLAliasAuth('BKF_HD00361002460'): query failed (1) - MySQL server has
gone
away
2008/07/06 09:52:06.079 4             gkauth.cxx(1503)  GKAUTH
SQLAliasAuth
auth condition not found for alias 'BKF_HD00361002460'
2008/07/06 09:52:06.079 2            sqlauth.cxx(237)   SQLAUTH
SQLAliasAuth('default'): query failed (1) - MySQL server has gone away
2008/07/06 09:52:06.079 4             gkauth.cxx(1503)  GKAUTH
SQLAliasAuth
auth condition not found for alias 'default'
2008/07/06 09:52:06.079 4             gkauth.cxx(1503)  GKAUTH
AliasAuth
auth condition not found for alias '00361002460'
2008/07/06 09:52:06.079 4             gkauth.cxx(1503)  GKAUTH
AliasAuth
auth condition not found for alias 'BKF_HD00361002460'
2008/07/06 09:52:06.079 4             gkauth.cxx(1503)  GKAUTH
AliasAuth
auth condition not found for alias 'default'
2008/07/06 09:52:06.079 3             gkauth.cxx(927)   GKAUTH
AliasAuth
RRQ check failed
2008/07/06 09:52:06.080 2             RasSrv.cxx(413)
RRJ|193.224.67.1|00361002460:dialedDigits=BKF_HD00361002460:h323_ID|terminal|securityDenial;
2008/07/06 09:52:06.080 3             RasSrv.cxx(250)   RAS     Send to
193.224.67.1:1719
registrationReject {
    requestSeqNum = 52495
    protocolIdentifier = 0.0.8.2250.0.5
    rejectReason = securityDenial <<null>>
    gatekeeperIdentifier =  7 characters {
      004e 0049 0049 0046 002d 0047 004b        NIIF-GK
    }
  }


The key is MySQL server is gone(so this line): 

2008/07/06 09:52:06.079 2            sqlauth.cxx(237)   SQLAUTH
SQLAliasAuth('00361002460'): query failed (1) - MySQL server 
has gone away


The patch:
misi at hal:/tmp$ cat gksql_mysql.cxx.diff 
--- gnugk-2.2.6.orig/gksql_mysql.cxx
+++ gnugk-2.2.6/gksql_mysql.cxx
@@ -480,6 +480,11 @@
 	}
 	mysql_options(conn, MYSQL_OPT_CONNECT_TIMEOUT, (const
char*)&CONNECT_TIMEOUT);
 
+#if (MYSQL_VERSION_ID >= 50013)
+	my_bool reconnect = 1;	// enable auto-reconnect, older versions
have it on by default
+	mysql_options(conn, MYSQL_OPT_RECONNECT, &reconnect);
+#endif
+
 	// connect to the MySQL database, try each host on the list in
 	// case of failure
 	if (mysql_real_connect(conn, m_host, m_username, 
 			m_password.IsEmpty() ? (const char*)NULL :
(const char*)m_password,



-- System Information:
Debian Release: lenny/sid
  APT prefers testing
  APT policy: (500, 'testing')
Architecture: i386 (i686)

Kernel: Linux 2.6.25-2-686 (SMP w/2 CPU cores)
Locale: LANG=hu_HU.UTF-8, LC_CTYPE=hu_HU.UTF-8 (charmap=ISO-8859-2) (ignored: LC_ALL set to hu_HU)
Shell: /bin/sh linked to /bin/bash

Versions of packages gnugk depends on:
ii  adduser              3.108               add and remove users and groups
ii  libc6                2.7-10              GNU C Library: Shared libraries
ii  libexpat1            2.0.1-4             XML parsing C library - runtime li
ii  libfbclient2         2.0.4.13130-1.ds1-3 Firebird client library
ii  libgcc1              1:4.3.1-2           GCC support library
ii  libldap-2.4-2        2.4.10-2+lenny1     OpenLDAP libraries
ii  libmysqlclient15off  5.0.51a-9+lenny2    MySQL database client library
ii  libopenh323-1.19.1-d 1.19.1~dfsg-3+b1    H.323 aka VoIP library
ii  libpq5               8.3.3-1             PostgreSQL C client library
ii  libpt-1.11.2         1.11.2-2            Portable Windows Library
ii  libsasl2-2           2.1.22.dfsg1-21     Cyrus SASL - authentication abstra
ii  libsdl1.2debian      1.2.13-2            Simple DirectMedia Layer
ii  libssl0.9.8          0.9.8g-10.1         SSL shared libraries
ii  libstdc++6           4.3.1-2             The GNU Standard C++ Library v3
ii  zlib1g               1:1.2.3.3.dfsg-12   compression library - runtime

gnugk recommends no packages.

-- no debconf information