Re: Re[8]: daily limit

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 <mahfudz@cyber-isp.net> 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