be8c719942e930d2f4846f231297120d03b4826d
hiram
  Fri May 8 08:15:49 2026 -0700
fortify against cron job usage full path to hgsql command refs #31811

diff --git src/hg/makeDb/trackDb/loadTracks src/hg/makeDb/trackDb/loadTracks
index 16b52e27694..be268b54521 100755
--- src/hg/makeDb/trackDb/loadTracks
+++ src/hg/makeDb/trackDb/loadTracks
@@ -48,31 +48,31 @@
     shift
 done
 
 if [ $# -lt 3 ] ; then
     echo "wrong # args: $usage" >&2
     exit 1
 fi
 
 trackDb="$1"; shift
 hgFindSpec="$1" ; shift
 dbs="$@"
 
 # check if a database exists, print note and return non-zero if it doesn't
 dbExists() {
     local db="$1"
-    local dbChk=$(hgsql -Ne 'show databases like "'$db'"')
+    local dbChk=$(/cluster/bin/x86_64/hgsql -Ne 'show databases like "'$db'"')
     if [ -z "$dbChk" ] ; then
         echo "Note: database $db does not exist, skipping"
         return 1
     else
         return 0
     fi
 }
 
 # load trackDb for a database
 loadDbTracks() {
     local db="$1"
     local dbpath=$(ls -1 -d */$db)
     local org=$(echo $dbpath | sed -e 's/\/.*//')
     local topts='' fopts='' qopts='-check'
     if [ -f $dbpath/visibility.ra ] ; then
@@ -100,56 +100,56 @@
         topts="$topts -strict"
         fopts="$fopts -strict"
         qopts="$qopts -strict"
     fi
     if [ -n "$settings" ] ; then
         topts="$topts -settings"
     fi
     if [ -n "$raName" ] ; then
         topts="$topts -raName=$raName"
         fopts="$fopts -raName=$raName"
     fi
     if [ -n "$gbdbList" ] ; then
         topts="$topts -gbdbList=$gbdbList"
     fi
     # don't use set -x, since the autoload scripts e-mail stderr.
-    local cmd="hgTrackDb $topts $org $db $trackDb ${sqlDir}/trackDb.sql ."
+    local cmd="$HOME/bin/x86_64/hgTrackDb $topts $org $db $trackDb ${sqlDir}/trackDb.sql ."
     echo $cmd
     eval $cmd
 
     cmd="tdbQuery $qopts 'select count(*) from $db' -root=`pwd`"
     echo $cmd
     eval $cmd
 
     cmd="hgFindSpec $fopts $org $db $hgFindSpec ${sqlDir}/hgFindSpec.sql ."
     echo $cmd
     eval $cmd
     if [ -n "$noHtmlCheck" -a -f $dbpath/description.html ] ; then
 	if [ "X${UNAME_N}Y" = "XhgwdevY" ]; then
 	    if [ ! -L /gbdb/$db/html -a -d /hive/data/genomes/$db/html ]; then
 		rm -f /gbdb/$db/html/description.html
 		rmdir /gbdb/$db/html
 		ln -s /hive/data/genomes/$db/html /gbdb/$db/html
 	    fi
 	    if [ -f /gbdb/$db/html/description.html ]; then
 		rm -f /gbdb/$db/html/description.html
 	    fi
 	fi
 	if [ $dbpath/description.html -nt /gbdb/$db/html/description.html ]; then
 	    rm -f /gbdb/$db/html/description.html
 	    cp -p $dbpath/description.html /gbdb/$db/html/description.html
 	fi
     fi
     if [ -n "$grpSql" ] ; then
-        cmd="hgsql $db < $grpSql"
+        cmd="/cluster/bin/x86_64/hgsql $db < $grpSql"
         echo $cmd
         eval $cmd
     fi
 }
 
 # load for all specified databases
 for db in $dbs ; do
     if dbExists $db ; then
         loadDbTracks $db
     fi
 done