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
>>
>
>
_______________________________________________
pmacct-discussion mailing list
http://www.pmacct.net/#mailinglists
