Changeset 8380

Timestamp:

03/20/07 17:21:03 (18 years ago)

Author:

hoehne

Message:

*** empty log message ***

Location:

trunk/MagicSoft/Mars

Files:

• Changelog (modified) (1 diff)
• datacenter/db/db.php (modified) (1 diff)
• datacenter/scripts/budb (modified) (1 diff)
• datacenter/scripts/dbchk (modified) (1 diff)
• datacenter/scripts/dunotseqruns (modified) (1 diff)
• datacenter/scripts/findnewstars (modified) (1 diff)
• datacenter/scripts/findnotseqruns (modified) (1 diff)
• datacenter/scripts/sourcefile (modified) (4 diffs)
• datacenter/tools/comparesequences (modified) (1 diff)
• datacenter/tools/resetdataset (modified) (1 diff)

trunk/MagicSoft/Mars/Changelog

@@ -19 +19 @@
                                                  -*-*- END OF LINE -*-*-
 
+ 2007/03/20 Daniel Hoehne
+
+   * datacenter/db/db.php, datacenter/scripts/budb,
+     datacenter/scripts/dbchk, /datacenter/scripts/dunotseqruns,
+     /datacenter/scripts/findnewstars,
+     /datacenter/scripts/findnotseqruns, /datacenter/scripts/sourcefile,
+     /datacenter/tools/comparesequences, datacenter/tools/resetdataset,
+     sql.rc:
+     - changed the host from hercules to vela
+
+
+
  2007/03/17 Thomas Bretz
 

trunk/MagicSoft/Mars/datacenter/db/db.php

@@ -1 +1 @@
 <?php
 
-$host="hercules.astro.uni-wuerzburg.de";
+$host="vela.astro.uni-wuerzburg.de";
 $user="MAGIC";
 $pw="d99swMT!";

trunk/MagicSoft/Mars/datacenter/scripts/budb

@@ -28 +28 @@
 echo "writing all databases to file..." >> $logfile 2>&1
 set +C
-mysqldump --host=hercules --all-databases -u dump | bzip2 -9 -c > $file$datum$end 2>> $logfile
+mysqldump --host=vela --all-databases -u dump | bzip2 -9 -c > $file$datum$end 2>> $logfile
 
 

trunk/MagicSoft/Mars/datacenter/scripts/dbchk

@@ -9 +9 @@
 stardir=/magic/data/star
 # access to the sql database
-alias mymysql='mysql -s -u MAGIC -h hercules --password=d99swMT!'
+alias mymysql='mysql -s -u MAGIC -h vela --password=d99swMT!'
 # database name
 db=MyMagic

trunk/MagicSoft/Mars/datacenter/scripts/dunotseqruns

@@ -4 +4 @@
 query="select concat('/magic/data/rawfiles', Date_Format(adddate(fRunStart, interval 12 HOUR), '/%Y/%m/%d/'),'*', fRunNumber, '*.raw.gz')  from RunData where fSequenceFirst='0' and fRunStart > '2004-08-20'"
 
-files=`mysql -u MAGIC --host=hercules --password=d99swMT! MyMagic -s -e " $query"`
+files=`mysql -u MAGIC --host=vela --password=d99swMT! MyMagic -s -e " $query"`
 
 sum=0

trunk/MagicSoft/Mars/datacenter/scripts/findnewstars

@@ -67 +67 @@
 done
 
-alias mymysql='mysql -u MAGIC --password=d99swMT! --host=hercules MyMagic -s -e'
+alias mymysql='mysql -u MAGIC --password=d99swMT! --host=vela MyMagic -s -e'
 
 query="SELECT fSequenceFirst FROM SequenceProcessStatus WHERE NOT ISNULL(fStar) "

trunk/MagicSoft/Mars/datacenter/scripts/findnotseqruns

@@ -106 +106 @@
 done
 
-alias mymysql='mysql -u MAGIC --password=d99swMT! --host=hercules MyMagic -s -e'
+alias mymysql='mysql -u MAGIC --password=d99swMT! --host=vela MyMagic -s -e'
 
 if [ "$dat" = "" ] && [ "$cal" = "" ] && [ "$ped" = "" ] && ! [ "$all" = "yes" ]

trunk/MagicSoft/Mars/datacenter/scripts/sourcefile

@@ -310 +310 @@
    query=$query" order by $primary desc "
 #   echo " QUERY: "$query
-   if ! process=`mysql -s -u $us --password=$pw --host=hercules $db -e " $query "`
+   if ! process=`mysql -s -u $us --password=$pw --host=vela $db -e " $query "`
    then
       echo "ERROR could not query processes from db -> exit"
@@ -356 +356 @@
    query=$query" limit 0, 1 "
 #   echo " QUERY: "$query
-   if ! process=`mysql -s -u $us --password=$pw --host=hercules $db -e " $query "`
+   if ! process=`mysql -s -u $us --password=$pw --host=vela $db -e " $query "`
    then
       echo "ERROR could not query process from db -> exit"
@@ -392 +392 @@
 #   echo " QUERY: "$query
    numproc=0
-   if ! numproc=`mysql -s -u $us --password=$pw --host=hercules $db -e " $query "`
+   if ! numproc=`mysql -s -u $us --password=$pw --host=vela $db -e " $query "`
    then
       echo "ERROR could not query number of todo proceses from db -> continue"
@@ -430 +430 @@
    query=$query" where $primary='$var2'"
    echo " QUERY: "$query
-   if ! mysql -s -u $us --password=$pw --host=hercules $db -e " $query "
+   if ! mysql -s -u $us --password=$pw --host=vela $db -e " $query "
    then
       echo "ERROR could not insert status into db -> exit"

trunk/MagicSoft/Mars/datacenter/tools/comparesequences

@@ -30 +30 @@
 newdb=TestSequ2
 pw=d99swMT!
-host=hercules
+host=vela
 
 query="select fRunNumber from RunData where fRunNumber > 32000";

trunk/MagicSoft/Mars/datacenter/tools/resetdataset

@@ -93 +93 @@
 
 
-alias mymysql='mysql -u $user --password=$ps --host=hercules $db -s -e'
+alias mymysql='mysql -u $user --password=$ps --host=vela $db -s -e'
 
 whereclause1=" WHERE fDataSetNumer=$dataset"