Changeset 42455 for trunk/tools/eam/rawfix.20230221/src/queue.rawfix.sh

Timestamp:

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

Author:

eugene

Message:

enable ippc190 mysql 5.7

File:

• trunk/tools/eam/rawfix.20230221/src/queue.rawfix.sh (modified) (2 diffs)

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