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