FreeRadius 3.0.4

[Oscar Jofre]

Thanks for answer Fajar:

>>
>> The database MariaDB 10.x is running on a different server with more 
>> RAM and CPU.
>>
>>
>Do you have a monitoring system setup on THAT server? In particular, something to monitor its disk IOPS usage?
>If you don't, a realtime "iostat -mx 3" on that server will suffice during tests.
>

Yes I setup this tool https://github.com/major/MySQLTuner-perl/tarball/master to setup best performance on database. I will check the one you told.


>
>> I have 10.000 test users connectes with PPoE with 5 minutes timeout 
>> and interim every 1 minute.
>>
>>
>
>Interim 1 minute? really? Is that how you REAL production environment is going to be, or is it just a method to test db scalability? 15 minutes - 1 hour interim should generally be acceptable in production environment.

This is test scalability and to know limits from database and to make grow fast radacct and see how works database with 10.000.000 rows on radacct.
 I will have on production more than 1.000 routers with average 20 users on each router connected during 1h (always 10 connected) and all this routers will be 15 min interim.


>
>DB write operations (including one caused by interim updates) are generally much more expensive than read operations. 1 minute interim for 10k connected users would roughly equal to average of 167 insert/update operations on the DB. That would translate to several times the number of that in disk random write IOPS, probably to around 300-1k IOPS. An average consumer SSD can handle that easily, but a HDD will not be able to provide that number of random write IOPS.
>

Yes there is SSD disk and at the moment i got on test 140.000 rows on radacct every hour (that was with 12.000 users 5 minutes timeout and internim 1 minute - that will be: 12.000 x (60/5) = 144.000)

>
>
>
>>
>> As Alan Dekok told this duplicate key error is because FreeRadius 3.0.4 .
>> but I'm not able to compile and install newer version because is not 
>> on the
>> Centos_7 repository ..
>>
>>
>You're not able to COMPILE? Why?
>Is there a reason that prevents you from building FR RPM from latest 3.x source? If you encounter an error when building it, post the errors so that it can be fixed.
>
>

I've tried but because I'm not developer and not expert on servers and linux is hard to me to build other version thant the one I can download from "official" repository.
And even I've read that 3.0.10 still on test on some environments.

So for my production I really one to use the most stable version. And I prefere to use the one that comes with the centos 7 at the moment 3.0.4.



>
>> Is there any PATCH or file I can modify to fix this error ?
>>
>>
>>
>> 2)
>>
>>
>>
>> I modify max_spare_server to 400 and still you probably need to 
>> increase spare . wich value do you think could be ok ?
>>
>>
>>
>>
>>
>> Do I need to modify any other value ?
>>
>>
>
>I'd say leave FR alone for now, and check your db disk performance. Then either adjust your test scenario, or adjust your hardware.


I'm working and will keep testing to setup the best performance on database (last month I've been doing this... ) at the beginig database was able to handle only 50.000 new rows on radacct every hour, now it's writing 140.000 so new versions of mariaDB and increasing RAM, disk and performance has made tha database works beter.

But I will like to fix this errors on freeRadius (that is working really perfecte).

Is there any possibility to fix this errors on 3.0.4 ? 


Error: rlm_sql_mysql: MySQL error 'Duplicate entry 'e35620bfd04391bc9c6f5afe3628449d' for key 'acctuniqueid''

Fri Nov 20 00:10:14 2015 : Error: rlm_sql (sql): Duplicate entry 'ab0c9cb893d6af4de3388749d7004c2b' for key 'acctuniqueid'

Fri Nov 20 00:10:14 2015 : Error: rlm_sql_mysql: Cannot store result

Fri Nov 20 00:10:14 2015 : Error: rlm_sql_mysql: MySQL error 'Duplicate entry 'ab0c9cb893d6af4de3388749d7004c2b' for key 'acctuniqueid''

Fri Nov 20 00:10:14 2015 : Error: rlm_sql (sql): Duplicate entry '8902d57334a046e00c6231ad91aad63e' for key 'acctuniqueid'

Fri Nov 20 00:10:14 2015 : Error: rlm_sql_mysql: Cannot store result

Fri Nov 20 00:10:14 2015 : Error: rlm_sql_mysql: MySQL error 'Duplicate entry '8902d57334a046e00c6231ad91aad63e' for key 'acctuniqueid''

Fri Nov 20 00:10:23 2015 : Error: rlm_sql (sql): Duplicate entry '4b5b0717c9b3c5f2100ff001efa9f6b3' for key 'acctuniqueid'

Fri Nov 20 00:10:23 2015 : Error: rlm_sql_mysql: Cannot store result

Fri Nov 20 00:10:23 2015 : Error: rlm_sql_mysql: MySQL error 'Duplicate entry '4b5b0717c9b3c5f2100ff001efa9f6b3' for key 'acctuniqueid''


Thanks



>--
Fajar
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html