Dear all I'm trying to configure and make available to my boss, a sort of IP traffic stats related to our web services exposed on Internet.
Unfortunately I'm not strictly a sysadmin guy, so I have some difficulty to understand how build the configuration file. Let me say that we have enabled sflow on the external links where we make ebgp peering. We have also sfacctd up&running on a centos server and I am able to collect the sflow datas. The goal should be collect traffic statistic for 5minutes, 1 hour, 1 day and make them available respectively for 1 year, 2 years, 5 years. How to use the sql plugins in order to make this? A first attempt could be to collect data only for a day and then delete the old entries, just to understand how much space will be necessary for the storage. How is feasible? I want to share the relevant part of the configuration file. plugins: mysql[in],mysql[out] aggregate[in]: src_as,src_host,dst_host,proto,dst_port aggregate[out]: dst_as,src_host,dst_host,proto,dst_port sql_optimize_clauses: true sql_dont_try_update: true sql_recovery_logfile: /var/netflow/pmacct-1.5.0/recovery_log sql_table_version: 6 sql_cache_entries: 256000 sql_table_schema[in]: /var/netflow/pmacct-1.5.0/acct_v6_in.schema sql_table_schema[out]: /var/netflow/pmacct-1.5.0/acct_v6_out.schema sql_table[in]: acct_v6_in_%Y_%m_%d sql_table[out]: acct_v6_out_%Y_%m_%d sql_refresh_time: 300 sql_history: 5m sql_history_roundoff: d Thanks in advance for your help... -- IP
_______________________________________________ pmacct-discussion mailing list http://www.pmacct.net/#mailinglists
