sqlcounter_expire_on_login module

Johan Meiring jmeiring at pcservices.co.za
Thu May 3 09:45:15 CEST 2012

On 2012/05/03 09:37 AM, tonimanel wrote:
> Hi everybody,
> I have been looking for how to solve this: A user log in to freeradius, and
> after the first login, exactly one day later the access should to expire.
> Example:
> User: 'aaa' - 1 day (24hours).
> First login: 2012-04-02 12:00:00
> Expires on: 2012-04-03 12:00:00
> I have enabled sqlcounter_expire_on_login module, when user log in first
> time, there are not uses (radacct is empty for this user) but,
> sqlcounter_expire_on_login's query returns empty set value, not returns a
> valid value (for example 0) so, when freeradius check the return, says this:

Modify your query...

select ifnull((The rest of your query),0)

It will then return 0 when no records are found.


Johan Meiring
Cape PC Services CC
Tel: (021) 883-8271
Fax: (021) 886-7782

Before acting on this email or opening any attachments
you should read Cape PC Service's email disclaimer at:


More information about the Freeradius-Users mailing list