Changeset 17530 for trunk/DataCheck/Monitoring

Timestamp:

01/21/14 01:35:59 (11 years ago)

Author:

Daniela Dorner

Message:

improved logging output to be sent via email

File:

• trunk/DataCheck/Monitoring/CheckNetworkStatus.sh (modified) (1 diff)

trunk/DataCheck/Monitoring/CheckNetworkStatus.sh

@@ -4 +4 @@
 
 vals=(`/sbin/ifconfig -s | tr -s ' ' | cut -d' ' -f1,5,9 | grep -v RX `)
+#echo ${vals[@]}
+#echo ${#vals[@]}
 
+numvals=`echo " $numnetworks * 3 + 3" | bc -l`
+#echo $numvals
+if [ ${#vals[@]} -ne $numvals ]
+then 
+   echo "ERROR Not all "$numnetworks" networks available."
+   exit
+fi
 
 for (( i=0 ; i < $numnetworks ; i++ )) 
 do 
    query="SELECT fRXErrors, fTXErrors FROM NetworkErrors WHERE fEth="$i" ORDER BY fTime DESC LIMIT 0,1;" 
-   errors=( `/usr/bin/mysql -u systemstatus --host=fact01 SystemStatus -s -e "$query"`)
+   #echo $query
+   errors=( `/usr/bin/mysql -u systemstatus --host=fact01 systemstatus -s -e "$query"` )
+   #echo ${errors[@]}
    if [ ${errors[0]} -lt ${vals[$i*3+1]} ]
    then 
-      echo "RX errors increased to "${errors[0]} 
+      echo "RX errors increased to "${errors[0]}" on eth"$i
    fi
    if [ ${errors[1]} -lt ${vals[$i*3+2]} ]
    then
-      echo "TX errors increased to "${errors[0]}
+      echo "TX errors increased to "${errors[0]}" on eth"$i
    fi
    query="INSERT NetworkErrors SET fEth="$i", fRXErrors="${vals[$i*3+1]}", fTXErrors="${vals[$i*3+2]}", fTime=Now()"
-   /usr/bin/mysql -u systemstatus --host=fact01 SystemStatus -e "$query"
+   /usr/bin/mysql -u systemstatus --host=fact01 systemstatus -e "$query"
 done