Last change
on this file since 19846 was 18690, checked in by Daniela Dorner, 8 years ago |
updated mysql access after system upgrade
|
-
Property svn:executable
set to
*
|
File size:
598 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 |
|
---|
7 | offset=`/usr/sbin/ntpdate -d ptbtime1.ptb.de 2>/dev/null | grep '^offset*' | cut -d' ' -f2`
|
---|
8 | query="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 systemstatus -e "$query"
|
---|
11 |
|
---|
12 | if [ $(echo " $offset > 1 || $offset < -1 " | bc) -eq 1 ]
|
---|
13 | then
|
---|
14 | echo `date`": time difference of "$offset" sec on "$HOSTNAME
|
---|
15 | fi
|
---|
16 |
|
---|
Note:
See
TracBrowser
for help on using the repository browser.