b83a712841b95fd10067370018adeef01c0d0cf3
galt
  Wed Sep 11 17:54:04 2013 -0700
Fixing a problem with Ubuntu and other systems where load data LOCAL infile has been disabled by default for mysql clients
diff --git src/hg/lib/jksql.c src/hg/lib/jksql.c
index 4882946..60be68c 100644
--- src/hg/lib/jksql.c
+++ src/hg/lib/jksql.c
@@ -724,30 +724,32 @@
 MYSQL *conn;
 long deltaTime;
 
 sqlInitTracking();
 
 AllocVar(sc);
 sc->resultList = newDlList();
 sc->node = dlAddValTail(sqlOpenConnections, sc);
 
 monitorEnter();
 if ((sc->conn = conn = mysql_init(NULL)) == NULL)
     {
     monitorLeave();
     errAbort("Couldn't connect to mySQL.");
     }
+// Fix problem where client LOCAL setting is disabled by default for security
+mysql_options(conn, MYSQL_OPT_LOCAL_INFILE, NULL);
 if (mysql_real_connect(
 	conn,
 	host, /* host */
 	user,	/* user name */
 	password,	/* password */
 	database, /* database */
 	port,	/* port */
 	socket,	/* socket */
 	0)	/* flags */  == NULL)
     {
     monitorLeave();
     if (abort)
 	errAbort("Couldn't connect to database %s on %s as %s.\n%s",
 	    database, host, user, mysql_error(conn));
     else if (sqlParanoid)