FreeRadius + MySQL | radacct: Errors and Warnings

[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: Received conflicting packet from client
> my-pppoe-01 port 39595 - ID: 75 due to unfinished request 625066.  Giving
up
> on old request.
> Tue Oct 25 15:43:20 2011 : Error: WARNING: Unresponsive child for request
> 784, in module radutmp component accounting

There are a few basic steps you can take to improve the performance of
FreeRADIUS with MySQL.

1. User the InnoDB Engine in MySQL. 
2. Increase the number of SQL sockets in sql.conf (num_sql_socks). The
default is 5, try 25.
3. Increase the number of connections (max_connections) in my.cnf to match
the number of SQL sockets in sql.conf.
4. Enable the MySQL slow query log (slow_query_log) in my.cnf.
5. Check the MySQL slow query log file for problems.

Start with this list.

Tim