Changeset 42455

Timestamp:

Apr 21, 2023, 4:39:59 PM (3 years ago)

Author:

eugene

Message:

enable ippc190 mysql 5.7

Location:

trunk/tools/eam/rawfix.20230221

Files:

• Makefile (modified) (2 diffs)
• src/check.rawfix.sh (modified) (1 diff)
• src/create.rawfix.sh (modified) (1 diff)
• src/queue.rawfix.sh (modified) (2 diffs)
• src/rawfix.pt (modified) (1 diff)
• src/update.rawfix.sh (modified) (1 diff)

trunk/tools/eam/rawfix.20230221/Makefile

@@ -18 +18 @@
 check.rawfix.sh \
 queue.rawfix.sh \
-update.rawfix.sh \
-create.rawfix.sh
+update.rawfix.sh
 
 # these are in order used by the tasks
@@ -43 +42 @@
 triple.fix.pl \
 fix_chip_failures.pl \
+create.rawfix.sh
 
 PROGRAMS = $(PANTASKS) $(DB_PROG) $(PERL_PROG) $(TOOLS)

trunk/tools/eam/rawfix.20230221/src/check.rawfix.sh

@@ -16 +16 @@
 set DBHOST = "ippc190"
 set DBNAME = "rawfix"
-set DBUSER = "dvo"
-set DBPASS = "dvo"
+# set DBUSER = "dvo"
+# set DBPASS = "dvo"
 
 # set DBOPTS = "-B --skip-column-names -h $DBHOST -u $DBUSER -p$DBPASS $DBNAME"
-set DBOPTS = "-B -h $DBHOST -u $DBUSER -p$DBPASS $DBNAME"
+set DBOPTS = "--defaults-extra-file=~/.my.cnf.rawfix -B -h $DBHOST $DBNAME"
 
 if ($mode == "all") then

trunk/tools/eam/rawfix.20230221/src/create.rawfix.sh

@@ -1 +1 @@
 #!/bin/csh
+
+echo "do not use without caution"
+exit 2
 
 # make the rawfix database to track rawfix operations

trunk/tools/eam/rawfix.20230221/src/queue.rawfix.sh

@@ -12 +12 @@
 set DBHOST = "ippc190"
 set DBNAME = "rawfix"
-set DBUSER = "dvo"
-set DBPASS = "dvo"
+# set DBUSER = "dvo"
+# set DBPASS = "dvo"
+
+set DBOPTS = "--defaults-extra-file=~/.my.cnf.rawfix -h $DBHOST $DBNAME"
 
 if ($mode == "list") then
@@ -49 +51 @@
   endif
 
-  mysql -h $DBHOST -u $DBUSER -p$DBPASS $DBNAME -e "insert into nights (dateobs, state) values ('$mynight', 'new')"
+  mysql $DBOPTS -e "insert into nights (dateobs, state) values ('$mynight', 'new')"
   exit 0
 endif

trunk/tools/eam/rawfix.20230221/src/rawfix.pt

@@ -1 +1 @@
 ## pantasks scripts to manage the raw exposure data repair / cleanup
-
-$TPOLL = 5
-$TEXEC = 5
-$RPOLL = 5
-$REXEC = 5
-$VERBOSE = 1
-$NETWORK = 1
-
-# use this to find the files in this local directory
-# $mypath = /home/panstarrs/eugene/rawfix.20230221
-
-# NOTE: use a directory located on a b-node so the results can
-# be seen by both ATRC and ITC machines
-$mypath = /data/ippb07.0/home/eugene/rawfix.20230221
-
-# I need to avoid ATRC machines for jobs which try to access Nebulous or GPC
-# I cannot define an avoidance list for a job, so I need to specify the 
-# required host
-
-# run check_chip_locations.pl on this machine:
-$HOST_CKCHIP  = ippc180
-
-if (not($?LOGDIR)) 
-  $LOGDIR = $mypath/pantasks_logs
-  mkdir $LOGDIR
-end
-
-# these are listed in stage order, but the 
-# order is this file is not determinative, only the
-# change of state from STAGE1.new -> STAGE1.done -> STAGE2.new
-input rawfix.advance.pt
-input rawfix.ckchip.pt
-input rawfix.fixchip.pt
-input rawfix.md5sum.pt
-input rawfix.md5chk.pt
-
-if (not($?INIT_RAWFIX)) 
-  control host add $HOST_CKCHIP
-  $INIT_RAWFIX = 1
-end
 
 ######################### UTILITIES #################################

trunk/tools/eam/rawfix.20230221/src/update.rawfix.sh

@@ -18 +18 @@
 set DBHOST = "ippc190"
 set DBNAME = "rawfix"
-set DBUSER = "dvo"
-set DBPASS = "dvo"
+# set DBUSER = "dvo"
+# set DBPASS = "dvo"
 
-set DBOPTS = "-B --skip-column-names -h $DBHOST -u $DBUSER -p$DBPASS $DBNAME"
+# set DBOPTS = "-B --skip-column-names -h $DBHOST -u $DBUSER -p$DBPASS $DBNAME"
+set DBOPTS = "--defaults-extra-file=~/.my.cnf.rawfix -B --skip-column-names -h $DBHOST $DBNAME"
 
 mysql $DBOPTS -e "update nights set state = '$state' $iter where (dateobs = '$mynight')"