Hi Stefan, We crossed each other's email, very good. So if in your config you replace the "aggregate: src_host,dst_host,proto" line with:
aggregate[in]: dst_host aggregate[out]: src_host ! imt_path[in]: /path/to/in.pipe imt_path[out]: /path/to/out.pipe Then query the memory tables: shell> pmacct -s -p /path/to/in.pipe shell> pmacct -s -p /path/to/out.pipe Do you achieve what you want? About how that will work with all the 50 virtual interfaces requires you to test and answer to my a), b) questions in the previous email. Cheers, Paolo On Thu, Apr 03, 2014 at 07:33:54AM +0200, Whisky wrote: > Hi Mario. > > Thanks again for your reply. > > I'm really sorry to bother the list but I obviously don't really understand > the configuration options although I've managed to narrow down the results I > get. So I suggest we leave the MySQL problem aside for the time being. > Here's my config on a local test system (hence the local ip addresses): > > daemonize: true > pidfile: /var/run/pmacctd.pid > syslog: daemon > promisc: true > interface: eth0 > plugins: memory,memory[in], memory[out] > plugin_pipe_size:1024000 > plugin_buffer_size:8192 > imt_buckets: 65537 > imt_mem_pools_size: 1024000 > aggregate: src_host,dst_host,proto > aggregate_filter[in]: dst net 192.168.1.5 > aggregate_filter[out]: src net 192.168.1.5 > > The ip address of eth0 is 192.168.1.5. As mentioned before all I want know > is how much incoming and outgoing traffic is generated for that ip. > > Here's an excerpt of what I get as a result of pmacct -s: > > SRC_IP DST_IP > PROTOCOL PACKETS BYTES > 192.168.1.5 195.20.242.89 > tcp 14 2134 > 192.168.1.5 192.168.1.75 > tcp 490 77648 > 192.168.1.5 192.168.1.1 > udp 20 1430 > 192.168.1.5 192.168.1.1 > tcp 73021 8940812 > 192.168.1.5 212.211.132.32 > tcp 235 13626 > 192.168.1.5 144.76.109.57 > tcp 132 18032 > 192.168.1.5 192.168.1.255 > udp 4 964 > 192.168.1.5 198.20.8.246 > tcp 27 11265 > 192.168.1.5 198.20.8.241 > tcp 32 3093 > 192.168.1.5 141.76.2.4 > tcp 86 11184 > > As you can see 192.168.1.5 doesn't show up under DST_IP but in my opinion it > should, because there obviously has to be incoming traffic. At least my idea > was that incoming traffic has to show up under DST_IP - am I wrong here? > > So my current questions are: > > 1) How do I also get the incoming traffic? > 2) What If that finally works and I wish to monitor about 50 virtual > interfaces? Do I need a separate config for each of them? And if so, how do > I get the results for each interface? > > Thank you very much for your patience, > > Stefan > > > > > -----Ursprüngliche Nachricht----- > Von: pmacct-discussion [mailto:pmacct-discussion-boun...@pmacct.net] Im > Auftrag von Jentsch, Mario > Gesendet: Mittwoch, 2. April 2014 11:43 > An: pmacct-discussion@pmacct.net > Betreff: Re: [pmacct-discussion] Virtual interfaces setup problem > > Hey Stefan, > > I use nfacctd with a custom plugin, never used pmacctd nor one of the SQL > plugins. > My guess is that you don't use "aggregate[]: none" and "sql_history[]: 1d". > Whatever configuration proposal I give you is a shot in the dark. > > To have the data of all interfaces in one table I would create a pretag map > file for each of them, setting the tag to an interface index I choose (e.g. > tag=1 for eth0, tag=2 for eth1, ...) and use the "tag" primitive in the > aggregate directive. > > MySQL table: > > CREATE TABLE `if_daily` ( > `agent_id` INT(10) UNSIGNED NOT NULL, > `stamp_inserted` DATETIME NOT NULL, > `packets` INT(10) UNSIGNED NOT NULL, > `bytes` BIGINT(20) UNSIGNED NOT NULL, > `stamp_updated` DATETIME NULL DEFAULT NULL, > PRIMARY KEY (`agent_id`, `stamp_inserted`) > ) > > File pretag-eth0.map file: > > ! > set_tag: 1 > ! > > The configuration file: > > ! > plugins: mysql > ! > sql_optimize_clauses: true > sql_history: 1d > sql_history_roundoff: d > sql_table: if_daily > sql_refresh_time: 300 > ! > aggregate: tag > interface: eth0 > pre_tag_map: pretag-eth0.map > ! > plugin_pipe_size: 10240000 > plugin_buffer_size: 102400 > ! > sql_host: <mysqld-host> > sql_db: <db-name> > sql_user: <db-username> > sql_passwd: <db-password> > ! > > "agent_id" in the MySQL table contains the interface id as of the > pre-tagging. > Data is updated every 300 seconds. > > Regards, > Mario > > > -----Original Message----- > > From: pmacct-discussion [mailto:pmacct-discussion-boun...@pmacct.net] > > On Behalf Of Whisky > > Sent: Dienstag, 1. April 2014 16:16 > > To: pmacct-discussion@pmacct.net > > Subject: Re: [pmacct-discussion] Virtual interfaces setup problem > > > > Hi Mario. > > > > Thanks for your message. I think what would help me most would be a > > correct configuration. As I said, I only need the total in and out > > values for one specific interface without ports or protocol. Shouldn't > > be too difficult but I just can't figure out how a fitting config > > would look like. > > > > Regards, > > > > Stefan > > > > _______________________________________________ > pmacct-discussion mailing list > http://www.pmacct.net/#mailinglists > > > _______________________________________________ > pmacct-discussion mailing list > http://www.pmacct.net/#mailinglists _______________________________________________ pmacct-discussion mailing list http://www.pmacct.net/#mailinglists