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

Alan DeKok aland at deployingradius.com
Wed Feb 10 17:04:04 CET 2016

On Feb 10, 2016, at 10:52 AM, Vincent MARCEL <Vincent.MARCEL at monext.net> wrote:
> I am trying to authorize a user through a authorize_check_query on Oracle database.
> When I test, I get this error on my radius server :
> (0) sql: Executing select query: SELECT 1,'FT10895748','User-Password','FT10895748',':=' FROM DUAL

  As the later error message says, DON"T have "User-Password" here.  Use "Cleartext-Password".

> (0) sql: ERROR: Error fetching row
> (0) sql: ERROR: rlm_sql_oracle: ORA-01403: no data found
> But this can't be true, this query always returns 1 row !

  That error is returned from Oracle.  There's very little we can do to fix Oracle.

> Below is the output of my server in debug mode, starting from database connection, ending to the authorize test :

  It still seems to work, so I'm not sure what the problem is.

  Alan DeKok.

More information about the Freeradius-Users mailing list