Hi We have been working on tuning SQL behind a FreeRadius Server. Part of this has been moving to stored procedures where possible and these are working well. However we have some cases that I need some help with. EG at accounting start we have: ----- (1735) sql1: --> EXEC radius.[dbo].proc_RadaccInsert_1 'S60000026971709702CD00', 'ae67d6f1a5a55e4868ff02b8f6d30da6', etc (1735) sql1: EXPAND /usr/local/var/log/radius/accounting.sql (1735) sql1: --> /usr/local/var/log/radius/accounting.sql (1735) sql1: Executing query: EXEC radius.[dbo].proc_RadaccInsert_1 'S60000026971709702CD00', 'ae67d6f1a5a55e4868ff02b8f6d30da6', etc (1735) sql1: SQL query returned: success (1735) sql1: -1 record(s) updated (1735) sql1: No additional queries configured ----- Now the stored procedure worked fine - However as it does a few checks after the insert we get (1735) sql1: -1 record(s) updated (1735) sql1: No additional queries configured And FreeRadius assumes the query did not update the database Is there a way that we can configure FreeRadius to 'ignore' the fact that number of records updated was -1 if the query returned OK and assume the query update was good (it was) ? Obviously I can look at the stored procedure and create a 'fake' query so that it returns the record update? Richard Palmer | Director | Merula Limited Company Registered in England and Wales No. 3243995 5 Avro Court, Huntingdon, Cambridgeshire, PE29 6XS Phone 01480 222940 | Support 0845 330 0666 Support Email support@merula.net
On 06/07/2019 17:31, Arran Cudbard-Bell wrote:
On Jul 5, 2019, at 3:29 PM, Richard J Palmer <richard@merula.net> wrote:
We have been working on tuning SQL behind a FreeRadius Server.
Which SQL server?
"Executing query: EXEC radius.[dbo].proc_RadaccInsert_1 " That [dbo] makes it look like SQL Server to me. So, @Richard - what driver are you using?
participants (3)
-
Arran Cudbard-Bell -
Dom Latter -
Richard J Palmer