Enable automatic reconnection in mysql

* src/sql.c (sql_init_dictionary): Enable automatic reconnection
(sql_open): Call mysql_ping

1 files changed, 7 insertions, 1 deletions

diff --git a/src/sql.c b/src/sql.c
index 65cc5df..ff8d3c6 100644
--- a/src/sql.c
+++ b/src/sql.c
@@ -67,6 +67,8 @@ sql_init_dictionary(struct dictionary *dict)
     }
 
     if (conn->initcount++ == 0) {
+	my_bool reconnect = 1;
+	
 	mysql_init(&conn->mysql);
 
 	if (conn->config_file)
@@ -76,6 +78,8 @@ sql_init_dictionary(struct dictionary *dict)
 	    mysql_options(&conn->mysql, MYSQL_READ_DEFAULT_GROUP,
 			  conn->config_group);
 
+	mysql_options(&conn->mysql, MYSQL_OPT_RECONNECT, &reconnect);
+	
 	if (conn->cacert)
 	    mysql_ssl_set(&conn->mysql, NULL, NULL, conn->cacert,
 			  NULL, NULL);
@@ -97,7 +101,9 @@ sql_init_dictionary(struct dictionary *dict)
 void *
 sql_open(struct dictionary *dict)
 {
-    return dict->storage;
+    struct sqlconn *conn = dict->storage;
+    mysql_ping(&conn->mysql);    
+    return conn;
 }
 
 int