Not using mysql. you must peruse the manual pages about how to do it in your mysql module, however, the magic lies in the users file. you need a stanza similar to the following (but modified for sql) DEFAULT Ldap-Group == "WifiDisabled", Auth-Type := Reject Reply-Message = "Your account has been disabled." On 9/13/2011 18:33, 2394263740 wrote:
Christ, Thanks for your help. Can you please advise how to configurre a group reject access? Thanks! Tom ------------------ Original ------------------ *From: * "freeradius-users"<freeradius-users-request@lists.freeradius.org>; *Date: * Wed, Sep 14, 2011 02:01 AM *To: * "freeradius-users"<freeradius-users@lists.freeradius.org>; *Subject: * Freeradius-Users Digest, Vol 77, Issue 51 Send Freeradius-Users mailing list submissions to freeradius-users@lists.freeradius.org
To subscribe or unsubscribe via the World Wide Web, visit http://lists.freeradius.org/mailman/listinfo/freeradius-users or, via email, send a message with subject or body 'help' to freeradius-users-request@lists.freeradius.org
You can reach the person managing the list at freeradius-users-owner@lists.freeradius.org
When replying, please edit your Subject line so it is more specific than "Re: Contents of Freeradius-Users digest..."
Today's Topics:
1. RE: Problem with rml_sqlcounter with GigaByte datavolume (Nicolas FOUREL) 2. Re: Problem with rml_sqlcounter with GigaByte datavolume (Suman Dash) 3. Re: Best Practices - maximum NAS entries in clients.conf (Christ Schlacta) 4. Re: Quick enable/disable user account. (Christ Schlacta) 5. Re: Best Practices - maximum NAS entries in clients.conf (Arran Cudbard-Bell)
----------------------------------------------------------------------
Message: 1 Date: Tue, 13 Sep 2011 18:30:55 +0200 From: "Nicolas FOUREL" <nicolas.fourel@adipsys.com> Subject: RE: Problem with rml_sqlcounter with GigaByte datavolume To: "'FreeRadius users mailing list'" <freeradius-users@lists.freeradius.org> Message-ID: <4e6f8544.8dc5e30a.148c.558f@mx.google.com> Content-Type: text/plain; charset="iso-8859-1"
Hi Arran,
I have get version 3.0.0 with 64 bit counters support from Git and installed it. Unfortunatly, I still have the same problem with my sql counter which has always "check_item=0" when I put a value bigger than 2^32. On Access-Request in debug mode, I have the following lines :
Tue Sep 13 18:20:47 2011 : Debug: rlm_sqlcounter: (Check item - counter) is less than zero Tue Sep 13 18:20:47 2011 : Debug: rlm_sqlcounter: Rejected user foo@bar.com, check_item=0, counter=68882
Here is my counter definition : sqlcounter totalinputoctets { counter-name = Total-Max-Input-Octets check-name = Max-Input-Octets reply-name = ChilliSpot-Max-Input-Octets sqlmod-inst = sql key = User-Name reset = never query = "SELECT SUM(AcctInputOctets) FROM radacct WHERE UserName='%{%k}'" }
I have added "Max-Input-Octets" in the dictionary file like that : ATTRIBUTE Max-Input-Octets 3001 integer64
In radcheck table: foo@bar.com Max-Input-Octets := 107374182400
Did I miss a thing ?
Many thanks
Nicolas
-----Message d'origine----- De?: freeradius-users-bounces+nicolas.fourel=adipsys.com@lists.freeradius.org [mailto:freeradius-users-bounces+nicolas.fourel=adipsys.com@lists.freeradius .org] De la part de Arran Cudbard-Bell Envoy??: lundi 12 septembre 2011 11:46 ??: FreeRadius users mailing list Objet?: Re: Problem with rml_sqlcounter with GigaByte datavolume
On 12 Sep 2011, at 10:20, nfourel wrote:
Thanks for your reply but I can't find any version 3.x.x of freeRADIUS. Where can I find it ?
3.x.x is currently in development on the master branch.
-Arran
Arran Cudbard-Bell a.cudbardb@freeradius.org
RADIUS - Waging war on ignorance and apathy one Access-Challenge at a time.
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
------------------------------
Message: 2 Date: Tue, 13 Sep 2011 23:09:39 +0530 From: Suman Dash <sumandash@gmail.com> Subject: Re: Problem with rml_sqlcounter with GigaByte datavolume To: FreeRadius users mailing list <freeradius-users@lists.freeradius.org> Message-ID: <CAOywgS8G==MvAZPs=s18pYsN36mA+xzGScb9e0KvcPELOHFsng@mail.gmail.com> Content-Type: text/plain; charset="iso-8859-1"
SELECT SUM(AcctInputOctets) FROM radacct WHERE UserName='username'
Run the above query in mysql and post the result
then post the freeradius log specific to this section.
On Tue, Sep 13, 2011 at 10:00 PM, Nicolas FOUREL <nicolas.fourel@adipsys.com
wrote:
Hi Arran,
I have get version 3.0.0 with 64 bit counters support from Git and installed it. Unfortunatly, I still have the same problem with my sql counter which has always "check_item=0" when I put a value bigger than 2^32. On Access-Request in debug mode, I have the following lines :
Tue Sep 13 18:20:47 2011 : Debug: rlm_sqlcounter: (Check item - counter) is less than zero Tue Sep 13 18:20:47 2011 : Debug: rlm_sqlcounter: Rejected user foo@bar.com, check_item=0, counter=68882
Here is my counter definition : sqlcounter totalinputoctets { counter-name = Total-Max-Input-Octets check-name = Max-Input-Octets reply-name = ChilliSpot-Max-Input-Octets sqlmod-inst = sql key = User-Name reset = never query = "SELECT SUM(AcctInputOctets) FROM radacct WHERE UserName='%{%k}'" }
I have added "Max-Input-Octets" in the dictionary file like that : ATTRIBUTE Max-Input-Octets 3001 integer64
In radcheck table: foo@bar.com Max-Input-Octets := 107374182400
Did I miss a thing ?
Many thanks
Nicolas
-----Message d'origine----- De : freeradius-users-bounces+nicolas.fourel=adipsys.com@lists.freeradius.org [mailto:freeradius-users-bounces+nicolas.fourel =adipsys.com@lists.freeradius .org] De la part de Arran Cudbard-Bell Envoy? : lundi 12 septembre 2011 11:46 ? : FreeRadius users mailing list Objet : Re: Problem with rml_sqlcounter with GigaByte datavolume
On 12 Sep 2011, at 10:20, nfourel wrote:
Thanks for your reply but I can't find any version 3.x.x of freeRADIUS. Where can I find it ?
3.x.x is currently in development on the master branch.
-Arran
Arran Cudbard-Bell a.cudbardb@freeradius.org
RADIUS - Waging war on ignorance and apathy one Access-Challenge at a time.
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html