MRTG graphics and reports of the customers traffic

RouterOS General
1

Hi all!

The client radios that I’ve in my customers don’t have snmp support, than I can’t do the mrtg graphics getting the data from the client radio.

My main router is a RB1000 and I want to create a condition to do daily/weekly/monthly/yearly reports and MRTG Graphics of the traffic of each customers mine. I was thinking in use one simple queue for each customer and get these informations using snmp and create a script to put the data into my MySQL database, but I don’t know if this is the best pratice or if there are a right form to do this.

What’s the right form to collect the traffic statistics of each customer and put these data on my MySQL server? And what’s the best pratice to create a MRTG graphics with the traffic of each customer of my network?

Thank in advance!

Fabrício F. Kammer

2

maybe, Traffic Flow? use any NetFlow collector to aggregate the data

3

Thanks for the answer Chupaka,

Do you have idea where can I get more informations about the use of Traffic Flow on the Mikrotik and NetFlow collector softwares?

Best regards

Fabrício

4

http://www.networkuptime.com/tools/netflow/

5

Hi Chupaka, sorry by my ignorance, but I’m completly lost here.

Traffic Flow is something really new to me and I need some help.

I want to get the informations of my gateway (RB1000) and create some graphics with the traffic (in kbps) of each user.

Before using a RB1000 as gateway I had a FreeBSD machine with a count Firewall rule of each IP address of my network. Than I’d a script that got the counters of the firewall rules and sent this information to mrtg make the graphics.

I tried to do the same with the RB1000, but 1.500 firewall rules or simple queues on the rb1000 causes 100% of CPU.

You suggest the Traffic Flow and I think that is the best solution to me, but I’m trying to use it for 1 week without success. Can you help me?

Thanks again