Um, I think I kinda understand now. Basically all connections are logged into mysql, and whether "bytes" mean upload or download depends on how I am querying ... if that's right, then my problem is what's the meaning of ip_src and ip_dst. i.e. what's src and what's dst?
I understand that for *every* single tcp/ip connection, the packets uploaded will be logged in a DB row, and the packets downloaded will be logged into another row, is that correct ? If so, why are the results from these queries different: select distinct ip_src from acct_v2; select distinct ip_dst from acct_v2; one returns 67, the other returns 257! I expected them to be equal, since each connection will be logged as both uploading/downloading?! Any help is highly appreciated till I get my head around this. Stability is awesome compared to ntop (piece of pure crashing shit). Thanks 2008/6/4 Ahmed Kamal <[EMAIL PROTECTED]>: > 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
