Fixed Duration Weekly, Monthly and Daily Accounts

Fajar A. Nugraha list at
Sat Nov 12 14:03:22 CET 2011

On Sat, Nov 12, 2011 at 7:49 PM, JennyBlunt <jennyshoehorn at> wrote:
> Thanks for the help, that's very useful. I can get the time in there now but
> have a question about getting our access-period out.
> In post-auth, I've tried this query to get the access-period out:
> if (! "%{control.Tmp-String-0}") {
>    update control {
>      Tmp-String-2 := "%{sql: SELECT value FROM radcheck WHERE
> username='%{User-Name}' and attribute = 'Access-Period'}"
>      Tmp-String-3 := "%{sql: INSERT INTO radcheck
> (username,attribute,op,value) values ('%{User-Name}', 'Expiration', ':=',
> '%{Tmp-String-2}')}; SELECT NOW()"
>    }
>  }
> In freeradius, Tmp-String-2 has no value, whereas if I run the query in
> mysql, I get a value of 86400 (I know the above doesn't sum anything).
> How can I get and use the value?

I don't think Access-Period is a valid attribute (are you using your
own dictionary?)

Anyway, if you think freeradius is not passing the correct query, try
activating mysql's general query log: . It should
print out exactly what queries are recevied by mysql, and you can run
those queries manually. Pretty handy for debug cases of mismatched
quotes or brackets.


More information about the Freeradius-Users mailing list