SQL Counter for Expiration Attribute - Prepaid Cards

[Mulindwa]

Hi there, 
You can use the frontend tool called daloradius,  it will sort you out in what you are trying to achieve, it uses freeradius as the back end.

------------------------------
On Tue, Jan 1, 2013 12:01 PM MSK Prabhpal S. Mavi wrote:

>
>Dear List Members,
>
>i have working setup of FreeRadius 2x (freeradius-2.1.12-4.el6_3.x86_64)
>including "rlm_sqlcounter" (Max-Daily-Session). User are logged off
>alright when "Max Session Timeout" is reached. But users can re login to
>gain access. The username and passwords are for hotspot. We do not want
>the username and password to work again once it has been used.
>
>For example: prepaid voucher (MySQL username & password) has 1 hour
>access. User should be able to use sum of one hour, either continuously
>once they are logged in or in parts (30min today & 30min tomorrow so on)
>username & password must never work for more than 1 hour to access our
>network. i am bit confuse attribute to use, i would grateful if someone
>can advice the correct attribute to use for the purpose.
>
>Thanks
>
>
>Hi Members,
>
>
>after working for four days still unable to make it work. Alan Buxey
>advised me to implemented "Expiration" Attribute. Expiration works just
>fine. If i specify any date (01 Sep 2013). But i am working to expire
>username after certain amount of time, such as one hour (not one hour
>after first log in) sum of one hour internet used either by one time login
>or multiple logins (30Min morning & 30min afternoon etc..).
>
>i understand i would need sql_counter to achieve. I am trying but not
>working. my configuration.
>
>1.) Created Counter:
>
>sqlcounter expiration {
>               count-attribute = "Acct-Session-Time"
>               counter-name = "Max-Allowed-Session"
>               check-name = "Expiration"
>               sqlmod-inst = "sql"
>               key = "User-Name"
>               reset = "never"
>               query = "SELECT IFNULL(TIME_TO_SEC(TIMEDIFF(NOW(),
>MIN(AcctStartTime))),0) FROM radacct WHERE
>UserName='${key}' ORDER BY AcctStartTime LIMIT 1;"
>
>
>2.) Added in radiusd.conf
>
>
>instantiate {
>        expiration
>}
>
>
>3.) Added under auth section:
>
>
>authorize {
>        expiration
>}
>
>
>When we expire account with expiration attribute which kind of value can
>we define to the attribute so that account gets expire after 1 hour of
>internet use (using sql counter). Date format is working alright (01 Sep
>2013).
>
>
>Thanks everyone for attending to this material.
>
>
>
>
>
>
>
>
>-
>List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html