Interesting you should say that. I have both http and ftp, but at this time all I get is: fileserver (10.136.209.164) - ftp:green:1h14m

I¹ve been trying different things for the http, with no luck. I do a wget http://fileserver to make sure it works, and it does. I¹ll check and see if its generatign the rrd...

On 27/05/09 10:01 AM, "Scot Kreienkamp" <SKreien at la-z-boy.com> wrote:

It might not be sending in the format that Hobbit needs. Is it creating the RRD¹s?

Thanks,

Scot Kreienkamp

From: Cayo de Moraes [mailto:camorae at googlemail.com] Sent: Wednesday, May 27, 2009 5:06 AM To: hobbit at hswn.dk Subject: [hobbit] Problem with external script and RRD-Graphs

Hi guys,

im trying to monitor some mysql performances like slowqueries, threads, queries per second, etc. trought an external script. So far i get all results from the client (Big Brother-Client) unless the graphs. Using big brother (server) i get 3 graphs (slowqueries, threads and queries per second) but after migrating BB to Hobbit i cant get any graph anymore. I already did all steps from "How to setup custom graphs" but its not working.

Did i forget something / did something wrong or is it with the BB-Client not possible?

After editing the hobbitserver.cfg and hobbitgraph.cfg i had some confrontations with:

how should i configure the parameters of the hobbitserver.cfg and hobbitgraph.cfg if i want 3 diferent graphs in one page, when the graph name has to be the same as the column name?

when trying to get the only graph into the browser i get only an 1x1 Pixel graph...

has anybody any idea??

TIA

-- This message has been scanned for dangerous content by MailScanner, and is believed to be clean.

Hi Scot,

after I tried to solve this problem in many diferent ways, hobbit does create only one RRD file (supposed to create 3 diferents, but this is not the main problem). When i try to get the graph directly in my browser, i only get a 1x1 pixel graph.

I think i will test Tom's solution. It could work!

2009/5/27 Scot Kreienkamp <SKreien at la-z-boy.com>

It might not be sending in the format that Hobbit needs. Is it creating the RRD’s?

Thanks,

Scot Kreienkamp

*From:* Cayo de Moraes [mailto:camorae at googlemail.com] *Sent:* Wednesday, May 27, 2009 5:06 AM *To:* hobbit at hswn.dk *Subject:* [hobbit] Problem with external script and RRD-Graphs

Hi guys,

im trying to monitor some mysql performances like slowqueries, threads, queries per second, etc. trought an external script. So far i get all results from the client (Big Brother-Client) unless the graphs. Using big brother (server) i get 3 graphs (slowqueries, threads and queries per second) but after migrating BB to Hobbit i cant get any graph anymore. I already did all steps from "How to setup custom graphs" but its not working.

Did i forget something / did something wrong or is it with the BB-Client not possible?

After editing the hobbitserver.cfg and hobbitgraph.cfg i had some confrontations with:

how should i configure the parameters of the hobbitserver.cfg and hobbitgraph.cfg if i want 3 diferent graphs in one page, when the graph name has to be the same as the column name?

when trying to get the only graph into the browser i get only an 1x1 Pixel graph...

has anybody any idea??

TIA

.. please send it also to the list :-)

martin

On Thu, 28 May 2009, Cayo de Moraes wrote:

Hi Tom,

oh plz!!! send it to me! it could be a big step for me when the first graph is working!

I tought if im able only to generate the RRD files, i can manually call them all (html-codes) in the bb-mysqlstat.sh. It was the solution for Big-Brother and it was working so far.

thank you guys for your support!

2009/5/27 Brand, Thomas R. <TRBrand at cvs.com>

...

...

After editing the hobbitserver.cfg and hobbitgraph.cfg i had some confrontations with:

how should i configure the parameters of the hobbitserver.cfg and hobbitgraph.cfg if i want 3 diferent

...

graphs in one page, when the graph name has to be the same as the column name?

when trying to get the only graph into the browser i get only an 1x1 Pixel graph...

I can?t help with the multiple graphs on one page; I have mine set up for one graph on the page.

If you?re intererested, I can send you my version of bb-mysqlstat.sh (heavily modified from the one available on Deadcat.net ?. )

Here are the relevant parts from hobbitserver.cfg:

NCV_mysql="Threads:GAUGE,SlowQueries:GAUGE,OpenTables:GAUGE,FlushTables:NONE,Questions:NONE,Opens:NONE,AvgQuerysPerSecond:NONE,Uptime:NONE,FreeBufferPool:NONE"

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

Here is the stanza from my hobbitgraph.cfg for the mysql graphs:

[mysql]

    TITLE MySQL Statistics

    YAXIS Number of

    DEF:threads=mysql.rrd:Threads:AVERAGE

    DEF:slow=mysql.rrd:SlowQueries:AVERAGE

    DEF:opentables=mysql.rrd:OpenTables:AVERAGE

    LINE2:threads#FF0000:Threads

    LINE2:slow#00CCCC:Slow Queries

    LINE2:opentables#FF00FF:Open Tables

    COMMENT:\n

    GPRINT:threads:LAST:Threads     \: %5.1lf (cur)

    GPRINT:threads:MAX: \: %5.1lf (max)

    GPRINT:threads:MIN: \: %5.1lf (min)

    GPRINT:threads:AVERAGE: \: %5.1lf (avg)\n

    GPRINT:slow:LAST:Slow Queries\: %5.1lf (cur)

    GPRINT:slow:MAX: \: %5.1lf (max)

    GPRINT:slow:MIN: \: %5.1lf (min)

    GPRINT:slow:AVERAGE: \: %5.1lf (avg)\n

    GPRINT:opentables:LAST:Open Tables \: %5.1lf (cur)

    GPRINT:opentables:MAX: \: %5.1lf (max)

    GPRINT:opentables:MIN: \: %5.1lf (min)

    GPRINT:opentables:AVERAGE: \: %5.1lf (avg)\n

The client side extension script sends up the information which is then displayed as: *Wed May 27 10:12:53 EDT 2009 - mySQL is OK*

Threads : 10

Slow Queries : 1

Open Tables : 89

Flush Tables : 1

Questions : 83279

Opens : 94

AvgQuerysPerSecond : 2.455

Uptime : 33923

Free Buffer Pool : 62

Hope this helps,

*Tom Brand*

*CVS/pharmacy*

*IS Rx SysAdmin Store Support*

---

*From:* Cayo de Moraes [mailto:camorae at googlemail.com] *Sent:* Wednesday, May 27, 2009 5:06 AM *To:* hobbit at hswn.dk *Subject:* [hobbit] Problem with external script and RRD-Graphs

Hi guys,

im trying to monitor some mysql performances like slowqueries, threads, queries per second, etc. trought an external script. So far i get all results from the client (Big Brother-Client) unless the graphs. Using big brother (server) i get 3 graphs (slowqueries, threads and queries per second) but after migrating BB to Hobbit i cant get any graph anymore. I already did all steps from "How to setup custom graphs" but its not working.

Did i forget something / did something wrong or is it with the BB-Client not possible?

After editing the hobbitserver.cfg and hobbitgraph.cfg i had some confrontations with:

how should i configure the parameters of the hobbitserver.cfg and hobbitgraph.cfg if i want 3 diferent graphs in one page, when the graph name has to be the same as the column name?

when trying to get the only graph into the browser i get only an 1x1 Pixel graph...

has anybody any idea??

TIA

Gruss

    Martin Flemming

Martin Flemming DESY / IT office : Building 2b / 008a Notkestr. 85 phone : 040 - 8998 - 4667 22603 Hamburg mail : martin.flemming at desy.de