[hobbit] mysql connections

[Jones, Jason (Altrincham)]

"Our test script provides data that goes up and down in value (it is the
number of bytes of memory used for a Linux kernel bufffer), and for that
kind of data we'll use the RRD GAUGE datatype. So we add an extra
setting to hobbitserver.cfg:

 
        NCV_slab="inodecache:GAUGE,dentrycache:GAUGE"
This tells the hobbitd_rrd module that it should create an RRD file with
two datasets of type GAUGE instead of the default (DERIVE). The setting
must be named NCV_<columnname>." - from help > custom graphs
 
If you do this then it should work properly
Jason.

 

________________________________

From: Sabeer MZ [mailto:sabeer.mz at gmail.com] 
Sent: 06 March 2007 10:19
To: hobbit at hswn.dk
Subject: Re: [hobbit] mysql connections

 


I am not getting data on my graphs. How to clear the old mysql.rrd and
create a new one ?

pls find below mysql entries on hobbitserver.cfg and let me know if i
have to add anything.
I am using hobbit Hobbit Monitor 4.3.0-20061124
<http://hobbitmon.sourceforge.net/> 

[hobbit at abc etc]$ grep mysql hobbitserver.cfg

TEST2RRD="cpu=la,disk,inode,qtree,memory,$PINGCOLUMN=tcp,http=tcp,dns=tc
p, 
dig=tcp,time=ntpstat,vmstat,iostat,netstat,temperature,apache,bind,sendm
ail,mailq,
nmailq=mailq,socks,bea,iishealth,citrix,bbgen,bbtest,bbproxy,hobbitd,fil
es,procs=processes,
ports,clock,lines",mysql=ncv" 

GRAPHS="la,mysql,disk,inode,qtree,files,processes,memory,users,vmstat,io
stat,tcp.http,
tcp,ncv,netstat,ifstat,mrtg::1,ports,temperature,ntpstat,apache,bind,sen
dmail,mailq,socks,
bea,iishealth,citrix,bbgen,bbtest,bbproxy,hobbitd,clock,lines" 

thanks
Sabeer MZ

On 3/6/07, Jones, Jason (Altrincham) <JasonAS_Jones at mentor.com> wrote: 

One other thing is that I'm mostly half sure that you will want GAUGE
data types not DERIVE since derive assumes the value will always 
increase (I can't remember why this is the case) whereas gauge can
increase and decrease.  What changes have you made to hobbitserver.cfg
for this test?

Jason.

-----Original Message-----
From: Stef Coene [mailto: stef.coene at docum.org]
Sent: 06 March 2007 08:32
To: hobbit at hswn.dk
Subject: Re: [hobbit] mysql connections

On Tuesday 06 March 2007 06:44, Sabeer MZ wrote: 
> good suggestion. i got one more clue.-
>
> Use of uninitialized value in concatenation (.) or string at
> bb-mysql.plline 119.
>   "config bb-mysql.cfg-"sh: config bb-mysql.cfg-: command not found
>
> this is showing that BB/Hobbit variables are not set.
> So Where is the soure profile that We need to execute to get these
> variables.
> or how to set bb/hobbit env varibales. 
The hobbit variables are set with the "bbcmd" command.  That's why you
have to
execute "../bin/bbcmd perl bb-mysql.pl".

For the error, on line 119, you will find "system($cmd);".  You can add 
the
line "print $cmd" before this line.  This will print the command that
will be
executed when you run the script.  Check the command for errors or
missing
options.


Stef

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



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






-- 
Warm Regards
Sabeer MZ 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.xymon.com/pipermail/xymon/attachments/20070306/e772dec8/attachment.html>