12-04-2008
Thanks for all your help guys, here is what I have done so far
1 - a check-hosts script that uses a host-list.txt to ping konwn hosts
./check-hosts (script that pings hosts and generates the ping-results.txt)
rm -f ping-results.txt
cat hosts-list.txt |\
while read line
do
echo . >> ping-results.txt
date >> ping-results.txt
ping -c 5 -q $line >> ping-results.txt
echo $line
done
2 - host-list.txt
Host11
Host12
Host13
Host14
3 - I have modified the awk script (named extract-sla) from Zaxxon's response to read like this
awk '
/^PING / {h=$2}
/packet loss/ {pl=$6}
/min\/avg\/max/ {
split($4,a,"/")
printf("%s %s %s %s\n", h, a[2], a[4], pl )
}
' ping-results.txt
4 - Here is the new output from the results (which I can store into a file)
Host11 56.817 8.520 0%
Host12 55.031 8.485 0%
Host13 72.351 40.053 0%
Host14 32.590 9.705 0%
** Is there a way to get rid of the % sign since we already know it's a percentage.
5 - I would like to input these numbers into a database with a mysql command (the database and tables are already created)
Hostxx a b c
mysql -h 10.255.1.11 -u ping --password='ping' -D host_SLA -e "UPDATE device_list SET latency=a, jitter=b, loss=c WHERE host='Hostxx'";
Thanks for all your responses
9 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
if i wanted to ping all the machines in a given directory (/etc/hosts) and return a total count of responses how would i go about scripting that?
complete newbie...so be gentle
if ; then //$1 = /etc/hosts
cd "$1"
//this puts me into the directory i need...but how do i send ... (2 Replies)
Discussion started by: trostycp
2 Replies
2. Shell Programming and Scripting
I would have searched for this but I couldn't really think of what to use for the search text...
I've got a situation where I need to automate responses to an executable when running it from a script so that it can be made into a job the operators don't have to interact with. When I run it... (2 Replies)
Discussion started by: djp
2 Replies
3. Linux
Unfortunately googling the word 'chat' gives you zebedee billion responses that relate to everything and few of them refer to the linux chat command. I've read the man page and found a couple of examples but can't see how to do this.
I want to query the modem for it's manufacturer, product id... (8 Replies)
Discussion started by: Bashingaway
8 Replies
4. Shell Programming and Scripting
Hello,
I am trying to count how many times a subject makes a correct switch or a correct stay response in a simple task. I have data on which condition they were in (here, labeled "IMAGINE" and "RECALL"), as well as whether they made a left or right button response, and whether the outcome was... (5 Replies)
Discussion started by: Jahn
5 Replies
5. Shell Programming and Scripting
Hello Everyone,
Below is the output of the ping from a router. Please help with a script which extract the Avg value from the o/p (Avg here = 4, as depicted below) and put the value into a new file.
Will appreciate your help dearly
Router#ping 36.36.36.36
Type escape sequence to abort.... (2 Replies)
Discussion started by: sanjugab
2 Replies
6. AIX
(5 Replies)
Discussion started by: Vishal_dba
5 Replies
7. IP Networking
Hey everyone,
Okay, so I've been having some fun with the dig command, and wanted to dig my old school. Two questions came up from this. So I:
dig @8.8.8.8 +recurse njcu.edu ANY
and the result is about 8 records, including the SOA record. One of them is this weird TXT record, and the other is... (1 Reply)
Discussion started by: Lost in Cyberia
1 Replies
8. Shell Programming and Scripting
So first: Sorry if the title is confusing...
I have a script I'm writing with a file with several names in it (some other info - but it's not really pertinent...) - I want to be allow the user to delete certain records, but I ran into a problem I'm not sure how to go about fixing.
If I were... (6 Replies)
Discussion started by: sabster
6 Replies
9. UNIX for Beginners Questions & Answers
In this script:
#!/bin/bash
# bird
read -p "Enter name of a bird "
REPLY=$REPLY
birdname="duck sparrow hawk"
for i in $birdname
do
if ]
then
echo "Yes, that is a bird."
else
echo "That is not a bird."
fi
done
I get... (9 Replies)
Discussion started by: Xubuntu56
9 Replies
LEARN ABOUT CENTOS
ocf_pacemaker_ping
OCF_PACEMAKER_PING(7) Pacemaker Configuration OCF_PACEMAKER_PING(7)
NAME
ocf_pacemaker_ping - node connectivity
SYNOPSIS
[OCF_RESKEY_pidfile=string] [OCF_RESKEY_dampen=integer] [OCF_RESKEY_name=string] [OCF_RESKEY_multiplier=integer]
[OCF_RESKEY_host_list=string] [OCF_RESKEY_attempts=integer] [OCF_RESKEY_timeout=integer] [OCF_RESKEY_options=string]
[OCF_RESKEY_failure_score=integer] [OCF_RESKEY_debug=string] ping [start | stop | reload | monitor | meta-data | validate-all]
DESCRIPTION
Every time the monitor action is run, this resource agent records (in the CIB) the current number of ping nodes the host can connect to. It
is essentially the same as pingd except that it uses the system ping tool to obtain the results.
SUPPORTED PARAMETERS
OCF_RESKEY_pidfile = string [/ping-]
PID file
OCF_RESKEY_dampen = integer [5s]
Dampening interval
The time to wait (dampening) further changes occur
OCF_RESKEY_name = string [pingd]
Attribute name
The name of the attributes to set. This is the name to be used in the constraints.
OCF_RESKEY_multiplier = integer []
Value multiplier
The number by which to multiply the number of connected ping nodes by
OCF_RESKEY_host_list = string []
Host list
The list of ping nodes to count.
OCF_RESKEY_attempts = integer [2]
no. of ping attempts
Number of ping attempts, per host, before declaring it dead
OCF_RESKEY_timeout = integer [2]
ping timeout in seconds
How long, in seconds, to wait before declaring a ping lost
OCF_RESKEY_options = string []
Extra Options
A catch all for any other options that need to be passed to ping.
OCF_RESKEY_failure_score = integer []
failure_score
Resource is failed if the score is less than failure_score. Default never fails.
OCF_RESKEY_debug = string [false]
Verbose logging
Enables to use default attrd_updater verbose logging on every call.
AUTHOR
Andrew Beekhof <andrew@beekhof.net>
Author.
Pacemaker Configuration 06/10/2014 OCF_PACEMAKER_PING(7)