Unable to find user in DB.

[mustafa mujahid]

It's not working thats whats confusing me. Running the exact same query in DB client returns the user information but radius reports 'user not found' , I execute the exact same query that shows up in the debug output after EXPAND --> "query".  I'll keep trying and update if I come up with something. If anyone has any ideas kindly let me know . Thankyou



________________________________
From: Freeradius-Users <freeradius-users-bounces+mustafa.mujahid=outlook.com at lists.freeradius.org> on behalf of Alan DeKok <aland at deployingradius.com>
Sent: Tuesday, March 7, 2017 6:17 AM
To: FreeRadius users mailing list
Subject: Re: Unable to find user in DB.

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.


-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
FreeRADIUS -- users' list info<http://www.freeradius.org/list/users.html>
www.freeradius.org
Users' List Information. The freeradius-users mailing list is for users of the FreeRADIUS server not Cistron's server! There are a few house-rules to which we'd like ...