Re: [pmacct-discussion] IP accounting simple reporting

[enrico lambertini]

Ahmed Kamal ha scritto:

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 <http://1.2.3.4>  600M 100M
5.6.7.8 <http://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

yes,

query  download:
SELECT sum( bytes )
FROM `table`
WHERE ip_dst = '1.2.3.4'

query  upload:
SELECT sum( bytes )
FROM `table`
WHERE ip_src = '1.2.3.4'

another way: mahe this changes in the script
!download
aggregate[in]: src_host, dst_host
aggregate_filter[in]: dst host 1.2.3.4

!upload
aggregate[out]: src_host, dst_host
aggregate_filter[out]: src host 1.2.3.4

!you need data per mounth
sql_history: 30m
sql_refresh_time: 300

then you can make a sum per column

byz

enrico

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