909fa0bac52797915a8ac240f595d0ca0bf304f1
hiram
  Thu May 23 11:10:43 2013 -0700
adding auto detection of mysql lib installs and more userApps source fetch refs #9104
diff --git src/inc/common.mk src/inc/common.mk
index 07e3127..b878ca7 100644
--- src/inc/common.mk
+++ src/inc/common.mk
@@ -39,32 +39,83 @@
     HG_DEFS+=-DUSE_SSL
 endif
 
 # autodetect where png is installed
 ifeq (${PNGLIB},)
   ifneq ($(wildcard /usr/lib64/libpng.a),)
       PNGLIB=/usr/lib64/libpng.a
   endif
 endif
 ifeq (${PNGLIB},)
   ifneq ($(wildcard /usr/lib/libpng.a),)
       PNGLIB=/usr/lib/libpng.a
   endif
 endif
 ifeq (${PNGLIB},)
+  ifneq ($(wildcard /opt/local/lib/libpng.a),)
+      PNGLIB=/opt/local/lib/libpng.a
+  endif
+endif
+ifeq (${PNGLIB},)
   PNGLIB=-lpng
 endif
+ifeq (${PNGINCL},)
+  ifneq ($(wildcard /opt/local/include/png.h),)
+      PNGINCL=-I/opt/local/include
+  endif
+endif
+
+# autodetect where libmysql is installed
+ifeq (${MYSQLINC},)
+  ifneq ($(wildcard /usr/local/mysql/include/mysql.h),)
+      MYSQLINC=/usr/local/mysql/include
+  endif
+endif
+ifeq (${MYSQLINC},)
+  ifneq ($(wildcard /usr/include/mysql/mysql.h),)
+      MYSQLINC=/usr/include/mysql
+  endif
+endif
+ifeq (${MYSQLLIBS},)
+  ifneq ($(wildcard /usr/lib64/mysql/libmysqlclient.a),)
+      MYSQLLIBS=/usr/lib64/mysql/libmysqlclient.a
+  endif
+endif
+ifeq (${MYSQLLIBS},)
+  ifneq ($(wildcard /usr/local/mysql/lib/libmysqlclient.a),)
+      MYSQLLIBS=/usr/local/mysql/lib/libmysqlclient.a
+  endif
+endif
+ifeq (${MYSQLLIBS},)
+  ifneq ($(wildcard /usr/local/mysql/lib/libmysqlclient.a),)
+      MYSQLLIBS=/usr/local/mysql/lib/libmysqlclient.a
+  endif
+endif
+ifeq (${MYSQLLIBS},)
+  ifneq ($(wildcard /usr/lib64/mysql/libmysqlclient.so),)
+      MYSQLLIBS=/usr/lib64/mysql/libmysqlclient.so
+  endif
+endif
+ifeq (${MYSQLLIBS},)
+  ifneq ($(wildcard /usr/lib/libmysqlclient.a),)
+      MYSQLLIBS=/usr/lib/libmysqlclient.a
+  endif
+endif
+# last resort, hoping the compiler can find it in standard locations
+ifeq (${MYSQLLIBS},)
+  MYSQLLIBS="-lmysqlclient"
+endif
 
 L+=${PNGLIB}
 HG_INC+=${PNGINCL}
 
 # 32-bit color enabled by default
 ifneq (${COLOR32},0)
     HG_DEFS+=-DCOLOR32
 endif
 
 # autodetect UCSC installation of samtabix:
 ifeq (${SAMTABIXDIR},)
     SAMTABIXDIR = /hive/data/outside/samtabix/${MACHTYPE}
     ifneq ($(wildcard ${SAMTABIXDIR}),)
         ifeq (${USE_SAMTABIX},)
           USE_SAMTABIX=1