Unable to find user in DB.

[Alan DeKok]

On Mar 7, 2017, at 1:38 AM, mustafa mujahid <mustafa.mujahid at outlook.com> wrote:
> I've been trying to get LAN authentication working on a test radius server v2.2.8 and have run into a problem. My server can't seem to find the user in database. I have verified the exact same query on th DB and it returns the correct query result but somehow radius is unable to find the user. Please see below the debug output :
> ...
> But when the exact same query is run on the DB it returns positive results. please see attached screen shot from DB. Currently my sql.conf file only contains :

  Version 3 prints out the actual SQL statement it's using.  Which means you can cut & paste it into an SQL client program, and run it there.

> authorize_check_query ="SELECT id,UserName,Attribute,Value,op FROM ${authcheck_table} where username = '%{SQL-User-Name}' order by id"
> 
> and queries for accounting but they are not of concern as I only need authentication from this radius so I can match MAC Address against user name, but that comes after. I'm stuck at the first stage. I don't understand what the issue might be . Kindly let me know if I'm missing something or if further information is required. Any help on this would be greatly appreciated.

  The server isn't magic.  It does normal SQL queries as text strings.  If the SQL server doesn't return the "right" data, then either the query is wrong, or the data isn't in the DB.

  Alan DeKok.