Re: Re[6]: daily limit

On Wed, May 11, 2005 at 04:31:49PM +0700, avudz wrote:
> Hello Marcin,
>
> Wednesday, May 11, 2005, 4:06:52 PM, you wrote:
>
> MJ> Hi.
>
> MJ> As far as I know the sqlcounter will disallow furhter
> MJ> authentrication only if the user has used her time limit quota.
> MJ> The Session-Timeout Attribute will kick him out when loged in
> MJ> and the Max-XYZ-Session will be checked the next time a user wants
> MJ> to login.
> MJ> You would need an additional Attribute for user expiration date as well.
>
> --- mm i c, so i think i need external script to do this ?? like
> Exec-Program ? if min(AcctStartTime) or AcctStartTime == 0 the voucher
> will not expire, or its possible to generate from PHP script and doing
> query to database 'Expire' each time there was authenticate ?
>

I'll second that idea. Definately would need some external maintenance
on the database every night to expire accounts older than 24hrs...

Alternatively, you *can* do some nifty sql query on the authentication query
that compaires radacct to the account being authenticated, but that would be
a performance hit on authentication times. A nightly maintenance run would
be the best way to go IMHO.

--
Chris.


-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html