New activity for FreeRADIUS (the high performance and highly configurable RADIUS server) ====== gpgsig -----BEGIN PGP SIGNATURE----- iQEzBAABCAAdFiEE8n1lTTL4FC4LtEWpfQ55zXdiHs0FAl5ZOtgACgkQfQ55zXdi Hs0qBwf/eYnHy13fnGWA50MXydpruMo5QmJwtEBn6pZa4uCFXpTdchHcMH3EoraH bBKo2ovAu2hd1KBqXaVALDnhmlxcgkR+XgYflOLvK0VfUqL5aHwMpIOdM8IZE43o ezPe2jj0TWNW+ucbjRbDkPWDMQw/MJ1p5iTsP8aGvpve7JSxXuDryemA257Bk9RZ XbgwMzCLAjOnvM+XmKrm/1mACCZJ0kzjR3jYF6oOKjup2nXm1BOk7GW0riuw1fIH RanNwi7wJK285EJrUUkcnpJRgYcB7u7ZS58HA/LziosSTqXiXcMCZ7jArHdVNYGT epN/t8D8bfqDa7vK0oZnnyJ8KwoXcg== =uOMe -----END PGP SIGNATURE----- remove unnecessary whitespace Alan T. DeKok@2020-02-28T16:07:52Z Files modified: * src/lib/server/xlat_eval.c Commit diff: https://github.com/FreeRADIUS/freeradius-server/commit/a82aa6d156ec45e0be632... ====== gpgsig -----BEGIN PGP SIGNATURE----- wsBcBAABCAAQBQJeWSkLCRBK7hj4Ov3rIwAAdHIIAKX5cekvj8VKZsj8nZoYrW+U W/6DmlZtDaz/dyMe9OkJpmlJiqKHBT11n3iyvHhuPUY1FG08AftXjCnIMEOCbIaY dO008ztgumtv6wdgq4ha1JwBvI05ac582fx9EM6DSt03Ib23s99xilHk868tvQMY 0Gmbcv9N7liUBvzBdPR79R7ELcoct6aELJh5KjhSpApRSoHnvyM5tq4n3yKPKi/Y uRr36w1oJyYwPG4TwRYSsuFzh5EIDR9gak43grRf295380BUfHuJRiJhJ+mOhysd kVrTcg+biS4KCGaEkYIm4LCRoxftwx1ye9fqyUJFJdjIwfmfzpgpch0ZZu803Z4= =D1jf -----END PGP SIGNATURE----- Merge pull request #3298 from jirutka/cui-pgsql Fix and improve cui/postgresql Matthew Newton (via GitHub)@2020-02-28T14:51:55Z Files modified: * raddb/mods-config/sql/cui/postgresql/queries.conf * raddb/mods-config/sql/cui/postgresql/schema.sql Commit diff: https://github.com/FreeRADIUS/freeradius-server/commit/7e08e4f2e38a6bcec47fb... ====== gpgsig -----BEGIN PGP SIGNATURE----- iQGzBAABCQAdFiEEv7UV5T50WUImhovnefKZsENajiMFAl5ZJN8ACgkQefKZsENa jiMyxAv/cVNFgmggoi15rRyr15Os96jufQ3Fe8bHXn5C+4luCJCl8M5eUEqkVe4c TQC46FHcMNYQrJrgygqmE9FZ+d2WSEzo2G6CudLIKK6toAslpM8aMuAZEr637ljS XgBUbuCW1kUYYsfpS1lznedC7pDLusAqBvJUMQ4GViKc7PSBvp4Ww16kzmK7a/LG PTee9T496THrQeGO4toC8578jQn65Ck9/MZL5BuqVCLuhKWOeYqsL1QVOx5+4cns wDW+omFkc9+PuV1I82ZBK10Tr+j9GuIXNwpO7h3/bLjcDkVc4X/qlzkitgjHj9pi Mv6QgV8q1x6zZnJiTQeV1oTb+VX8dOK9Wa43oqhqa8Kp7GDqqvxB9bpBJiYqrd8D WDV0V/YU4WPkriJENC6a1Hl3OSSgJqxktlQ4oXF1HmiW7tFdty1NqxxsDmzSZXTW vDVCbw8nNTz4ueK3u28XBXIuA5Z2TixdyPvoYvEc2vo/xDZQaexzQ5Zkf5/iK2bA /6+IL73W =D68v -----END PGP SIGNATURE----- specify name for pkey constraint and use it in query for cui postgresql Jakub Jirutka@2020-02-28T14:34:07Z Files modified: * raddb/mods-config/sql/cui/postgresql/queries.conf * raddb/mods-config/sql/cui/postgresql/schema.sql Commit diff: https://github.com/FreeRADIUS/freeradius-server/commit/6b0ca6366da2bf27e609c... ====== gpgsig -----BEGIN PGP SIGNATURE----- iQGzBAABCQAdFiEEv7UV5T50WUImhovnefKZsENajiMFAl5ZJN4ACgkQefKZsENa jiNhfQv+JdaIl1IyZptNqLu5GQKGai9aYr1W5Zy14f48Vek5eQfv9pCxX1mVthoV pHsadJAsX5S+q00DOQqeoh+Hif40Y85Ov9/RzYOOvlENaiIEK8QCDp/FU735WbHU sCbVEHzc+KCdLDYfmQKuQ8kGnqTYNdwpCK0fhhyDUwD+7dJBAgkRom1qd9m7mlYn MMS6nJZi6AKtnMD/RfdD9DA9DH2DEqAKfRsFQOr1msXeEPUUzayYQKSuh2e1UPHm NeGYIPCJKmLbc9TagUnoe1Up9SN4GvE1o7OASDVEvqEdPPulLRRFtS51bBc1+Zvw 4PwDuIraICuZEUcjamssLi5sa10ySOn9W7WBwVL8YSOe9OE1myZA22liO2sitcVn saC8ZG+MlhVvAwkhgfjwhSTAxsnJXFEkSkvDLGNeJTMurToOm9YzfW0BsTvB7KKd zmHAqCD96hIA6Gm9dbVgZB3KhqySAFc/2eLlWRUIxX4EzXmbhO9Ce1yZMbpnANx8 OYsStqxF =Z6XC -----END PGP SIGNATURE----- use real upsert (ON CONFLICT) instead of workaround in postgresql cui Clause ON CONFLICT performs better than the RULE workaround and it's guaranted to be atomic (the workaround is not). It requires PostgreSQL 9.5 or newer; this version was released in 2016 and the previous versions are already unsupported, so it shouldn't be a problem for anyone using latest FreeRADIUS versions. There's a problem with backward compatibility because ON CONFLICT doesn't work when there's a RULE ON INSERT defined on the table. It results in the following error in radius.log: Error: rlm_sql_postgresql: 0A000: FEATURE NOT SUPPORTED Jakub Jirutka@2020-02-28T14:34:06Z Files modified: * raddb/mods-config/sql/cui/postgresql/queries.conf * raddb/mods-config/sql/cui/postgresql/schema.sql Commit diff: https://github.com/FreeRADIUS/freeradius-server/commit/5657117d99a79b038a480... ====== gpgsig -----BEGIN PGP SIGNATURE----- iQGzBAABCQAdFiEEv7UV5T50WUImhovnefKZsENajiMFAl5ZJN0ACgkQefKZsENa jiPRKgwAlCkuk2vrUczT2+ziEvGXUYtAS8pB7hPexnha9YtiVTtEyZ3YBX1HHQpl 72yFY5WAm7KJxZr8l9EIT5QiI20u1dMFNqZhGGbJxBdY9rJhD0Rx7lFanYTJlyJl 6RgysF8BuWCj84D9R3I1fULDQRYp7J+LemU0Qaq/GwtWd5GaAAw6MVaCtdX8CeHz I8DJdFSgbBBXMzGDmu9B0fiI2bNlCQwEn9L6qxHJ6xO2mtBWNr/fAyJjiXL3nDnU i0AMeQ8nrMd4EtLSr6vQcnBrgbZ9zLRHkMJptwtzvinXw/3xgAF363fekQGWbQwM t9PrJDV+C+Whk0LsTGXuz0ZGRTmKsHtw1dUudXJwAc2nn6/kIGcewOdgSX9c4p1v jDn8qQtS8SiU4fXbSQF1ibd470smjv3aF2b3jMz2qnH9y94pxuv0HJo+Y3LS3NGO cEMJ9PdVsOGo5Yv5vAfznl/1wipHaU17XLI6FvUhWJSTDBJ8nDepgEl7VdStXbf/ iq4SuXQR =vbkp -----END PGP SIGNATURE----- fix postgresql schema for cui I'm getting the following error with the current schema: rlm_sql_postgresql: 22001: STRING DATA RIGHT TRUNCATION Moreover, in PostgreSQL the text type is highly preferred above varchar. Schema for radacct already uses it, so it seems that schema for cui is just outdated. I also remove quotes around `now()`, it was probably some archaism. Jakub Jirutka@2020-02-28T14:34:05Z Files modified: * raddb/mods-config/sql/cui/postgresql/schema.sql Commit diff: https://github.com/FreeRADIUS/freeradius-server/commit/720f2dd69579caa7e1ddf... ====== gpgsig -----BEGIN PGP SIGNATURE----- iQGzBAABCQAdFiEEv7UV5T50WUImhovnefKZsENajiMFAl5ZJNwACgkQefKZsENa jiPItgv/U78pPvTb5CW+tWTz3x9laLhBcBaDiGIXe2K/I2qsKV4JR8aH9A6z06wt tfNpUeHPUrO4wldW3CIMExg1x13koPyVpcNhHfriu0BfEejoIlhZHr3ZBQkeEtx6 TSV12KcAljXH3Nuw1IoY5+3v+hwv3H46agasilm40FLw1Qj41jh0bQ+YAG0jcpXa WzD9JLEQ7n8+cnqbxReL83aT5u0hVVYLmwoXLy5CcJylQMt+bUSVp1gsEAmamWSm I533BDFTSrhTeKb1yDvl9fEq2cdnuuMlDB2dC7G14+F6NufxTmbj0BrSWJBmXDwr Qk9R5l/+2b7kU7CUTg9lXmbZTgEGC2HAylZ8uB+njlYTUEQ0vfk1986VoYp/CCHK oGVwW32SRX71eXabtbTpZy3Qx/vAMTjxSxtGeSOEP/NIxfQsOfKd5+Re+ji2fvQx f6haE9oHu8d70DtkRfVmqZuPNn3lzWkTY4+HqmqP5F2+qabf9x/CMWc1lWcTU8Lc DX1tmUL7 =HTdz -----END PGP SIGNATURE----- fix formatting in cui postgresql schema to be consistent Jakub Jirutka@2020-02-28T14:34:04Z Files modified: * raddb/mods-config/sql/cui/postgresql/schema.sql Commit diff: https://github.com/FreeRADIUS/freeradius-server/commit/6cc0edb8f3195438509e7... ====== gpgsig -----BEGIN PGP SIGNATURE----- iQEzBAABCAAdFiEE8n1lTTL4FC4LtEWpfQ55zXdiHs0FAl5ZEWMACgkQfQ55zXdi Hs0SAwf/bOQubSdCLqL673P8lBo7Du2C9rIDHEw4iU7zlsyC4HMv1B+0DaLFj7+b fxqplRvdbde+MrvbYkW3+US/5jXFL8n2LU0YQ/w0svnnYAnf/8goJPk8nb4L1kd4 V8eWIf6DMrKGh5g89btuP+ck/rjeAfK88pWW4ItOGqdBocPrVEYSh9uLQDcpFaIh 5Bfascv8yiZs5tt0/NIf139M6IA6S9+m1FFYIO+wwnDv6Um/RIH3EXHFgff4sPoU a3eIvmOqBA4YImK8DhLYLlXWkmxMqWwXFngcVNfc14/3G8QmmadsZHae6lgqDzE/ mwOKckf/JZLK9ZUng4UhuNPRmgSpCw== =eD2q -----END PGP SIGNATURE----- use usec since current second, not usec since epoch Alan T. DeKok@2020-02-28T13:10:59Z Files modified: * src/lib/server/xlat_eval.c Commit diff: https://github.com/FreeRADIUS/freeradius-server/commit/0128254ffeb8d74d1f818... ====== gpgsig -----BEGIN PGP SIGNATURE----- iQJWBAABCgBAFiEEpcXpnfubXB9wp6L/2bkzwSrtdPAFAl5YbTEiHG1hdHRoZXct Z2l0QG5ld3RvbmNvbXB1dGluZy5jby51awAKCRDZuTPBKu108APUD/95SldtQv2U v/m27LhhhJ8rULQ3yqO4PVbb/SjfVTXL5zX+oEJQBuiWsJwcvxsiXGVFyqLXyEyS 7JZPABiPeCmnfwBrVoAdv7w6gkZT9qsyVxTigGyb9cZpiZOujVpp5Bdte7vap8AI jTLo4qxoi6kmQ2KDVbRANELfpCCQ0lXsAxAb+9vIzg3iKZ+dMp0B2Ci2E9dKhrne JN7DXJYj3XHu3N/PB9YCnvxKyU7rxkvBdo/pydDsgELx6rmmvBm28WxOkvN1JZ6H 8pJLTc9NpebeBw5OhVQd3Rcm2KXhbQPLv6zCmbkiRj4PNNRxgttRJwRv1L9S5n9q attg/NrNLB9v1xpExatvxb0vmBgt5ws3pEmMYylIP39gIpRz1A4FsRqiumHNeCw3 7BaXjAGtrG8ohiWbdRmpfTS2twjYo/wRlTRmhhvcU112neHDwP5DXUOWiRovFVPB tQjOPq+wXSb2/Kz9x/UgQ6E7jRwOeS8wEzQImz3GbEnPeNtClw0ORMtdaVMyP8W6 /4+8WnegF2+UbLG4njL6aUvvW9Y4tlfPdSn+rk6XFKtOlQaYvGiNT55pIj8oLtC0 oLkAPYz1o3qaQzMYDfjCzMmQ27aiEldWhXz5Qxqlt2oP97AY7RuHaNAAFgW04jTm 4PbL8Nckl06GmCYPCj1aXFx5JUsrqy9m+g== =tuFQ -----END PGP SIGNATURE----- fix crash when no previous regex seen Matthew Newton@2020-02-28T01:30:09Z Files modified: * src/lib/server/regex.c * src/lib/server/xlat_builtin.c * src/tests/keywords/if-regex-match-named Commit diff: https://github.com/FreeRADIUS/freeradius-server/commit/1bedaca611e758635385b... ====== gpgsig -----BEGIN PGP SIGNATURE----- iQJWBAABCgBAFiEEpcXpnfubXB9wp6L/2bkzwSrtdPAFAl5YbRUiHG1hdHRoZXct Z2l0QG5ld3RvbmNvbXB1dGluZy5jby51awAKCRDZuTPBKu108ECoEACFwFpJCpwv /YBodf29iXHmfZ4RzqjlAPs58U9h/iSmy4NOrf5Ctg30hF+wQNCJuFaqWcYTrGiS 3rtsjXDR9pRlhk/EAHEKXckabz5hxbRgJdHuuB1vKIrnz3jbU12R///4akUBB8uW Qk+x1s2Mpe0ykoj1lUsrrqVD2fKX7q/YvJFUplf1559fT57Pb8Ez8e2BiWxykBH7 JtNdRdZ3ARZ8wbTUPuIoMm1c1zb0xU1SYV7SNtsVjmSl2Sl+vaEkPffAp690s8p9 1Ac9bBm7dPIrs4a1AoqeWXCjYhqiUgNoX61JatC7RPaJ8EiyitdOB6YDJmCM08S9 1/aJp761iPAGV+8KHKVOZ4mtcYjKjjYslATF3jJV5/hxAK9cqVHh81FaB0h0Y8Eb Rg0ML1eBR6U9+J8lzm/nkw8AMlvH/6D/hOEDy8iglmdy9s2zY/juo9/Yfg77Sf+F QF+sbazr4G++9g9oU4WA//qaHN29ny1LTni1LHGIbPHqUlGQUWJUNQ9UZg/r007Y iWNAX8UELqsNFaT1Y58SHMB9ud8wL36sqzoTMIX5jnDvrKyQqZDxqeXbuJR5yfVK Rmr5P7IL8CIa5jlTgV3DdtY90uJFy8Ij52EkySuC/3B0ZD3Y0K0HVTKPro6xrQeE tbU7uM3GEXj9rjZ7d7SpACOdmwQUf1nLHQ== =JRgF -----END PGP SIGNATURE----- doxygen Matthew Newton@2020-02-28T01:29:57Z Files modified: * src/lib/server/xlat_builtin.c Commit diff: https://github.com/FreeRADIUS/freeradius-server/commit/acb9639cea13b9fc7b0ef... ====== -- This commit summary was generated @2020-02-29T00:00:02Z by lgfeed version 0.00 (https://github.com/arr2036/lgfeed).