Index: /trunk/tools/eam/rawfix.20230221/Makefile
===================================================================
--- /trunk/tools/eam/rawfix.20230221/Makefile	(revision 42454)
+++ /trunk/tools/eam/rawfix.20230221/Makefile	(revision 42455)
@@ -18,6 +18,5 @@
 check.rawfix.sh \
 queue.rawfix.sh \
-update.rawfix.sh \
-create.rawfix.sh
+update.rawfix.sh
 
 # these are in order used by the tasks
@@ -43,4 +42,5 @@
 triple.fix.pl \
 fix_chip_failures.pl \
+create.rawfix.sh
 
 PROGRAMS = $(PANTASKS) $(DB_PROG) $(PERL_PROG) $(TOOLS)
Index: /trunk/tools/eam/rawfix.20230221/src/check.rawfix.sh
===================================================================
--- /trunk/tools/eam/rawfix.20230221/src/check.rawfix.sh	(revision 42454)
+++ /trunk/tools/eam/rawfix.20230221/src/check.rawfix.sh	(revision 42455)
@@ -16,9 +16,9 @@
 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
Index: /trunk/tools/eam/rawfix.20230221/src/create.rawfix.sh
===================================================================
--- /trunk/tools/eam/rawfix.20230221/src/create.rawfix.sh	(revision 42454)
+++ /trunk/tools/eam/rawfix.20230221/src/create.rawfix.sh	(revision 42455)
@@ -1,3 +1,6 @@
 #!/bin/csh
+
+echo "do not use without caution"
+exit 2
 
 # make the rawfix database to track rawfix operations
Index: /trunk/tools/eam/rawfix.20230221/src/queue.rawfix.sh
===================================================================
--- /trunk/tools/eam/rawfix.20230221/src/queue.rawfix.sh	(revision 42454)
+++ /trunk/tools/eam/rawfix.20230221/src/queue.rawfix.sh	(revision 42455)
@@ -12,6 +12,8 @@
 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,5 +51,5 @@
   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
Index: /trunk/tools/eam/rawfix.20230221/src/rawfix.pt
===================================================================
--- /trunk/tools/eam/rawfix.20230221/src/rawfix.pt	(revision 42454)
+++ /trunk/tools/eam/rawfix.20230221/src/rawfix.pt	(revision 42455)
@@ -1,43 +1,3 @@
 ## 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 #################################
Index: /trunk/tools/eam/rawfix.20230221/src/update.rawfix.sh
===================================================================
--- /trunk/tools/eam/rawfix.20230221/src/update.rawfix.sh	(revision 42454)
+++ /trunk/tools/eam/rawfix.20230221/src/update.rawfix.sh	(revision 42455)
@@ -18,8 +18,9 @@
 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')"