Hi Alan, you are right!! I created indexes in the database and everything is working fine. I only have a few quantity of these message: Thu Sep 28 13:39:41 2017 : Error: Discarding duplicate request from client todos port 22988 - ID: 230 due to unfinished request 1066195 Thu Sep 28 13:39:41 2017 : Error: Discarding duplicate request from client todos port 22988 - ID: 190 due to unfinished request 1066221 Thu Sep 28 13:39:41 2017 : Error: Discarding duplicate request from client todos port 22988 - ID: 190 due to unfinished request 1066221 Thu Sep 28 13:39:43 2017 : Error: Discarding duplicate request from client todos port 22988 - ID: 171 due to unfinished request 1066307 Its a very sporadic message!! What could be the reason? Regards!! 2017-09-28 10:33 GMT-05:00 Alan DeKok <aland@deployingradius.com>:
On Sep 28, 2017, at 9:16 AM, Andrés Gómez <andres.gomez.ruiz@gmail.com> wrote:
I have this message on my freeradius log:
Error: rlm_sql (sql): There are no DB handles to use! skipped 0
so I increased the num_sql_socks to 50 in the sql.conf file.
It fixed the issue!!!
No, it made that message go away. It didn't fix the issue,
But after that has appeared this new message:
Error: Discarding duplicate request from client todos port ZZZZ - ID: 5 due to unfinished request XXXX
a lot of times.
What does it mean? Do I have to improve the sql configuration?
It means your SQL database is slow. Fix the database so that it takes less than 5 seconds to respond to a query from FreeRADIUS.
No amount of poking FreeRADIUS will make the database faster.
Be sure that the database has indexes, and doesn't have millions of rows.
Alan DeKok.
- List info/subscribe/unsubscribe? See http://www.freeradius.org/ list/users.html
-- *C. Andrés Gómez R.*