Help with graphing 🔗 link

Hi all

Any help appreciated here.

I was trying to create a custom graph of database tablespace
utilization.
I was getting some input from the clients, which my external script was
eventually reducing to this.
---snip---
DS:siebprod.XDB:GAUGE:600:0:100
DS:siebprod.WHS_INDEX:GAUGE:600:0:100
DS:siebprod.WHS_DATA:GAUGE:600:0:100
DS:siebprod.USERS:GAUGE:600:0:100
DS:siebprod.UNDOTBS1:GAUGE:600:0:100
DS:siebprod.TOOLS:GAUGE:600:0:100
DS:siebprod.SYSTEM:GAUGE:600:0:100
DS:siebprod.SIEB_INDEX:GAUGE:600:0:100
DS:siebprod.SIEB_DATA:GAUGE:600:0:100
DS:siebprod.LOADER_DATA:GAUGE:600:0:100
tablespace.rrd
0:71:78:1:26:66:69:81:84:0 
---snip---

No worries so far, except no .rrd file was created.
I checked the logs, and found 
---snip---
2005-05-06 11:36:30 RRD error creating
/var/lib/hobbit/rrd/aufin2/tablespace.rrd: can't parse argument
'DS:siebprod.XDB:GAUGE:600:0:100'
---snip---
It was getting stuck on the first row.

On a hunch, I changed the output from database.tablename to
database_tablename, so my output looked like this.
---snip---
DS:siebprod_XDB:GAUGE:600:0:100
DS:siebprod_WHS_INDEX:GAUGE:600:0:100
DS:siebprod_WHS_DATA:GAUGE:600:0:100
DS:siebprod_USERS:GAUGE:600:0:100
DS:siebprod_UNDOTBS1:GAUGE:600:0:100
DS:siebprod_TOOLS:GAUGE:600:0:100
DS:siebprod_SYSTEM:GAUGE:600:0:100
DS:siebprod_SIEB_INDEX:GAUGE:600:0:100
DS:siebprod_SIEB_DATA:GAUGE:600:0:100
DS:siebprod_LOADER_DATA:GAUGE:600:0:100
tablespace.rrd
0:71:78:1:26:66:69:81:84:0 
---snip---

Still nothing in the .rrd file, but the logs now showed this.

---snip---
2005-05-06 12:01:30 RRD error creating
/var/lib/hobbit/rrd/aufin2/tablespace.rrd: can't parse argument
'DS:siebprod_LOADER_DATA:GAUGE:600:0:100'
---snip---

The last line!
I thought stuff-it, I can do without the last line, and took it out with
a grep -v
All of a sudden, I had my tablespace.rrd Woohoo!

I left it for an hour, and came back from lunch hoping to find a lovely
graph.
No dice. 

All I get is a link to a graph, and the link gives me 4 (empty) links to
the history graphs. No graphs appeared.

My hobbitgraph.cfg entry for this looks like this.

---snip---
[ora9-sga]
        FNPATTERN tablespace(.*).rrd
        TITLE TableSpace Utilization
        YAXIS % Full
        DEF:p at RRDIDX@=@RRDFN@:pct:AVERAGE
        LINE2:p at RRDIDX@#@COLOR@:@RRDPARAM@
        -u 100
        -l 0
        GPRINT:p at RRDIDX@:LAST: \: %5.1lf (cur)
        GPRINT:p at RRDIDX@:MAX: \: %5.1lf (max)
        GPRINT:p at RRDIDX@:MIN: \: %5.1lf (min)
        GPRINT:p at RRDIDX@:AVERAGE: \: %5.1lf (avg)\n

---snip---

and the hobbitserver.cfg looks like this

---snip---
LARRDS="cpu=la,disk,inode,qtree,memory,ora9-sga,vmio,$PINGCOLUMN=tcp,htt
p=tcp,dns=tcp,dig=tcp,time=ntpstat,vmstat,iostat,netstat,temperature,apa
che,bind,sendmail,nmailq,socks,bea,iishealth,citrix,bbgen,bbtest,bbproxy
,hobbitd"

GRAPHS="la,disk,inode,qtree,memory,users,vmstat,iostat,tcp.http,tcp,nets
tat,mrtg::1,temperature,ntpstat,apache,bind,sendmail,nmailq,socks,bea,ii
shealth,citrix,bbgen,bbtest,bbproxy,hobbitd,ora9-sga,vmio"
---snip---

What am I missing?

Right now I will settle for any advice that will get the graphs to
display.
However I am curious about the "couldn't parse" logs.
Any ideas?

Cheers
    Vernon
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

NOTICE: This message and any attachments are confidential and may contain copyright material 
of Australian Finance Group Limited or a third party. It is intended solely for the purpose of the 
addressee and any other named recipient. If you are not the intended recipient, any use, 
distribution, disclosure or copying of this message is strictly prohibited. The confidentiality attached 
to this message is not waived or lost by reason of the mistaken transmission or delivery to any 
unintended party. If you have received this message in error, please notify the author immediately 
or contact Australian Finance Group on +61 8 9420 7888.

On Fri, May 06, 2005 at 02:45:29PM +0800, Vernon Everett wrote:

