9 Dec
2014
9 Dec
'14
1:35 p.m.
On Dec 9, 2014, at 12:08 PM, Dave Aldwinckle <daldwinc@uwaterloo.ca> wrote:
When I run an SQL query from freeradius, I get no results. When I copy and paste the query into mysql, there is a result. Configs and debug below; help is appreciated. ... if("%{sql:SELECT COUNT(macaddress) FROM `radmacauthgroup` WHERE macaddress = '%{User-Name}'" > 0){
That query has a typo. It *should* be caught, but the parser isn’t (yet) smart enough to look that deeply into strings. You’re missing a closing brace at the end of the string: … ‘%{User-Name}’}" I’ll see if I can add a test case to catch this. Alan DeKok.