Jonathan Bastin wrote:
> *Issue I get is that I always get *
>
> Tue Oct 9 13:43:17 2012 : Info: ++- if ("%{sql: SELECT
> radgroupcheck.value FROM radusergroup Inner Join radgroupcheck ON
> radusergroup.groupname = radgroupcheck.groupname WHERE
> radusergroup.username = '%{User-Name}' AND radgroupcheck.attribute =
> 'CS-Total-Octets-Monthly';}"<= "%{sql: SELECT SUM( AcctInputOctets +
> AcctOutputOctets) FROM radacct WHERE UserName='%{User-Name}' AND
> AcctStartTime > (DATE_SUB(CURDATE(),INTERVAL
> DAYOFMONTH(CURDATE())DAY));}") returns ok
>
> *It doesn’t actualy update the reply biased on what the outcome is of
> the SQL query. Any help would be very much appreciated.*
a) you're using "radiusd -xX". That's not necessary. Just use
"radiusd -X"
b) You're not looking at the debug lines BEFORE that one. They show
why the "if" is taken, or not taken.
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
