zulkarnain schrieb: > Hi, > > I'm having problem with running pmacct in my network. MySQL database > size and number of row increase every minutes. I'm just wondering if > is it possible to keep only one row for each ip_src and ip_dst ip > address and reduce the size of mysql database? > Here is my config. > > ------pmacctd.conf > syslog: daemon > interface: eth1 > daemonize: true > promisc: true > aggregate: src_host,dst_host > plugins: mysql > sql_host: 192.168.1.1 > sql_db: eth1 > sql_table: acct > sql_table_version: 1 > sql_passwd: pmacctpasswd > sql_user: pmacct > sql_history: 5m > sql_history_roundoff: m > sql_cache_entries: 2 > networks_file: /etc/pmacct/networks.lst > pcap_filter: not ip broadcast and not 192.168.1.1 > > -----networks.lst > 192.168.1.2/32 > 192.168.1.3/32 > 192.168.1.4/32 >
Leave the "sql_history" and "sql_history_roundoff" directives out and you should be all set -- Cheers, Gregor _______________________________________________ pmacct-discussion mailing list http://www.pmacct.net/#mailinglists
