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

Matthew Newton mcn4 at leicester.ac.uk
Thu Feb 11 18:35:57 CET 2016

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 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>

More information about the Freeradius-Users mailing list