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.