Check traffic quota / rlm_sqlcounter
aland at deployingradius.com
Wed Apr 7 14:02:19 CEST 2010
> 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.
More information about the Freeradius-Users