On Feb 10, 2016, at 10:52 AM, Vincent MARCEL <Vincent.MARCEL@monext.net> wrote:
I am trying to authorize a user through a authorize_check_query on Oracle database. When I test, I get this error on my radius server : (0) sql: Executing select query: SELECT 1,'FT10895748','User-Password','FT10895748',':=' FROM DUAL
As the later error message says, DON"T have "User-Password" here. Use "Cleartext-Password".
(0) sql: ERROR: Error fetching row (0) sql: ERROR: rlm_sql_oracle: ORA-01403: no data found
But this can't be true, this query always returns 1 row !
That error is returned from Oracle. There's very little we can do to fix Oracle.
Below is the output of my server in debug mode, starting from database connection, ending to the authorize test :
It still seems to work, so I'm not sure what the problem is. Alan DeKok.