<div dir="ltr">would u please show me the code u used?<br><br><div class="gmail_quote">On Fri, Apr 9, 2010 at 4:27 PM, Alexander <span dir="ltr"><<a href="mailto:alexander_austria@yahoo.com">alexander_austria@yahoo.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;"><div class="im">--- On Wed, 4/7/10, Alan DeKok <<a href="mailto:aland@deployingradius.com">aland@deployingradius.com</a>> wrote:<br>
><br>
</div><div class="im">> See "man unlang"<br>
><br>
> In the "authorize" section, do:<br>
><br>
> if ("%{sql: SELECT ...quota ...}" <=<br>
> "%{sql:SELECT ... usage ...}") {<br>
> reject<br>
> }<br>
<br>
</div>Finally I got it to work. Thanks!<br>
<br>
Only drawback is that there must be traffic quota configured per user otherwise I get an access reject because of the SQL query.<br>
<br>
Is it possible to first check if there is a user traffic quota and if not fallback to the group traffic quota?<br>
<br>
Cheers,<br>
<font color="#888888">Alexander<br>
</font><div><div></div><div class="h5"><br>
<br>
<br>
<br>
<br>
-<br>
List info/subscribe/unsubscribe? See <a href="http://www.freeradius.org/list/users.html" target="_blank">http://www.freeradius.org/list/users.html</a><br>
</div></div></blockquote></div><br></div>