Re: FreeRadius + MySQL | radacct: Errors and Warnings

2011-10-27 Thread Fajar A. Nugraha
On Thu, Oct 27, 2011 at 8:19 PM, Daniel Menezes wrote: > Fajar, > > I had radutmp and SQL commented out in account {}. > I don't know why, a possible mistake. > After mark radutmp and restart freeradius I don't see new errors in log. So you mean radutmp was the root cause of your problem? That's

Re: FreeRadius + MySQL | radacct: Errors and Warnings

2011-10-26 Thread Fajar A. Nugraha
On Thu, Oct 27, 2011 at 12:13 AM, Daniel Menezes wrote: > Yes, there is a large number of rows in the radacct and radposauth tables. > The attribute 'Acct-Interim-Interval' works very well but makes many > records. Interim update aren't suppose to add records, they simply update existing ones. Th

RE: FreeRadius + MySQL | radacct: Errors and Warnings

2011-10-26 Thread Tim Sylvester
Hi Daniel, > I have a FreeRadius + MySQL setup with MikroTik as NAS. > And a few days ago I have some warnings and errors in the log: > > Tue Oct 25 04:02:41 2011 : Info: Released IP xxx.xxx.xxx.xxx (did > via-pppoe-01 cli xx:xx:xx:xx:xx:xx user dmnzs-test) Tue Oct 25 05:30:36 2011 : > Error: Rec

Re: FreeRadius + MySQL | radacct: Errors and Warnings

2011-10-26 Thread Fajar A. Nugraha
On Wed, Oct 26, 2011 at 10:08 PM, Daniel Menezes wrote: > Tue Oct 25 15:43:20 2011 : Error: WARNING: Unresponsive child for request > 784, in module radutmp component accounting Another thing to try, are you using radutmp? If no (e.g. session/simultaneous use check is using sql), just mark all in

Re: FreeRadius + MySQL | radacct: Errors and Warnings

2011-10-26 Thread Fajar A. Nugraha
On Wed, Oct 26, 2011 at 10:08 PM, Daniel Menezes wrote: > I read something about slow backend, tables indexes and other things. > I've used the backend script 'mysqltuner.pl' to adjust the performance. > It's better now, but the warnings and erros persists. > > Can anyone help me on this? Obvious