From LB0074453@TechMahindra.com Wed Feb  6 11:21:07 2013
From: Lakshmi Narayana Baliah <LB0074453@TechMahindra.com>
To: freeradius-users@lists.freeradius.org
Subject: free radius output attributes configuration
Date: Wed, 06 Feb 2013 15:49:55 +0530
Message-ID:
 <1B91A6A3C38A4F4B9E3B1AE4D3746E18058EC29D@SINBNGEX001.TechMahindra.com>
In-Reply-To:
 <mailman.4042.1360052971.1503.freeradius-users@lists.freeradius.org>
MIME-Version: 1.0
Content-Type: multipart/mixed; boundary="===============1546136509641928156=="

--===============1546136509641928156==
Content-Type: text/plain; charset="utf-8"
Content-Transfer-Encoding: quoted-printable

Hi All,

	How can configure output attributes in free-radius?
	How do i do that ??? please help....
	=20

Thanks
Lakshmi



=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
Disclaimer:  This message and the information contained herein is proprietary=
 and confidential and subject to the
 Tech Mahindra policy statement, you may review the policy at <a href=3D"http=
://www.techmahindra.com/Disclaimer.html">http://www.techmahindra.com/Disclaim=
er.html</a>=20
externally and <a href=3D"http://tim.techmahindra.com/tim/disclaimer.html">ht=
tp://tim.techmahindra.com/tim/disclaimer.html</a> internally within Tech Mahi=
ndra.
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D

--===============1546136509641928156==--


From radius.sir@gmail.com Wed Feb  6 11:54:25 2013
From: Russell Mike <radius.sir@gmail.com>
To: freeradius-users@lists.freeradius.org
Subject: Re: free radius output attributes configuration
Date: Wed, 06 Feb 2013 10:54:23 +0000
Message-ID:
 <CADao4CoK3Nw2xP93eBmy=3oaipchzpyiumjPeUvB7uZ20rw_6g@mail.gmail.com>
In-Reply-To:
 <1B91A6A3C38A4F4B9E3B1AE4D3746E18058EC29D@SINBNGEX001.TechMahindra.com>
MIME-Version: 1.0
Content-Type: multipart/mixed; boundary="===============7546375888767991848=="

--===============7546375888767991848==
Content-Type: text/plain; charset="utf-8"
Content-Transfer-Encoding: quoted-printable

what is output attributes ?


On Wed, Feb 6, 2013 at 10:19 AM, Lakshmi Narayana Baliah <
LB0074453@techmahindra.com> wrote:

> Hi All,
>
>         How can configure output attributes in free-radius?
>         How do i do that ??? please help....
>
>
> Thanks
> Lakshmi
>
>
>
>
> =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
> Disclaimer:  This message and the information contained herein is
> proprietary and confidential and subject to the
>  Tech Mahindra policy statement, you may review the policy at <a href=3D"
> http://www.techmahindra.com/Disclaimer.html">
> http://www.techmahindra.com/Disclaimer.html</a>
> externally and <a href=3D"http://tim.techmahindra.com/tim/disclaimer.html">
> http://tim.techmahindra.com/tim/disclaimer.html</a> internally within
> Tech Mahindra.
>
> =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
> -
> List info/subscribe/unsubscribe? See
> http://www.freeradius.org/list/users.html
>



--===============7546375888767991848==
Content-Type: text/html
Content-Transfer-Encoding: base64
Content-Disposition: attachment; filename="attachment.html"
MIME-Version: 1.0

