Hi, i've just tested your configuration and schema file and i see both of them working just fine (table is created and records are inserted). I'm using pmacct 0.11.6, MySQL server 5.1.33 and Linux and doing everything with the unpriviledged 'pmacct' MySQL user.
I don't get what is happening in your case, expecially because you can't see any errors logged down (and if things go wrong you should definitely see something). If you feel this can help, we can follow-up privately and I can take a look myself at your installation. Cheers, Paolo On Wed, Apr 08, 2009 at 11:54:13PM +0200, s.kub...@gmail.com wrote: > 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
