Hi,
i'm trying to use the dynamic feature but i get this error in syslog:
Apr 8 22:18:01 localhost pmacctd[2332]: ERROR ( default/mysql ): PRIMARY
'mysql' backend trouble.
Apr 8 22:18:01 localhost pmacctd[2332]: ERROR ( default/mysql ): The SQL
server says: Table 'pmacct.acct_20090408' doesn't exist#012
The table isn't created and nothing is collected.
This is my config file:
!
debug: true
daemonize: true
syslog: daemon
promisc: true
plugins: mysql
aggregate: src_host,dst_host
interface: eth0
sql_table_version: 1
sql_history: 5m
sql_history_roundoff: m
sql_table: acct_%Y%m%d
sql_table_schema: /etc/pmacct/giorno_v1.mysql
sql_host: localhost
sql_user: pmacct
sql_passwd: xxxxxxx
sql_db: pmacct
!
This is /etc/pmacct/giorno_v1.mysql:
create table acct_%Y%m%d (
mac_src CHAR(17) NOT NULL,
mac_dst CHAR(17) NOT NULL,
ip_src CHAR(15) NOT NULL,
ip_dst CHAR(15) NOT NULL,
src_port INT(2) UNSIGNED NOT NULL,
dst_port INT(2) UNSIGNED NOT NULL,
ip_proto CHAR(6) NOT NULL,
packets INT UNSIGNED NOT NULL,
bytes BIGINT UNSIGNED NOT NULL,
stamp_inserted DATETIME NOT NULL,
stamp_updated DATETIME,
PRIMARY KEY (mac_src, mac_dst, ip_src, ip_dst, src_port, dst_port,
ip_proto, stamp_inserted)
);
Any help or suggestions?
Thanks.
_______________________________________________
pmacct-discussion mailing list
http://www.pmacct.net/#mailinglists
