Hi, I'm lost. I tried to use dynamic table names but the tables aren't created by pmacctd and nothing is collected. There is always message about syntax error:
error : You have an error in your SQL syntax; check the manual that corresponds
to your MySQL server version for the right syntax to use near '%Y%m%d (
' at line 1
create table acct_v7_outgoing_%Y%m%d (
agent_id INT(4) UNSIGNED NOT NULL,
class_id CHAR(16) NOT NULL,
mac_src CHAR(17) NOT NULL,
mac_dst CHAR(17) NOT NULL,
vlan INT(2) UNSIGNED NOT NULL,
as_src INT(4) UNSIGNED NOT NULL,
as_dst INT(4) UNSIGNED 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,
tcp_flags INT(4) UNSIGNED NOT NULL,
ip_proto CHAR(6) NOT NULL,.
tos INT(4) UNSIGNED NOT NULL,.
packets INT UNSIGNED NOT NULL,
bytes BIGINT UNSIGNED NOT NULL,
flows INT UNSIGNED NOT NULL,
stamp_inserted DATETIME NOT NULL,
stamp_updated DATETIME,
PRIMARY KEY (agent_id, class_id, mac_src, mac_dst, vlan, as_src, as_dst,
ip_src, ip_dst, src_port, dst_port, ip_proto, tos, stamp_inserted)
);
uname -a:
Linux gateway 2.6.31-gentoo-r6 #5 Wed Jan 6 16:43:32 EST 2010 i686 Intel(R)
Celeron(R) CPU 2.50GHz GenuineIntel GNU/Linux
mysql --version:
mysql Ver 14.12 Distrib 5.0.90, for pc-linux-gnu (i686) using readline 6.0
pmacctd -h:
Promiscuous Mode Accounting Daemon, pmacctd 0.12.0
Cheers,
Thomas Cale
_______________________________________________
pmacct-discussion mailing list
http://www.pmacct.net/#mailinglists
