thank you ________________________________ From: Freeradius-Users <freeradius-users-bounces+ejazrom=hotmail.com@lists.freeradius.org> on behalf of Alan Buxey <A.L.M.Buxey@lboro.ac.uk> Sent: Sunday, November 6, 2016 4:46:19 PM To: FreeRadius users mailing list; Ejaz; 'FreeRadius users mailing list' Subject: RE: rad-error Hi On 6 November 2016 13:56:49 GMT+00:00, Ejaz <mejaz@cyberia.net.sa> wrote:
SELECT GroupName FROM usergroup WHERE UserName='%{SQL-User-Name}'
Do you mean we don’t have any data in usergroup table??
Look at the query. Look how it got populated. SQL-User-Name was blank. So check in your freeradius sql config to see what it is supposed to represent.
alternative option is in "sql" file, the table name should be as is in oracle database where that table contents users info ??
Obviously the table name needs to be what you've actually chosen to call it. Either you use the table names that freeradius uses out of the box OR you reconfigure freeradius to use the table names that you have chosen to use. alan - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html