On Tue, 17 Aug 2004, Charles J. Boening wrote: > That would give a user 30 days total. They could take 6 months to use > it right?
Oh ya, you are right. The suggestion I gave would give 30 days total but it could take forever to expire. > > If you're issuing a scratch type ticket I'm assuming it has a username > and password on it. So you should already have those users in your > database. If your accounting is working right, you could run a nightly > query to see what accounts don't have an expiration and then if those > accounts have ever logged in. If they've logged in and don't have an > expiration, set the expiration for 30 days from the initial login. > > > Charlie > > > > -----Original Message----- > From: Dustin Doris [mailto:[EMAIL PROTECTED] > Sent: Tuesday, August 17, 2004 6:25 AM > To: [EMAIL PROTECTED] > Subject: Re: 30Day Limit > > Check out the rlm_sqlcounter module. Read doc/rlm_sqlcounter. In your > sqlcounter.conf file you can use something like this. > > sqlcounter poolofminutes { > counter-name = Max-All-Session-Time > check-name = Max-All-Session > sqlmod-inst = sql > key = User-Name > reset = never > query = "SELECT SUM(AcctSessionTime) FROM radacct WHERE > UserName='%{%k}'" > } > > Then in your sql table, you'll add something like this for say user bob > > insert into radcheck set UserName = 'bob', Attribute = > 'Max-All-Session-Time', Value = '2592000', op = ':='; > > This will insert the Max-All-Session-Time of 2592000 seconds > (30*24*60*60). > > > Hope that helps, > > -Dusty Doris > > On Tue, 17 Aug 2004, sarky wrote: > > > Hi all > > > > I am using Mysql to do the restrictions. > > > > I want to do something like this: > > When a user logs in for the first time it will give a restriction of > > 30days access time, i.e: logged on: 1st Jan 2004 then it expires 30th > > Jan 2004 > > > > Thank you > > > > Sarky > > > > > > - > > 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 > - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
