pmacct-discussion  

[pmacct-discussion] dynamic sql tables not created

christian
Mon, 03 Aug 2009 02:53:24 -0700

hello world,

since i have changed my 'frontend' to slack64 on a e5520, pmacctd doesn't 
create weekly tables any more on my 'backend' server.

it seems it doesn't even try..

when i create them manually, they get populated.

a typical sunday/monday switch looks like this:

__cut__
Aug  3 00:00:04 ns pmacctd[7614]: ERROR ( default/mysql ): PRIMARY 'mysql' 
backend trouble.
Aug  3 00:00:04 ns pmacctd[7614]: ERROR ( default/mysql ): The SQL server says: 
Table 'pmacct.acct_ppp0_200931' doesn't exist
__cut__

no other error messages.

i definitely *can* create these tables when doing `mysql` on the same 
machine as user pmacct (just tested)...

what am i possibly doing wrong, and how could i find or fix it?


thanks for reading!

regards,
christian

-- 

_______________________________________________
pmacct-discussion mailing list
http://www.pmacct.net/#mailinglists