Your query doesn't return data from the database
False : here is the query (debug mode) for an accepted user : (1) sql: EXPAND SELECT distinct 1,NUM_SERIE,'Cleartext-Password',NUM_SERIE,':=' FROM E_MEMA_TPE WHERE NUM_SERIE = '%{User-Name}' (1) sql: --> SELECT distinct 1,NUM_SERIE,'Cleartext-Password',NUM_SERIE,':=' FROM E_MEMA_TPE WHERE NUM_SERIE = 'FT10895748' (1) sql: Executing select query: SELECT distinct 1,NUM_SERIE,'Cleartext-Password',NUM_SERIE,':=' FROM E_MEMA_TPE WHERE NUM_SERIE = 'FT10895748' (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 := This error may occur in PL/SQL blocks. Do Radius create PL/SQL blocks ?? Cordialement, Vincent MARCEL Tél : 04 42 25 92 22 -----Message d'origine----- De : Freeradius-Users [mailto:freeradius-users-bounces+vincent.marcel=monext.net@lists.freeradius.org] De la part de Alan DeKok Envoyé : jeudi 11 février 2016 17:57 À : FreeRadius users mailing list Objet : Re: sql: ERROR: rlm_sql_oracle: ORA-01403: no data found 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. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html