Re[8]: daily limit

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