Hello guys,
I would like an opinion concerning a situation that is happening with us. I'm sure you have faced a similar situation.
Currently I have about 3000 clients connected simultaneously in 8 concentrators Mikrotik. These concentrators authenticate to 3 servers freeradius doing consulting and accounting users in a mysql db.
The time we have the message "Discarding duplicate request ..." and "Discarding conflicting ..." and in recent days began using ippool in postgresql where we started having problems duplicating IPs.
We believed that such duplication was due to these messages which were caused by our server mysql which was ancient and did not allow more make the necessary adjustments as the number of clients and memory.
So we did the installation of new server Mysql and changed the parameters possible and even indicated by mysqltunner and mysqlprimer, but the message continued Discarding occurs.
So we started using two tables for the radacct, but the message remains.
Finally, we migrated the radacct for postgresql, where the number (two tables) where the incidence of this message decreased, but remains on average 50 per hour to about 1300 sections with pppoe interim-update 5 minutes.
What are the parameters that could be changed to make the tuning of freeradius?
The question that remains ... MySQL or PostgreSQL?
We've done several settings in radius and mysql and still can not stop these messages.
Attached my freeradius settings.
I appreciate the attention and the help of everyone,
Att