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