You already asked this question a couple of hours again AND you received an answer. Why would you spam the list a second time with the same question?
-Peter On Mon 28 Aug 2006 23:30, zulkarnain wrote: > 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 > > Any help would be great. > > regards, > Zul > > > > --------------------------------- > How low will we go? Check out Yahoo! Messengers low PC-to-Phone call > rates. -- Peter Nixon http://www.peternixon.net/ PGP Key: http://www.peternixon.net/public.asc
pgpibtFgtWSsH.pgp
Description: PGP signature
_______________________________________________ pmacct-discussion mailing list http://www.pmacct.net/#mailinglists
