Errata. I meant radgroupcheck, not radgroupreply.
On Wed, 11 May 2005 12:09:01 +0200 Marcin Jessa <[EMAIL PROTECTED]> wrote: > Hi. > > Yepp, that should work, i.e. > > mysql> select * from radcheck; > +----+----------+-------------------+----+------------+ > | id | UserName | Attribute | op | Value | > +----+----------+-------------------+----+------------+ > | 5 | yazzy | User-Password | := | yazzy | > | 6 | yazzy | Max-Daily-Session | := | 3600 | > | 7 | yazzy | Expiration | := | 2005-01-10 | > +----+----------+-------------------+----+------------+ > > Or you could put it to the readgroupreply table as well for your group. > > > > On Wed, 11 May 2005 16:56:53 +0700 > avudz <[EMAIL PROTECTED]> wrote: > > > > > Wednesday, May 11, 2005, 4:36:26 PM, you wrote: > > > > > > > > CK> I'll second that idea. Definately would need some external maintenance > > CK> on the database every night to expire accounts older than 24hrs... > > > > CK> Alternatively, you *can* do some nifty sql query on the authentication > > query > > CK> that compaires radacct to the account being authenticated, but that > > would be > > CK> a performance hit on authentication times. A nightly maintenance run > > would > > CK> be the best way to go IMHO. > > > > --- thanks so much for response and idea, btw last *hope* :-) is it > > possible to do like this : > > > > Database changed > > mysql> select * from radgroupcheck; > > +----+-----------+-----------------+----+------------+ > > | id | GroupName | Attribute | op | Value | > > +----+-----------+-----------------+----+------------+ > > [SNIP] > > | 6 | test | Expiration | := | 2005-01-10 | > > +----+-----------+-----------------+----+------------+ > > 4 rows in set (0.00 sec) > > > > so all user which in group test if date > 10-01-2005 will expire. > > *last hope* :-) > > > > -- > > Best regards, > > avudz > > > > > > - > > 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