55ed63b493027583cbd68e954b9ced58d608fba8 hiram Fri May 8 10:15:15 2026 -0700 fortify against cron job usage full path to kent commands refs #31811 diff --git src/hg/makeDb/trackDb/makeMetaDb src/hg/makeDb/trackDb/makeMetaDb index dba391e6fed..bbade021610 100755 --- src/hg/makeDb/trackDb/makeMetaDb +++ src/hg/makeDb/trackDb/makeMetaDb @@ -1,53 +1,53 @@ #!/bin/bash -e usage='makeMetaDb db metaDb file [file ..]' UNAME_N=`uname -n` UNAME_N=${UNAME_N/.soe.ucsc.edu/} if [ $# -lt 3 ] ; then echo "wrong # args: $usage" >&2 exit 1 fi db="$1"; shift metaDb="$1"; shift files="$@" # 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 metaDb for a database loadMetaDb() { local db="$1" local metaDb="$2" local tmpTable=$metaDb"_tmp"; local bakTable=$metaDb"_back"; - local cmd="hgsql -e \"drop table if exists $tmpTable;\" $db" + local cmd="/cluster/bin/x86_64/hgsql -e \"drop table if exists $tmpTable;\" $db" echo $cmd eval $cmd - local cmd="rm -f allRas; touch allRas; cat $files >> allRas; mdbUpdate -recreate $db -table=$tmpTable allRas" + local cmd="rm -f allRas; touch allRas; cat $files >> allRas; /cluster/bin/x86_64/mdbUpdate -recreate $db -table=$tmpTable allRas" echo $cmd eval $cmd local cmd="rm allRas" echo $cmd eval $cmd - local cmd="hgsqlSwapTables -okNoTable2 -dropTable3 $db $tmpTable $metaDb $bakTable" + local cmd="/cluster/bin/x86_64/hgsqlSwapTables -okNoTable2 -dropTable3 $db $tmpTable $metaDb $bakTable" echo $cmd eval $cmd } loadMetaDb $db $metaDb $files