[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [hobbit] graphs with external script



Hi ..

I'm using 2 versions of hobbit today (09/06) snapshot and 4.1.1.

Is anybody could just answer me what can be wrong in my setting ? I have
my rrd files updated, got "mysql" section on trends columns.. All seems
ok there.


hobbit-cgi/hobbitgraph.sh?host=test-sql.cvf&service=disk&graph_width=576&graph_height=120&first=1&count=1&disp=sms%2test-sql%2ecvf&graph=hourly&action=view

==> show me disk trends

hobbit-cgi/hobbitgraph.sh?host=test-sql.cvf&service=mysql&graph_width=576&graph_height=120&first=1&count=1&disp=sms%2test-sql%2ecvf&graph=hourly&action=view

==> "Unknown graph requested"

(I have [mysqlslow] & [mysqlthread] in my hobbitgraph.cfg)


Please... I have checked many many many times all my config and still
not see where i could make a mistake. 

Maybe a bug ?

Heeeeelp

rgds,

Etienne

> Hi,
> 
> sorry for boring everybody with my problem..
> 
> But i made all check that  i can and i 'm still not able to get graphs...
> 
> I can get my rrd file up to date with NCV module but _no_ graphs ..
> 
> 
> Etienne
> 
> >Hi,
> >
> >i've checked ont more time my setting and still see where i made a
> >mistake...
> >
> >I use this night snapshot, my rrd files  are updated as i can see :
> >
> >
> >2005-08-29 11:11:36 RRD update param 00: 'rrdupdate'
> >2005-08-29 11:11:36 RRD update param 01:
> >'/usr2/hobbit/data/rrd/sql-test.cvf/mysql.rrd'
> >2005-08-29 11:11:36 RRD update param 02: '-t'
> >2005-08-29 11:11:36 RRD update param 03:
> >'Threads:Questions:Slowqueries:Opens:Flushtables:Opentables:Queriespersecondavg'
> >2005-08-29 11:11:36 RRD update param 04:
> >'1125306696:177:370689709:824:30520:3:512:70.571'
> >
> >I think it's all right to this point.
> >
> >As i can see in man page or on this ML i've add :
> >
> >to catch result from client test:
> >
> >TEST2RRD="cpu=la,disk,inode,qtree,memory,mysql=ncv...."
> >
> >NCV_mysql="Uptime:NONE,Queriespersecondavg:GAUGE,Slowqueries:GAUGE"
> >
> >and to have graphs on the trends column :
> >
> >GRAPHS="mysql,la,disk...
> >
> >In hobbitgraph.cfg
> >
> >i have 
> >
> >[mysqlslow]
> >        DEF:slow=mysql.rrd:Slowqueries:AVERAGE
> >        TITLE MySQL Slow Queries
> >        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
> >        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
> >
> >
> >
> >In my bb-hosts:
> >
> >10.1.1.8  sql-test.cvf       # noping
> >TRENDS:*,mysql:mysqlslow,mysqlthread
> >
> >No SQL graphs on the page ...
> >
> >a "hobbit graphs mysqlslow"
> >
> >HREF="/hobbit-cgi/hobbitgraph.sh?host=test-sql.cvf&amp;service=mysqlslow&amp;graph_width=576&amp;graph_height=120&amp;first=1&amp;count=1&amp;disp=%2dtest-sql%2efr&amp;action=menu"><IMG
> >
> >I think i should have "service=mysql" and not "service=mysqlslow" ?
> >
> >Am i so wrong ?
> >
> >Rgds,
> >
> >Etienne
> >
> >
> >
> >On Fri, 2005-08-26 at 19:50 +0200, Etienne Roulland wrote:
> >  
> >
> >>Oupps last mail was sent a little bit  quickly.
> >>
> >>The Henrik post on GRAPHS
> >>
> >>http://www.hswn.dk/hobbiton/2005/06/msg00268.html
> >>
> >>Regards,
> >>
> >>Etienne
> >>
> >>    
> >>
> >>>>Options in bb-hosts for this box
> >>>>
> >>>># noping GRAPHS:*,mysql:mysqlslow,mysqlthread
> >>>>   
> >>>>
> >>>>        
> >>>>
> >>>i don't think GRPAHS works in bb-hosts, it's named TRENDS in the man
> >>>
> >>>
> >>> 
> >>>
> >>>      
> >>>
> >>>>in hobbitserver.cfg
> >>>>
> >>>>GRAPHS="la,mysql,disk,inode,qtree,memory,users,.......[...]
> >>>>   
> >>>>
> >>>>        
> >>>>
> >>>add mysqlslow,mysqlthread in this line
> >>>
> >>>
> >>>Olivier
> >>>
> >>>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
> >>
> >>
> >>    
> >>
> 
> 
> To unsubscribe from the hobbit list, send an e-mail to
> hobbit-unsubscribe (at) hswn.dk
> 
> 
-- 
Etienne Roulland -- CVF Bordeaux