[rrd-users] member count graph

Mike Zupan hijinks at gmail.com
Thu Jun 23 15:03:53 MEST 2005

I have a members table in a mysqlDB that stores the join date as a
unix timestamp. I'm trying to make a simple graph that shows like a
day/week/month/year of members joined as a graph of the bar going up
and up type thing. I wrote a simple script to pull the join date out
and doing a running counter of all the members like

while () {
  system(rrdtool update);

type thing.. this is how i created my db

rrdtool create test.rrd --step 120 DS:line1:COUNTER:180:0:U
RRA:AVERAGE:0.5:1:600 RRA:AVERAGE:0.5:6:700 RRA:AVERAGE:0.5:24:775

then is how i update

rrdtool update test.rrd $time:$count

$time = timestamp of member join date
$count = is the current member count

now i get this error cause i think the timestamp is in the paste

ERROR: illegal attempt to update using time 1118268121 when last
update time is 1119531130 (minimum one second step)

Is there a way to do this? I looked around but couldn't find anything.
I've used rrdtool to do like snmp graphs but never something like this

My Linux Howto/Tips Wiki

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://lists.ee.ethz.ch/rrd-users
WebAdmin    http://lists.ee.ethz.ch/lsg2.cgi

More information about the rrd-users mailing list