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