Please remove me from this mailing list! Thank you! B. --- On Wed, 4/8/09, s.kub...@gmail.com <s.kub...@gmail.com> wrote:
From: s.kub...@gmail.com <s.kub...@gmail.com> Subject: Re: [pmacct-discussion] Dynamic Table not created To: "Paolo Lucente" <pa...@pmacct.net>, pmacct-discussion@pmacct.net Date: Wednesday, April 8, 2009, 5:54 PM Paolo, i get this two lines in the mysqld.log when i get pmacct error: 9 Connect r...@localhost on pmacct 9 Query LOCK TABLES `acct_20090408` WRITE It seems that pmacct doesn't try to create the table...it tries only to write into the table. 2009/4/8 <s.kub...@gmail.com> 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 -----Inline Attachment Follows----- _______________________________________________ pmacct-discussion mailing list http://www.pmacct.net/#mailinglists
_______________________________________________ pmacct-discussion mailing list http://www.pmacct.net/#mailinglists