Hi Paolo, i've created the table manually and the table is populated by pmacct. Now i get no errors in messages log. mysqld.log shows no errors. The only exisiting table before the manual created "acct_20090408" was the standard "acct".
2009/4/8 Paolo Lucente <pa...@pmacct.net> > 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 >
_______________________________________________ pmacct-discussion mailing list http://www.pmacct.net/#mailinglists