Check traffic quota / rlm_sqlcounter
Dear all, please forgive me if this has been answered before but I have searched the list archive, FAQ and docs over and over again, without success so far. 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. 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! BTW: I am using a Cisco 7206/NPE-G1 w/ 12.4 as LNS. Cheers, Alexander
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.
participants (2)
-
Alan DeKok -
Alexander