Mapping SQL counters to groups
Hello Everyone, We are using freeradius Version 2.1.12, for x86 64bit linux to manage many hotspots for different vendors(groups) who all use our capative portal to provide free wifi to their customers. Right now all no one has a user data(upload/download) limit(daily/weekly/monthly) but Speed(UP/DOWN limits) control and accounting only. Now some of our vendors want data cap, like vendor A want 100 MB/user/day and vendor B want 500 MB/user/month. I have read about SQL Counter and implemented one but the limitation is that will apply throughout vendors(groups). We do not want to have 1 free radius server running for each vendor. Can someone please tell me if it is possible to have some all vendors on same freeradius server with some vendors having no data cap limit for end users, some having daily data limits and some having monthly limit. Policy should apply when a user login from that specific vendor hotspot. Any weblink/idea will be helpful. Thanks in advance. RegardsSY
Many ways. First way- define a distended virtual server for each client and put their requests into that different virtual server. May use different sql tables per group to. Second way use unlang in the default virtual server. Base decisions on client id or address. Those are the 2 quick main ways. alan Ps obligatory upgrade note - upgrade to at least version 2.2.9 now. You don't run the rest of your IT on > 5 year old software do you? :/
Thank Alan for your reply. I will update server and will try to implement using unlang. I am quite new to FR in general to had to read a lot. Is there any other way like implementing SQL counter? I am asking because that's what i am only good at so far. Also, any thread of link for reference? Thanks again and i will upgrade :) On Saturday, October 10, 2015 1:55 PM, Alan Buxey <A.L.M.Buxey@lboro.ac.uk> wrote: Many ways. First way- define a distended virtual server for each client and put their requests into that different virtual server. May use different sql tables per group to. Second way use unlang in the default virtual server. Base decisions on client id or address. Those are the 2 quick main ways. alan Ps obligatory upgrade note - upgrade to at least version 2.2.9 now. You don't run the rest of your IT on > 5 year old software do you? :/
participants (2)
-
Alan Buxey -
Sachin Yadav