Query help

Alan DeKok aland at deployingradius.com
Tue Oct 9 15:16:52 CEST 2012


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.


More information about the Freeradius-Users mailing list