Re: Check traffic quota / rlm_sqlcounter

--- On Wed, 4/7/10, Alan DeKok <aland@deployingradius.com> wrote:

  See "man unlang"

Thanks for your hint, Alan.

  In the "authorize" section, do:

    if ("%{sql: SELECT ...quota ...}" <= "%{sql:SELECT ... usage ...}") {         reject     }

I am using the following in the authorize section: if ("%{sql: SELECT Value from radcheck WHERE UserName='%{User-Name}' AND Attribute='Max-Octets';}" <= "%{sql: SELECT (SUM(Ac ctInputOctets + AcctOutputOctets)) FROM radacct WHERE UserName='%{User-Name}';}") { reject } Unfortunatly I get: rlm_sql: Failed to create the pair: Invalid octet string "200000000" for attribute name "Max-Octets" Any idea how to fix that? Cheers, Alexander