SQL Maps

FRANKS, Andy (SHREWSBURY AND TELFORD HOSPITAL NHS TRUST) andy.franks1 at nhs.net
Wed Jul 15 12:17:28 CEST 2020


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



More information about the Freeradius-Users mailing list