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.