Check traffic quota / rlm_sqlcounter

[Alan DeKok]

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.