New activity for FreeRADIUS (the high performance and highly configurable RADIUS server) ====== SQL IP Pools support for MS SQL Tested using the FreeTDS driver against SQL Server 2017 on Linux Docker, mostly focussing on the stored procedure which gives 350 allocs/sec; 425 reallocs/sec (with no specific database server optimisation). The queries are more complicated than with most other dialects since MS SQL lacks a "SELECT FOR UPDATE" statement, and its table hints do not provide a direct means to implement the row-level read lock needed to guarentee that concurrent queries do not select the same Framed-IP-Address for allocation to distinct users. Terry Burton (via Alan DeKok)@2019-11-27T22:25:08Z Files modified: * raddb/mods-config/sql/ippool/mssql/procedure.sql * raddb/mods-config/sql/ippool/mssql/queries.conf * raddb/mods-config/sql/ippool/mssql/schema.sql Commit diff: https://github.com/FreeRADIUS/freeradius-server/commit/6d32440714bcc8acf6669... ====== MS SQL schema: Syntax fixes and reorganise Rework this dump so that it is suitable for humans _and_ computers. Terry Burton (via Alan DeKok)@2019-11-27T22:25:08Z Files modified: * raddb/mods-config/sql/main/mssql/schema.sql Commit diff: https://github.com/FreeRADIUS/freeradius-server/commit/d5930f52a59f9460ce9e8... ====== -- This commit summary was generated @2019-11-28T00:00:02Z by lgfeed version 0.00 (https://github.com/arr2036/lgfeed).