[hobbit] mysql connections

[Sabeer MZ]

Dear all,

Any comments on below errors. I am not able to see graphs for the data
coming.
And I see below errors on /var/log/hobbit/rrd-stastus.log

2007-03-05 02:34:05 RRD error updating
/home/hobbit/data/rrd/abx.acc.com/mysql.rrd from 147.183.128.102: not a
simple integer: '13.617'
2007-03-05 02:34:16 RRD error updating
/home/hobbit/data/rrd/abcx.abccom/mysql.rrd from 147.183.128.98: not a
simple integer: '106.435'
2007-03-05 02:35:16 RRD error updating
/home/hobbit/data/rrd/abc.abc.com/mysql.rrd from 147.183.128.98: not a
simple integer: '106.435'

thanks
Sabeer MZ

On 3/2/07, Sabeer MZ <sabeer.mz at gmail.com> wrote:
>
> Hi all,
>
> Thanks. Finally i am able to run the perl script and getting the results
> in the hobbit server.
>
> one issue: my graphs are not coming. pls find below rrd-staus.log error
> details ...
>
> 2007-03-02 02:28:24 RRD error updating
> /home/hobbit/data/rrd/tor.abc.com/mysql.rrd from 64.88.160.214: not a
> simple integer: '0.024'
> 2007-03-02 02:32:51 RRD error updating
> /home/hobbit/data/rrd/jacc3.zbc.com/mysql.rrd from 147.183.128.102 : not a
> simple integer: '13.910'
> 2007-03-02 02:38:25 RRD error updating
> /home/hobbit/data/rrd/abc.example.com/mysql.rrd from 64.88.160.214: not a
> simple integer: '0.024 '
> 2007-03-02 02:42:53 RRD error updating
> /home/hobbit/data/rrd/abc.exam.com/mysql.rrd from 147.183.128.102: not a
> simple integer: '13.908'
>
> Thanks
> Sabeer MZ
>
> On 3/1/07, Dominique Frise <Dominique.Frise at unil.ch> wrote:
> >
> > Sabeer MZ wrote:
> > > Hi all,
> > >
> > > cloud anyone help me why there is no graphs showing for me.
> > > I am trying to monitor mysql connections using bb-mysql.pl.
> > >
> > >
> > > 1. /etc/bb-hosts
> > > hostname TRENDS:*,mysql:mysqlslow,mysqlthread
> > >
> > > 2. 3 entries for mysql at hobbitserver.cfg
> > >
> > > TEST2RRD="cpu=la,disk,------cut--------,ports,clock,lines",mysql=ncv"
> > >
> > > GRAPHS="la,mysql,disk,-------cut-------clock,lines"
> > >
> > > NCV_mysql="Uptime:NONE,Queriespersecondavg:GAUGE,Slowqueries:GAUGE"
> > >
> > > 3. my hobbitgraph.cfg
> > >
> > > [mysqlslow]
> > >         DEF:slow=mysql.rrd:Slowqueries:AVERAGE
> > >         TITLE MySQL Slow Queries
> > >         YAXIS #
> > >         LINE2:slow#00CCCC:Slow Queries
> > >         COMMENT:\n
> > >         GPRINT:slow:LAST: \: %5.1lf (cur)
> > >         GPRINT:slow:MAX: \: %5.1lf (max)
> > >         GPRINT:slow:MIN: \: %5.1lf (min)
> > >         GPRINT:slow:AVERAGE: \: %5.1lf (avg)\n
> > >
> > > [mysqlthread]
> > >         DEF:threads= mysql.rrd:Threads:AVERAGE
> > >         TITLE MySQL Active Threads
> > >         YAXIS #
> > >         AREA:threads#00CCCC:Threads
> > >         COMMENT:\n
> > >         GPRINT:threads:LAST: \: %5.1lf (cur)
> > >         GPRINT:threads:MAX: \: %5.1lf (max)
> > >         GPRINT:threads:MIN: \: %5.1lf (min)
> > >         GPRINT:threads:AVERAGE: \: %5.1lf (avg)\n
> > >
> > >
> > > --
> > > Warm Regards
> > > Sabeer MZ
> >
> > Double-check your settings using the documentation from your Hobbit
> > installation at
> > http|https://$BBSERVERWWWNAME/$BBSERVERWWWURL/help/howtograph.html
> >
> > or use Henrik's:
> >
> > http://www.hswn.dk/hobbit/help/howtograph.html
> >
> >
> >
> > Dominique
> > UNIL - University of Lausanne
> >
> > To unsubscribe from the hobbit list, send an e-mail to
> > hobbit-unsubscribe at hswn.dk
> >
> >
> >
>
>
> --
> Warm Regards
> Sabeer MZ




-- 
Warm Regards
Sabeer MZ
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.xymon.com/pipermail/xymon/attachments/20070305/4053f7cb/attachment.html>