Hi all, We've been using the 3.1 branch for the sql maps ability for a bit, but realise we now need to move onto a currently supported branch as it no longer compiles in recenty versions of Ubuntu, our preferred linux flavour. We extensively used sql maps with the syntax talked about here: https://github.com/FreeRADIUS/freeradius-server/issues/984 e.g. map <map proc isnt> <source> { <server attr0> <op0> <result attr0> <server attr1> <op1> <result attr1> <server attrN> <opN> <result attrN> } .. a real example we used being map sql_SP_radiussql &control:Tmp-String-0 { control:Tmp-string-1 += tmp_acctuniqueid control:Tmp-string-2 += tmp_acctsessionid control:Tmp-string-3 += tmp_username control:Tmp-string-4 += tmp_devicetype control:Tmp-string-5 += tmp_macaddresslimit control:Tmp-string-6 += tmp_acctstarttime control:Tmp-string-7 += tmp_duplicate } Which worked well. Is this functionality still valid, and is the syntax now different? Kind Regards Andy ******************************************************************************************************************** This message may contain confidential information. If you are not the intended recipient please inform the sender that you have received the message in error before deleting it. Please do not disclose, copy or distribute information in this e-mail or take any action in relation to its contents. To do so is strictly prohibited and may be unlawful. Thank you for your co-operation. NHSmail is the secure email and directory service available for all NHS staff in England and Scotland. NHSmail is approved for exchanging patient data and other sensitive information with NHSmail and other accredited email services. For more information and to find out how you can switch, https://portal.nhs.net/help/joiningnhsmail
On Jul 15, 2020, at 6:17 AM, FRANKS, Andy (SHREWSBURY AND TELFORD HOSPITAL NHS TRUST) via Freeradius-Users <freeradius-users@lists.freeradius.org> wrote:
We've been using the 3.1 branch for the sql maps ability for a bit, but realise we now need to move onto a currently supported branch as it no longer compiles in recenty versions of Ubuntu, our preferred linux flavour.
Switch to the "master" branch. It supports SQL maps, and it compiles. It has a superset of the functionality of 3.1, including maps. Some configuration options have changed or been renamed, but the upgrade shouldn't take too long. Alan DeKok.
That's awesome, thanks Alan. Been a bit shy to try 4, not sure why, but will give it a go. Looking at the v4 source, found some examples here, they seem very similar to 3.1: src/tests/modules/sql/map.unlang Thank you again Andy -----Original Message----- From: Freeradius-Users <freeradius-users-bounces+andy.franks1=nhs.net@lists.freeradius.org> On Behalf Of Alan DeKok Sent: 15 July 2020 16:17 To: FreeRadius users mailing list <freeradius-users@lists.freeradius.org> Subject: Re: SQL Maps On Jul 15, 2020, at 6:17 AM, FRANKS, Andy (SHREWSBURY AND TELFORD HOSPITAL NHS TRUST) via Freeradius-Users <freeradius-users@lists.freeradius.org> wrote:
We've been using the 3.1 branch for the sql maps ability for a bit, but realise we now need to move onto a currently supported branch as it no longer compiles in recenty versions of Ubuntu, our preferred linux flavour.
Switch to the "master" branch. It supports SQL maps, and it compiles. It has a superset of the functionality of 3.1, including maps. Some configuration options have changed or been renamed, but the upgrade shouldn't take too long. Alan DeKok. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html ******************************************************************************************************************** This message may contain confidential information. If you are not the intended recipient please inform the sender that you have received the message in error before deleting it. Please do not disclose, copy or distribute information in this e-mail or take any action in relation to its contents. To do so is strictly prohibited and may be unlawful. Thank you for your co-operation. NHSmail is the secure email and directory service available for all NHS staff in England and Scotland. NHSmail is approved for exchanging patient data and other sensitive information with NHSmail and other accredited email services. For more information and to find out how you can switch, https://portal.nhs.net/help/joiningnhsmail
On Jul 15, 2020, at 11:52 AM, FRANKS, Andy (SHREWSBURY AND TELFORD HOSPITAL NHS TRUST) via Freeradius-Users <freeradius-users@lists.freeradius.org> wrote:
That's awesome, thanks Alan. Been a bit shy to try 4, not sure why, but will give it a go.
It's pretty stable from day to day.
Looking at the v4 source, found some examples here, they seem very similar to 3.1:
src/tests/modules/sql/map.unlang
See also full documentation in doc/antora/modules/unlang/pages/map.adoc Alan DeKok.
Just an update - v4 builds fine here on Ubuntu 20.04, on to testing.. I know you instruct people to build using make, but I quite like the debs to install from, so also tried building with "make deb" - possibly found an issue in debian/freeradius-dhcp.install I had to change usr/lib/freeradius/libfreeradius-dhcp.so to usr/lib/freeradius/libfreeradius-dhcp*.so .. due to the separate v4/6 modules; it missed out the .so files from the freeradius-dhcp package otherwise. I also had to manually run the cert bootstrap and change some permissions to get it to work. I guess you probably already knew all that anyway though, and why you don't instruct people to use e.g. make deb ! :-) Thanks Andy -----Original Message----- From: Freeradius-Users <freeradius-users-bounces+andy.franks1=nhs.net@lists.freeradius.org> On Behalf Of Alan DeKok Sent: 15 July 2020 16:56 To: FreeRadius users mailing list <freeradius-users@lists.freeradius.org> Subject: Re: SQL Maps On Jul 15, 2020, at 11:52 AM, FRANKS, Andy (SHREWSBURY AND TELFORD HOSPITAL NHS TRUST) via Freeradius-Users <freeradius-users@lists.freeradius.org> wrote:
That's awesome, thanks Alan. Been a bit shy to try 4, not sure why, but will give it a go.
It's pretty stable from day to day.
Looking at the v4 source, found some examples here, they seem very similar to 3.1:
src/tests/modules/sql/map.unlang
See also full documentation in doc/antora/modules/unlang/pages/map.adoc Alan DeKok. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html ******************************************************************************************************************** This message may contain confidential information. If you are not the intended recipient please inform the sender that you have received the message in error before deleting it. Please do not disclose, copy or distribute information in this e-mail or take any action in relation to its contents. To do so is strictly prohibited and may be unlawful. Thank you for your co-operation. NHSmail is the secure email and directory service available for all NHS staff in England and Scotland. NHSmail is approved for exchanging patient data and other sensitive information with NHSmail and other accredited email services. For more information and to find out how you can switch, https://portal.nhs.net/help/joiningnhsmail
On 16/07/2020 15:36, FRANKS, Andy (SHREWSBURY AND TELFORD HOSPITAL NHS TRUST) via Freeradius-Users wrote:
I know you instruct people to build using make, but I quite like the debs to install from, so also tried building with "make deb" - possibly found an issue in ... I also had to manually run the cert bootstrap and change some permissions to get it to work. I guess you probably already knew all that anyway though, and why you don't instruct people to use e.g. make deb !
"make deb" should generally work - but v4 changes a lot so it often gets out of sync with the code. I'm actually working through some of the packaging stuff at the moment, so it'll likely get a good look within the next couple of weeks or so. -- Matthew
Hi Matthew, Certainly no complaints here, the main recommended way of compiling works fine, thanks for the update though, helpful. Kind Regards Andy -----Original Message----- From: Freeradius-Users <freeradius-users-bounces+andy.franks1=nhs.net@lists.freeradius.org> On Behalf Of Matthew Newton Sent: 16 July 2020 16:02 To: freeradius-users@lists.freeradius.org Subject: Re: SQL Maps On 16/07/2020 15:36, FRANKS, Andy (SHREWSBURY AND TELFORD HOSPITAL NHS TRUST) via Freeradius-Users wrote:
I know you instruct people to build using make, but I quite like the debs to install from, so also tried building with "make deb" - possibly found an issue in ... I also had to manually run the cert bootstrap and change some permissions to get it to work. I guess you probably already knew all that anyway though, and why you don't instruct people to use e.g. make deb !
"make deb" should generally work - but v4 changes a lot so it often gets out of sync with the code. I'm actually working through some of the packaging stuff at the moment, so it'll likely get a good look within the next couple of weeks or so. -- Matthew - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html ******************************************************************************************************************** This message may contain confidential information. If you are not the intended recipient please inform the sender that you have received the message in error before deleting it. Please do not disclose, copy or distribute information in this e-mail or take any action in relation to its contents. To do so is strictly prohibited and may be unlawful. Thank you for your co-operation. NHSmail is the secure email and directory service available for all NHS staff in England and Scotland. NHSmail is approved for exchanging patient data and other sensitive information with NHSmail and other accredited email services. For more information and to find out how you can switch, https://portal.nhs.net/help/joiningnhsmail
participants (3)
-
Alan DeKok -
FRANKS, Andy (SHREWSBURY AND TELFORD HOSPITAL NHS TRUST) -
Matthew Newton