From 938b5f98bf867c70b822d0f047fae10f668eace1 Mon Sep 17 00:00:00 2001
From: Eric Bollengier <eric@eb.homelinux.org>
Date: Sun, 20 Jul 2008 11:53:40 +0000
Subject: [PATCH] ebl  fix #1034 by setting big timeout on mysql connections

git-svn-id: https://bacula.svn.sourceforge.net/svnroot/bacula/branches/Branch-2.4@7403 91ce42f0-d328-0410-95d8-f526ca767f89
---
 bacula/patches/2.4.1-mysql-timeout.patch | 27 ++++++++++++++++++++++++
 bacula/technotes-2.4                     |  2 ++
 2 files changed, 29 insertions(+)
 create mode 100644 bacula/patches/2.4.1-mysql-timeout.patch

diff --git a/bacula/patches/2.4.1-mysql-timeout.patch b/bacula/patches/2.4.1-mysql-timeout.patch
new file mode 100644
index 0000000000..2885e462d9
--- /dev/null
+++ b/bacula/patches/2.4.1-mysql-timeout.patch
@@ -0,0 +1,27 @@
+ This patch fixes #1034 by setting big timeout on mysql connections
+
+ Apply this patch to version 2.4.1 with:
+
+ cd <bacula-source>
+ patch -p0 < patches/2.4.1-mysql-timeout.patch
+ ./configure <your-options>
+ make
+ ...
+ make install
+
+
+Index: src/cats/mysql.c
+===================================================================
+--- src/cats/mysql.c    (révision 7401)
++++ src/cats/mysql.c    (copie de travail)
+@@ -205,6 +205,10 @@
+    Dmsg3(100, "opendb ref=%d connected=%d db=%p\n", mdb->ref_count,
+          mdb->connected, mdb->db);
+
++   /* Set connection timeout to 8 days specialy for batch mode */
++   sql_query(mdb, "SET wait_timeout=691200");
++   sql_query(mdb, "SET interactive_timeout=691200");
++
+    V(mutex);
+    return 1;
+ }
diff --git a/bacula/technotes-2.4 b/bacula/technotes-2.4
index 5349e6763f..e8ced7c756 100644
--- a/bacula/technotes-2.4
+++ b/bacula/technotes-2.4
@@ -1,6 +1,8 @@
               Technical notes on version 2.4
 
 General:
+20Jul08
+ebl  fix #1034 by setting big timeout on mysql connections
 19Jul08
 kes  Do partial integration of the Win32 bat build created by Eric.
 kes  Fix bat not to block.
-- 
2.39.5