/var/lib/hobbit/rrd/aufin2/tablespace.rrd: can't parse argument
'DS:siebprod.XDB:GAUGE:600:0:100'

[snip]

/var/lib/hobbit/rrd/aufin2/tablespace.rrd: can't parse argument
'DS:siebprod_LOADER_DATA:GAUGE:600:0:100'

I'd advise anyone trying to do custom graphs to read the "rrdcreate"
man-page from RRDtool. Here you'll find this:

    A ds-name must be 1 to 19 characters long in the 
    characters [a-zA-Z0-9_].


[no graphs show up]

The DEF: line here is wrong. The "pct" here is the name of the dataset
you want to graph - the same string that you use in the "DS:" definition
of the RRD file. So to get a graph of the siebprod_XDB data, you should
have
          DEF:p at RRDIDX@=@RRDFN@:siebprod_XDB:AVERAGE
          LINE2:p at RRDIDX@#@COLOR@:@RRDPARAM@

If you want to graph more than one dataset in a single image, you just 
add more DEF and LINE entries - but make sure you keep a unique name for
each of the DEF's you define. E.g.

          DEF:whsidx at RRDIDX@=@RRDFN@:siebprod_WHS_INDEX:AVERAGE
          DEF:whsdata at RRDIDX@=@RRDFN@:siebprod_WHS_DATA:AVERAGE
          LINE2:whsidx at RRDIDX@#@COLOR@:@RRDPARAM@
          LINE2:whsdata at RRDIDX@#@COLOR@:@RRDPARAM@

But that is usually not a good idea when you are also combining multiple
RRD files into one graph.


Regards,
Henrik

Hi Henrik

Thanks
This helped me a lot. I got the graph working, but it's very busy.
I need to split this over 2, or even 3 graphs.
However, before I bug you any more, I would love to RTFM, as you say.

However, I found this. :-(

---snip---
Not Found

The requested URL /hobbit/help/manpages/man1/rrdcreate.1.html was not
found on this server.
Apache/2.0.54 (Debian GNU/Linux) PHP/4.3.10-13 mod_ssl/2.0.54
OpenSSL/0.9.7e user-0b6b1e38fa24@xymon.invalid Port 80
---snip---

If you get the time, could you repair it?

Cheers, and thanks
    Vernon

-----Original Message-----
From: Henrik Stoerner [mailto:user-ce4a2c883f75@xymon.invalid] 
Sent: Friday, 6 May 2005 4:02 PM
To: user-ae9b8668bcde@xymon.invalid
Subject: Re: [hobbit] Help with graphing

On Fri, May 06, 2005 at 02:45:29PM +0800, Vernon Everett wrote:

[snip]

I'd advise anyone trying to do custom graphs to read the "rrdcreate"
man-page from RRDtool. Here you'll find this:

    A ds-name must be 1 to 19 characters long in the 
    characters [a-zA-Z0-9_].


[no graphs show up]

The DEF: line here is wrong. The "pct" here is the name of the dataset
you want to graph - the same string that you use in the "DS:" definition
of the RRD file. So to get a graph of the siebprod_XDB data, you should
have
          DEF:p at RRDIDX@=@RRDFN@:siebprod_XDB:AVERAGE
          LINE2:p at RRDIDX@#@COLOR@:@RRDPARAM@

If you want to graph more than one dataset in a single image, you just 
add more DEF and LINE entries - but make sure you keep a unique name for
each of the DEF's you define. E.g.

          DEF:whsidx at RRDIDX@=@RRDFN@:siebprod_WHS_INDEX:AVERAGE
          DEF:whsdata at RRDIDX@=@RRDFN@:siebprod_WHS_DATA:AVERAGE
          LINE2:whsidx at RRDIDX@#@COLOR@:@RRDPARAM@
          LINE2:whsdata at RRDIDX@#@COLOR@:@RRDPARAM@

But that is usually not a good idea when you are also combining multiple
RRD files into one graph.


Regards,
Henrik


_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

NOTICE: This message and any attachments are confidential and may contain copyright material 
of Australian Finance Group Limited or a third party. It is intended solely for the purpose of the 
addressee and any other named recipient. If you are not the intended recipient, any use, 
distribution, disclosure or copying of this message is strictly prohibited. The confidentiality attached 
to this message is not waived or lost by reason of the mistaken transmission or delivery to any 
unintended party. If you have received this message in error, please notify the author immediately 
or contact Australian Finance Group on +61 8 9420 7888.

On Mon, May 09, 2005 at 09:25:01AM +0800, Vernon Everett wrote:

The rrd manpages are installed as part of your RRDtool installation.
They are not part of Hobbit. If you have RRdtool installed in the
default location - /usr/local/rrdtool-1.0.49, for instance - then
do an

  MANPATH=/usr/local/rrdtool-1.0.49/man
  export MANPATH

and then try "man rrdcreate".


Henrik

Hi,

I would suggest a small change to this:

 MANPATH=/usr/local/rrdtool-1.0.49/man

Instead:
MANPATH=$MANPATH:/usr/local/rrdtool-1.0.49/man

and then try "man rrdcreate".

Or add the path to the MANPATH file (in HP-UX /etc/MANPATH)

Regards
Lars