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

[Alan DeKok]

On Feb 11, 2016, at 11:53 AM, Vincent MARCEL <Vincent.MARCEL at monext.net> wrote:
> 
> Thank you, my radius server is working fine now, except thoses unjustified ORA-01403 errors each time a user authorization is tested.

  It's an Oracle problem.

http://www.orafaq.com/wiki/ORA-01403

  Your query doesn't return data from the database, so Oracle claims that it fails.  The solution is to use the database as a database.

> ORA-01403 is not correct because data is found. Injecting the query in sqlplus don't make ORA-01403 error, so I think it is a radius problem.

  Please think about it a little.

  FreeRADIUS doesn't invent Oracle errors.  It can't.  FreeRADIUS queries Oracle, which returns an error.

  It is 100% an Oracle problem.

> Finally, everything works great except that my log file is contaminated with 2 unjustified ERROR lines each time a user calls the server, instead having just "Login OK" and "Login incorrect" type lines.
> Is there an explanation/solution for this or does this mean that everybody with radius v3.0.11 has the same problem with authorize_check_query on Oracle, whatever the query actually is ?

  Complain to Oracle about Oracle problems.

  Alan DeKok.