IPTRAF to MySQL database

sorinbuda · December 28, 2004, 12:13am

Hi,

Does anybody knows how can I get the traffic data from the router directly into a MuSQL database without sing the Traffic Counter application from MicroTik?

Thank you in advance,
Sorin

_ASM · December 28, 2004, 9:15am

see in docs for /ip accounting and make a script that adds the data to database

gianluca · January 3, 2005, 7:31pm

if there is any news on it I am interested. thanks

sorinbuda · January 4, 2005, 10:34am

Yes, Thanks. I know how to get data out from MySQL but I do not know how to add it. Can enybody give some help with this?

Thank you in advance.

workshop · January 4, 2005, 1:26pm

Huh ?

I answered this one a few hours ago but my post dissappeared ?

Youll find a great solution here: http://www.fament.com/mikrotik/

Its free to download. Read the readme’s at the beginning of each file

nikhil · January 4, 2005, 7:43pm

I was looking for something just like this . I am going to check this out

Looks cool and is perl & php .

IP Accounting System v1

Bill per Mbit used don’t need to be hard!
IP Accounting System is a collection of scripts that will connect to
your Mikrotik router and collect the accounting data from it.
It currently consist out of 3 parts.

Accounting Collector
Daily Accounting Summarizer
Datamining interface

Thanks for the link