03-20-2009
Monitoring script (Ping, MySQL)
Hi guys - Relatively new to shell programming so please bare with me (I bet everyone says that!)
I'm faced with a problem:
I need a shell script to do the following:
- Connect to a MySQL database and pull all entrys from the nodes field in a table called 'nodes'
- These nodes will then be pinged every 2 minutes
- I need to take the ping response for each node and determine node status (Up or down) and packet loss value and send this back to a database table called 'nodeStatus' with fields node, nodeStatus, and packetLoss.
I need to do this to integrate this into a larger college project. I found a resource online with the following script which pings values from a HOSTS variable and emails on a report but I need to integrate a lot more functionaliy obviously. I'd apreciate if anyone has any pointers / tips on how to do the above.
HOSTS="google.com msn.com"
# no ping request
COUNT=1
# email report when
SUBJECT="Ping failed"
EMAILID="me@mydomain.com"
for myHost
in $HOSTS
do
count=$
(ping -c
$COUNT $myHost |
grep 'received' |
awk -F
',' '{ print $2 }' |
awk '{ print $1 }')
if [ $count -eq
0 ];
then
# 100% failed
echo "Host : $myHost is down (ping failed) at $(date)" | mail -s
"$SUBJECT" $EMAILID
fi
done
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
hello, I am looking to make a script that will ping a remote ip address. Upon completion of the ping I want the program to either ping again if the # of packets transmitted is equal to the number of packets received or exit if the two values are unequal and information was lost. I am not sure if I... (3 Replies)
Discussion started by: mcrosby
3 Replies
2. UNIX for Advanced & Expert Users
hi all,
i want to monitor mysql processes/threads/queries with respect to cpu usage.how can i do it?
show processlist is of no use as no information abt cpu usage is given.
plz help (7 Replies)
Discussion started by: rohitmahambre
7 Replies
3. Solaris
Hello, it is my first post :)
I need to implement some monitoring tools in a script, ping telnet traceroute
I found this one to ping, it works,
#!/bin/sh
for i in `cat /tmp/PingStatus.txt`
do
ping -c 5 -w 5 -n $i | grep -q "bytes from" && echo "$i is OK" || opcmsg object=PING a=OS... (5 Replies)
Discussion started by: marmellata
5 Replies
4. Shell Programming and Scripting
Hi,
I develop simple animation ping script on Solaris Platform. It is like Cisco ping.
Examples and source code are below.
bash-3.00$ gokcell 152.155.180.8 30
Sending 30 Ping Packets to 152.155.180.8
!!!!!!!!!!!!!.!!!!!!!!!!!!!!!.
% 93.33 success... % 6.66 packet loss...... (1 Reply)
Discussion started by: gokcell
1 Replies
5. Shell Programming and Scripting
Hi. I have a server with multiple network ports that need to be tested to a list of destinations. I'm trying to write a scripts to automate this but can't seem to get past an error and could use some help.
I have two test files one contains the ip addresses of the onboard NICs and the other... (10 Replies)
Discussion started by: mikez104
10 Replies
6. Infrastructure Monitoring
Hello,
Can somebody suggest me any Free monitoring utility (preferably GUI) for Mysql DB(community edition).
What i am looking at is something that can give me a trend of DB performance and suggest when to upgrade or add more DB resources to existing infra.
Note - I tried mtop. but it... (3 Replies)
Discussion started by: Hari_Ganesh
3 Replies
7. Shell Programming and Scripting
HI,
I have a file serverlist in that all host names are placed.
i have written a small script
#./testping
#! /bin/bash
for i in `cat serverlist`
do
ping $i >> output.txt
done
so now it creates a file output.txt till here fine..
now each time i run this script the output file... (4 Replies)
Discussion started by: madhudeva
4 Replies
8. Shell Programming and Scripting
hello fellows,
I need help with a script, I'm using this one
HOSTS="192.168.10.9 192.168.10.15 "
SUBJECT="Attention - Gateway San Martin DOWN "
COUNT=1
EMAILID="lmail@mydomain.com"
for myHost in $HOSTS
do
count=$(ping -c $COUNT $myHost | grep 'received' | awk -F',' '{ print $2... (2 Replies)
Discussion started by: lucas.fradusco
2 Replies
9. Shell Programming and Scripting
I have a question is there any posibility for writing a script that you can see if a pc in your network is up of down , when you run this script for ex. ./test.sh 63 45 54 , which are the ip adresses of the computers , when you give the last digit of the ip adres as argument
63 , 45 and 54 are... (5 Replies)
Discussion started by: Roggy
5 Replies
10. Programming
help with bash script!
im am working on this script to make sure my server will stay online, so i made this script..
HOSTS="192.168.138.155"
COUNT=4
pingtest(){
for myhost in "$@"
do
ping -c "$COUNT" "$myhost" &&return 1
done
return 0
}
if pingtest $HOSTS
#100% failed... (4 Replies)
Discussion started by: mort3924
4 Replies