Hi Alan , thank you. Can you tell more about RCA of this issue, for better understanding ? \ AK
On 3 Feb 2023, at 22:10, Alan DeKok <aland@deployingradius.com> wrote:
On Feb 1, 2023, at 2:14 AM, Anatoliy Kushner <cphlpd@gmail.com> wrote:
Hi , trying both versions from freeradius.org 3.0.26 and 3.2.1 , in both cases while communicating with oracle db via odbc driver I got same error (11) sql: Executing select query: select * from table(radius.pkg_freeradius_auth.radcheck('itest', '100.64.0.1', '8ef5.5e4c.9e0a')) rlm_sql_unixodbc: 22003 [Oracle][ODBC]Numeric value out of range. (11) sql: ERROR: Error fetching row (11) sql: ERROR: Unknown error
That's weird.
At the same time with centos freeradius release 3.0.13 it works fine. Also same query via isql client works fine , without any errors
Found old issue on github , but think it should be resolved in these versions. https://github.com/FreeRADIUS/freeradius-server/issues/2822
That change was made because the 3.0.13 version didn't work for many people. The change fixed that.
If you say that 3.0.13 works for you and the newer version doesn't work, then we're not sure what to do.
For now, you can use another driver to talk to Oracle.
Alan DeKok.
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html