[ previous ] [ next ] [ threads ]
 
 From:  "Bruno LAURET" <bruno dot lauret at semita dot fr>
 To:  "Jonathan De Graeve" <Jonathan dot De dot Graeve at imelda dot be>
 Cc:  "m0n0wall" <m0n0wall at lists dot m0n0 dot ch>
 Subject:  RE : [m0n0wall] RE: RE: access for 24 hours after first login?
 Date:  Mon, 28 Nov 2005 12:27:32 +0400
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] 


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