<div dir="ltr"><span id="result_box" class="" lang="en"><span class="">Hello guys</span><span>,</span><br><br><span class="">I would like</span> <span class="">an opinion</span> <span class="">concerning a</span> <span class="">situation that</span> <span class="">is happening</span> <span class="">with us</span><span>.</span> <span class="">I'm sure you</span> <span class="">have faced</span> <span class="">a similar situation.</span><br>

<br><span class="">Currently I have</span> <span class="">about 3000</span> <span class="">clients connected</span> <span class="">simultaneously</span> <span class="">in 8</span> <span class="">concentrators</span> <span class="">Mikrotik</span><span>.</span> <span class="">These</span> <span class="">concentrators</span> <span class="">authenticate to</span> <span class="">3</span> <span class="">servers</span> <span class="">freeradius</span> <span class="">doing</span> <span class="">consulting</span> <span class="">and</span> <span class="">accounting</span> <span class="">users</span> <span class="">in a</span> <span class="">mysql</span> <span class="">db</span><span>.</span><br>

<br><span class="">The</span> <span class="">time</span> <span class="">we have the</span> <span class="">message</span> <span class="">"</span><span>Discarding</span> <span class="">duplicate</span> <span class="">request</span> <span class="">...</span><span>"</span> <span class="">and</span> <span class="">"</span><span>Discarding</span> <span class="">conflicting</span> <span class="">...</span><span>"</span> <span class="">and in recent days</span> <span class="">began using</span> <span class="">ippool</span> <span class="">in postgresql</span> <span class="">where</span> <span class="">we started having</span> <span class="">problems</span> <span class="">duplicating</span> <span class="">IPs</span><span>.</span><br>

<br><span class="">We believed</span> <span class="">that such</span> <span class="">duplication</span> <span class="">was</span> <span class="">due to these</span> <span class="">messages</span> <span class="">which were</span> <span class="">caused</span> <span class="">by our server</span> <span class="">mysql</span> <span class="">which</span> <span class="">was ancient</span> <span class="">and</span> <span class="">did not allow</span> <span class="">more</span> <span class="">make the</span> <span class="">necessary</span> <span class="">adjustments</span> <span class="">as the number of</span> <span class="">clients</span> <span class="">and memory</span><span>.</span><br>

<br><span class="">So we did</span> <span class="">the installation of</span> <span class="">new server</span> <span class="">Mysql</span> <span class="">and changed</span> <span class="">the parameters</span> <span class="">possible</span> <span class="">and even</span> <span class="">indicated</span> <span class="">by</span> <span class="">mysqltunner</span> <span class="">and</span> <span class="">mysqlprimer</span><span>,</span> <span class="">but the</span> <span class="">message</span> <span class="">continued</span> <span class="">Discarding</span> <span class="">occurs</span><span>.</span><br>

<br><span class="">So</span> <span class="">we started using</span> <span class="">two tables</span> <span class="">for</span> <span class="">the</span> <span class="">radacct</span><span>,</span> <span class="">but the</span> <span class="">message remains</span><span>.</span><br>

<br><span class="">Finally</span><span>,</span> <span class="">we migrated</span> <span class="">the</span> <span class="">radacct</span> <span class="">for</span> <span class="">postgresql</span><span>,</span> <span class="">where the number</span> <span class="">(</span><span>two</span> <span class="">tables</span><span>)</span> <span class="">where the incidence</span> <span class="">of this message</span> <span class="">decreased</span><span>,</span> <span class="">but remains</span> <span class="">on</span> <span class="">average</span> <span class="">50</span> <span class="">per hour to</span> <span class="">about 1300</span> <span class="">sections</span> <span class="">with</span> <span class="">pppoe</span> <span class="">interim</span><span>-update</span> <span class="">5 minutes</span><span>.</span><br>

<br><span class="">What are the</span> <span class="">parameters</span> <span class="">that could</span> <span class="">be changed</span> <span class="">to make the</span> <span class="">tuning</span> <span class="">of</span> <span class="">freeradius</span><span>?</span><br>

<span class="">The question</span> <span class="">that remains</span> <span class="">...</span> <span class="">MySQL</span> <span class="">or</span> <span class="">PostgreSQL</span><span>?</span><br><br><span class="">We've done</span> <span class="">several</span> <span class="">settings in</span> <span class="">radius</span> <span class="">and</span> <span class="">mysql</span> <span class="">and</span> <span class="">still can not</span> <span class="">stop</span> <span class="">these messages</span><span>.</span><br>

</span><span id="result_box" class="" lang="en"><span class="">Attached</span> <span class="">my</span> <span class="">freeradius settings</span>.<span class=""></span><span class=""></span></span><br><span id="result_box" class="" lang="en"><br>

<span class="">I appreciate</span> <span class="">the attention and</span> <span class="">the help of</span> <span class="">everyone,</span><br><br><span class="">Att</span></span></div>