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@pobox.com> Sent: Tuesday, March 7, 2017 1:00 AM To: mustafa mujahid; freeradius-users@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.