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