On 21 Jul 2014, at 10:09, David Peterson <davidp@wirelessconnections.net> wrote:
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:
rlm_sql (sql): Reserved connection (4) (6) sql : EXPAND SELECT id, username, attribute, value, op FROM radcheck WHERE username = '%{SQL-User-Name}' ORDER BY id (6) sql : --> SELECT id, username, attribute, value, op FROM radcheck WHERE username = 'test@WiMax.com' ORDER BY id rlm_sql (sql): Executing query: 'SELECT id, username, attribute, value, op FROM radcheck WHERE username = 'test@WiMax.com' ORDER BY id' (6) sql : User found in radcheck table (6) sql : Check items matched (6) sql : EXPAND SELECT id, username, attribute, value, op FROM radreply WHERE username = '%{SQL-User-Name}' ORDER BY id (6) sql : --> SELECT id, username, attribute, value, op FROM radreply WHERE username = 'test@WiMax.com' ORDER BY id rlm_sql (sql): Executing query: 'SELECT id, username, attribute, value, op FROM radreply WHERE username = 'test@WiMax.com' ORDER BY id' (6) sql : EXPAND # SELECT groupname # FROM radusergroup # WHERE username = BINARY '%{SQL-User-Name}' # ORDER BY priority (6) sql : --> # SELECT groupname # FROM radusergroup # WHERE username = BINARY 'test@WiMax.com' # ORDER BY priority rlm_sql (sql): Executing query: '# SELECT groupname # FROM radusergroup # WHERE username = BINARY 'test@WiMax.com' # ORDER BY priority' rlm_sql_mysql: MYSQL Error: No Fields rlm_sql_mysql: MYSQL error: (6) sql : User not found in any groups
https://github.com/FreeRADIUS/freeradius-server/blob/v3.0.x/doc/ChangeLog#L2... I guess you're using a version < 3.0.2? Arran Cudbard-Bell <a.cudbardb@freeradius.org> FreeRADIUS development team FD31 3077 42EC 7FCD 32FE 5EE2 56CF 27F9 30A8 CAA2