SELECT GroupName FROM usergroup WHERE UserName='%{SQL-User-Name}'
Do you mean we don’t have any data in usergroup table?? alternative option is in "sql" file, the table name should be as is in oracle database where that table contents users info ?? Thank you so much for your help. -----Original Message----- From: Freeradius-Users [mailto:freeradius-users-bounces+mejaz=cyberia.net.sa@lists.freeradius.org] On Behalf Of A.L.M.Buxey@lboro.ac.uk Sent: Sunday, November 6, 2016 2:49 PM To: FreeRadius users mailing list <freeradius-users@lists.freeradius.org> Subject: Re: rad-error Hi,
Would you please assist me to get rid of this problem,
you need to fix your SQL config the debug clearly shows what is happening.....so you need to work with that. look:
(31) sql: ERROR: Error fetching row (31) sql: ERROR: rlm_sql_oracle: ORA-01403: no data found
so thats thwe error. lets look to see why (debug tells us!)
(31) sql: EXPAND SELECT GroupName FROM usergroup WHERE UserName='%{SQL-User-Name}'
(31) sql: --> SELECT GroupName FROM usergroup WHERE UserName=''
there. SELECT GroupName FROM usergroup WHERE UserName='' I bet if you go onto the database server and run that query, you will get the same result. no answers. so, why is UserName='' ? well, look a couple of lines up and the server debug tells you what it is doing EXPAND SELECT GroupName FROM usergroup WHERE UserName='%{SQL-User-Name}' so, obviously, UserName='%{SQL-User-Name}' enumerated to '' - so, you need to fix your sql config in FreeRADIUS to ensure that %{SQL-User-Name} is mapped to something that actually exists....so you need to go through the debug - and not just look at the error bit...go back a few more dozen lines and you'll see what the request looks like...and therefore what happens to the values.... eg whether Stripped-User-Name is actually populated etc etc. alan - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html