Dear all I've made some progress in the meanwhile. Now I'm trying to configure PNRG as frontend to analyze data.
Unfortunately when I try to use the pmacct client, I receive the following error: [root@netflow bin]# pmacct -s -p /tmp/sfacctd.pipe INFO: Connection refused while trying to connect to '/tmp/sfacctd.pipe' Do you know why this happens? This is my config file: daemonize: true pidfile: /var/run/sfacctd.pid plugins: mysql[in] plugin_buffer_size: 40960 ! sql_db: pmacct sql_host: localhost sql_user: pmacct sql_passwd: pmacct ! aggregate[in]: src_as,dst_as,src_host,dst_host,dst_port,proto !aggregate[out]: dst_as,dst_host,dst_port,proto !aggregate_filter[in]: !aggregate_filter[out]: ! sfacctd_port: 6344 sfacctd_renormalize: true ! sql_optimize_clauses: true sql_dont_try_update: true sql_recovery_logfile: /var/netflow/sfacctd/recovery_log sql_cache_entries: 256000 ! sql_table_version: 6 sql_table[in]: acct_v6_test !sql_table[out]: acct_v6_out ! sql_refresh_time: 300 sql_history: 5m sql_history_roundoff: m ! imt_path: /tmp/sfacctd.pipe Thanks IP 2015-03-03 12:12 GMT+01:00 IP <[email protected]>: > 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 > -- IP
_______________________________________________ pmacct-discussion mailing list http://www.pmacct.net/#mailinglists
