Re: Freeradius Expire-After How To .. ?

2013-04-02 Thread Muhammad Nuzaihan bin Kamal Luddin 
Hi,

Have you tried expiration module?

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;
}

of course you have to put expiration (without quotes) in:

instantiate portion of radiusd.conf
accounting section of sql.conf (or sites-available/default file in
debian)

You may have to add Expiration in the check attributes as well.


From what i have looked within daloradius code, you will need to set the
time settings in Plan.

Regards,
Muhammad Nuzaihan Bin Kamal Luddin

On Mon, 2013-04-01 at 17:12 +, Russell Mike wrote:
 Hi List,
 
 
 i need to expire the prepaid card after three months of first login.
 after reading mail achieves, i was able to figured out that i need to
 use Expire-After  FR attribute and value in seconds. i was bit of
 unclear how to bring the module in to the action because i am unable
 to locate Expire-After attribute to users (Through Daloradius).
 Someone please help ...
 
 
 # Default Module Came With FR v2.2
 
 
 sqlcounter expire_on_login {
 counter-name = Expire-After-Initial-Login
 check-name = Expire-After
 sqlmod-inst = sql
 key = User-Name
 reset = never
 query = SELECT TIME_TO_SEC(TIMEDIFF(NOW(), acctstarttime)) \
  FROM radacct \
  WHERE UserName='%{${key}}' \
  ORDER BY acctstarttime \
  LIMIT 1;
 }
 
 
 
 
 Thanks / Regards
 
 
 RM --
 -
 List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html


-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Re: Freeradius Expire-After How To .. ?

2013-04-02 Thread Russell Mike 
Thanks Muhammed,

Expiration module (Attribute) works for me already, if i want to expie a
account on the calendar date. it does the job just fine. i need to expire
the account after 90 days but count must start after first login.
Your help is appreciated / Thanks


On Tue, Apr 2, 2013 at 9:58 AM, Muhammad Nuzaihan bin Kamal Luddin 
muham...@taqisystems.com wrote:

 Hi,

 Have you tried expiration module?

 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;
 }

 of course you have to put expiration (without quotes) in:

 instantiate portion of radiusd.conf
 accounting section of sql.conf (or sites-available/default file in
 debian)

 You may have to add Expiration in the check attributes as well.


 From what i have looked within daloradius code, you will need to set the
 time settings in Plan.

 Regards,
 Muhammad Nuzaihan Bin Kamal Luddin

 On Mon, 2013-04-01 at 17:12 +, Russell Mike wrote:
  Hi List,
 
 
  i need to expire the prepaid card after three months of first login.
  after reading mail achieves, i was able to figured out that i need to
  use Expire-After  FR attribute and value in seconds. i was bit of
  unclear how to bring the module in to the action because i am unable
  to locate Expire-After attribute to users (Through Daloradius).
  Someone please help ...
 
 
  # Default Module Came With FR v2.2
 
 
  sqlcounter expire_on_login {
  counter-name = Expire-After-Initial-Login
  check-name = Expire-After
  sqlmod-inst = sql
  key = User-Name
  reset = never
  query = SELECT TIME_TO_SEC(TIMEDIFF(NOW(), acctstarttime)) \
   FROM radacct \
   WHERE UserName='%{${key}}' \
   ORDER BY acctstarttime \
   LIMIT 1;
  }
 
 
 
 
  Thanks / Regards
 
 
  RM --
  -
  List info/subscribe/unsubscribe? See
 http://www.freeradius.org/list/users.html


 -
 List info/subscribe/unsubscribe? See
 http://www.freeradius.org/list/users.html

-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Freeradius Expire-After How To .. ?

2013-04-01 Thread Russell Mike 
Hi List,

i need to expire the prepaid card after three months of first login. after
reading mail achieves, i was able to figured out that i need to use 
Expire-After  FR attribute and value in seconds. i was bit of unclear how
to bring the module in to the action because i am unable to locate
Expire-After
attribute to users (Through Daloradius). Someone please help ...

# Default Module Came With FR v2.2

sqlcounter expire_on_login {
counter-name = Expire-After-Initial-Login
check-name = Expire-After
sqlmod-inst = sql
key = User-Name
reset = never
query = SELECT TIME_TO_SEC(TIMEDIFF(NOW(), acctstarttime)) \
 FROM radacct \
 WHERE UserName='%{${key}}' \
 ORDER BY acctstarttime \
 LIMIT 1;
}


Thanks / Regards

RM --
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html