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