[ previous ] [ next ] [ threads ]
 From:  "Jonathan De Graeve" <Jonathan dot De dot Graeve at imelda dot be>
 To:  "FreeRadius users mailing list" <freeradius dash users at lists dot freeradius dot org>
 Cc:  "m0n0wall" <m0n0wall at lists dot m0n0 dot ch>
 Subject:  RE: RE: access for 24 hours after first login?
 Date:  Fri, 7 Oct 2005 10:03:15 +0200
>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

>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...