i mean where to set Max Daily Session time for Calling station ID ? On Thursday, May 16, 2019, 3:11:56 PM GMT+2, Alan DeKok <aland@deployingradius.com> wrote: On May 16, 2019, at 8:59 AM, myxmail1919--- via Freeradius-Users <freeradius-users@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. Alan DeKok.