22 Jul
2014
22 Jul
'14
10:50 a.m.
Le 22 juil. 2014 à 14:01, David Peterson a écrit :
OK I am seeing some strangeness from the sql query for the group user lookup. The table exists and the entry for this user exists, I ran the query manually. mysql> select groupname from radusergroup where username = BINARY'test@WiMax.com'; +-----------+ | groupname | +-----------+ | Test | +-----------+ 1 row in set (0.00 sec)
But here is what FreeRadius shows:
[...] (6) sql : EXPAND # SELECT groupname # FROM radusergroup # WHERE username = BINARY '%{SQL-User-Name}' # ORDER BY priority [...]
Hello David, Looks like there is a missing # in file raddb/mods-config/sql/main/mysql/queries.conf around line 128. HTH, Axel