sql: ERROR: rlm_sql_oracle: ORA-01403: no data found

[Matthew Newton]

On Thu, Feb 11, 2016 at 05:19:29PM +0000, Vincent MARCEL wrote:
> >  Your query doesn't return data from the database

> (1) sql: ERROR: Error fetching row
> (1) sql: ERROR: rlm_sql_oracle: ORA-01403: no data found
> 
> Here is the result of the copy/paste query in sqlplus :
> SQL> SELECT distinct 1,NUM_SERIE,'Cleartext-Password',NUM_SERIE,':=' FROM E_MEMA_TPE WHERE NUM_SERIE = 'FT10895748';
> 
>          1 NUM_SERIE            'CLEARTEXT-PASSWOR NUM_SERIE            ':
> ---------- -------------------- ------------------ -------------------- --
>          1 FT10895748           Cleartext-Password FT10895748           :=

Just a thought... in sqlplus are you using the same user with the
same permission to read the database as FreeRADIUS is using?

Matthew


-- 
Matthew Newton, Ph.D. <mcn4 at le.ac.uk>

Systems Specialist, Infrastructure Services,
I.T. Services, University of Leicester, Leicester LE1 7RH, United Kingdom

For IT help contact helpdesk extn. 2253, <ithelp at le.ac.uk>