diff options
| author | Matt Rude <[email protected]> | 2011-06-22 07:47:23 -0500 |
|---|---|---|
| committer | Matt Rude <[email protected]> | 2011-06-22 07:47:23 -0500 |
| commit | 83e891b218fcf550fbad48967aa39a53c4f4a246 (patch) | |
| tree | 492eff62ce6a95a8b4f33419ee3ca9c0f58315d2 /scripts | |
| parent | 82ea3dff28cd49bab871f2e61d89972de400557b (diff) | |
| download | time.mattrude.com-83e891b218fcf550fbad48967aa39a53c4f4a246.tar.gz time.mattrude.com-83e891b218fcf550fbad48967aa39a53c4f4a246.tar.bz2 time.mattrude.com-83e891b218fcf550fbad48967aa39a53c4f4a246.zip | |
Reverting some changes from c3d0bd3f76212ff36654
Diffstat (limited to 'scripts')
| -rwxr-xr-x | scripts/do-ntp-rrdstats | 16 |
1 files changed, 3 insertions, 13 deletions
diff --git a/scripts/do-ntp-rrdstats b/scripts/do-ntp-rrdstats index 7ed3cfa..4492aff 100755 --- a/scripts/do-ntp-rrdstats +++ b/scripts/do-ntp-rrdstats @@ -1,18 +1,9 @@ #!/bin/sh -DATE=`date +%Y-%m-%d' '%T` case "$1" in "") echo "Missing system name."; exit 1 esac -if [ ! -f ntpstatus.sqlite ]; then - echo "CREATE TABLE status (date datetime NOT NULL, host varchar(255) NOT NULL, offset varchar(255), freq varchar(255), sjit varchar(255), cjit varchar(255), wander varchar(255), disp varchar(255));" |sqlite3 ntpstatus.sqlite -fi - -if [ ! -f ntpclients.sqlite ]; then - echo "CREATE TABLE clientss (date datetime NOT NULL, host varchar(255) NOT NULL, value blob);" |sqlite3 ntpclients.sqlite -fi - /usr/sbin/ntpq -4 -c rv $1 | awk 'BEGIN{ RS=","}{ print }' >> /tmp/ntp-rrdstats.$$ NOFFSET=`grep offset /tmp/ntp-rrdstats.$$ | awk 'BEGIN{FS="="}{print $2}'` @@ -24,8 +15,7 @@ NDISPER=`grep rootdisp /tmp/ntp-rrdstats.$$ | awk 'BEGIN{FS="="}{print $2}'` JITTER=`grep jitter /tmp/ntp-rrdstats.$$ | awk 'BEGIN{FS="="}{print $2}'` # keep this in the same order as do-newntpstat creates them, please. -/usr/bin/rrdtool update $1.rrd N:${NOFFSET}:${NSJIT}:${NCJIT}:${NWANDER}:${NFREQ}:${NDISPER}:0 -rm /tmp/ntp-rrdstats.$$ +/usr/bin/rrdtool update \ + $1.rrd N:${NOFFSET}:${NSJIT}:${NCJIT}:${NWANDER}:${NFREQ}:${NDISPER}:0 -echo "INSERT INTO status (date, host, offset, freq, sjit, cjit, wander, disp) VALUES ('${DATE}', '${1}', '${NOFFSET}', '${NSJIT}', '${NCJIT}', '${NWANDER}', '${NFREQ}', '${NDISPER}');" |sqlite3 ntpstatus.sqlite -echo "INSERT INTO status (date, host, offset, freq, sjit, cjit, wander, disp) VALUES ('${DATE}', '${1}', '${NOFFSET}', '${NSJIT}', '${NCJIT}', '${NWANDER}', '${NFREQ}', '${NDISPER}');" +rm /tmp/ntp-rrdstats.$$ |