source: trunk/DataCheck/CheckNTPDate.sh@ 12021

Last change on this file since 12021 was 11849, checked in by Daniela Dorner, 13 years ago
small fixes
  • Property svn:executable set to *
File size: 474 bytes
Line 
1#!/bin/bash
2#
3# script to check whether the time of the computer is off
4# offset is inserted into the database
5#
6
7offset=`/usr/sbin/ntpdate -d ptbtime1.ptb.de 2>/dev/null | grep '^offset*' | cut -d' ' -f2`
8query="INSERT NTPDate set fOffset="$offset", fMachineKEY=(SELECT fMachineKEY from Machine WHERE fMachineName='"$HOSTNAME"'), fTime=Now()"
9# host needs full address to work also on fact01
10/usr/bin/mysql -u systemstatus --host=fact01.ethz.ch SystemStatus -e "$query"
11
12
Note: See TracBrowser for help on using the repository browser.