Error: OCI release failed in sql_finish_query
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
On Oct 15, 2024, at 6:57 AM, Mucci Andrea via Freeradius-Users <freeradius-users@lists.freeradius.org> wrote:
In the log file I notice this error "OCI release failed in sql_finish_query" every time the sql module is called.
It's some weird Oracle thing. :( I've added a patch to produce a more descriptive error message. Alan DeKok.
Good morning. Where can I download this patch? I downloaded the latest version available from GITHUB(3.2.7), but there is no extra information in the log. Best Regards Andrea -----Original Message----- From: Alan DeKok <aland@deployingradius.com> Sent: 18 October 2024 15:20 To: FreeRadius users mailing list <freeradius-users@lists.freeradius.org> Cc: Mucci Andrea <Andrea.Mucci@hpecds.com>; luciana.coppola@hpe.com Subject: Re: Error: OCI release failed in sql_finish_query On Oct 15, 2024, at 6:57 AM, Mucci Andrea via Freeradius-Users <freeradius-users@lists.freeradius.org> wrote:
In the log file I notice this error "OCI release failed in sql_finish_query" every time the sql module is called.
It's some weird Oracle thing. :( I've added a patch to produce a more descriptive error message. Alan DeKok.
On Oct 21, 2024, at 4:08 AM, Mucci Andrea via Freeradius-Users <freeradius-users@lists.freeradius.org> wrote:
Where can I download this patch?
Github.
I downloaded the latest version available from GITHUB(3.2.7), but there is no extra information in the log.
Look at the git history. It includes a patch. I didn't update doc/ChangeLog. Alan DeKok.
Sorry, but I can't find the patch. I've searched the commit history, but I can't find anything that references the issue. Can you help me? BR Andrea -----Original Message----- From: Freeradius-Users <freeradius-users-bounces+andrea.mucci=hpecds.com@lists.freeradius.org> On Behalf Of Alan DeKok Sent: 21 October 2024 14:32 To: FreeRadius users mailing list <freeradius-users@lists.freeradius.org> Subject: Re: Error: OCI release failed in sql_finish_query On Oct 21, 2024, at 4:08 AM, Mucci Andrea via Freeradius-Users <freeradius-users@lists.freeradius.org> wrote:
Where can I download this patch?
Github.
I downloaded the latest version available from GITHUB(3.2.7), but there is no extra information in the log.
Look at the git history. It includes a patch. I didn't update doc/ChangeLog. Alan DeKok. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
I've pushed them now. Apparently they didn't make it out before.
On Oct 21, 2024, at 11:44 AM, Mucci Andrea via Freeradius-Users <freeradius-users@lists.freeradius.org> wrote:
Sorry, but I can't find the patch. I've searched the commit history, but I can't find anything that references the issue. Can you help me?
BR Andrea
-----Original Message----- From: Freeradius-Users <freeradius-users-bounces+andrea.mucci=hpecds.com@lists.freeradius.org> On Behalf Of Alan DeKok Sent: 21 October 2024 14:32 To: FreeRadius users mailing list <freeradius-users@lists.freeradius.org> Subject: Re: Error: OCI release failed in sql_finish_query
On Oct 21, 2024, at 4:08 AM, Mucci Andrea via Freeradius-Users <freeradius-users@lists.freeradius.org> wrote:
Where can I download this patch?
Github.
I downloaded the latest version available from GITHUB(3.2.7), but there is no extra information in the log.
Look at the git history. It includes a patch.
I didn't update doc/ChangeLog.
Alan DeKok.
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Thank you for the patch " add more errors ". This is the new information collected: Tue Oct 22 13:38:06 2024 : Error: OCI release failed in sql_finish_query - patch sql_finish_select_query Tue Oct 22 13:38:06 2024 : Error: rlm_sql_oracle: error ORA-24434: OCIStmtRelease called before OCIStmtPrepare2. The function called is "sql_finish_select_query" not "sql_finish_query" as indicated in the log. BR Andrea -----Original Message----- From: Alan DeKok <aland@deployingradius.com> Sent: 21 October 2024 19:11 To: FreeRadius users mailing list <freeradius-users@lists.freeradius.org> Cc: Mucci Andrea <Andrea.Mucci@hpecds.com>; luciana.coppola@hpe.com Subject: Re: Error: OCI release failed in sql_finish_query I've pushed them now. Apparently they didn't make it out before.
On Oct 21, 2024, at 11:44 AM, Mucci Andrea via Freeradius-Users <freeradius-users@lists.freeradius.org> wrote:
Sorry, but I can't find the patch. I've searched the commit history, but I can't find anything that references the issue. Can you help me?
BR Andrea
-----Original Message----- From: Freeradius-Users <freeradius-users-bounces+andrea.mucci=hpecds.com@lists.freeradius.org> On Behalf Of Alan DeKok Sent: 21 October 2024 14:32 To: FreeRadius users mailing list <freeradius-users@lists.freeradius.org> Subject: Re: Error: OCI release failed in sql_finish_query
On Oct 21, 2024, at 4:08 AM, Mucci Andrea via Freeradius-Users <freeradius-users@lists.freeradius.org> wrote:
Where can I download this patch?
Github.
I downloaded the latest version available from GITHUB(3.2.7), but there is no extra information in the log.
Look at the git history. It includes a patch.
I didn't update doc/ChangeLog.
Alan DeKok.
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
On Oct 22, 2024, at 7:47 AM, Mucci Andrea <Andrea.Mucci@hpecds.com> wrote:
Thank you for the patch " add more errors ". This is the new information collected:
Tue Oct 22 13:38:06 2024 : Error: OCI release failed in sql_finish_query - patch sql_finish_select_query Tue Oct 22 13:38:06 2024 : Error: rlm_sql_oracle: error ORA-24434: OCIStmtRelease called before OCIStmtPrepare2.
<shrug> Magic Oracle nonsense. Since it isn't causing issues, I'd suggest ignoring it. Alan DeKok.
participants (2)
-
Alan DeKok -
Mucci Andrea