[rrd-users] Re: Web server log (access_log)

[Kempf, Reed]

I would disagree.  I believe that rrdtool is a great tool for analyzing
data from an apache access_log.  I set up a custom apache log which had
all the fields of data I required, then parsed through and sent the
totals to an rrdtool database which has been running flawlessly for over
2 years.  I keep one year of data in the database so I have trend data
over that time.

Here is the way I have the rrdtool db set up.  This is a python function
which I send a few parameters through but you should be able to get the
gist of how it is set up.

def checkRRD( rrd = None, rrdid = None, daystart = None ):

    rrdStart = "-b " + str(daystart)
    step = "-s " + str(300)

    cur_id = str(rrdid) + '.rrd'
    cur_rrd = rrd_db_dir + '/' + cur_id
    rrdtuple = (cur_rrd,rrdStart,step,
        'DS:adm_bytes:GAUGE:600:0:U',
        'DS:adm_hits:GAUGE:600:0:U',
        'DS:adm_avg_load:GAUGE:600:0:U',
        'DS:adm_max_load:GAUGE:600:0:U',
        'DS:adm_min_load:GAUGE:600:0:U',
        'DS:adm_err_cnt:GAUGE:600:0:U',
        'DS:end_bytes:GAUGE:600:0:U',
        'DS:end_hits:GAUGE:600:0:U',
        'DS:end_avg_load:GAUGE:600:0:U',
        'DS:end_max_load:GAUGE:600:0:U',
        'DS:end_min_load:GAUGE:600:0:U',
        'DS:end_err_cnt:GAUGE:600:0:U',
        'DS:bandwidth_bytes:GAUGE:600:0:U',
        'RRA:AVERAGE:0.5:1:105120',
        'RRA:MAX:0.5:1:105120')

    if os.path.exists(cur_rrd):
        pass
    else:
        rrd.create(rrdtuple)

    return (cur_id, cur_rrd)


Hope this helps,

ReedK

On Tue, 2003-12-02 at 12:37, Hugo van der Kooij wrote:
> On Tue, 2 Dec 2003, Felipe Piccirilo wrote:
> 
> > 
> > 	Anyone already try to feed a rrd database and create graphs getting the data from apache's access_log?
> > 
> > 	If yes, what kind of ds did you use? COUNTER?
> > 	Did anyone know some script to analyze the access_log that works similar to webalizer(www.webalizer.org) or something like that?
> 
> Look for the right tool. (rrdtools is not.)
> 
> You want something like analog or awstats.
> 
> Hugo.

--
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