aland at deployingradius.com
Thu May 16 15:12:03 CEST 2019
On May 16, 2019, at 8:59 AM, myxmail1919--- via Freeradius-Users <freeradius-users at lists.freeradius.org> wrote:
> @Alan DeKok
> so first i used sql daily counters, but it didnt work ! bcs as i know its works only for predefined users,
You can use sql counters. Just read the documentation in raddb/mods-available/sqlcounter
Change the key from "User-Name" to "Calling-Station-Id". If the Calling-Station-Id is just a MAC address, it will work.
> then i made an sql query in authorization section to check data usage for last 24 hours
That may also work, too.
> its didnt work in some networks , because only authentication and accounting packets are sent and not authorization ,
There are no "authorization" packets in RADIUS.
> every networks has more than 2.000 auth req per minute and where authorization packets are sent it gonna be huge load on mysql and sessions takes long time to be stablished and often session time out ...!
2K requests per minute is 33 request/s. Any reasonable SQL database should be able to handle that load.
More information about the Freeradius-Users