Index: /trunk/DataCheck/CheckNTPDate.sh
===================================================================
--- /trunk/DataCheck/CheckNTPDate.sh	(revision 11848)
+++ /trunk/DataCheck/CheckNTPDate.sh	(revision 11848)
@@ -0,0 +1,12 @@
+#!/bin/bash
+#
+# script to check whether the time of the computer is off
+# offset is inserted into the database
+# 
+
+offset=`ntpdate -d ptbtime1.ptb.de 2>/dev/null | grep '^offset*' | cut -d' ' -f2`
+query="INSERT NTPDate set fOffset="$offset", fMachineKEY=(SELECT fMachineKEY from Machine WHERE fMachineName='"$HOSTNAME"'), fTime=Now()"
+#echo $query
+/usr/bin/mysql -u systemstatus --host=fact01 SystemStatus -e "$query"
+
+
Index: /trunk/DataCheck/CheckNetworkStatus.sh
===================================================================
--- /trunk/DataCheck/CheckNetworkStatus.sh	(revision 11848)
+++ /trunk/DataCheck/CheckNetworkStatus.sh	(revision 11848)
@@ -0,0 +1,23 @@
+#!/bin/bash
+
+numnetworks=6
+
+vals=(`/sbin/ifconfig -s | tr -s ' ' | cut -d' ' -f1,5,9 | grep -v RX `)
+
+
+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"`)
+   if [ ${errors[0]} -lt ${vals[$i*3+1]} ]
+   then 
+      echo "RX errors increased to "${errors[0]} 
+   fi
+   if [ ${errors[1]} -lt ${vals[$i*3+2]} ]
+   then
+      echo "TX errors increased to "${errors[0]}
+   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"
+done
+
Index: /trunk/DataCheck/crontab.fact01
===================================================================
--- /trunk/DataCheck/crontab.fact01	(revision 11848)
+++ /trunk/DataCheck/crontab.fact01	(revision 11848)
@@ -0,0 +1,4 @@
+# check time offset of machine
+0 */6 * * * /home/fact/DataCheck/CheckNTPDate.sh
+# backup databases 
+0 8 * * * export AUTOMATIONSETUP="lp.fact" ; /home/fact/DB_Backup/Mars.svn.2011.08.05/datacenter/scripts/budb
Index: /trunk/DataCheck/crontab.fact02
===================================================================
--- /trunk/DataCheck/crontab.fact02	(revision 11848)
+++ /trunk/DataCheck/crontab.fact02	(revision 11848)
@@ -0,0 +1,2 @@
+# check time offset of machine
+0 */6 * * * /home/fact/DataCheck/CheckNTPDate.sh
Index: /trunk/DataCheck/crontab.fact1
===================================================================
--- /trunk/DataCheck/crontab.fact1	(revision 11848)
+++ /trunk/DataCheck/crontab.fact1	(revision 11848)
@@ -0,0 +1,2 @@
+# check time offset of machine
+0 */6 * * * /home/fact/DataCheck/CheckNTPDate.sh
Index: /trunk/DataCheck/crontab.fact2
===================================================================
--- /trunk/DataCheck/crontab.fact2	(revision 11848)
+++ /trunk/DataCheck/crontab.fact2	(revision 11848)
@@ -0,0 +1,4 @@
+# check network status 
+*/15 * * * * /home/fact/DataCheck/CheckNetworkStatus.sh
+# check time offset of machine
+0 */6 * * * /home/fact/DataCheck/CheckNTPDate.sh