[EXTERNAL] Limiting Max daily session

myxmail1919 at yahoo.com myxmail1919 at yahoo.com
Fri Apr 5 15:49:14 CEST 2019

 i set the quote of Max-daily-session in /etc/freeradius/3.0/dictionary   is it right ? 
and as i know i can run a mysql query to authorize a user !
so it will be mysql query that checkt for SUM(acctsessiontime)  and if bigger than 10800 in wont let user to be authorized ! 
DHCP leasse time is set to 30 minutes 

    On Friday, April 5, 2019, 12:54:45 PM GMT+2, Winfield, Alister <Alister.Winfield at sky.uk> wrote:  
 You need to understand the equipment managing the users sessions...

It 'might' support quotas in some way including associated accounting.
It 'might' only support the default timeout options in which case work that out.
It 'might' claim to support the above options but not really work well because its behaviour is broken w.r.t. DHCP clients having leases longer than the timeout.

Note first step how does your equipment behave and what can you do with RADIUS attributes. Then work out what FR needs to do to get it to happen. One thing you can't avoid, however, is storing state, no matter how you do this you are tracking the time usage of a 'device' across distinct sessions.

On 05/04/2019, 11:13, "Freeradius-Users on behalf of myxmail1919--- via Freeradius-Users" <freeradius-users-bounces+alister.winfield=sky.uk at lists.freeradius.org on behalf of freeradius-users at lists.freeradius.org> wrote:

    Hi Guys,

    its a long time that im busy withConfiguring Freeradius to limiting daily usage time for all users,

    would you please help me ?

    I tried a lot of things but did not getany result ….

    Im using  freeradius 3.0.16and mysql

    There is more than 300.000 users and Iwant to set daily usage limit to 3 Hours !

    There is MAC-based access control and allow everyone toconnect,  so have no databases for users,

    I tried Max-daily-session withmysqlcounter  so it was not successful,
    Cansomeone tell me step by step what should I do ?

    thank you

Information in this email including any attachments may be privileged, confidential and is intended exclusively for the addressee. The views expressed may not be official policy, but the personal views of the originator. If you have received it in error, please notify the sender by return e-mail and delete it from your system. You should not reproduce, distribute, store, retransmit, use or disclose its contents to anyone. Please note we reserve the right to monitor all e-mail communication through our internal and external networks. SKY and the SKY marks are trademarks of Sky Limited and Sky International AG and are used under licence.

Sky UK Limited (Registration No. 2906991), Sky-In-Home Service Limited (Registration No. 2067075), Sky Subscribers Services Limited (Registration No. 2340150) and Sky CP Limited (Registration No. 9513259) are direct or indirect subsidiaries of Sky Limited (Registration No. 2247735). All of the companies mentioned in this paragraph are incorporated in England and Wales and share the same registered office at Grant Way, Isleworth, Middlesex TW7 5QD

More information about the Freeradius-Users mailing list