rlm_sqlcounter: Max-Daily-Session.

12 May 2014

      Hi,

I have to follow this tutorial to get the the session limit working. But
looking at the debug output it seems the sql counter is not executed. No
Session-Timeout is sent to NAS as well.

Accounting is working fine. I can see all the accounting information
radacct time.

Here is my configuration. Please let me know if I should provide more
information.

Jake He

FreeRADIUS V. 3

mods-enabled/sqlcounter

sqlcounter noresetcounter {
        sql_module_instance = sql
        #dialect = ${sql_module_instance}.dialect
        dialect = mysql
        counter_name = Daily-Session-Time
        check_name = Max-Daily-Session
        reply_name = Session-Timeout
        key = User-Name
        reset = never
        query = “SELECT SUM(AcctSessionTime) FROM radacct where
UserName=’%{%k}’”
}

sites-enabled/default:

authorize {

preprocess
chap
mschap
suffix
eap
files
sql
pap
noresetcounter
}

radcheck:
Max-Daily-Session:=60 for the user bob

rlm_sqlcounter: Max-Daily-Session.

*