Check traffic quota / rlm_sqlcounter

Alan DeKok aland at
Wed Apr 7 14:02:19 CEST 2010

Alexander wrote:
> What I want to achieve is *traffic quota* enforcement per user at login time. E.g. user is permitted a quota of 100 MB and authentication shall be rejected if the traffic limit is exceeded. What I understood so far is hat I need a script to do a traffic quota check at authentication and configure sqlcounter.conf accordingly.

  You need to:

a) store traffic data in the DB when an accounting packet is received

b) check that on loging

  You shouldn't need to use sqlcounter.  Just a plain SELECT will do it.

> Has anyone done this before with FR 2.1 plus rlm_sqlcounter and MySQL? Would someone share his *script* snippets and relevant config parts with me? Where do I have to include the script in FR to make it work? Help is really appreciated!

  Write the logic in Perl first, then convert it to the server config.

  Alan DeKok.

More information about the Freeradius-Users mailing list