PGRpdiBkaXI9Imx0ciI+d2hhdCBpcyBvdXRwdXQgYXR0cmlidXRlcyA/oDxicj48ZGl2IGNsYXNz
PSJnbWFpbF9leHRyYSI+PGJyPjxicj48ZGl2IGNsYXNzPSJnbWFpbF9xdW90ZSI+T24gV2VkLCBG
ZWIgNiwgMjAxMyBhdCAxMDoxOSBBTSwgTGFrc2htaSBOYXJheWFuYSBCYWxpYWggPHNwYW4gZGly
PSJsdHIiPiZsdDs8YSBocmVmPSJtYWlsdG86TEIwMDc0NDUzQHRlY2htYWhpbmRyYS5jb20iIHRh
cmdldD0iX2JsYW5rIj5MQjAwNzQ0NTNAdGVjaG1haGluZHJhLmNvbTwvYT4mZ3Q7PC9zcGFuPiB3
cm90ZTo8YnI+CjxibG9ja3F1b3RlIGNsYXNzPSJnbWFpbF9xdW90ZSIgc3R5bGU9Im1hcmdpbjow
IDAgMCAuOGV4O2JvcmRlci1sZWZ0OjFweCAjY2NjIHNvbGlkO3BhZGRpbmctbGVmdDoxZXgiPkhp
IEFsbCw8YnI+Cjxicj4KoCCgIKAgoCBIb3cgY2FuIGNvbmZpZ3VyZSBvdXRwdXQgYXR0cmlidXRl
cyBpbiBmcmVlLXJhZGl1cz88YnI+CqAgoCCgIKAgSG93IGRvIGkgZG8gdGhhdCA/Pz8gcGxlYXNl
IGhlbHAuLi4uPGJyPgo8YnI+Cjxicj4KVGhhbmtzPGJyPgpMYWtzaG1pPGJyPgo8YnI+Cjxicj4K
PGJyPgo9PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09
PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09
PT09PT09PT09PT09PT09PGJyPgpEaXNjbGFpbWVyOiCgVGhpcyBtZXNzYWdlIGFuZCB0aGUgaW5m
b3JtYXRpb24gY29udGFpbmVkIGhlcmVpbiBpcyBwcm9wcmlldGFyeSBhbmQgY29uZmlkZW50aWFs
IGFuZCBzdWJqZWN0IHRvIHRoZTxicj4KoFRlY2ggTWFoaW5kcmEgcG9saWN5IHN0YXRlbWVudCwg
eW91IG1heSByZXZpZXcgdGhlIHBvbGljeSBhdCAmbHQ7YSBocmVmPSZxdW90OzxhIGhyZWY9Imh0
dHA6Ly93d3cudGVjaG1haGluZHJhLmNvbS9EaXNjbGFpbWVyLmh0bWwiIHRhcmdldD0iX2JsYW5r
Ij5odHRwOi8vd3d3LnRlY2htYWhpbmRyYS5jb20vRGlzY2xhaW1lci5odG1sPC9hPiZxdW90OyZn
dDs8YSBocmVmPSJodHRwOi8vd3d3LnRlY2htYWhpbmRyYS5jb20vRGlzY2xhaW1lci5odG1sIiB0
YXJnZXQ9Il9ibGFuayI+aHR0cDovL3d3dy50ZWNobWFoaW5kcmEuY29tL0Rpc2NsYWltZXIuaHRt
bDwvYT4mbHQ7L2EmZ3Q7PGJyPgoKZXh0ZXJuYWxseSBhbmQgJmx0O2EgaHJlZj0mcXVvdDs8YSBo
cmVmPSJodHRwOi8vdGltLnRlY2htYWhpbmRyYS5jb20vdGltL2Rpc2NsYWltZXIuaHRtbCIgdGFy
Z2V0PSJfYmxhbmsiPmh0dHA6Ly90aW0udGVjaG1haGluZHJhLmNvbS90aW0vZGlzY2xhaW1lci5o
dG1sPC9hPiZxdW90OyZndDs8YSBocmVmPSJodHRwOi8vdGltLnRlY2htYWhpbmRyYS5jb20vdGlt
L2Rpc2NsYWltZXIuaHRtbCIgdGFyZ2V0PSJfYmxhbmsiPmh0dHA6Ly90aW0udGVjaG1haGluZHJh
LmNvbS90aW0vZGlzY2xhaW1lci5odG1sPC9hPiZsdDsvYSZndDsgaW50ZXJuYWxseSB3aXRoaW4g
VGVjaCBNYWhpbmRyYS48YnI+Cgo9PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09
PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09
PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PGJyPgotPGJyPgpMaXN0IGluZm8vc3Vic2Ny
aWJlL3Vuc3Vic2NyaWJlPyBTZWUgPGEgaHJlZj0iaHR0cDovL3d3dy5mcmVlcmFkaXVzLm9yZy9s
aXN0L3VzZXJzLmh0bWwiIHRhcmdldD0iX2JsYW5rIj5odHRwOi8vd3d3LmZyZWVyYWRpdXMub3Jn
L2xpc3QvdXNlcnMuaHRtbDwvYT48YnI+CjwvYmxvY2txdW90ZT48L2Rpdj48YnI+PC9kaXY+PC9k
aXY+Cg==

--===============7546375888767991848==--


From iperegudov@cboss.ru Wed Feb  6 12:31:50 2013
From: Iliya Peregoudov <iperegudov@cboss.ru>
To: freeradius-users@lists.freeradius.org
Subject: Re: free radius output attributes configuration
Date: Wed, 06 Feb 2013 15:31:44 +0400
Message-ID: <51123F20.8080201@cboss.ru>
In-Reply-To:
 <1B91A6A3C38A4F4B9E3B1AE4D3746E18058EC29D@SINBNGEX001.TechMahindra.com>
MIME-Version: 1.0
Content-Type: multipart/mixed; boundary="===============8342885166087843296=="

--===============8342885166087843296==
Content-Type: text/plain; charset="utf-8"
Content-Transfer-Encoding: 7bit

rlm_sql does not support sql parameter binding, neither input, nor 
output.  Specifically rlm_sql xlat (i.e. "%{sql: ...}") return number of 
rows affected for insert/update/delete, and return result of single-row 
and single-column select.

So your only option is a function called inside select from dual:

    if ("{sql: select func('%{User-Name}') from dual}") {
       ...
    }

On 06.02.2013 14:19, Lakshmi Narayana Baliah wrote:
> Hi All,
>
> 	How can configure output attributes in free-radius?
> 	How do i do that ??? please help....

--===============8342885166087843296==--