Re: how to calculate how much data does each ip address use ?

On Tue, Feb 5, 2013 at 10:13 AM, Bulent Malik <bmalik@ihlas.net.tr> wrote: > > >> >This task is not really suited for php. I would suggest looking into > Ntop. >> >It does exactly what you described. >> >> >> Hello >> >> >> >> I have a freebsdbox firewall . also I have some internet customers. >> >> I want to save how much data they used in a table ( such as mysql >> >>table ) for each ip address. >> >>Apache2, php5 and mysql5.5 work on the box. >> >> >> >> How can I do it ? any script or tool. >> >> >> >> Thanks >> >> How can i save in table using ntop ? is there any document ? >> >> >> -- >> PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: >> http://www.php.net/unsub.php >> > >>Read the man pages. There are sql export options that you can specify on run. > > I could not see any sql options on the man file of ntop. > Where is it? > > > Whoops, my mistake. I was reading the NetFlow documentation and going off vague memories of older versions of Ntop. Ntop saves data in RRD files. There are PHP libraries to parse this data [1]. You could theoretically scrape the RRDs and put them in a SQL DB, but they may be useful enough on their own if you can parse them correctly. (Note: I have never personally parsed RRDs manually. This info was pulled from a simple Google search. YMMV.) [1] http://www.ioncannon.net/system-administration/59/php-rrdtool-tutorial/ -- --Zootboy Sent from some sort of computing device.