Unable to find user in DB.

[mustafa mujahid]

I'm sorry, I sent you the screen shot  of our attempt which we made before changing the table name.


This table that is mentioned in the screenshot is correct. backup.radcheck_office_replica is just a test table we created specifically for this user for testing purposes. it didn't work either. Each time I received user not found.


> [sql]     expand: SELECT id,UserName,Attribute,Value,op FROM radcheck_office where username = '%{SQL-User-Name}' order by id -> SELECT id,UserName,Attribute,Value,op FROM radcheck_office where username = 'test.user' order by id.


is the actual query that is to be compared with the screenshot.


Mustafa.


________________________________
From: Brian Candler <b.candler at pobox.com>
Sent: Tuesday, March 7, 2017 1:00 AM
To: mustafa mujahid; freeradius-users at lists.freeradius.org
Subject: Re: Unable to find user in DB.

On 07/03/2017 06:40, mustafa mujahid wrote:
> [sql]     expand: SELECT id,UserName,Attribute,Value,op FROM backup.radcheck_office_replica where username = '%{SQL-User-Name}' order by id -> SELECT id,UserName,Attribute,Value,op FROM backup.radcheck_office_replica where username = 'test.user' order by id

That's not the same query as you showed in your screenshot.