Commit report for v3.0.x branch

[The git bot]

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/9733211fd9363f464e956821b6ab6ed7bd938e7f
====== 
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 at 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/3747c21abfeefe97db77cd3f6dfbdec7f200ad7c
====== 
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/28ad0e18e84e2abc39468b8dad24a62691abd217
====== 
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 at 2019-11-19T10:39:01Z
Files modified:
	* src/main/tls.c

Commit diff:
https://github.com/FreeRADIUS/freeradius-server/commit/04392b99da4ddc1b6f209923cd8eee7c19001000
====== 
-- 
This commit summary was generated @2019-11-20T00:00:01Z by lgfeed version 0.00 (https://github.com/arr2036/lgfeed).