Skip to content

[defect]: rlm_sql_oracle Error logs are continuously recorded. #5540

Open
@Dreamups

Description

@Dreamups

What type of defect/bug is this?

Recurring error log history

How can the issue be reproduced?

RockyLinux 9.5

freeradius 3.2.7 sourcecode compile with Oracle instantclient12.1

using rlm_sql_oracle

Log output from the FreeRADIUS daemon

(9) sql: EXPAND %{User-Name}
(9) sql:    --> testuser
(9) sql: SQL-User-Name set to 'testuser'
rlm_sql (sql): Reserved connection (2)
(9) sql: EXPAND SELECT id, UserName, Attribute, Value, op FROM radcheck WHERE Username = '%{SQL-User-Name}' ORDER BY id
(9) sql:    --> SELECT id, UserName, Attribute, Value, op FROM radcheck WHERE Username = 'testuser' ORDER BY id
(9) sql: Executing select query: SELECT id, UserName, Attribute, Value, op FROM radcheck WHERE Username = 'testuser' ORDER BY id
OCI release failed in sql_finish_select_query
rlm_sql_oracle: error ORA-24434: OCIStmtRelease called before OCIStmtPrepare2.
(9) sql: User found in radcheck table
(9) sql: Conditional check items matched, merging assignment check items
(9) sql:   Cleartext-Password := "testpassword1"
(9) sql: EXPAND SELECT id, UserName, Attribute, Value, op FROM radreply WHERE Username = '%{SQL-User-Name}' ORDER BY id
(9) sql:    --> SELECT id, UserName, Attribute, Value, op FROM radreply WHERE Username = 'testuser' ORDER BY id
(9) sql: Executing select query: SELECT id, UserName, Attribute, Value, op FROM radreply WHERE Username = 'testuser' ORDER BY id
OCI release failed in sql_finish_select_query
rlm_sql_oracle: error ORA-24434: OCIStmtRelease called before OCIStmtPrepare2.
(9) sql: EXPAND SELECT GroupName FROM radusergroup WHERE UserName='%{SQL-User-Name}'
(9) sql:    --> SELECT GroupName FROM radusergroup WHERE UserName='testuser'
(9) sql: Executing select query: SELECT GroupName FROM radusergroup WHERE UserName='testuser'
OCI release failed in sql_finish_select_query
rlm_sql_oracle: error ORA-24434: OCIStmtRelease called before OCIStmtPrepare2.
(9) sql: User not found in any groups
rlm_sql (sql): Released connection (2)
(9)       [sql] = ok
(9)       [expiration] = noop
(9)       [logintime] = noop

Relevant log output from client utilities

/var/log/radius/radius.log
Wed Apr 2 16:53:13 2025 : Error: rlm_sql_oracle: error ORA-24434: OCIStmtRelease called before OCIStmtPrepare2.
Wed Apr 2 16:53:13 2025 : Error: OCI release failed in sql_finish_select_query
Wed Apr 2 16:53:13 2025 : Error: rlm_sql_oracle: error ORA-24434: OCIStmtRelease called before OCIStmtPrepare2.
Wed Apr 2 16:53:13 2025 : Error: OCI release failed in sql_finish_select_query
Wed Apr 2 16:53:13 2025 : Error: rlm_sql_oracle: error ORA-24434: OCIStmtRelease called before OCIStmtPrepare2.
Wed Apr 2 16:53:13 2025 : Error: OCI release failed in sql_finish_select_query
Wed Apr 2 16:53:13 2025 : Error: rlm_sql_oracle: error ORA-24434: OCIStmtRelease called before OCIStmtPrepare2.
Wed Apr 2 16:53:13 2025 : Error: OCI release failed in sql_finish_select_query
Wed Apr 2 16:53:13 2025 : Error: rlm_sql_oracle: error ORA-24434: OCIStmtRelease called before OCIStmtPrepare2.
Wed Apr 2 16:53:13 2025 : Error: OCI release failed in sql_finish_select_query
Wed Apr 2 16:53:13 2025 : Error: rlm_sql_oracle: error ORA-24434: OCIStmtRelease called before OCIStmtPrepare2.
Wed Apr 2 16:53:13 2025 : Error: OCI release failed in sql_finish_select_query
Wed Apr 2 16:53:13 2025 : Error: rlm_sql_oracle: error ORA-24434: OCIStmtRelease called before OCIStmtPrepare2.
Wed Apr 2 16:53:13 2025 : Error: OCI release failed in sql_finish_select_query
Wed Apr 2 16:53:13 2025 : Error: rlm_sql_oracle: error ORA-24434: OCIStmtRelease called before OCIStmtPrepare2.
Wed Apr 2 16:53:13 2025 : Error: OCI release failed in sql_finish_select_query
Wed Apr 2 16:53:13 2025 : Error: rlm_sql_oracle: error ORA-24434: OCIStmtRelease called before OCIStmtPrepare2.
Wed Apr 2 16:53:13 2025 : Error: OCI release failed in sql_finish_query
Wed Apr 2 16:53:13 2025 : Error: rlm_sql_oracle: error ORA-24434: OCIStmtRelease called before OCIStmtPrepare2.
Wed Apr 2 16:53:13 2025 : Error: OCI release failed in sql_finish_query
Wed Apr 2 16:53:13 2025 : Error: rlm_sql_oracle: error ORA-24434: OCIStmtRelease called before OCIStmtPrepare2.
Wed Apr 2 16:53:13 2025 : Error: OCI release failed in sql_finish_query
Wed Apr 2 16:53:13 2025 : Error: rlm_sql_oracle: error ORA-24434: OCIStmtRelease called before OCIStmtPrepare2.
Wed Apr 2 16:54:05 2025 : Error: OCI release failed in sql_finish_query
Wed Apr 2 16:54:05 2025 : Error: rlm_sql_oracle: error ORA-24434: OCIStmtRelease called before OCIStmtPrepare2.

Backtrace from LLDB or GDB

Metadata

Metadata

Assignees

No one assigned

    Labels

    defectcategory: a defect or misbehaviour

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions