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 +0000, 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