sql: ERROR: rlm_sql_oracle: ORA-01403: no data found
aland at deployingradius.com
Thu Feb 11 17:57:03 CET 2016
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.
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.
More information about the Freeradius-Users