Changeset 9129 for trunk/MagicSoft/Mars/datacenter/scripts/sourcefile

Timestamp:

08/21/08 18:49:35 (16 years ago)

Author:

Daniela Dorner

Message:

*** empty log message ***

File:

• trunk/MagicSoft/Mars/datacenter/scripts/sourcefile (modified) (5 diffs)

trunk/MagicSoft/Mars/datacenter/scripts/sourcefile

@@ -231 +231 @@
    pw=`grep Password $mars/sql.rc | grep -v '#' | sed -e 's/Password: //' -e 's/ //g'`
    us=`grep User $mars/sql.rc | grep -v '#' | sed -e 's/User: //' -e 's/ //g'`
+   ho=`grep URL $mars/sql.rc | grep -v '#' | sed -e 's/ //g' -e 's/URL:mysql:\/\///'`
 #   echo "setup: "
 #   echo " db: "$db
 #   echo " pw: "$pw
 #   echo " us: "$us
+#   echo " ho: "$ho
 }
 
@@ -284 +286 @@
    fi
    echo " QUERY: "$query
-   if ! process=`mysql -s -u $us --password=$pw --host=vela $db -e " $query "`
+   if ! process=`mysql -s -u $us --password=$pw --host=$ho $db -e " $query "`
    then
       echo "ERROR could not query processes from db -> exit"
@@ -321 +323 @@
    query=$query" group by $column "
 #   echo " QUERY: "$query
-   if ! numproc=`mysql -s -u $us --password=$pw --host=vela $db -e " $query "`
+   if ! numproc=`mysql -s -u $us --password=$pw --host=$ho $db -e " $query "`
    then
       echo "ERROR could not query number of todo proceses from db -> continue"
@@ -373 +375 @@
    done
    echo " QUERY: "$query
-   if ! mysql -s -u $us --password=$pw --host=vela $db -e " $query "
+   if ! mysql -s -u $us --password=$pw --host=$ho $db -e " $query "
    then
       echo "ERROR could not insert status into db -> exit"
@@ -386 +388 @@
 {
    getdbsetup
-   if ! val=`mysql -s -u $us --password=$pw --host=vela $db -e " $query "`
+   if ! val=`mysql -s -u $us --password=$pw --host=$ho $db -e " $query "`
    then
       printprocesslog "ERROR could not query db (program: $program, function sendquery)"