Myql montoring with graphs

[Nelson Amaral <namaral (at) fnot.org.uk>]

Hi,

I would like to monitor my mysql servers with hobbit with graphs to show trends, etc.

Does anyone know a good way to do this, i tried the one from the link below but it only gives me the values, i would really like the graphs.

http://www.phpprogrammer.co.nz/how-to-setup-hobbit-including-mysql-graphs

by the way hobbit is the perfect monitoring tool i just love it

Regards

Nelson Amaral

----- Original Message -----
From: "Kevin McAllister" <kevin (at) shadowsoft.com>
To: hobbit (at) hswn.dk
Sent: Thursday, 11 March, 2010 11:08:37 PM
Subject: [hobbit] Using Xymon to monitor the ink and toner levels in printers

Hello,

The scripts that I have for gathering this doesn't seem to be getting 
any data at all. I am new to this any help would be appreciated. I am 
running Centos 5.3 x86_64.  I have put a copy of the scripts in the email.

#!/bin/sh


#ink

#

#BIG BROTHER - monitor HP printer ink levels

#


HOSTIP=$1; export HOSTIP

HOST=$2; export HOST

VHOST=$3; export VHOST


InkTmp=$BBTMP/ink.$$; export InkTmp

COLOR="blue"; export COLOR

echo $COLOR > ${InkTmp}-color


URL="http://${HOSTIP}/SSI/device_status_info.htm";

echo "URL: $URL" > ${InkTmp}-2

echo "" >> ${InkTmp}-2


/usr/bin/curl -w "$SS_LOGCURL" -m 120 -H "Host: $VHOST" -G $URL > 
$InkTmp 2>> ${InkTmp}-2


#bit a monkeybusiness with COLOR here because the variable doesn't 
propagate back from the sub-shells


if test $? -eq 0

then

echo "" >> ${InkTmp}-2

COLOR="green"; export COLOR

$GREP CARTRIDGE $InkTmp | $SED -r 's/<[^>]*>|&nbsp;//g' | $SED 's/ 
CARTRIDGE/ _CARTRIDGE: /' | tee -a ${InkTmp}-2 | $SED 's/%//' | while 
read x

do

if test $COLOR != "red"

then

set $x

if test $2 -le 10

then

COLOR="yellow"

fi

fi

echo $COLOR > ${InkTmp}-color

done

fi


#

#THE FIRST LINE IS STATUS INFORMATION .....STRUCTURE IMPORTANT!

#THE REST IS FREE-FORM - WHATEVER YOU'D LIKE TO SEND ....

#

LINE="status ${HOST}.${TEST} `cat ${InkTmp}-color` `date`

<code>`cat ${InkTmp}-2`</code>"


$RM -f $InkTmp ${InkTmp}-2 ${InkTmp}-color


#NOW USE THE BB COMMAND TO SEND THE DATA ACROSS

$BB $BBDISP "$LINE" #SEND IT TO BBDISPLAY

++++++++++++++++++++++++++++++++++++++++++++++++++

#!/bin/sh


#toner

#

#BIG BROTHER - monitor HP printer ink levels

#


HOSTIP=$1; export HOSTIP

HOST=$2; export HOST

VHOST=$3; export VHOST


InkTmp=$BBTMP/toner.$$; export InkTmp

COLOR="blue"; export COLOR

echo $COLOR > ${InkTmp}-color


URL="http://${HOSTIP}/hp/device/this.LCDispatcher?nav=hp.DeviceStatus";

echo "URL: $URL" > ${InkTmp}-2

echo "" >> ${InkTmp}-2


/usr/bin/curl -w "$SS_LOGCURL" -m 120 -H "Host: $VHOST" -G $URL > 
$InkTmp 2>> ${InkTmp}-2


#bit a monkeybusiness with COLOR here because the variable doesn't 
propagate back from the sub-shells


if test $? -eq 0

then

echo "" >> ${InkTmp}-2

COLOR="green"; export COLOR

$GREP CARTRIDGE $InkTmp | $SED -r 's/<[^>]*>|&nbsp;//g' | $SED 's/ 
CARTRIDGE/ _CARTRIDGE: /' | tee -a ${InkTmp}-2 | $SED 's/%//' | while 
read x

do

if test $COLOR != "red"

then

set $x

if test $2 -le 10

then

COLOR="yellow"

fi

fi

echo $COLOR > ${InkTmp}-color

done

fi


#

#THE FIRST LINE IS STATUS INFORMATION .....STRUCTURE IMPORTANT!

#THE REST IS FREE-FORM - WHATEVER YOU'D LIKE TO SEND ....

#


LINE="status ${HOST}.${TEST} `cat ${InkTmp}-color` `date` <code> `cat 
${InkTmp}-2`</code>"


$RM -f $InkTmp ${InkTmp}-2 ${InkTmp}-color


#NOW USE THE BB COMMAND TO SEND THE DATA ACROSS

$BB $BBDISP "$LINE" #SEND IT TO BBDISPLAY






To unsubscribe from the hobbit list, send an e-mail to
hobbit-unsubscribe (at) hswn.dk