The strange thing is you don't see any further error message other than the one below - which is generated by the first SQL sentence actually trying to make use of the table.
If, accessing the pmacct database with the MySQL client, you do a "SHOW TABLES", do you see any table being created? Also, can you find anything within the MySQL server logs? Just for curiosity, if you create the table manually (ie. cut and paste of the content of the schema file) what happens? Is pmacct able to write in? Cheers, Paolo On Wed, Apr 08, 2009 at 10:35:24PM +0200, s.kub...@gmail.com wrote: > I've tried to use "root" user as sql_user but it is the same. > > > 2009/4/8 Karl O. Pinc <k...@meme.com> > > > > > On 04/08/2009 03:26:26 PM, s.kub...@gmail.com wrote: > > > Hi, > > > i'm trying to use the dynamic feature but i get this error in syslog: > > > > > > Apr 8 22:18:01 localhost pmacctd[2332]: ERROR ( default/mysql ): > > > PRIMARY > > > 'mysql' backend trouble. > > > Apr 8 22:18:01 localhost pmacctd[2332]: ERROR ( default/mysql ): The > > > SQL > > > server says: Table 'pmacct.acct_20090408' doesn't exist#012 > > > > > > > > > The table isn't created and nothing is collected. > > > > > Any help or suggestions? > > > > A permission problem? > > > > Karl <k...@meme.com> > > Free Software: "You don't pay back, you pay forward." > > -- Robert A. Heinlein _______________________________________________ pmacct-discussion mailing list http://www.pmacct.net/#mailinglists
