Re: [pmacct-discussion] The accounting of flows requires SQL table v4?

[Zenon Mousmoulas]

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