On Feb 11, 2016, at 11:53 AM, Vincent MARCEL <Vincent.MARCEL@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.