Problem with freeradius 3.0.13
hieu.ntrong at gmail.com
Wed Apr 4 16:49:36 CEST 2018
1. I don't think the problem is my DB.
Because I saw another topic related this issue :
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 at Host: freeradius[freeradius] @ [127.0.0.1] Id: 10063
# Query_time: 1.259778 Lock_time: 0.000101 Rows_sent: 0 Rows_examined:
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 at fajar.net>:
> On Wed, Apr 4, 2018 at 10:44 AM, Hieu Nguyen <hieu.ntrong at gmail.com>
> > 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
> > - ID: 74 due to unfinished request in component authenticate module
> > Error: (680844) Ignoring duplicate packet from client AP-Aerohive port
> > 43470 - ID: 156 due to unfinished request in component accounting
> 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.
> List info/subscribe/unsubscribe? See
More information about the Freeradius-Users