Re: [pmacct-discussion] Dynamic Table not created
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
Re: [pmacct-discussion] Dynamic Table not created
Am 09.04.2009 um 14:14 schrieb Karl O. Pinc: On 04/08/2009 11:24:17 PM, Ben Paradis wrote: Please remove me from this mailing list! Thank you. Just as when you signed up, you are expected to go to the web page address that is at the bottom of every email to this list and do it yourself. No, the link at the bottom doesn't help. But this link does: http://www.pmacct.net/mailman/listinfo/pmacct-discussion (look at the bottom of the page) Regards, Sven -- Sven Anderson Institute of Computer Science - University of Goettingen Goldschmidtstr. 7, 37077 Goettingen, Germany http://www.ifi.informatik.uni-goettingen.de ___ pmacct-discussion mailing list http://www.pmacct.net/#mailinglists
Re: [pmacct-discussion] Dynamic Table not created
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
Re: [pmacct-discussion] Dynamic Table not created
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
Re: [pmacct-discussion] Dynamic Table not created
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
Re: [pmacct-discussion] Dynamic Table not created
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