New activity for FreeRADIUS (the high performance and highly configurable RADIUS server) ====== Increase the 'nasportid' SQL field for 'varchar(30)' #3141 Jorge Pereira (via Alan DeKok)@2019-11-19T21:06:48Z Files modified: * doc/ChangeLog * raddb/mods-config/sql/main/mysql/schema.sql * raddb/mods-config/sql/main/ndb/schema.sql * raddb/mods-config/sql/main/sqlite/schema.sql Commit diff: https://github.com/FreeRADIUS/freeradius-server/commit/9733211fd9363f464e956... ====== gpgsig -----BEGIN PGP SIGNATURE----- iQEzBAABCAAdFiEE8n1lTTL4FC4LtEWpfQ55zXdiHs0FAl3USXoACgkQfQ55zXdi Hs0I0Qf+J/9SrfUaTQVw7W9on+IrkZOyFqraNvn8UvqA69bCVM3fGffwCd8udRpp y/+bGJ4YhBcoySgS8aV3UQ0/2BxeKqYCfwo1ManlzcqHVNaRkfUTlvTovC7oZeK7 jJaqeBBdqrLkFbJ/FrbcGdWEyPjKZiXfGIUPQ7SxR7l9GF+hWgbetiovnAqY8iwl KbK5/1ar90bRTI7n4hv5T44GvEEAKG1tVljMhjWXs/sv1/LPhb015VdZOO22CeOi 0CUMr6UigcGm8gcFCfYZkOJBr5miAWLpTfnKIoOxI323CYQIsMJ7atON89//JuRs fzcLI9fLro6ZWidJH/GqooTNXvJROA== =IFsN -----END PGP SIGNATURE----- use fr_allocate instead of sp_allocate so anyone rooting thru the list of stored procedures knows that it's a FR function Alan T. DeKok@2019-11-19T19:58:47Z Files modified: * raddb/mods-config/sql/ippool/mysql/procedure.sql * raddb/mods-config/sql/ippool/mysql/queries.conf * raddb/mods-config/sql/ippool/postgresql/procedure.sql * raddb/mods-config/sql/ippool/postgresql/queries.conf Commit diff: https://github.com/FreeRADIUS/freeradius-server/commit/3747c21abfeefe97db77c... ====== PostgreSQL sqlippools: Find and allocate stored procedure Replace existing stored procedure with one that combines the allocate_find and allocate_update queries. We can additionally avoid round trips by avoiding BEGIN and COMMIT since calling an SP provides a new transaction context [*]. Therefore the IP allocation process is reduced to running a single statement. Indicative performance testing showed increased IP allocation performance from 120 allocs/sec with separate queries to 1500 allocs/sec on a two-node master/slave cluster. [*] Verfied as follows which indicates that we are within a transaction rather than "autocommit"ing:

CREATE OR REPLACE FUNCTION sp_txid () RETURNS text LANGUAGE plpgsql AS $$ DECLARE BEGIN -- Write the current txid to a table INSERT INTO txids SELECT txid_current(); INSERT INTO txids SELECT txid_current(); RETURN txid_current(); END$$;

CREATE TEMPORARY TABLE txids (txid TEXT);

SELECT sp_txid(); txsp_txid = 651120 SELECT sp_txid(); txsp_txid = 651121

SELECT * FROM txids txids

651120 651120 651121 651121 Terry Burton (via Alan DeKok)@2019-11-19T19:56:48Z Files modified: * raddb/mods-config/sql/ippool/postgresql/procedure.sql * raddb/mods-config/sql/ippool/postgresql/queries.conf Commit diff: https://github.com/FreeRADIUS/freeradius-server/commit/28ad0e18e84e2abc39468... ====== gpgsig -----BEGIN PGP SIGNATURE----- iQJWBAABCgBAFiEEpcXpnfubXB9wp6L/2bkzwSrtdPAFAl3TxkUiHG1hdHRoZXct Z2l0QG5ld3RvbmNvbXB1dGluZy5jby51awAKCRDZuTPBKu108FWuD/9YFZ6EcLnr eT2QWw88/x9FL3/DzYmyrZJB0M7Kvn4t0oK9LGXLyqaEEKUfczDPgHW4w0FdKzr6 7nfuy2hYGEjlVJhOintokU3MfaTjzKxER9QPZOOWlQ00b6kRgjR3Jl1tFLb9EobM /fXL8bmldfc3VYOR+8JkZDSiNBfYraeSBoL9ekbMHONGhgq36/LT/Bpp3/TUVU1K AJiRraWawFxxW+eRnYBQrLD36NVWAGuXIQV7Dzk73M3hnUvRmwQph0jg8Cgl2jW5 afUqka2OCr6bVIfV5BgMGz6WbcM6mB3torx5YHT0+3+q/iwKOXnS7qTPqUYe4XC0 I87FxJ23ctmrrAumEYDVg0I8/FyrrDbUFrfhr9yXJry4cvckH9OUVoe8hJ1ueKgk tbEzYMBl2B28TllDV/J8c0GNlsJo7U6xI0bR1v3hgoVYZUBhADbHGWQ3QXsoi5hr EJu2egY6iGJGQ8XlQrmhjavdjWtuhSj0OErLsMiO0QFxUiuLsIWCFCVkgAp1mRJA UvaXqBL7REzOueJIoqzEJft4V20W01ghbN9JObfwfmoLlHElGJLBgitRFpwtpDBY xycfvUweXtHecMjKJWTkU6t35T4yFVhM+CIelN8xTTL/aqAW51Yn/kg9OnyCXSvi 3OcaY208F50o8tFUoSFrD5MpFDSuoSaG3g== =o9pJ -----END PGP SIGNATURE----- typo Matthew Newton@2019-11-19T10:39:01Z Files modified: * src/main/tls.c Commit diff: https://github.com/FreeRADIUS/freeradius-server/commit/04392b99da4ddc1b6f209... ====== -- This commit summary was generated @2019-11-20T00:00:01Z by lgfeed version 0.00 (https://github.com/arr2036/lgfeed).