Ignore:
Timestamp:
11/11/08 10:38:56 (16 years ago)
Author:
Daniela Dorner
Message:
*** empty log message ***
Location:
trunk/MagicSoft/Mars/datacenter/scripts
Files:
3 edited

Legend:

Unmodified
Added
Removed

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

    r9136 r9147  
    6464
    6565# complete databases
    66 if ! mysqldump --host=vela --all-databases -u dump | bzip2 -9 -c >| $zipfile 2>> $logfile
     66if ! mysqldump --host=$ho --all-databases -u dump | bzip2 -9 -c >| $zipfile 2>> $logfile
    6767then
    6868   printprocesslog "ERROR mysqldump failed "
    … …  
    7171echo "writing create commands to $command..." >> $logfile 2>&1
    7272# commands to create MyMagic
    73 if ! mysqldump --host=vela --database $dbname -u dump --no-data >| $command 2>> $logfile
     73if ! mysqldump --host=$ho --database $dbname -u dump --no-data >| $command 2>> $logfile
    7474then
    7575   printprocesslog "ERROR mysqldump failed "

  • trunk/MagicSoft/Mars/datacenter/scripts/fillcamera

    r9144 r9147  
    124124      pquery=" select fRunNumber from MCRunProcessStatus where fFileName=\"$pedfile\" "
    125125     
    126       crun=`mysql -ss -u $user --password=$pw --host=vela $db -e " $cquery "`
    127       prun=`mysql -ss -u $user --password=$pw --host=vela $db -e " $pquery "`
     126      crun=`mysql -ss -u $user --password=$pw --host=$ho $db -e " $cquery "`
     127      prun=`mysql -ss -u $user --password=$pw --host=$ho $db -e " $pquery "`
    128128      cnum=`printf %08d $crun`
    129129      pnum=`printf %08d $prun`
    … …  
    150150            echo "P run already there, do mysql update" >> $scriptlog 2>&1
    151151   #         continue
    152             mysql -ss -u $user --password=$pw --host=vela $db -e " $pupdate "
     152            mysql -ss -u $user --password=$pw --host=$ho $db -e " $pupdate "
    153153         else
    154154            echo "linking P run for epoch $epo" >> $scriptlog 2>&1
    155155            ln -sv $pedfile $newpedfile >> $scriptlog 2>&1
    156             mysql -ss -u $user --password=$pw --host=vela $db -e " $pupdate "
     156            mysql -ss -u $user --password=$pw --host=$ho $db -e " $pupdate "
    157157         fi
    158158         
    … …  
    161161            echo "C run already there, do mysql update" >> $scriptlog 2>&1
    162162   #         continue
    163             mysql -ss -u $user --password=$pw --host=vela $db -e " $cupdate "
     163            mysql -ss -u $user --password=$pw --host=$ho $db -e " $cupdate "
    164164         else
    165165            echo "linking C run for epoch $epo" >> $scriptlog 2>&1
    166166            ln -sv $calfile $newcalfile >> $scriptlog 2>&1
    167             mysql -ss -u $user --password=$pw --host=vela $db -e " $cupdate "
     167            mysql -ss -u $user --password=$pw --host=$ho $db -e " $cupdate "
    168168         fi
    169169   

  • trunk/MagicSoft/Mars/datacenter/scripts/mcsequences

    r8967 r9147  
    1919#
    2020#   Author(s): Daniela Dorner  12/2005 <mailto:dorner@astro.uni-wuerzburg.de>
    21 #   Author(s): Daniela Dorner  06/2008 <mailto:hoehne@astro.uni-wuerzburg.de>
     21#   Author(s): Daniel Hoehne  06/2008 <mailto:hoehne@astro.uni-wuerzburg.de>
    2222#
    2323#   Copyright: MAGIC Software Development, 2000-2008
    … …  
    103103            do
    104104               trainupdate=" update MCRunData set fSequenceFirst=\"$firstruntrain\" where fRunNumber=\"$trainrun\" "
    105                mysql -ss -u $user --password=$pw --host=vela $db -e " $trainupdate "
     105               mysql -ss -u $user --password=$pw --host=$ho $db -e " $trainupdate "
    106106            done   
    107107
    108108            trainquery1=" select fSpectrumKEY, fPSFKEY, fAmplFadcKEY, fAtmosphericModelKEY, fObservationModeKEY, fMCParticleKEY, fReflectorVersionKEY, fCorsikaVersionKEY, fCameraVersionKEY, fViewConeAngleOKEY, fAddSpotSizeKEY from MCRunData where fRunNumber=\"$firstruntrain\" "
    109109            trainquery2=" select sum(fNumEvents), sum(fNumtriggers) from MCRunData where fRunNumber in ($trainruns2) "
    110             trainvalues=`mysql -ss -u $user --password=$pw --host=vela $db -e " $trainquery1 "`
    111             trainvalues2=`mysql -ss -u $user --password=$pw --host=vela $db -e " $trainquery2 "`
     110            trainvalues=`mysql -ss -u $user --password=$pw --host=$ho $db -e " $trainquery1 "`
     111            trainvalues2=`mysql -ss -u $user --password=$pw --host=$ho $db -e " $trainquery2 "`
    112112            trainspec=`echo $trainvalues | cut -d" " -f1`
    113113            trainpsf=`echo $trainvalues | cut -d" " -f2`
    … …  
    125125            trainquery3=" select fSequenceFirst from MCSequenceProcessStatus where fSequenceFirst=\"$firstruntrain\" "
    126126            trainquery4=" select fSequenceFirst from MCSequences where fSequenceFirst=\"$firstruntrain\" "
    127             traincheck3=`mysql -ss -u $user --password=$pw --host=vela $db -e " $trainquery3 "`
    128             traincheck4=`mysql -ss -u $user --password=$pw --host=vela $db -e " $trainquery4 "`
     127            traincheck3=`mysql -ss -u $user --password=$pw --host=$ho $db -e " $trainquery3 "`
     128            traincheck4=`mysql -ss -u $user --password=$pw --host=$ho $db -e " $trainquery4 "`
    129129            traininsert1=" insert MCSequenceProcessStatus set fSequenceFirst=\"$firstruntrain\", fSequenceFileWritten=Now() "
    130130            traininsert2=" insert MCSequences set fSequenceFirst=\"$firstruntrain\", fRunStart=\"$date\", fNumEvents=\"$trainevents\", fNumTriggers=\"$traintriggers\", fZBin=\"$zbin\", fSpectrumKEY=\"$trainspec\", fPSFKEY=\"$trainpsf\", fAddSpotSizeKEY=\"$trainass\", fAmplFadcKEY=\"$trainamplfadc\", fAtmosphericModelKEY=\"$trainatmo\", fObservationModeKEY=\"$trainobs\", fMCParticleKEY=\"$trainpart\", fReflectorVersionKEY=\"$trainrefl\", fCorsikaVersionKEY=\"$traincors\", fCameraVersionKEY=\"$traincam\", fViewConeAngleOKEY=\"$trainview\", fTestTrainKEY=2 "
    … …  
    132132            if [ "$traincheck3" == "" ]
    133133            then
    134                mysql -ss -u $user --password=$pw --host=vela $db -e " $traininsert1 "
     134               mysql -ss -u $user --password=$pw --host=$ho $db -e " $traininsert1 "
    135135            fi
    136136            if [ "$traincheck4" == "" ]
    137137            then
    138                mysql -ss -u $user --password=$pw --host=vela $db -e " $traininsert2 "
     138               mysql -ss -u $user --password=$pw --host=$ho $db -e " $traininsert2 "
    139139            else
    140                mysql -ss -u $user --password=$pw --host=vela $db -e " $trainupdate2 "
     140               mysql -ss -u $user --password=$pw --host=$ho $db -e " $trainupdate2 "
    141141            fi
    142142           
    … …  
    166166            do
    167167               testupdate=" update MCRunData set fSequenceFirst=\"$firstruntest\" where fRunNumber=\"$testrun\" "
    168                mysql -ss -u $user --password=$pw --host=vela $db -e " $testupdate "
     168               mysql -ss -u $user --password=$pw --host=$ho $db -e " $testupdate "
    169169            done   
    170170
    171171            testquery1=" select fSpectrumKEY, fPSFKEY, fAmplFadcKEY, fAtmosphericModelKEY, fObservationModeKEY, fMCParticleKEY, fReflectorVersionKEY, fCorsikaVersionKEY, fCameraVersionKEY, fViewConeAngleOKEY, fAddSpotSizeKEY from MCRunData where fRunNumber=\"$firstruntest\" "
    172172            testquery2=" select sum(fNumEvents), sum(fNumtriggers) from MCRunData where fRunNumber in ($testruns2) "
    173             testvalues=`mysql -ss -u $user --password=$pw --host=vela $db -e " $testquery1 "`
    174             testvalues2=`mysql -ss -u $user --password=$pw --host=vela $db -e " $testquery2 "`
     173            testvalues=`mysql -ss -u $user --password=$pw --host=$ho $db -e " $testquery1 "`
     174            testvalues2=`mysql -ss -u $user --password=$pw --host=$ho $db -e " $testquery2 "`
    175175            testspec=`echo $testvalues | cut -d" " -f1`
    176176            testpsf=`echo $testvalues | cut -d" " -f2`
    … …  
    188188            testquery3=" select fSequenceFirst from MCSequenceProcessStatus where fSequenceFirst=\"$firstruntest\" "
    189189            testquery4=" select fSequenceFirst from MCSequences where fSequenceFirst=\"$firstruntest\" "
    190             testcheck3=`mysql -ss -u $user --password=$pw --host=vela $db -e " $testquery3 "`
    191             testcheck4=`mysql -ss -u $user --password=$pw --host=vela $db -e " $testquery4 "`
     190            testcheck3=`mysql -ss -u $user --password=$pw --host=$ho $db -e " $testquery3 "`
     191            testcheck4=`mysql -ss -u $user --password=$pw --host=$ho $db -e " $testquery4 "`
    192192            testinsert1=" insert MCSequenceProcessStatus set fSequenceFirst=\"$firstruntest\", fSequenceFileWritten=Now() "
    193193            testinsert2=" insert MCSequences set fSequenceFirst=\"$firstruntest\", fRunStart=\"$date\", fNumEvents=\"$testevents\", fNumTriggers=\"$testtriggers\", fZBin=\"$zbin\", fSpectrumKEY=\"$testspec\", fPSFKEY=\"$testpsf\", fAddSpotSizeKEY=\"$testass\", fAmplFadcKEY=\"$testamplfadc\", fAtmosphericModelKEY=\"$testatmo\", fObservationModeKEY=\"$testobs\", fMCParticleKEY=\"$testpart\", fReflectorVersionKEY=\"$testrefl\", fCorsikaVersionKEY=\"$testcors\", fCameraVersionKEY=\"$testcam\", fViewConeAngleOKEY=\"$testview\", fTestTrainKEY=3 "
    … …  
    195195            if [ "$testcheck3" == "" ]
    196196            then
    197                mysql -ss -u $user --password=$pw --host=vela $db -e " $testinsert1 "
     197               mysql -ss -u $user --password=$pw --host=$ho $db -e " $testinsert1 "
    198198            fi
    199199            if [ "$testcheck4" == "" ]
    200200            then
    201                mysql -ss -u $user --password=$pw --host=vela $db -e " $testinsert2 "
     201               mysql -ss -u $user --password=$pw --host=$ho $db -e " $testinsert2 "
    202202            else
    203                mysql -ss -u $user --password=$pw --host=vela $db -e " $testupdate2 "
     203               mysql -ss -u $user --password=$pw --host=$ho $db -e " $testupdate2 "
    204204            fi
    205205           
Note: See TracChangeset for help on using the changeset viewer.