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

[Vincent MARCEL]

>  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 at 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 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.


-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html