Bug#420010: Patch

[Johann Glaser <glaser@ict.tuwien.ac.at>]

Hi!

I've resolved the problem by modifying the sources. Please find attached
the patch.

The modified version is now running for more than two weeks and the
reported problem has not reappeared.

Bye
  Hansi

--- libapache-mod-auth-mysql-4.3.9/mod_auth_mysql.c.ori	2007-04-20 10:29:27.000000000 +0200
+++ libapache-mod-auth-mysql-4.3.9/mod_auth_mysql.c	2007-04-20 10:42:13.000000000 +0200
@@ -1093,6 +1093,7 @@
 	char *dbname = auth_db_name, *user = auth_db_user, *pwd = auth_db_pwd;
 	void (*sigpipe_handler)();
 	unsigned long client_flag = 0;
+	my_bool do_reconnect = 1;
 
 	APACHELOG(APLOG_DEBUG, r, "Opening DB connection for %s", sec->dir);
 	
@@ -1161,6 +1162,10 @@
 		return errno;
 	}
 
+	/* The default is no longer to automatically reconnect on failure,
+	 * (as of 5.0.3) so we have to set that option here. */
+	mysql_options(sec->dbh, MYSQL_OPT_RECONNECT, &do_reconnect);
+
 	signal(SIGPIPE, sigpipe_handler);
 	
 	APACHELOG(APLOG_DEBUG, r, "Persistent in %s is %i", sec->dir, sec->persistent);