SQL error
David Peterson
davidp at wirelessconnections.net
Mon Jul 21 16:09:25 CEST 2014
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 at 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 at WiMax.com' ORDER BY id
rlm_sql (sql): Executing query: 'SELECT id, username, attribute, value, op
FROM radcheck WHERE username = 'test at 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 at WiMax.com' ORDER BY id
rlm_sql (sql): Executing query: 'SELECT id, username, attribute, value, op
FROM radreply WHERE username = 'test at 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 at WiMax.com' # ORDER BY priority
rlm_sql (sql): Executing query: '# SELECT groupname # FROM
radusergroup # WHERE username = BINARY 'test at 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
More information about the Freeradius-Users
mailing list