From YS0072917@TechMahindra.com Mon Jan 14 04:50:45 2013
From: Yashaswini Sathyanarayana <YS0072917@TechMahindra.com>
To: freeradius-users@lists.freeradius.org
Subject:
Date: Mon, 14 Jan 2013 09:19:59 +0530
Message-ID:
 <1B91A6A3C38A4F4B9E3B1AE4D3746E18051F3156@SINBNGEX001.TechMahindra.com>
MIME-Version: 1.0
Content-Type: multipart/mixed; boundary="===============2656820760317245137=="

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

Hi all,

                I want to configure the  free radius to return access-
reject based on the value of a particular column in database .=20

                How do i do that ??? please help....

=20

Thanks & Regards,

Yashaswini | Prod Engg | Tech Mahindra Ltd.
9 / 7 Hosur Road, Bangalore - 560029, India.
(Office: +91 80 40243000, Extn: 3478

Mobile: +91 9611591177

www.techmahindra.com <http://www.techmahindra.com/>=20

=20

=20


=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=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



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

PGh0bWwgeG1sbnM6dj0idXJuOnNjaGVtYXMtbWljcm9zb2Z0LWNvbTp2bWwiIHhtbG5zOm89InVy
bjpzY2hlbWFzLW1pY3Jvc29mdC1jb206b2ZmaWNlOm9mZmljZSIgeG1sbnM6dz0idXJuOnNjaGVt
YXMtbWljcm9zb2Z0LWNvbTpvZmZpY2U6d29yZCIgeG1sbnM6bT0iaHR0cDovL3NjaGVtYXMubWlj
cm9zb2Z0LmNvbS9vZmZpY2UvMjAwNC8xMi9vbW1sIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcv
VFIvUkVDLWh0bWw0MCI+PGhlYWQ+PE1FVEEgSFRUUC1FUVVJVj0iQ29udGVudC1UeXBlIiBDT05U
RU5UPSJ0ZXh0L2h0bWw7IGNoYXJzZXQ9dXMtYXNjaWkiPjxtZXRhIG5hbWU9R2VuZXJhdG9yIGNv
bnRlbnQ9Ik1pY3Jvc29mdCBXb3JkIDEyIChmaWx0ZXJlZCBtZWRpdW0pIj48c3R5bGU+PCEtLQov
KiBGb250IERlZmluaXRpb25zICovCkBmb250LWZhY2UKCXtmb250LWZhbWlseToiQ2FtYnJpYSBN
YXRoIjsKCXBhbm9zZS0xOjIgNCA1IDMgNSA0IDYgMyAyIDQ7fQpAZm9udC1mYWNlCgl7Zm9udC1m
YW1pbHk6Q2FsaWJyaTsKCXBhbm9zZS0xOjIgMTUgNSAyIDIgMiA0IDMgMiA0O30KQGZvbnQtZmFj
ZQoJe2ZvbnQtZmFtaWx5OkFuZ3NhbmFVUEM7CglwYW5vc2UtMToyIDIgNiAzIDUgNCA1IDIgMyA0
O30KQGZvbnQtZmFjZQoJe2ZvbnQtZmFtaWx5OiJNb25vdHlwZSBDb3JzaXZhIjsKCXBhbm9zZS0x
OjMgMSAxIDEgMSAyIDEgMSAxIDE7fQovKiBTdHlsZSBEZWZpbml0aW9ucyAqLwpwLk1zb05vcm1h
bCwgbGkuTXNvTm9ybWFsLCBkaXYuTXNvTm9ybWFsCgl7bWFyZ2luOjBjbTsKCW1hcmdpbi1ib3R0
b206LjAwMDFwdDsKCWZvbnQtc2l6ZToxMS4wcHQ7Cglmb250LWZhbWlseToiQ2FsaWJyaSIsInNh
bnMtc2VyaWYiO30KYTpsaW5rLCBzcGFuLk1zb0h5cGVybGluawoJe21zby1zdHlsZS1wcmlvcml0
eTo5OTsKCWNvbG9yOmJsdWU7Cgl0ZXh0LWRlY29yYXRpb246dW5kZXJsaW5lO30KYTp2aXNpdGVk
LCBzcGFuLk1zb0h5cGVybGlua0ZvbGxvd2VkCgl7bXNvLXN0eWxlLXByaW9yaXR5Ojk5OwoJY29s
b3I6cHVycGxlOwoJdGV4dC1kZWNvcmF0aW9uOnVuZGVybGluZTt9CnNwYW4uRW1haWxTdHlsZTE3
Cgl7bXNvLXN0eWxlLXR5cGU6cGVyc29uYWwtY29tcG9zZTsKCWZvbnQtZmFtaWx5OiJDYWxpYnJp
Iiwic2Fucy1zZXJpZiI7Cgljb2xvcjp3aW5kb3d0ZXh0O30KLk1zb0NocERlZmF1bHQKCXttc28t
c3R5bGUtdHlwZTpleHBvcnQtb25seTt9CkBwYWdlIFdvcmRTZWN0aW9uMQoJe3NpemU6NjEyLjBw
dCA3OTIuMHB0OwoJbWFyZ2luOjcyLjBwdCA3Mi4wcHQgNzIuMHB0IDcyLjBwdDt9CmRpdi5Xb3Jk
U2VjdGlvbjEKCXtwYWdlOldvcmRTZWN0aW9uMTt9Ci0tPjwvc3R5bGU+PCEtLVtpZiBndGUgbXNv
IDldPjx4bWw+CjxvOnNoYXBlZGVmYXVsdHMgdjpleHQ9ImVkaXQiIHNwaWRtYXg9IjEwMjYiIC8+
CjwveG1sPjwhW2VuZGlmXS0tPjwhLS1baWYgZ3RlIG1zbyA5XT48eG1sPgo8bzpzaGFwZWxheW91
dCB2OmV4dD0iZWRpdCI+CjxvOmlkbWFwIHY6ZXh0PSJlZGl0IiBkYXRhPSIxIiAvPgo8L286c2hh
cGVsYXlvdXQ+PC94bWw+PCFbZW5kaWZdLS0+PC9oZWFkPjxib2R5IGxhbmc9RU4tSU4gbGluaz1i
bHVlIHZsaW5rPXB1cnBsZT48ZGl2IGNsYXNzPVdvcmRTZWN0aW9uMT48cCBjbGFzcz1Nc29Ob3Jt
YWw+SGkgYWxsLDxvOnA+PC9vOnA+PC9wPjxwIGNsYXNzPU1zb05vcm1hbD4mbmJzcDsmbmJzcDsm
bmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJz
cDsmbmJzcDsmbmJzcDsmbmJzcDsgSSB3YW50IHRvIGNvbmZpZ3VyZSB0aGUmbmJzcDsgZnJlZSBy
YWRpdXMgdG8gcmV0dXJuIGFjY2Vzcy0gcmVqZWN0IGJhc2VkIG9uIHRoZSB2YWx1ZSBvZiBhIHBh
cnRpY3VsYXIgY29sdW1uIGluIGRhdGFiYXNlIC4gPG86cD48L286cD48L3A+PHAgY2xhc3M9TXNv
Tm9ybWFsPiZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZu
YnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyBIb3cgZG8gaSBkbyB0aGF0
ID8/PyBwbGVhc2UgaGVscC4uLi48bzpwPjwvbzpwPjwvcD48cCBjbGFzcz1Nc29Ob3JtYWw+PG86
cD4mbmJzcDs8L286cD48L3A+PHAgY2xhc3M9TXNvTm9ybWFsPjxiPjxzcGFuIGxhbmc9RU4tVVMg
c3R5bGU9J2ZvbnQtZmFtaWx5OiJNb25vdHlwZSBDb3JzaXZhIjtjb2xvcjojMzM2NkZGJz5UaGFu
a3MgJmFtcDsgUmVnYXJkcyw8bzpwPjwvbzpwPjwvc3Bhbj48L2I+PC9wPjxwIGNsYXNzPU1zb05v
cm1hbD48Yj48c3BhbiBsYW5nPUVOLVVTIHN0eWxlPSdmb250LWZhbWlseToiTW9ub3R5cGUgQ29y
c2l2YSInPllhc2hhc3dpbmkgPHNwYW4gc3R5bGU9J2NvbG9yOnJlZCc+fCA8L3NwYW4+PHNwYW4g
c3R5bGU9J2NvbG9yOmJsYWNrJz5Qcm9kIEVuZ2c8L3NwYW4+PHNwYW4gc3R5bGU9J2NvbG9yOmdy
YXknPiA8L3NwYW4+PHNwYW4gc3R5bGU9J2NvbG9yOnJlZCc+fCA8L3NwYW4+PHNwYW4gc3R5bGU9
J2NvbG9yOmJsYWNrJz5UZWNoPC9zcGFuPjxzcGFuIHN0eWxlPSdjb2xvcjpncmF5Jz4gPC9zcGFu
PjxzcGFuIHN0eWxlPSdjb2xvcjpyZWQnPk1haGluZHJhPC9zcGFuPjxzcGFuIHN0eWxlPSdjb2xv
cjpncmF5Jz4gPC9zcGFuPjxzcGFuIHN0eWxlPSdjb2xvcjpibGFjayc+THRkLjxicj48L3NwYW4+
PHNwYW4gc3R5bGU9J2NvbG9yOmdyYXknPjkgLyA3IEhvc3VyIFJvYWQsIEJhbmdhbG9yZSAtIDU2
MDAyOSwgSW5kaWEuPC9zcGFuPjxzcGFuIHN0eWxlPSdjb2xvcjojOTk5OTk5Jz48YnI+PC9zcGFu
PjxzcGFuIHN0eWxlPSdjb2xvcjpncmF5Jz4oT2ZmaWNlOiArOTEgODAmbmJzcDs0MDI0MzAwMCwg
RXh0bjogMzwvc3Bhbj48L3NwYW4+PC9iPjxiPjxzcGFuIGxhbmc9RlIgc3R5bGU9J2ZvbnQtZmFt
aWx5OiJNb25vdHlwZSBDb3JzaXZhIjtjb2xvcjpncmF5Jz40Nzg8bzpwPjwvbzpwPjwvc3Bhbj48
L2I+PC9wPjxwIGNsYXNzPU1zb05vcm1hbD48Yj48c3BhbiBsYW5nPUZSIHN0eWxlPSdmb250LWZh
bWlseToiTW9ub3R5cGUgQ29yc2l2YSI7Y29sb3I6Z3JheSc+TW9iaWxlOiArOTEgOTYxMTU5MTE3
Nzwvc3Bhbj48L2I+PGI+PHNwYW4gbGFuZz1FTi1VUyBzdHlsZT0nZm9udC1mYW1pbHk6Ik1vbm90
eXBlIENvcnNpdmEiO2NvbG9yOmJsYWNrJz48bzpwPjwvbzpwPjwvc3Bhbj48L2I+PC9wPjxwIGNs
YXNzPU1zb05vcm1hbD48Yj48c3BhbiBsYW5nPUVOLVVTIHN0eWxlPSdmb250LWZhbWlseToiTW9u
b3R5cGUgQ29yc2l2YSInPjxhIGhyZWY9Imh0dHA6Ly93d3cudGVjaG1haGluZHJhLmNvbS8iIHRp
dGxlPSJodHRwOi8vd3d3LnRlY2htYWhpbmRyYS5jb20vIj48c3BhbiBzdHlsZT0nY29sb3I6Ymx1
ZSc+d3d3LnRlY2g8L3NwYW4+PHNwYW4gc3R5bGU9J2NvbG9yOnJlZCc+bWFoaW5kcmE8L3NwYW4+
PHNwYW4gc3R5bGU9J2NvbG9yOmJsdWUnPi5jb208L3NwYW4+PC9hPjxvOnA+PC9vOnA+PC9zcGFu
PjwvYj48L3A+PHAgY2xhc3M9TXNvTm9ybWFsPjxvOnA+Jm5ic3A7PC9vOnA+PC9wPjxwIGNsYXNz
PU1zb05vcm1hbD48bzpwPiZuYnNwOzwvbzpwPjwvcD48L2Rpdj48L2JvZHk+PC9odG1sPgo8dGFi
bGU+PHRyPjx0ZCBiZ2NvbG9yPSNmZmZmZmY+PGZvbnQgY29sb3I9IzAwMDAwMD48cHJlPj09PT09
PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09
PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09
PT09PT0KRGlzY2xhaW1lcjogIFRoaXMgbWVzc2FnZSBhbmQgdGhlIGluZm9ybWF0aW9uIGNvbnRh
aW5lZCBoZXJlaW4gaXMgcHJvcHJpZXRhcnkgYW5kIGNvbmZpZGVudGlhbCBhbmQgc3ViamVjdCB0
byB0aGUKIFRlY2ggTWFoaW5kcmEgcG9saWN5IHN0YXRlbWVudCwgeW91IG1heSByZXZpZXcgdGhl
IHBvbGljeSBhdCA8YSBocmVmPSJodHRwOi8vd3d3LnRlY2htYWhpbmRyYS5jb20vRGlzY2xhaW1l
ci5odG1sIj5odHRwOi8vd3d3LnRlY2htYWhpbmRyYS5jb20vRGlzY2xhaW1lci5odG1sPC9hPiAK
ZXh0ZXJuYWxseSBhbmQgPGEgaHJlZj0iaHR0cDovL3RpbS50ZWNobWFoaW5kcmEuY29tL3RpbS9k
aXNjbGFpbWVyLmh0bWwiPmh0dHA6Ly90aW0udGVjaG1haGluZHJhLmNvbS90aW0vZGlzY2xhaW1l
ci5odG1sPC9hPiBpbnRlcm5hbGx5IHdpdGhpbiBUZWNoIE1haGluZHJhLgo9PT09PT09PT09PT09
PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09
PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PC9w
cmU+PC9mb250PjwvdGQ+PC90cj48L3RhYmxlPgo=

--===============2656820760317245137==--


From a.l.m.buxey@lboro.ac.uk Mon Jan 14 12:47:32 2013
From: "A.L.M.Buxey@lboro.ac.uk" <a.l.m.buxey@lboro.ac.uk>
To: freeradius-users@lists.freeradius.org
Subject: Re: your mail
Date: Mon, 14 Jan 2013 11:47:28 +0000
Message-ID: <20130114114728.GB14405@lboro.ac.uk>
In-Reply-To:
 <1B91A6A3C38A4F4B9E3B1AE4D3746E18051F3156@SINBNGEX001.TechMahindra.com>
MIME-Version: 1.0
Content-Type: multipart/mixed; boundary="===============1857319222259602208=="

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

Hi,
>    Hi all,
>=20
>                    I want to configure the  free radius to return access-
>    reject based on the value of a particular column in database .
>=20
>                    How do i do that ??? please help....

probably with a bit of unlang like

if("%{sql:SELECT group FROM `table` where user =3D %{User-Name}}" !=3D "group=
_I_want"){
	reject
	}

man unlang and http://wiki.freeradius.org/modules/Rlm_sql

alan

--===============1857319222259602208==--