Error: OCI release failed in sql_finish_query

Mucci Andrea Andrea.Mucci at hpecds.com
Tue Oct 15 10:57:11 UTC 2024


Hi all,
I installed FreeRADIUS v.3.2.6 on Red Hat Enterprise Linux release 9.4 (Plow).

Using Oracle as database:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.23.0.0.0

As instant client:
oracle-instantclient19.19-basic-19.19.0.0.0-1.x86_64

In the log file I notice this error "OCI release failed in sql_finish_query" every time the sql module is called.

Tue Oct 15 12:28:49 2024 : Debug: (0) sql_clid: EXPAND SELECT rgr.id as id, rg.name as groupname, decode(ra.has_tag,'Y',ra.name||':'||rgr.tag,ra.name) as attribute, value, op FROM RADIUS_GROUP_REPLY rgr, RADIUS_GROUP rg, RADIUS_ATTR ra WHERE rgr.group_id = rg.id AND rgr.radius_attr_id = ra.id AND (ra.vendor_id in (0,%{&control:HPE-Nas-VendorId}) OR (ra.vendor_id = 9999 AND ra.attr_id = 17)) AND rg.name = '%{sql_clid-SQL-Group}'  ORDER BY id
Tue Oct 15 12:28:49 2024 : Debug: (0) sql_clid:    --> SELECT rgr.id as id, rg.name as groupname, decode(ra.has_tag,'Y',ra.name||':'||rgr.tag,ra.name) as attribute, value, op FROM RADIUS_GROUP_REPLY rgr, RADIUS_GROUP rg, RADIUS_ATTR ra WHERE rgr.group_id = rg.id AND rgr.radius_attr_id = ra.id AND (ra.vendor_id in (0,0) OR (ra.vendor_id = 9999 AND ra.attr_id = 17)) AND rg.name = 'FTTHFIBRAFTTH1000_ETH'  ORDER BY id
Tue Oct 15 12:28:49 2024 : Debug: (0) sql_clid: Executing select query: SELECT rgr.id as id, rg.name as groupname, decode(ra.has_tag,'Y',ra.name||':'||rgr.tag,ra.name) as attribute, value, op FROM RADIUS_GROUP_REPLY rgr, RADIUS_GROUP rg, RADIUS_ATTR ra WHERE rgr.group_id = rg.id AND rgr.radius_attr_id = ra.id AND (ra.vendor_id in (0,0) OR (ra.vendor_id = 9999 AND ra.attr_id = 17)) AND rg.name = 'FTTHFIBRAFTTH1000_ETH'  ORDER BY id
Tue Oct 15 12:28:49 2024 : Error: OCI release failed in sql_finish_query
Tue Oct 15 12:28:49 2024 : Debug: (0) sql_clid: Group "FTTHFIBRAFTTH1000_ETH": Merging reply items
Tue Oct 15 12:28:49 2024 : Debug: (0) sql_clid:   Service-Type = Framed-User
Tue Oct 15 12:28:49 2024 : Debug: (0) sql_clid:   Framed-Protocol = PPP
Tue Oct 15 12:28:49 2024 : Debug: (0) sql_clid:   Acct-Interim-Interval = 21600
Tue Oct 15 12:28:49 2024 : Debug: (0) sql_clid:   Fall-Through = Yes

Anyone have any idea??
Best Regards
Andrea


More information about the Freeradius-Users mailing list