SQL Error

[Axel Luttgens]

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 at 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