Hi, i'm using pmacctd 0.11.6-2build1 on 64-bit Ubuntu Linux 10.04 with database postgresql 9.0b1.. i feel that something wrong with the pmacct INSERT query, i found that it insert the value too large such as: 140733193388172 bytes for 5 packets (ping). would anyone kind enough to help me find what's wrong with my configuration? computer? or the pmacctd?
------------------------- here's my database: CREATE TABLE acct ( ip_src CHAR(15) NOT NULL, ip_dst CHAR(15) NOT NULL, packets INT NOT NULL, bytes BIGINT NOT NULL, stamp_inserted TIMESTAMP WITHOUT TIME ZONE NOT NULL, stamp_updated TIMESTAMP WITHOUT TIME ZONE DEFAULT NULL, CONSTRAINT acct_pk PRIMARY KEY (ip_src,ip_dst,stamp_inserted) ); ------------------------- here's my configuration: daemonize: false plugins: pgsql aggregate: src_host, dst_host sql_refresh_time: 1 sql_db: kyz sql_table: acct sql_host: 127.0.0.1 sql_history: 1m sql_history_roundoff: m sql_optimize_clauses: true sql_refresh_time: 60 debug: true interface: eth0 plugin_pipe_size: 16777216 plugin_buffer_size: 65536 ------------------------- and here's what i got on the DEBUG output: DEBUG ( default/pgsql ): INSERT INTO acct (stamp_updated, stamp_inserted, ip_src, ip_dst, packets, bytes) VALUES (ABSTIME(1275744266)::Timestamp, ABSTIME(1275744060)::Timestamp, '192.168.10.20', '192.168.21.2', 5, 140733193388172) DEBUG ( default/pgsql ): INSERT INTO acct (stamp_updated, stamp_inserted, ip_src, ip_dst, packets, bytes) VALUES (ABSTIME(1275744266)::Timestamp, ABSTIME(1275744060)::Timestamp, '192.168.10.20', '192.168.21.3', 5, 140733193388172) DEBUG ( default/pgsql ): INSERT INTO acct (stamp_updated, stamp_inserted, ip_src, ip_dst, packets, bytes) VALUES (ABSTIME(1275744266)::Timestamp, ABSTIME(1275744060)::Timestamp, '192.168.10.20', '216.252.108.50', 2, 140733193388136) DEBUG ( default/pgsql ): INSERT INTO acct (stamp_updated, stamp_inserted, ip_src, ip_dst, packets, bytes) VALUES (ABSTIME(1275744266)::Timestamp, ABSTIME(1275744060)::Timestamp, '192.168.10.20', '8.8.8.8', 8, 140733193388544) DEBUG ( default/pgsql ): INSERT INTO acct (stamp_updated, stamp_inserted, ip_src, ip_dst, packets, bytes) VALUES (ABSTIME(1275744266)::Timestamp, ABSTIME(1275744060)::Timestamp, '192.168.10.20', '66.220.146.18', 19, 140733193390121) -- Regards, Kiswono P GB _______________________________________________ pmacct-discussion mailing list http://www.pmacct.net/#mailinglists
