[rrd-users] Re: graphing using particular RRA

[Kempf, Reed]

Hi Libor,

I have done just exactly that process.  My platforms are RedHat Linux 6.2,
Oracle 8.1.7 and php 4.6 to display the graphs in a web page.

These are the steps that I took to do this.
1. Created oracle stored procedure which gathers past info from the db and
dumps them to a flat file in a specific format (spaces between values for
awk purposes).
2. Created korn shell script which creates rrdtool database on the fly, then
uses awk to populate the database from the flat file.
3. Within the above korn shell, a graph is also generated to standard output
which php will pick up and display a web browser.  (you can create named png
files though).
4. Removed the rrdtool database at the end of the above korn shell script,
to avoid clutter on servers. (I didn't want a bunch of unusable rrdtool
databases hanging around).

You can use any type of database you want to store values, the important
thing is to query the database for those values and have some way of
building an rrdtool database on the fly and appending the database values to
the new rrdtool database.  Oracle is really handy in that I used stored
procedures.  I'm not sure what mechanism you would use for dbase to get
those values into the rrdtool.

If you would like to look at my methodology and some sample scripts, let me
know.

ReedK



-----Original Message-----
From: Hemola Libor [mailto:libor.hemola at fincomnet.com]
Sent: Monday, December 03, 2001 8:55 AM
To: 'rrd-users at list.ee.ethz.ch'
Subject: [rrd-users] graphing using particular RRA


I'm graphing on daily and weekly basis. Dbase gets updated every hour. I'm
using type ABSOLUTE  for counting users and keeping these averages:

RRA:AVERAGE:0.5:1:168 (week-hour)
RRA:AVERAGE:0.5:24:30 (month-day)

Problem is : how to create last week's graph with day values ? (How to get
second AVERAGE's values ?)

Thanx

Libor


--
Unsubscribe mailto:rrd-users-request at list.ee.ethz.ch?subject=unsubscribe
Help        mailto:rrd-users-request at list.ee.ethz.ch?subject=help
Archive     http://www.ee.ethz.ch/~slist/rrd-users
WebAdmin    http://www.ee.ethz.ch/~slist/lsg2.cgi

--
Unsubscribe mailto:rrd-users-request at list.ee.ethz.ch?subject=unsubscribe
Help        mailto:rrd-users-request at list.ee.ethz.ch?subject=help
Archive     http://www.ee.ethz.ch/~slist/rrd-users
WebAdmin    http://www.ee.ethz.ch/~slist/lsg2.cgi