Hi Paolo,
it's nice to be back :)
I had already tried adding this directive (and tried it one more time
just before writing this). Unfortunately it made no difference...
Z.
On 08 Φεβ 2010, at 11:51 ΠΜ, Paolo Lucente wrote:
Hi Zenon,
Good to see you around again. Please add to your config:
sql_table_version[sqltest]: 4
Reason being most of the primitives are still connected to the
SQL table versioning concept (in essence: pmacct expects you to
make explicit which SQL schema you are running). This is in the
process of being dismantled, which is already the case with the
plethora of BGP-related primitives (i know you come from there
and hence it sounds new ...).
Cheers,
Paolo
On Mon, Feb 08, 2010 at 10:34:50AM +0200, Zenon Mousmoulas wrote:
Hi,
plugins: mysql[sqltest]
sql_optimize_clauses[sqltest]: true
sql_table[sqltest]: acct
...
aggregate: src_as, [...] flows, tag
I also tried
aggregate[sqltest]: src_as, [...] flows, tag
It is also in my schema:
create table acct (
id INT(4) UNSIGNED NOT NULL AUTO_INCREMENT,
agent_id INT(4) UNSIGNED NOT NULL,
as_src INT(4) UNSIGNED NOT NULL,
[...]
flows INT UNSIGNED NOT NULL,
packets INT UNSIGNED NOT NULL,
bytes BIGINT UNSIGNED NOT NULL,
stamp_inserted DATETIME NOT NULL,
stamp_updated DATETIME,
PRIMARY KEY (id),
INDEX idxall (agent_id, as_src, as_dst, stamp_inserted)
) TYPE=MyISAM AUTO_INCREMENT=1;
No matter what, I always get this:
ERROR ( sqltest/mysql ): The accounting of flows requires SQL table
v4.
Exiting.
Using latest cvs code (2010-01-29).
Any ideas?
Thanks,
Z.
_______________________________________________
pmacct-discussion mailing list
http://www.pmacct.net/#mailinglists
_______________________________________________
pmacct-discussion mailing list
http://www.pmacct.net/#mailinglists
