freeradius 3 sqlcounter not expanding and executing sql query

Heinz Ketchup tonitester at
Fri Nov 1 23:19:18 CET 2013

Thank you Alan,

but this query *does* exist in the default raddb/mods-config/sql/counter/mysql/queries.conf.
I only renamed the counter name itself from expire_on_login to expire_on_firstuse.

To make sure I also tried with the completely original "dailycounter" with exactly same result.
expand: "%{sql:%{sql:}" -> ''

Can I or will you do something about it in the code?

Thank you!

Am 01.11.2013 um 18:32 schrieb Alan DeKok:

> Heinz Ketchup wrote:
>> debug output:
>> (0) expire_on_firstuse : Entering module authorize code
>> (0) expire_on_firstuse : expand: "%{sql:%{sql:}" -> ''
>  Well, fix that.  That query doesn't exist in the default
> configuration.  So it's only there because you edited the config files
> to add it in.
>> Any ideas what is going wrong???
>  The query in the config file is wrong.

More information about the Freeradius-Users mailing list