rad-error

[Ejaz]

>> 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 at lists.freeradius.org] On Behalf Of A.L.M.Buxey at lboro.ac.uk
Sent: Sunday, November 6, 2016 2:49 PM
To: FreeRadius users mailing list <freeradius-users at 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