Re: [pmacct-discussion] IP accounting simple reporting

[Ahmed Kamal]

Um, sorry one more basic question. My config is below (straight from
examples), and the v2 table I have has a "bytes" column. I am not so sure if
this bytes column is for download or upload or both. In my sql query I need
to get the download and upload bytes per host IP address in last 30 days, a
la

IP    DOWN    UP
1.2.3.4  600M 100M
5.6.7.8  800M  80M

Is it possible to get this info, from this config:

interface: eth1
daemonize: true
aggregate: src_host,dst_host
! aggregate: src_net,dst_net
! plugins: pgsql
plugins: mysql
sql_db: pmacct
sql_table: acct_v2
sql_table_version: 2
sql_passwd: xxxxx
sql_user: pmacct
sql_refresh_time: 90
! sql_optimize_clauses: true
sql_history: 10m
sql_history_roundoff: mh
! sql_preprocess: qnum=1000, minp=5
!
networks_file: /etc/pmacct/pmacct-networks


Thanks a million



2008/6/2 Ahmed Kamal <[EMAIL PROTECTED]>:

> Thanks Enrico, I'm after total traffic per IP per month, not really
> graphing, so I'm not so sure cacti would be the answer? Although cacti looks
> darn cool. I will give it a look too.
> Thanks a lot Alex, I will take your script for a spin
> Regards
>
> 2008/6/2 alex <[EMAIL PROTECTED]>:
>
>>  Hello Ahmed!
>>  I can offer you to try adopt my personal report script for
>> your configuration.
>>  Feel free for any questions.
>>
>>  Alex
>>
>>
>>  Hi everyone,
>>> Thanks a million for this wonderful tool. The design and stability are
>>> impressive. It's currently monitoring my link. I would like to get
>>> "basic"
>>> reporting from the mysql database. This should be like: the amount of
>>> IN/OUT/total data per each unique IP in the database, during the last 30
>>> days!
>>> However, I cannot find a tool to do that. I would prefer a CLI tool to a
>>> web
>>> UI, but I could not find any CLI tool to do that. I tried directly
>>> building
>>> SQL queries, but it's a fairly complex query! So, if there's a tool I
>>> don't
>>> know about, or if any of you have written a quick'n'dirty script ;)
>>> Please
>>> share
>>> Thanks ...
>>>
>>
>>
>>
>> ------
>> Новые условия по вкладам! До 11% годовых в USD, до 14% годовых в BYR.
>> Возможность распоряжаться средствами без потери доходности.
>> Международная карточка VISA - в подарок! Белросбанк, т.(017) 21-000-22,
>> http://www.belrosbank.by
>>
>>
>> _______________________________________________
>> pmacct-discussion mailing list
>> http://www.pmacct.net/#mailinglists
>>
>
>

_______________________________________________
pmacct-discussion mailing list
http://www.pmacct.net/#mailinglists