I would like to make the same thing but with the monowall's base (limited acces time).
How make?

Bruno 



-----Message d'origine-----
De : Jonathan De Graeve [mailto:Jonathan dot De dot Graeve at imelda dot be] 
Envoyé : vendredi 7 octobre 2005 12:03
À : FreeRadius users mailing list
Cc : m0n0wall
Objet : [m0n0wall] RE: RE: access for 24 hours after first login?


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



---------------------------------------------------------------------
To unsubscribe, e-mail: m0n0wall dash unsubscribe at lists dot m0n0 dot ch
For additional commands, e-mail: m0n0wall dash help at lists dot m0n0 dot ch