Changeset 8380 for trunk


Ignore:
Timestamp:
03/20/07 17:21:03 (18 years ago)
Author:
hoehne
Message:
*** empty log message ***
Location:
trunk/MagicSoft/Mars
Files:
10 edited

Legend:

Unmodified
Added
Removed

  • trunk/MagicSoft/Mars/Changelog

    r8379 r8380  
    1919                                                 -*-*- END OF LINE -*-*-
    2020
     21 2007/03/20 Daniel Hoehne
     22
     23   * datacenter/db/db.php, datacenter/scripts/budb,
     24     datacenter/scripts/dbchk, /datacenter/scripts/dunotseqruns,
     25     /datacenter/scripts/findnewstars,
     26     /datacenter/scripts/findnotseqruns, /datacenter/scripts/sourcefile,
     27     /datacenter/tools/comparesequences, datacenter/tools/resetdataset,
     28     sql.rc:
     29     - changed the host from hercules to vela
     30
     31
     32
    2133 2007/03/17 Thomas Bretz
    2234

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

    r7546 r8380  
    11<?php
    22
    3 $host="hercules.astro.uni-wuerzburg.de";
     3$host="vela.astro.uni-wuerzburg.de";
    44$user="MAGIC";
    55$pw="d99swMT!";

  • trunk/MagicSoft/Mars/datacenter/scripts/budb

    r8078 r8380  
    2828echo "writing all databases to file..." >> $logfile 2>&1
    2929set +C
    30 mysqldump --host=hercules --all-databases -u dump | bzip2 -9 -c > $file$datum$end 2>> $logfile
     30mysqldump --host=vela --all-databases -u dump | bzip2 -9 -c > $file$datum$end 2>> $logfile
    3131
    3232

  • trunk/MagicSoft/Mars/datacenter/scripts/dbchk

    r8065 r8380  
    99stardir=/magic/data/star
    1010# access to the sql database
    11 alias mymysql='mysql -s -u MAGIC -h hercules --password=d99swMT!'
     11alias mymysql='mysql -s -u MAGIC -h vela --password=d99swMT!'
    1212# database name
    1313db=MyMagic

  • trunk/MagicSoft/Mars/datacenter/scripts/dunotseqruns

    r8058 r8380  
    44query="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'"
    55
    6 files=`mysql -u MAGIC --host=hercules --password=d99swMT! MyMagic -s -e " $query"`
     6files=`mysql -u MAGIC --host=vela --password=d99swMT! MyMagic -s -e " $query"`
    77
    88sum=0

  • trunk/MagicSoft/Mars/datacenter/scripts/findnewstars

    r8063 r8380  
    6767done
    6868
    69 alias mymysql='mysql -u MAGIC --password=d99swMT! --host=hercules MyMagic -s -e'
     69alias mymysql='mysql -u MAGIC --password=d99swMT! --host=vela MyMagic -s -e'
    7070
    7171query="SELECT fSequenceFirst FROM SequenceProcessStatus WHERE NOT ISNULL(fStar) "

  • trunk/MagicSoft/Mars/datacenter/scripts/findnotseqruns

    r8063 r8380  
    106106done
    107107
    108 alias mymysql='mysql -u MAGIC --password=d99swMT! --host=hercules MyMagic -s -e'
     108alias mymysql='mysql -u MAGIC --password=d99swMT! --host=vela MyMagic -s -e'
    109109
    110110if [ "$dat" = "" ] && [ "$cal" = "" ] && [ "$ped" = "" ] && ! [ "$all" = "yes" ]

  • trunk/MagicSoft/Mars/datacenter/scripts/sourcefile

    r8303 r8380  
    310310   query=$query" order by $primary desc "
    311311#   echo " QUERY: "$query
    312    if ! process=`mysql -s -u $us --password=$pw --host=hercules $db -e " $query "`
     312   if ! process=`mysql -s -u $us --password=$pw --host=vela $db -e " $query "`
    313313   then
    314314      echo "ERROR could not query processes from db -> exit"
    … …  
    356356   query=$query" limit 0, 1 "
    357357#   echo " QUERY: "$query
    358    if ! process=`mysql -s -u $us --password=$pw --host=hercules $db -e " $query "`
     358   if ! process=`mysql -s -u $us --password=$pw --host=vela $db -e " $query "`
    359359   then
    360360      echo "ERROR could not query process from db -> exit"
    … …  
    392392#   echo " QUERY: "$query
    393393   numproc=0
    394    if ! numproc=`mysql -s -u $us --password=$pw --host=hercules $db -e " $query "`
     394   if ! numproc=`mysql -s -u $us --password=$pw --host=vela $db -e " $query "`
    395395   then
    396396      echo "ERROR could not query number of todo proceses from db -> continue"
    … …  
    430430   query=$query" where $primary='$var2'"
    431431   echo " QUERY: "$query
    432    if ! mysql -s -u $us --password=$pw --host=hercules $db -e " $query "
     432   if ! mysql -s -u $us --password=$pw --host=vela $db -e " $query "
    433433   then
    434434      echo "ERROR could not insert status into db -> exit"

  • trunk/MagicSoft/Mars/datacenter/tools/comparesequences

    r8058 r8380  
    3030newdb=TestSequ2
    3131pw=d99swMT!
    32 host=hercules
     32host=vela
    3333
    3434query="select fRunNumber from RunData where fRunNumber > 32000";

  • trunk/MagicSoft/Mars/datacenter/tools/resetdataset

    r8064 r8380  
    9393
    9494
    95 alias mymysql='mysql -u $user --password=$ps --host=hercules $db -s -e'
     95alias mymysql='mysql -u $user --password=$ps --host=vela $db -s -e'
    9696
    9797whereclause1=" WHERE fDataSetNumer=$dataset"
Note: See TracChangeset for help on using the changeset viewer.