set absolute lifetimes

[Ivan Kalik]

> I've got a problem with the accounting of freeradius. The counter and
> sqlcounter are
> made for scenarios where people'll get a number of hours and can take them
> where
> ever they want to...
>
> I would like to setup a scenario where people can login for 1/2/3/4/...
> days.
> Let's say somebody is allowed to login for one day...then he shouldn't be
> able to
> login half a day today and half a day tomorrow.
> I would like to make "one day" absolute - to end at the end of day1.
>
>
> Into "radcheck" I would like to write something like
> Current-Time <= a value you set while creating the "ticket".
> Let's suppose everything to be in Unix Time format...
>
>
> I tried to write in the radius config in the modules part:
>
> 	sqlcounter maxlifetimecouter {
> 		counter-name = Max-End-Lifetime-Counter
> 		check-name = Current-Time
> 		sqlmod-inst = sql
> 		key = User-Name
> 		reset = never
> 		query = "SELECT UNIX_TIMESTAMP();"
> 	}
>
> But it didn't work out. To have got a cron job
> that will delete expired accounts (like [1]) isn't
> an option either...
>
> Can you please help me? :-(

Use Expiration attribute.

Ivan Kalik
Kalik Informatika ISP