[pmacct-discussion] pmacct can't create mysql table, but I can with the same schema.

2009-12-22 Thread Jeff Welling
Hi Im running into a strange problem where I'm trying to get pmacct to dynamically create the database tables, something that I understand it can do, with the simple pmacct-create-table_v7.sqlite3 file, with the table names updated. The error that I'm seeing from pmacct in my syslog is this Dec

Re: [pmacct-discussion] pmacct can't create mysql table, but I can with the same schema

2009-12-22 Thread Jeff Welling
Hi again, So it seems I spoke too soon . It looks like its accumulating information in the database in the right tables, but I don't know that the information is correct or why its trying to create the table even though it already exists..? I'm seeing this in my syslogs, one per table but

Re: [pmacct-discussion] pmacct can't create mysql table, but I can with the same schema

2009-12-22 Thread Paolo Lucente
Hi Jeff, If i'm getting this correctly, you see everything working except for the table creation error you get back. If this is the case, i wouldn't say you are doing something wrong; pmacct tries to create the table every time the SQL cache scanner kicks in (sql_refresh_time interval); table