SQL error

[Arran Cudbard-Bell]

On 21 Jul 2014, at 10:09, David Peterson <davidp at 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 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

https://github.com/FreeRADIUS/freeradius-server/blob/v3.0.x/doc/ChangeLog#L281

I guess you're using a version < 3.0.2?

Arran Cudbard-Bell <a.cudbardb at freeradius.org>
FreeRADIUS development team

FD31 3077 42EC 7FCD 32FE 5EE2 56CF 27F9 30A8 CAA2

-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 881 bytes
Desc: Message signed with OpenPGP using GPGMail
URL: <http://lists.freeradius.org/pipermail/freeradius-users/attachments/20140721/8f630bef/attachment.pgp>