Question regarding RRDTools

[Mnementh]

Hello,

I'm quite new in Cacti & RRDTool and I want to do something that seems weird :

My Data : Connection logs with the timestamp and the server ID (1 of the 4). One file per day, 30 days of log.

What I want : a daily and monthly graph with the 4 servers.
The daily graph should have one point each hour per server, the point should be the sum of all previous hour connections.
The monthly graph should have one point each day per server, the point is the sum of the previous day connections.

My status: I wrote a perl script that format the data. I tried to create a RRD DB with the following stucture :

Code: Select all

my $RRD_create = "rrdtool.exe create test.rrd --start 1398895200 --step 3600 \
					DS:BPR1:COUNTER:3600:0:U \
					DS:BPR1S:COUNTER:3600:0:U \
					DS:BPR2:COUNTER:3600:0:U \
					DS:BPR2S:COUNTER:3600:0:U \
					RRA:AVERAGE:0.5:1:24";

But it seems empty after the update.

My question : Is that possible on RRD Tool to create such a graphic or should I calculate by script and send only one point per hour / day to RRD DB ? If it's possible, could you tell me how create such DB and graph ? I read a lot of pages, but I didn't understand how to create this.

Thanks.