+ | 0 | 3PI | PS1 3PI Survey |
+ | 1 | MD01 | PS1 MD01 XMM-LSS-DXS 022224-043000 |
+ | 2 | MD02 | PS1 MD02 CDFS/GOODS/GEMS 033224-274800 |
+ | 3 | MD03 | PS1 MD03 IFA/Lynx 084300+444000 |
+ | 4 | MD04 | PS1 MD04 COSMOS 100000+021200 |
+ | 5 | MD05 | PS1 MD05 Lockman-DXS 110000+570000 |
+ | 6 | MD06 | PS1 MD06 NGC 4258 121857+471814 |
+ | 7 | MD07 | PS1 MD07 VISTA-Video1 140000+050000 |
+ | 8 | MD08 | PS1 MD08 EliasN1-DXS 160000+570000 |
+ | 9 | MD09 | PS1 MD09 Vimos4-DXS-SSA 220000+003000 |
+ | 10 | MD10 | PS1 MD10 Deep2 233000+000000 |
+ | 11 | M31 | PS1 M31 Andromeda 004242+411600 |
+ | 12 | STS1 | PS1 STS1 Outskirts of Bulge 195048+170339 |
+ | 26 | STS2 | PS1 STS2 Hyades 004000+150000 |
+ | 27 | STS3 | PS1 STS3 Praesepe 083000+200000 |
+ | 13 | CAL01 | PS1 Cal North Pole 000000+900000 |
+ | 14 | CAL02 | PS1 Cal SA92 Dense Landolt Std Field 005808+004232 |
+ | 15 | CAL03 | PS1 Cal Perseus Cluster / Abell 426 031900+413300 |
+ | 16 | CAL04 | PS1 Cal SA95 Dense Landolt Std Field 065207+001710 |
+ | 17 | CAL05 | PS1 Cal Taurus dark cloud (diverse extinction) 043000+250000 |
+ | 18 | CAL06 | PS1 Cal SA98 Densle Landolt Std Field 065207+001710 |
+ | 19 | CAL07 | PS1 Cal M81-M82-HolmIX (Local Group) 095640+692200 |
+ | 20 | CAL08 | PS1 Cal Virgo Cluster (Center) 123000+130000 |
+ | 21 | CAL09 | PS1 Cal Hercules Cluster (Center) 160508+1745+28 |
+ | 22 | CAL10 | PS1 Cal M17-M24 Region 181400+000544 |
+ | 23 | CAL11 | PS1 Cal SA110 Dense Landolt Std Field 184207+000544 |
+ | 24 | CAL12 | PS1 Cal Kepler Mission Astrometric field 192240+443000 |
+ | 25 | CAL13 | PS1 Cal 3C454.1 (Northern field) 225033+712919 |
+ | 28 | SSS | PS1 Solar System Sweet Spot Survey |
+
+ ![\"master](\"masterMask.png\")
\n";
opendir(DIR, $self->{path}) or die $!;
Index: /branches/eam_branches/ipp-20110404/tools/czartool/Nebulous.pm
===================================================================
--- /branches/eam_branches/ipp-20110404/tools/czartool/Nebulous.pm (revision 31438)
+++ /branches/eam_branches/ipp-20110404/tools/czartool/Nebulous.pm (revision 31439)
@@ -110,5 +110,6 @@
next;
}
- elsif ($line =~ m/(ipp[0-9]+)\s.+[0-9]+\s+([0-9]+)\s+([0-9]+)\s+([0-9]+)%.*/i) {
+ elsif (($line =~ m/(ipp[0-9]+)\s.+[0-9]+\s+([0-9]+)\s+([0-9]+)\s+([0-9]+)%.*/i)||
+ ($line =~ m/(ippb[0-9]+)\s.+[0-9]+\s+([0-9]+)\s+([0-9]+)\s+([0-9]+)%.*/i)) {
$self->{_totalHosts}++;
Index: /branches/eam_branches/ipp-20110404/tools/mysql-dump/README
===================================================================
--- /branches/eam_branches/ipp-20110404/tools/mysql-dump/README (revision 31439)
+++ /branches/eam_branches/ipp-20110404/tools/mysql-dump/README (revision 31439)
@@ -0,0 +1,16 @@
+See ~ipp/mysql-dump on the production and the Manoa cluster
+
+Various utilities for mySQL dumps.
+
+Documentation at:
+http://svn.pan-starrs.ifa.hawaii.edu/trac/ipp/wiki/DatabaseBackups
+
+and in each script:
+ * functions.sh: various utilities
+ * gpc1Import.py: "import" the last gpc1 dump into gpc1_0/gpc1_1
+ * gpc1_dump.sh: dumps and copies gpc1 from a server hosting gpc1
+ * gpc1_install.sh: checks, installs, distributes the gpc1 dumps
+ * neb_copy.sh: copies and checks the last nebulous dump
+ * neb_dump.sh: dumps nebulous
+ * ops_dump.csh: dumps (and distributes when necessary) the ippadmin,
+ isp, and ipprequestServer databases.
Index: /branches/eam_branches/ipp-20110404/tools/mysql-dump/functions.sh
===================================================================
--- /branches/eam_branches/ipp-20110404/tools/mysql-dump/functions.sh (revision 31439)
+++ /branches/eam_branches/ipp-20110404/tools/mysql-dump/functions.sh (revision 31439)
@@ -0,0 +1,39 @@
+#!/bin/bash
+
+# Some useful functions that can be reused in sh scripts
+
+# log: A limited logging function
+#
+# Usage: log ARG1 ARG2
+# where ARG1: a log level (put what is sensible for you)
+# ARG2: a message (preferrably enclosed in quotes)
+# The date is prepended to the log level and message
+# e.g.:
+# log USELESS "A useless message"
+# will show something like:
+# 2011-04-01T08:00:00: USELESS: A useless message
+function log() {
+ LOGLEVEL=`printf ":%8s:" $1`
+ shift
+ MESSAGE=$@
+ DATE=`date +"%FT%T"`
+ echo "$DATE$LOGLEVEL $MESSAGE"
+}
+
+# email: Send an e-mail
+#
+# Usage: email SUBJECT RECIPIENT MESSAGE
+# where SUBJECT: the e-mail subject
+# RECIPIENT: a valid e-mail address
+# MESSAGE: a message
+# e.g.:
+# email "Monday?" mailing-list@dictators.org "Let's conquer the world"
+function email() {
+ SUBJECT=$1
+ shift
+ RECIPIENT=$1
+ shift
+ MESSAGE=$@
+ echo "$MESSAGE" | /bin/mail -s "$SUBJECT" $RECIPIENT
+}
+
Index: /branches/eam_branches/ipp-20110404/tools/mysql-dump/gpc1Import.py
===================================================================
--- /branches/eam_branches/ipp-20110404/tools/mysql-dump/gpc1Import.py (revision 31439)
+++ /branches/eam_branches/ipp-20110404/tools/mysql-dump/gpc1Import.py (revision 31439)
@@ -0,0 +1,24 @@
+#!/usr/bin/python
+
+import commands
+filename='/netdisks/panstarrs/ipp/mysql-dump/.curr_gpc1_name'
+f=open(filename, 'r+')
+currname=f.read()
+f.close()
+
+if(currname=='gpc1_0'):
+ newname='gpc1_1'
+else:
+ newname='gpc1_0'
+
+print newname
+gpc1dumps=commands.getoutput('ls -t -1 /export/ipp001.0/ipp/mysql-dumps/mysql-gpc1*')
+dumparray=gpc1dumps.split()[1]
+cmd='bunzip2 < '+dumparray+' | mysql -hipp001 -u ipp -pipp -f ' + newname
+results = commands.getstatusoutput(cmd)
+
+f=open(filename, 'w')
+f.write(newname)
+f.close()
+
+print results
Index: /branches/eam_branches/ipp-20110404/tools/mysql-dump/gpc1_dump.sh
===================================================================
--- /branches/eam_branches/ipp-20110404/tools/mysql-dump/gpc1_dump.sh (revision 31439)
+++ /branches/eam_branches/ipp-20110404/tools/mysql-dump/gpc1_dump.sh (revision 31439)
@@ -0,0 +1,64 @@
+#!/bin/bash
+
+# This script is based on ops_dump.csh. It was originally run on ipp001. I changed it a bit
+#
+# Now it is supposed to be run on $HOST where a MySQL server hosts the gpc1 database (it can
+# the master or one of its slaves). It performs the following tasks:
+# 1) It tidies up the local directory used for MySQL dumps, namely:
+# - it deletes the old MySQL dumps
+# - it deletes the old MD5 checksum file
+# 2) It calls mysqldump to dump gpc1 to some bzipped file
+# 3) It computes the checksum
+# 4) It copies the dump and the checksum files onto the TARGET_HOST
+
+# Load utilities functions
+. /home/panstarrs/ipp/mysql-dump/functions.sh
+. /home/panstarrs/ipp/mysql-dump/password.sh
+
+EMAILTO=ps-ipp-ops@ifa.hawaii.edu
+
+HOST=ippc02
+TARGET_HOST=ipp0012
+TARGET_DIR=/export/ipp001.0/ipp/mysql-dumps/
+
+log INFO "Starting gpc1 backup"
+
+DUMP_PATH=/export/$HOST.0/mysql-dumps #path
+
+#1) Cleaning
+log INFO "Deleting old dumps"
+for file in `find $DUMP_PATH -name mysql-gpc1-$HOST-\*.dump.bz`; do
+ log INFO "Deleting $file"
+ /bin/rm -f $file
+done
+log INFO "Deleting old md5 sum file"
+/bin/rm -f $MD5FILENAME
+
+#2) Dumping
+DATEVAR=`date +%FT%T` #date
+FILENAME=$DUMP_PATH/mysql-gpc1-$HOST-$DATEVAR.dump.bz #dump file name
+DB_USERNAME=gpc1_dump
+MD5FILENAME=$DUMP_PATH/gpc1_checksum.md5
+log INFO "Dumping to $FILENAME"
+/usr/bin/mysqldump -h localhost -u $DB_USERNAME -p$DB_PASSWORD --flush-logs --single-transaction gpc1 | ~ipp/local/bin/pbzip2 > $FILENAME
+dump_status=${PIPESTATUS[0]}
+if [ "$dump_status" -ne "0" ]; then
+ log ERROR "Sending warning e-mail"
+ email "Gpc1 dump failed" $EMAILTO "Check log file: /export/$HOST.0/mysql-dumps/gpc1_dump.log"
+ log INFO "End of gpc1 dump (Error)"
+ exit 1
+fi
+
+#3) Checksum
+log INFO "Generating MD5 checksum"
+/usr/bin/md5sum $FILENAME > $MD5FILENAME
+log INFO "End of gpc1 dump (Success)"
+
+#4) Copy onto TARGET_HOST
+log INFO "Copying $FILENAME on $TARGET_HOST"
+sudo -u ipp /usr/bin/scp -q $FILENAME ipp@$TARGET_HOST:$TARGET_DIR
+log INFO "Copying MD5 checksum file to $TARGET_HOST"
+sudo -u ipp /usr/bin/scp -q $MD5FILENAME ipp@$TARGET_HOST:$TARGET_DIR
+
+log INFO "End of gpc1 backup (Success)"
+
Index: /branches/eam_branches/ipp-20110404/tools/mysql-dump/gpc1_install.sh
===================================================================
--- /branches/eam_branches/ipp-20110404/tools/mysql-dump/gpc1_install.sh (revision 31439)
+++ /branches/eam_branches/ipp-20110404/tools/mysql-dump/gpc1_install.sh (revision 31439)
@@ -0,0 +1,76 @@
+#!/bin/bash
+
+# This script is supposed to be executed on ipp001 (HOST)
+#
+# It checks, 'installs', and 'distributes' the last gpc1 MySQL dump.
+# The main steps are the following:
+# 1) Check if a checksum file is available
+# - if it is not, the script sleeps $SLEEPING_TIME seconds, and
+# iterates up to $MAX_ITERATIONS times.
+# 2) Check the gpc1 dump file against its checksum.
+# 3) Distribute the validated files, that is:
+# - Hard-links the bzipped MySQL dump in the distribution directory
+# - Moves the MD5 checksum to the distribution directory
+# 4) Import gpc1 into gpc1_0 or gpc1_1 (ensured by gpc1Import.py utility)
+. /home/panstarrs/ipp/mysql-dump/functions.sh
+
+EMAILTO=ps-ipp-ops@ifa.hawaii.edu
+
+HOST=ipp001
+TARGET=/export/$HOST.0/ipp/mysql-dumps
+MD5FILE=gpc1_checksum.md5
+
+DISTRIBUTION_TARGET=$TARGET/distribution/ippdb01-gpc1.dump.bz
+DISTRIBUTION_MD5=$TARGET/distribution/ippdb01-gpc1.md5
+
+MAX_ITERATIONS=200
+SLEEPING_TIME=60
+
+log INFO "Starting installation of gpc1"
+
+ITERATION=1
+MD5_STATUS=1
+while [ "$MD5_STATUS" -ne "0" ]; do
+ if [ ! -s $TARGET/$MD5FILE ]; then
+ log WARNING "MD5 file not found [$TARGET/$MD5FILE]. Waiting $SLEEPING_TIME seconds (Attempt: $ITERATION out of $MAX_ITERATIONS)"
+ sleep $SLEEPING_TIME
+ let ITERATION=ITERATION+1
+ if [ "$ITERATION" -ge "$MAX_ITERATIONS" ]; then
+ log ERROR "Copy of $TARGET/$MD5FILE failed after $ITERATION iterations. Giving up"
+ email "Too many failures when attempting to copy $TARGET/$MD5FILE" $EMAILTO "Check log"
+ log INFO "End of gpc1_install.sh (Failure)"
+ exit 1
+ fi
+ else
+ MD5_STATUS=0
+ fi
+done
+
+log INFO "Checking gpc1 backup file checksum"
+EXPECTED_MD5SUM=`cat $TARGET/$MD5FILE | sed 's/ .*$//'`
+BACKUP_FILE=`cat $TARGET/$MD5FILE | sed 's/^.* \//\//'`
+BACKUP_FILE=`basename $BACKUP_FILE`
+log INFO "Backup file is [$TARGET/$BACKUP_FILE]"
+ACTUAL_MD5SUM=`/usr/bin/md5sum $TARGET/$BACKUP_FILE | sed 's/ .*$//'`
+if [ "$ACTUAL_MD5SUM" != "$EXPECTED_MD5SUM" ]; then
+ log ERROR "Checksums are different: actual=[$ACTUAL_MD5SUM], expected=[$EXPECTED_MD5SUM]"
+ email "Invalid checksum for gpc1 backup" $EMAILTO "Checksums are different: actual=[$ACTUAL_MD5SUM], expected=[$EXPECTED_MD5SUM]"
+ log INFO "End of gpc1_install.sh (Failure)"
+ exit 2
+fi
+
+log INFO "Symlinking backup file [$TARGET/$BACKUP_FILE] to distribution [$DISTRIBUTION_TARGET]"
+/usr/bin/ln -f $TARGET/$BACKUP_FILE $DISTRIBUTION_TARGET
+/usr/bin/mv -f $TARGET/$MD5FILE $DISTRIBUTION_MD5
+
+# if it is between 0 and 4, ingest into gpc1_0 or gpc1_1
+HOUR=`date +"%H"`
+if [ "$HOUR" -lt "4" ]; then
+ log INFO "Importing gpc1 backup file to gpc1_0 or gpc1_1"
+ /usr/bin/python /home/panstarrs/ipp/mysql-dump/gpc1Import.py
+else
+ log DEBUG "No gpc1 backup importation"
+fi
+
+log INFO "End of gpc1_install.sh (Success)"
+
Index: /branches/eam_branches/ipp-20110404/tools/mysql-dump/neb_copy.sh
===================================================================
--- /branches/eam_branches/ipp-20110404/tools/mysql-dump/neb_copy.sh (revision 31439)
+++ /branches/eam_branches/ipp-20110404/tools/mysql-dump/neb_copy.sh (revision 31439)
@@ -0,0 +1,79 @@
+#!/bin/bash
+
+# This script is supposed to be executed on ipp001
+#
+# Its main steps:
+# 1) Copies the MD5 checksum from the ithe host where the nebulous db was dumped
+# using neb_dump.sh
+# 2) Copies the nebulous dump
+# 3) Checks the copy agaisnt the checksum
+# In case of failure, an e-mail is sent to $EMAILTO
+
+. /home/panstarrs/ipp/mysql-dump/functions.sh
+
+EMAILTO=ps-ipp-ops@ifa.hawaii.edu
+
+SOURCE_HOST=ippdb02
+HOST=ipp001
+
+SOURCE=ipp@$SOURCE_HOST:/export/$SOURCE_HOST.0/mysql-dumps
+TARGET=/export/$HOST.0/ipp/mysql-dumps
+
+MD5FILE=neb_checksum.md5
+
+MAX_ITERATIONS=200
+SLEEPING_TIME=60
+
+MD5_COPY_STATUS=1
+ITERATION=1
+while [ "$MD5_COPY_STATUS" -ne "0" ]; do
+ /usr/bin/scp -q $SOURCE/$MD5FILE $TARGET 2> /dev/null
+ MD5_COPY_STATUS=$?
+ if [ "$MD5_COPY_STATUS" -ne "0" ]; then
+ log WARNING "MD5 file not found on $SOURCE_HOST. Waiting $SLEEPING_TIME seconds (Attempt: $ITERATION out of $MAX_ITERATIONS)"
+ sleep $SLEEPING_TIME
+ else
+ log DEBUG "Checking size of $TARGET/$MD5FILE"
+ if [ ! -s $TARGET/$MD5FILE ]; then
+ log WARNING "MD5 file has zero-size. Waiting $SLEEPING_TIME seconds (Attempt: $ITERATION out of $MAX_ITERATIONS)"
+ MD5_COPY_STATUS=1
+ sleep $SLEEPING_TIME
+ fi
+ fi
+ let ITERATION=ITERATION+1
+ if [ "$ITERATION" -ge "$MAX_ITERATIONS" ]; then
+ log ERROR "Copy of $SOURCE/$MD5FILE failed after $ITERATION iterations. Giving up"
+ email "Nebulous MD5 copy failed" $EMAILTO "Copy of $SOURCE/$MD5FILE failed after $ITERATION iterations. Giving up"
+ exit 1
+ fi
+done
+
+log INFO "MD5 file successfully copied ($TARGET/$MD5FILE)"
+
+EXPECTED_MD5SUM=`cat $TARGET/$MD5FILE | sed 's/ .*$//'`
+FILE_TO_COPY=`cat $TARGET/$MD5FILE | sed 's/^.* \//\//'`
+FILE_TO_COPY=`basename $FILE_TO_COPY`
+
+log INFO "Copying [$FILE_TO_COPY] now (expected MD5 sum: [$EXPECTED_MD5SUM])"
+/usr/bin/scp -q $SOURCE/$FILE_TO_COPY $TARGET > /dev/null
+if [ "$?" -ne "0" ]; then
+ log ERROR "Can't copy nebulous backup file [$FILE_TO_COPY]"
+ email "Nebulous backup file [$FILE_TO_COPY] copy failed" $EMAILTO "Can't copy nebulous backup file [$FILE_TO_COPY]"
+ exit 2
+else
+ log INFO "Nebulous backup file [$FILE_TO_COPY] successfully copied"
+fi
+
+log INFO "Checking nebulous backup file now"
+ACTUAL_MD5SUM=`/usr/bin/md5sum $TARGET/$FILE_TO_COPY | sed 's/ .*$//'`
+
+if [ "$ACTUAL_MD5SUM" != "$EXPECTED_MD5SUM" ]; then
+ log ERROR "Checksums are different: actual=[$ACTUAL_MD5SUM], expected=[$EXPECTED_MD5SUM]"
+ email "Bad Nebulous checksum" $EMAILTO "Checksums are different: actual=[$ACTUAL_MD5SUM], expected=[$EXPECTED_MD5SUM]"
+ exit 3
+fi
+
+log INFO "Successfully done with [$TARGET/$FILE_TO_COPY]"
+
+exit 0
+
Index: /branches/eam_branches/ipp-20110404/tools/mysql-dump/neb_dump.sh
===================================================================
--- /branches/eam_branches/ipp-20110404/tools/mysql-dump/neb_dump.sh (revision 31439)
+++ /branches/eam_branches/ipp-20110404/tools/mysql-dump/neb_dump.sh (revision 31439)
@@ -0,0 +1,47 @@
+#!/bin/bash
+
+# This script is inspired by ops_dump.csh. It was originally run on ipp001.
+#
+# This is the script that performs nebulous databases dumps. It can be run on any
+# server hosting the nebulous database. Its main steps are:
+# 1) Clean the old dump and the old MD5 checksum files
+# 2) Dump the nebulous database
+# 3) Computes the MD5 checksum
+
+. /home/panstarrs/ipp/mysql-dump/functions.sh
+. /home/panstarrs/ipp/mysql-dump/password.sh
+
+EMAILTO=ps-ipp-ops@ifa.hawaii.edu
+
+HOST=ippdb02
+
+log INFO "Starting nebulous dump"
+
+DUMP_PATH=/export/$HOST.0/mysql-dumps #path
+
+log INFO "Deleting old dumps"
+for file in `find $DUMP_PATH -name mysql-neb-$HOST-\*.dump.bz`; do
+ log INFO "Deleting $file"
+ /bin/rm -f $file
+done
+DATEVAR=`date +%FT%T` #date
+FILENAME=$DUMP_PATH/mysql-neb-$HOST-$DATEVAR.dump.bz #dump file name
+DB_USERNAME=neb_dump
+MD5FILENAME=$DUMP_PATH/neb_checksum.md5
+
+log INFO "Deleting old md5 sum file"
+/bin/rm -f $MD5FILENAME
+
+log INFO "Dumping to [$FILENAME]"
+/usr/bin/mysqldump -h localhost -u $DB_USERNAME -p$DB_PASSWORD --flush-logs --single-transaction nebulous | ~ipp/local/bin/pbzip2 > $FILENAME
+dump_status=${PIPESTATUS[0]}
+if [ "$dump_status" -ne "0" ]; then
+ log ERROR "Sending warning e-mail"
+ email "Nebulous dump failed" $EMAILTO "Check log file: /export/ippdb02.0/mysql-dumps/neb-dump.log"
+ log INFO "End of nebulous dump (Error)"
+ exit 1
+fi
+
+/usr/bin/md5sum $FILENAME > $MD5FILENAME
+log INFO "End of nebulous dump (Success)"
+
Index: /branches/eam_branches/ipp-20110404/tools/mysql-dump/ops_dump.csh
===================================================================
--- /branches/eam_branches/ipp-20110404/tools/mysql-dump/ops_dump.csh (revision 31439)
+++ /branches/eam_branches/ipp-20110404/tools/mysql-dump/ops_dump.csh (revision 31439)
@@ -0,0 +1,42 @@
+#!/bin/csh
+
+echo "## `/bin/date +%FT%T`"
+
+set EMAILTO = ps-ipp-ops@ifa.hawaii.edu
+
+# dump ippRequestServer from ippc19
+set DUMP_PATH = /data/ipp001.0/ipp/mysql-dumps #path(SAB)
+mysqldump --compress -hippc19 -uipp -pipp --flush-logs --single-transaction --log-error=RS-err ippRequestServer | bzip2 > $DUMP_PATH/mysql-RS-ippc19-`date +%FT%T`.dump.bz
+if ($status != 0) then
+ /bin/mail -s "Warning ippRequestServer/RS dump failed" $EMAILTO < msg
+endif
+
+# dump ippadmin from ippdb01
+set DUMP_PATH = /data/ipp001.0/ipp/mysql-dumps #path(SAB)
+set DATEVAR=`date +%FT%T` #date
+set FILENAME = $DUMP_PATH/mysql-ippadmin-ippdb01-$DATEVAR.dump.bz
+mysqldump --compress -hippdb01 -uipp -pipp --flush-logs --single-transaction ippadmin | bzip2 > $FILENAME
+if ($status != 0) then
+ /bin/mail -s "Warning ippadmin dump failed" $EMAILTO < msg
+endif
+
+# simlink to ippadmin ippdb01 dump
+set DUMP_PATH = /data/ipp001.0/ipp/mysql-dumps #path(SAB)
+cd $DUMP_PATH/distribution/ #link dir
+ln -f ../mysql-ippadmin-ippdb01-$DATEVAR.dump.bz ippdb01-ippadmin.dump.bz
+
+
+# dump isp from ippdb01
+set DUMP_PATH = /data/ipp001.0/ipp/mysql-dumps #path(SAB)
+set DATEVAR=`date +%FT%T` #date
+set FILENAME = $DUMP_PATH/mysql-isp-ippdb01-$DATEVAR.dump.bz
+mysqldump --compress -hippdb01 -uipp -pipp --flush-logs --single-transaction isp | bzip2 > $FILENAME
+if ($status != 0) then
+ /bin/mail -s "Warning isp dump failed" $EMAILTO < msg
+endif
+
+# simlink to isp ippdb01 dump
+set DUMP_PATH = /data/ipp001.0/ipp/mysql-dumps #path(SAB)
+cd $DUMP_PATH/distribution/ #link dir
+ln -f ../mysql-isp-ippdb01-$DATEVAR.dump.bz ippdb01-isp.dump.bz
+
Index: /branches/eam_branches/ipp-20110404/tools/regpeek.pl
===================================================================
--- /branches/eam_branches/ipp-20110404/tools/regpeek.pl (revision 31438)
+++ /branches/eam_branches/ipp-20110404/tools/regpeek.pl (revision 31439)
@@ -17,4 +17,5 @@
}
print "Date: $date\n";
+print "CMD: regtool -checkstatus -date $date -class_id ota33 -dbname gpc1 -simple\n";
chomp(my $bad_exp = `regtool -checkstatus -date $date -class_id ota33 -dbname gpc1 -simple | grep 'stop run' | head -1`);
my @row = split /\s+/, $bad_exp;
Index: /branches/eam_branches/ipp-20110404/tools/runcameraexp.pl
===================================================================
--- /branches/eam_branches/ipp-20110404/tools/runcameraexp.pl (revision 31438)
+++ /branches/eam_branches/ipp-20110404/tools/runcameraexp.pl (revision 31439)
@@ -16,4 +16,5 @@
my $dbname = "gpc1";
my ($cam_id, $update, $redirect, $save_temps, $pretend, $no_verbose);
+my ($outdir);
GetOptions(
@@ -22,4 +23,5 @@
'redirect-output' => \$redirect,
'save-temps' => \$save_temps,
+ 'outdir=s' => \$outdir,
'update' => \$update,
'dbname=s' => \$dbname,
@@ -55,4 +57,11 @@
die "Cannot update when run is not faulted\n" if $update and ! $fault;
+
+if ($outdir) {
+ my $base = basename($path_base);
+ $path_base = "$outdir/$base";
+ print STDERR "changing path_base to $path_base";
+ $update = 0;
+}
my $run_state;