1. I don't think the problem is my DB. Because I saw another topic related this issue : http://lists.freeradius.org/pipermail/freeradius-users/2016-March/082483.htm... I also invited my colleague who has db experience. he has optimized some parameters for my MySQL DB. this is my slow query log from mysql. don't have any problem # User@Host: freeradius[freeradius] @ [127.0.0.1] Id: 10063 # Query_time: 1.259778 Lock_time: 0.000101 Rows_sent: 0 Rows_examined: 218535 use radius; SET timestamp=1522807036; delete from radpostauth where authdate<'2018-04-02 08:57:15.05'; 2. How I can capture request when the command line from radius debug mode run very fast. 2018-04-04 14:29 GMT+07:00 Fajar A. Nugraha <list@fajar.net>:
On Wed, Apr 4, 2018 at 10:44 AM, Hieu Nguyen <hieu.ntrong@gmail.com>
wrote:
I have encountered when I view the radius log. But the client still can authenticate to radius server
Error: (34406) Ignoring duplicate packet from client AP-Aerohive port 51961 - ID: 74 due to unfinished request in component authenticate module eap_peap ... Error: (680844) Ignoring duplicate packet from client AP-Aerohive port 43470 - ID: 156 due to unfinished request in component accounting module sql
This usually mean your accounting sql query took a long time to run. Fix that (usually you'd need the help of a dba)
Some usual (but not the ONLY) causes including accounting table too big or disk in db server too slow.
This is the output debug " freeradius -X "
FreeRADIUS Version 3.0.13
Ready to process requests
Unfortunately you didn't capture any accounting request in this debug log. Had you done that, you might be able to see what query takes up a long time.
-- Fajar - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html