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