Changeset 31229

Timestamp:

Apr 7, 2011, 9:23:10 AM (15 years ago)

Author:

Serge CHASTEL

Message:

E-mail recipient

Location:

trunk/tools/mysql-dump

Files:

• gpc1_dump.sh (modified) (2 diffs)
• neb_dump.sh (modified) (2 diffs)
• ops_dump.csh (modified) (5 diffs)

trunk/tools/mysql-dump/gpc1_dump.sh

@@ -15 +15 @@
 . /home/panstarrs/ipp/mysql-dump/functions.sh
 . /home/panstarrs/ipp/mysql-dump/password.sh
+
+EMAILTO=schastel@ifa.hawaii.edu
 
 HOST=ippc02
@@ -43 +45 @@
 if [ "$dump_status" -ne "0" ]; then
         log ERROR "Sending warning e-mail"
-        email "Gpc1 dump failed" schastel@ifa.hawaii.edu "Check log file: /export/$HOST.0/mysql-dumps/gpc1_dump.log"
+        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

trunk/tools/mysql-dump/neb_dump.sh

@@ -12 +12 @@
 . /home/panstarrs/ipp/mysql-dump/password.sh
 
+EMAILTO=schastel@ifa.hawaii.edu
 HOST=ippdb02
 
@@ -36 +37 @@
 if [ "$dump_status" -ne "0" ]; then
         log ERROR "Sending warning e-mail"
-        email "Nebulous dump failed" schastel@ifa.hawaii.edu "Check log file: /export/ippdb02.0/mysql-dumps/neb-dump.log"
+        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

trunk/tools/mysql-dump/ops_dump.csh

@@ -2 +2 @@
 
 echo "## `/bin/date +%FT%T`"
+
+set EMAILTO = schastel@ifa.hawaii.edu
 
 # dump ippRequestServer from ippc19
@@ -7 +9 @@
 mysqldump --compress -hippc19 -uipp -pipp --flush-logs --single-transaction --log-error=RS-err ippRequestServer | gzip -9 > $DUMP_PATH/mysql-RS-ippc19-`date +%FT%T`.dump.gz
 if ($status != 0) then
-   /bin/mail -s "Warning RS dump failed" schastel@ifa.hawaii.edu < msg
+   /bin/mail -s "Warning ippRequestServer/RS dump failed" $EMAILTO < msg
 endif
 
@@ -16 +18 @@
 mysqldump --compress -hippdb01 -uipp -pipp --flush-logs --single-transaction ippadmin | gzip -9 > $FILENAME
 if ($status != 0) then
-   /bin/mail -s "Warning ippadmin dump failed" schastel@ifa.hawaii.edu < msg  
+   /bin/mail -s "Warning ippadmin dump failed" $EMAILTO < msg  
 endif
 
@@ -31 +33 @@
 mysqldump --compress -hippdb01 -uipp -pipp --flush-logs --single-transaction isp | gzip -9 > $FILENAME
 if ($status != 0) then
-   /bin/mail -s "Warning isp dump failed" schastel@ifa.hawaii.edu < msg  
+   /bin/mail -s "Warning isp dump failed" $EMAILTO < msg  
 endif
 
@@ -39 +41 @@
 ln -f  ../mysql-isp-ippdb01-$DATEVAR.dump.gz ippdb01-isp.dump.gz
 
-# dump gpc1 from ippdb01
-#set DUMP_PATH = /data/ipp001.0/ipp/mysql-dumps               #path(SAB)
-#set DATEVAR=`date +%FT%T`                                    #date
-#set FILENAME = $DUMP_PATH/mysql-gpc1-ippc02-$DATEVAR.dump.gz #dump file name
-#mysqldump --compress -hippc -P3302 -uipp -pipp --flush-logs --single-transaction gpc1 | gzip -9 > $FILENAME
-#if ($status != 0) then
-#   /bin/mail -s "Warning gpc1 dump failed" schastel@ifa.hawaii.edu < msg  
-#endif
-
-# simlink to gpc1 ippdb01 dump
-#set DUMP_PATH = /data/ipp001.0/ipp/mysql-dumps       #path(SAB)
-#cd $DUMP_PATH/distribution/                          #link dir
-#ln -f  ../mysql-gpc1-ippc02-$DATEVAR.dump.gz ippdb01-gpc1.dump.gz   #hard link
-
-
-# dump the ippdb02 database
-#set DUMP_PATH = /data/ipp001.0/ipp/mysql-dumps             #path
-#set DATEVAR = `date +%FT%T`                                #date       
-#set FILENAME = $DUMP_PATH/mysql-neb-ippdb02-$DATEVAR.dump.gz   #dump file name
-#mysqldump --compress -hippdb02 -ujhipp -pjhipp --flush-logs --single-transaction nebulous | gzip -9 > $FILENAME
-#if ($status != 0) then
-#   /bin/mail -s "Warning nebulous dump failed" schastel@ifa.hawaii.edu < msg  
-#endif
-
-# simlink to latest ippdb02 dump
-#set DUMP_PATH = /data/ipp001.0/ipp/mysql-dumps            #path (SAB)
-#cd $DUMP_PATH/distribution/                                #link dir
-#ln -f  ../mysql-neb-ippdb02-$DATEVAR.dump.gz ippdb02.dump.gz   #hard link
-
-# dump the ippdb00 database
-#set DUMP_PATH = /data/ipp001.0/ipp/mysql-dumps             #path
-#set DATEVAR = `date +%FT%T`                                #date       
-#set FILENAME = $DUMP_PATH/mysql-neb-ippdb00-$DATEVAR.dump.gz   #dump file name
-#mysqldump --compress -hippdb00 -ujhipp -pjhipp --flush-logs --single-transaction nebulous | gzip -9 > $FILENAME
-#if ($status != 0) then
-#   /bin/mail -s "Warning nebulous dump failed" schastel@ifa.hawaii.edu < msg  
-#endif
-