access for 24 hours after first login?

Jonathan De Graeve Jonathan.De.Graeve at imelda.be
Fri Oct 7 10:03:15 CEST 2005


>how is the actual comparision of the calculated value in "query" done,
does >it
>mean, that the value returned by "query" has to be smaller than the one
>referred to by "check-name" (in your example Max-Secs-Passed)?

It works quite simple

If ( (Max-Secs-Passed - All-Secs-Passed > 0) => allow access


>what does the line "sqlmod-inst = sql" mean (in
>/usr/share/doc/freeradius/rlm_sqlcounter there is also the value
"sqlcc3", >what
>does this do?)

It are the defined SQL instances in sql.conf

>what about the following:
>
>SELECT TO_DAYS(NOW()) - TO_DAYS(AcctStartTime) from radacct WHERE
UserName >=
>'%(%k)' LIMIT 1;

This query works but I don't use it because of the rounding it gives
me...

>would this mean that a user can login until 23:59 after logged in the
first >time
>that day?

Yes, since he doesn't look at the hour/minutes/seconds...






More information about the Freeradius-Users mailing list