rlm_sqlcounter: Max-Daily-Session.

A.L.M.Buxey at lboro.ac.uk A.L.M.Buxey at lboro.ac.uk
Mon May 12 16:28:06 CEST 2014


Hi,

>    Please find my radius -X output.
>    Now, for some reason. It give this error:

the server doesnt just change its config...someone has edited the config to cause this.

I see this error:

(3) noresetcounter : Entering module authorize code
WARNING: Please replace '%k' with '${key}'
sqlcounter_expand:  'SELECT IFNULL(SUM(acctsessiontime -     GREATEST((0 - UNIX_TIMESTAMP(acctstarttime)), 0)),0)     FROM radacct
+WHERE username = '%{User-Name}' AND     UNIX_TIMESTAMP(acctstarttime) + acctsessiontime > '0''
(3) ERROR: noresetcounter : %{sql:SELECT IFNULL(SUM(acctsessiontime -     GREATEST((%b - UNIX_TIMESTAMP(acctstarttime)), 0)),0)
+FROM radacct WHERE username = '%{%k}' AND     UNIX_TIMESTAMP(acctstarttime) + acctsessiontime > '%b'}SELECT            
+IFNULL(SUM(acctsessiontime -     GREATEST((0 - UNIX_TIMESTAMP(acctstarttime)), 0)),0)     FROM radacct WHERE username =         
+'%{User-Name}' AND     UNIX_TIMESTAMP(acctstarttime) + acctsessiontime > '0'}
(3) ERROR: noresetcounter :                                                         ^ Invalid variable expansion
(3)   [noresetcounter] = fail                 "

this doesnt appear to be the provided configuration for 3.x - what tutorial are you following to 
do this to your server?

alan


More information about the Freeradius-Users mailing list