Hi Leonardo, In short: solution is what essentially Jerome was proposing - being more specific replace the 'port_src' column with the 'src_port' one.
More in detail: v8 schema for MySQL tried to address the fact that some primitives (ie. source/destination ports) were not confirming to the general naming convention and hence have been renamed, say, from src_port to port_src. Setting sql_optimize_clauses to 'true' essentially tells pmacct you are providing a custom table (which is correct since for example peer_src_ip is not part of the plain v8 schema) and this disables semantics specific to a v8 table. Cheers, Paolo On Wed, Jul 25, 2012 at 11:28:52AM -0300, Leonardo S?piras wrote: > Hello Osama and J?rome, > > 2012/7/25 Osama Abuelsorour <[email protected]> > > > Hello, > > > > You probably have a problem in the database schema version number. Check > > that the version number you are using (looks like it is 8) matches the file > > you used to create the database schema. Check in the directory sql/ you > > will find several files with version number. Make sure you use the file: > > sql/pmacct-create-db-v8.mysql > > > 2012/7/25 J?r?me Fleury <[email protected]> > > > Well, obviously you need to add a 'src_port' column to your SQL database. > > > > > My database schema is the same that sql/pmacct-create-db-v8.mysql. > > BTW, in the aggregate, as in the CONFIG-KEYS, the source port is 'src_port' > and in the v8 schema it is 'port_src'. > > I think this is a bug in the version 0.14, because in the version 0.14.0rc1 > (using the same schema and the same aggretate) this problem doesn't happen. > I didn't tested it in other pmacct versions. Sorry if I am wrong. > > > -- > Atenciosamente > Leonardo Augusto S?piras > _______________________________________________ > pmacct-discussion mailing list > http://www.pmacct.net/#mailinglists _______________________________________________ pmacct-discussion mailing list http://www.pmacct.net/#mailinglists
