|
Last change
on this file since 12421 was 12181, checked in by Daniela Dorner, 13 years ago |
|
update hostname of mysql server
|
-
Property svn:executable
set to
*
|
|
File size:
477 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.fact.local SystemStatus -e "$query"
|
|---|
| 11 |
|
|---|
| 12 |
|
|---|
Note:
See
TracBrowser
for help on using the repository browser.
