From LB0074453@TechMahindra.com Tue Jan 15 07:23:14 2013
From: Lakshmi Narayana Baliah <LB0074453@TechMahindra.com>
To: freeradius-users@lists.freeradius.org
Subject: how to call stored procedure with output varaibles in free-radius
Date: Tue, 15 Jan 2013 11:52:07 +0530
Message-ID:
 <1B91A6A3C38A4F4B9E3B1AE4D3746E18052A0DF3@SINBNGEX001.TechMahindra.com>
MIME-Version: 1.0
Content-Type: multipart/mixed; boundary="===============4873434561877822983=="

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

Hi All,

=20

How to call my own stored procedure ,which takes input and output
variable in free-radius server.

=20

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

=20

=20

 Lakshmi narayana | Prod Engineering | Tech Mahindra
#9/7 Hosur Road,Bangalore-560029

(Office: +91 80 40243000, Extn: 3486

| Mobile: +91 9060867386

Email:lb0074453@techmahindra.com

www.techmahindra.com <http://www.techmahindra.com/>=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



--===============4873434561877822983==
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
bnRlbnQ9Ik1pY3Jvc29mdCBXb3JkIDEyIChmaWx0ZXJlZCBtZWRpdW0pIj48IS0tW2lmICFtc29d
PjxzdHlsZT52XDoqIHtiZWhhdmlvcjp1cmwoI2RlZmF1bHQjVk1MKTt9Cm9cOioge2JlaGF2aW9y
OnVybCgjZGVmYXVsdCNWTUwpO30Kd1w6KiB7YmVoYXZpb3I6dXJsKCNkZWZhdWx0I1ZNTCk7fQou
c2hhcGUge2JlaGF2aW9yOnVybCgjZGVmYXVsdCNWTUwpO30KPC9zdHlsZT48IVtlbmRpZl0tLT48
c3R5bGU+PCEtLQovKiBGb250IERlZmluaXRpb25zICovCkBmb250LWZhY2UKCXtmb250LWZhbWls
eTpXaW5nZGluZ3M7CglwYW5vc2UtMTo1IDAgMCAwIDAgMCAwIDAgMCAwO30KQGZvbnQtZmFjZQoJ
e2ZvbnQtZmFtaWx5OiJDYW1icmlhIE1hdGgiOwoJcGFub3NlLTE6MiA0IDUgMyA1IDQgNiAzIDIg
NDt9CkBmb250LWZhY2UKCXtmb250LWZhbWlseTpDYWxpYnJpOwoJcGFub3NlLTE6MiAxNSA1IDIg
MiAyIDQgMyAyIDQ7fQpAZm9udC1mYWNlCgl7Zm9udC1mYW1pbHk6IlRyZWJ1Y2hldCBNUyI7Cglw
YW5vc2UtMToyIDExIDYgMyAyIDIgMiAyIDIgNDt9Ci8qIFN0eWxlIERlZmluaXRpb25zICovCnAu
TXNvTm9ybWFsLCBsaS5Nc29Ob3JtYWwsIGRpdi5Nc29Ob3JtYWwKCXttYXJnaW46MGNtOwoJbWFy
Z2luLWJvdHRvbTouMDAwMXB0OwoJZm9udC1zaXplOjExLjBwdDsKCWZvbnQtZmFtaWx5OiJDYWxp
YnJpIiwic2Fucy1zZXJpZiI7fQphOmxpbmssIHNwYW4uTXNvSHlwZXJsaW5rCgl7bXNvLXN0eWxl
LXByaW9yaXR5Ojk5OwoJY29sb3I6Ymx1ZTsKCXRleHQtZGVjb3JhdGlvbjp1bmRlcmxpbmU7fQph
OnZpc2l0ZWQsIHNwYW4uTXNvSHlwZXJsaW5rRm9sbG93ZWQKCXttc28tc3R5bGUtcHJpb3JpdHk6
OTk7Cgljb2xvcjpwdXJwbGU7Cgl0ZXh0LWRlY29yYXRpb246dW5kZXJsaW5lO30Kc3Bhbi5FbWFp
bFN0eWxlMTcKCXttc28tc3R5bGUtdHlwZTpwZXJzb25hbC1jb21wb3NlOwoJZm9udC1mYW1pbHk6
IkNhbGlicmkiLCJzYW5zLXNlcmlmIjsKCWNvbG9yOndpbmRvd3RleHQ7fQouTXNvQ2hwRGVmYXVs
dAoJe21zby1zdHlsZS10eXBlOmV4cG9ydC1vbmx5O30KQHBhZ2UgV29yZFNlY3Rpb24xCgl7c2l6
ZTo2MTIuMHB0IDc5Mi4wcHQ7CgltYXJnaW46NzIuMHB0IDcyLjBwdCA3Mi4wcHQgNzIuMHB0O30K
ZGl2LldvcmRTZWN0aW9uMQoJe3BhZ2U6V29yZFNlY3Rpb24xO30KLS0+PC9zdHlsZT48IS0tW2lm
IGd0ZSBtc28gOV0+PHhtbD4KPG86c2hhcGVkZWZhdWx0cyB2OmV4dD0iZWRpdCIgc3BpZG1heD0i
MTAyNyIgLz4KPC94bWw+PCFbZW5kaWZdLS0+PCEtLVtpZiBndGUgbXNvIDldPjx4bWw+CjxvOnNo
YXBlbGF5b3V0IHY6ZXh0PSJlZGl0Ij4KPG86aWRtYXAgdjpleHQ9ImVkaXQiIGRhdGE9IjEiIC8+
CjwvbzpzaGFwZWxheW91dD48L3htbD48IVtlbmRpZl0tLT48L2hlYWQ+PGJvZHkgbGFuZz1FTi1J
TiBsaW5rPWJsdWUgdmxpbms9cHVycGxlPjxkaXYgY2xhc3M9V29yZFNlY3Rpb24xPjxwIGNsYXNz
PU1zb05vcm1hbD5IaSBBbGwsPG86cD48L286cD48L3A+PHAgY2xhc3M9TXNvTm9ybWFsPjxvOnA+
Jm5ic3A7PC9vOnA+PC9wPjxwIGNsYXNzPU1zb05vcm1hbD5Ib3cgdG8gY2FsbCBteSBvd24gc3Rv
cmVkIHByb2NlZHVyZSAsd2hpY2ggdGFrZXMgaW5wdXQgYW5kIG91dHB1dCB2YXJpYWJsZSBpbiBm
cmVlLXJhZGl1cyBzZXJ2ZXIuPG86cD48L286cD48L3A+PHAgY2xhc3M9TXNvTm9ybWFsPjxvOnA+
Jm5ic3A7PC9vOnA+PC9wPjxwIGNsYXNzPU1zb05vcm1hbD5Ib3cgZG8gaSBkbyB0aGF0ID8/PyBw
bGVhc2UgaGVscC4uLi4uLi4uLi4uLi4uLi4uLi4uPG86cD48L286cD48L3A+PHAgY2xhc3M9TXNv
Tm9ybWFsPjxvOnA+Jm5ic3A7PC9vOnA+PC9wPjxwIGNsYXNzPU1zb05vcm1hbD48bzpwPiZuYnNw
OzwvbzpwPjwvcD48cCBjbGFzcz1Nc29Ob3JtYWw+PCEtLVtpZiBndGUgdm1sIDFdPjx2OmxpbmUg
aWQ9Il94MDAwMF9zMTAyNiIgc3R5bGU9J3Bvc2l0aW9uOmFic29sdXRlO3otaW5kZXg6MjUxNjU4
MjQwJyBmcm9tPSItLjlwdCwxMi41cHQiIHRvPSIyMTkuNHB0LDEyLjVwdCIgc3Ryb2tlY29sb3I9
InJlZCIgLz48IVtlbmRpZl0tLT48IVtpZiAhdm1sXT48c3BhbiBzdHlsZT0nbXNvLWlnbm9yZTp2
Z2xheW91dDtwb3NpdGlvbjphYnNvbHV0ZTt6LWluZGV4OjI1MTY1ODI0MDttYXJnaW4tbGVmdDot
MnB4O21hcmdpbi10b3A6MTZweDt3aWR0aDoyOTZweDtoZWlnaHQ6MnB4Jz48aW1nIHdpZHRoPTI5
NiBoZWlnaHQ9MiBzcmM9ImNpZDppbWFnZTAwMS5wbmdAMDFDREYzMTYuQkVBNDIxNzAiIHY6c2hh
cGVzPSJfeDAwMDBfczEwMjYiPjwvc3Bhbj48IVtlbmRpZl0+PGI+PHNwYW4gc3R5bGU9J2ZvbnQt
c2l6ZTo4LjBwdDtmb250LWZhbWlseToiVHJlYnVjaGV0IE1TIiwic2Fucy1zZXJpZiI7Y29sb3I6
Z3JheSc+TGFrc2htaSBuYXJheWFuYSA8L3NwYW4+PC9iPjxiPjxzcGFuIHN0eWxlPSdmb250LXNp
emU6OC4wcHQ7Zm9udC1mYW1pbHk6IlRyZWJ1Y2hldCBNUyIsInNhbnMtc2VyaWYiO2NvbG9yOnJl
ZCc+fDwvc3Bhbj48L2I+PGI+PHNwYW4gc3R5bGU9J2ZvbnQtc2l6ZTo4LjBwdDtmb250LWZhbWls
eToiVHJlYnVjaGV0IE1TIiwic2Fucy1zZXJpZiI7Y29sb3I6Z3JheSc+Jm5ic3A7UHJvZCBFbmdp
bmVlcmluZyB8IFRlY2ggTWFoaW5kcmE8L3NwYW4+PC9iPjxicj48c3BhbiBzdHlsZT0nZm9udC1z
aXplOjguMHB0O2ZvbnQtZmFtaWx5OiJUcmVidWNoZXQgTVMiLCJzYW5zLXNlcmlmIjtjb2xvcjpn
cmF5Jz4jOS83IEhvc3VyIFJvYWQsQmFuZ2Fsb3JlLTU2MDAyOTxvOnA+PC9vOnA+PC9zcGFuPjwv
cD48cCBjbGFzcz1Nc29Ob3JtYWw+PGI+PHNwYW4gbGFuZz1FTi1VUyBzdHlsZT0nZm9udC1zaXpl
OjguMHB0O2ZvbnQtZmFtaWx5OldpbmdkaW5ncztjb2xvcjpncmF5Jz4oPC9zcGFuPjwvYj48Yj48
c3BhbiBsYW5nPUVOLVVTIHN0eWxlPSdmb250LXNpemU6OC4wcHQ7Zm9udC1mYW1pbHk6IlRyZWJ1
Y2hldCBNUyIsInNhbnMtc2VyaWYiO2NvbG9yOmdyYXknPk9mZmljZTogPC9zcGFuPjwvYj48Yj48
c3BhbiBsYW5nPUVOLVVTIHN0eWxlPSdmb250LXNpemU6OC4wcHQ7Zm9udC1mYW1pbHk6IlRyZWJ1
Y2hldCBNUyIsInNhbnMtc2VyaWYiO2NvbG9yOmdyYXknPis8L3NwYW4+PC9iPjxiPjxzcGFuIGxh
bmc9RU4tVVMgc3R5bGU9J2ZvbnQtc2l6ZTo4LjBwdDtmb250LWZhbWlseToiVHJlYnVjaGV0IE1T
Iiwic2Fucy1zZXJpZiI7Y29sb3I6Z3JheSc+OTEgODAmbmJzcDs0MDI0MzAwMCwgRXh0bjogMzQ4
Njwvc3Bhbj48L2I+PGI+PHNwYW4gbGFuZz1FTi1VUyBzdHlsZT0nY29sb3I6YmxhY2snPjxvOnA+
PC9vOnA+PC9zcGFuPjwvYj48L3A+PHAgY2xhc3M9TXNvTm9ybWFsPjxiPjxzcGFuIGxhbmc9RlIg
c3R5bGU9J2ZvbnQtc2l6ZTo4LjBwdDtmb250LWZhbWlseToiVHJlYnVjaGV0IE1TIiwic2Fucy1z
ZXJpZiI7Y29sb3I6cmVkJz58PC9zcGFuPjwvYj48c3BhbiBsYW5nPUZSIHN0eWxlPSdmb250LXNp
emU6OC4wcHQ7Zm9udC1mYW1pbHk6IlRyZWJ1Y2hldCBNUyIsInNhbnMtc2VyaWYiO2NvbG9yOmdy
YXknPiBNb2JpbGU6ICs5MSA5MDYwODY3Mzg2PG86cD48L286cD48L3NwYW4+PC9wPjxwIGNsYXNz
PU1zb05vcm1hbD48c3BhbiBsYW5nPUZSIHN0eWxlPSdmb250LXNpemU6OC4wcHQ7Zm9udC1mYW1p
bHk6IlRyZWJ1Y2hldCBNUyIsInNhbnMtc2VyaWYiO2NvbG9yOmdyYXknPkVtYWlsOmxiMDA3NDQ1
M0B0ZWNobWFoaW5kcmEuY29tPG86cD48L286cD48L3NwYW4+PC9wPjxwIGNsYXNzPU1zb05vcm1h
bD48Yj48c3BhbiBzdHlsZT0nZm9udC1zaXplOjguMHB0O2NvbG9yOmdyYXknPjxhIGhyZWY9Imh0
dHA6Ly93d3cudGVjaG1haGluZHJhLmNvbS8iIHRpdGxlPSJodHRwOi8vd3d3LnRlY2htYWhpbmRy
YS5jb20vIj48c3BhbiBzdHlsZT0nZm9udC1mYW1pbHk6IlRyZWJ1Y2hldCBNUyIsInNhbnMtc2Vy
aWYiO2NvbG9yOmdyYXknPnd3dy50ZWNobWFoaW5kcmEuY29tPC9zcGFuPjwvYT48L3NwYW4+PC9i
PjxiPjxzcGFuIGxhbmc9RU4tVVMgc3R5bGU9J2ZvbnQtc2l6ZTo4LjBwdDtmb250LWZhbWlseToi
VGltZXMgTmV3IFJvbWFuIiwic2VyaWYiO2NvbG9yOmdyYXknPjxvOnA+PC9vOnA+PC9zcGFuPjwv
Yj48L3A+PHAgY2xhc3M9TXNvTm9ybWFsPjxvOnA+Jm5ic3A7PC9vOnA+PC9wPjwvZGl2PjwvYm9k
eT48L2h0bWw+Cjx0YWJsZT48dHI+PHRkIGJnY29sb3I9I2ZmZmZmZj48Zm9udCBjb2xvcj0jMDAw
MDAwPjxwcmU+PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09
PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09
PT09PT09PT09PT09PT09PT09PQpEaXNjbGFpbWVyOiAgVGhpcyBtZXNzYWdlIGFuZCB0aGUgaW5m
b3JtYXRpb24gY29udGFpbmVkIGhlcmVpbiBpcyBwcm9wcmlldGFyeSBhbmQgY29uZmlkZW50aWFs
IGFuZCBzdWJqZWN0IHRvIHRoZQogVGVjaCBNYWhpbmRyYSBwb2xpY3kgc3RhdGVtZW50LCB5b3Ug
bWF5IHJldmlldyB0aGUgcG9saWN5IGF0IDxhIGhyZWY9Imh0dHA6Ly93d3cudGVjaG1haGluZHJh
LmNvbS9EaXNjbGFpbWVyLmh0bWwiPmh0dHA6Ly93d3cudGVjaG1haGluZHJhLmNvbS9EaXNjbGFp
bWVyLmh0bWw8L2E+IApleHRlcm5hbGx5IGFuZCA8YSBocmVmPSJodHRwOi8vdGltLnRlY2htYWhp
bmRyYS5jb20vdGltL2Rpc2NsYWltZXIuaHRtbCI+aHR0cDovL3RpbS50ZWNobWFoaW5kcmEuY29t
L3RpbS9kaXNjbGFpbWVyLmh0bWw8L2E+IGludGVybmFsbHkgd2l0aGluIFRlY2ggTWFoaW5kcmEu
Cj09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09
PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09
PT09PT09PT09PT08L3ByZT48L2ZvbnQ+PC90ZD48L3RyPjwvdGFibGU+Cg==

--===============4873434561877822983==
Content-Type: image/png
Content-Transfer-Encoding: base64
Content-Disposition: attachment; filename="image001.png"
MIME-Version: 1.0

iVBORw0KGgoAAAANSUhEUgAAASgAAAACCAYAAADrR0H9AAAAAXNSR0ICQMB9xQAAAAlwSFlzAAAO
xAAADsQBlSsOGwAAABl0RVh0U29mdHdhcmUATWljcm9zb2Z0IE9mZmljZX/tNXEAAAAlSURBVEjH
7cQ5AQAACMSwWj9lSONxwdAhoaFWS9IjlQQuSfpoAHFPDGrupGdOAAAAAElFTkSuQmCC

--===============4873434561877822983==--


From a.cudbardb@freeradius.org Tue Jan 15 11:46:16 2013
From: Arran Cudbard-Bell <a.cudbardb@freeradius.org>
To: freeradius-users@lists.freeradius.org
Subject: Re: how to call stored procedure with output varaibles in free-radius
Date: Tue, 15 Jan 2013 10:46:08 +0000
Message-ID: <C47F1EE1-3524-4709-85FA-79D0B268C5D6@freeradius.org>
In-Reply-To:
 <1B91A6A3C38A4F4B9E3B1AE4D3746E18052A0DF3@SINBNGEX001.TechMahindra.com>
MIME-Version: 1.0
Content-Type: multipart/mixed; boundary="===============8397019410857928304=="

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


On 15 Jan 2013, at 06:22, "Lakshmi Narayana Baliah" <LB0074453@techmahindra.c=
om> wrote:

> Hi All,
> =20
> How to call my own stored procedure ,which takes input and output variable =
in free-radius server.
> =20
> How do i do that ??? please help....................

Guessing you're referring to stored procedures in SQL? Or are you misusing SQ=
L terminology to refer to something like a subroutine or function writen in t=
he policy language?

-Arran

--===============8397019410857928304==--


From a.l.m.buxey@lboro.ac.uk Tue Jan 15 12:48:05 2013
From: "A.L.M.Buxey@lboro.ac.uk" <a.l.m.buxey@lboro.ac.uk>
To: freeradius-users@lists.freeradius.org
Subject: Re: how to call stored procedure with output varaibles in free-radius
Date: Tue, 15 Jan 2013 11:48:01 +0000
Message-ID: <20130115114801.GA16968@lboro.ac.uk>
In-Reply-To: <C47F1EE1-3524-4709-85FA-79D0B268C5D6@freeradius.org>
MIME-Version: 1.0
Content-Type: multipart/mixed; boundary="===============2931591638578047751=="

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

Hi,

> > How to call my own stored procedure ,which takes input and output variabl=
e in free-radius server.
> > =20
> > How do i do that ??? please help....................
>=20
> Guessing you're referring to stored procedures in SQL? Or are you misusing =
SQL terminology to refer to something like a subroutine or function writen in=
 the policy language?

..or do you mean using an external program (C or perl etc) to be given values=
 and return values?

alan

--===============2931591638578047751==--


From list@fajar.net Tue Jan 15 13:12:20 2013
From: "Fajar A. Nugraha" <list@fajar.net>
To: freeradius-users@lists.freeradius.org
Subject: Re: how to call stored procedure with output varaibles in free-radius
Date: Tue, 15 Jan 2013 19:12:17 +0700
Message-ID:
 <CAG1y0seWEvFbXdKPsdfKBddKn-oWmA69UAbjm2TqRy+2qfjBFQ@mail.gmail.com>
In-Reply-To:
 <1B91A6A3C38A4F4B9E3B1AE4D3746E18052A0DF3@SINBNGEX001.TechMahindra.com>
MIME-Version: 1.0
Content-Type: multipart/mixed; boundary="===============7906505820551899040=="

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

On Tue, Jan 15, 2013 at 1:22 PM, Lakshmi Narayana Baliah
<LB0074453@techmahindra.com> wrote:
>
> Hi All,
>
>
>
> How to call my own stored procedure ,which takes input and output variable =
in free-radius server.

If it's SQL stored procedure, then short version is you can't.

Long version, FR doesn't really care much about what you put in a
query, as long as it returns the same output as normal "select"
statement. The implication is that if you use something like mysql,
you CAN use stored procedure, provided that:
- the parameters are all inputs
- the procedure ends with a single SELECT statement, even if it's just
to display the result variables.

In my case I use the stored procedure to get various internal
variables (e.g. given a user name someuser@somerealm, I translate it
to a "user id" and "group id"), and then use the internal variables to
actually perform the SELECT process.

--=20
Fajar

--===============7906505820551899040==--


From a.cudbardb@freeradius.org Tue Jan 15 13:24:26 2013
From: Arran Cudbard-Bell <a.cudbardb@freeradius.org>
To: freeradius-users@lists.freeradius.org
Subject: Re: how to call stored procedure with output varaibles in free-radius
Date: Tue, 15 Jan 2013 12:24:20 +0000
Message-ID: <8DB99D7B-120B-41E0-A4B1-BFD1FFFA5E04@freeradius.org>
In-Reply-To: <20130115114801.GA16968@lboro.ac.uk>
MIME-Version: 1.0
Content-Type: multipart/mixed; boundary="===============0335358221421386373=="

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


On 15 Jan 2013, at 11:48, A.L.M.Buxey@lboro.ac.uk wrote:

> Hi,
>=20
>>> How to call my own stored procedure ,which takes input and output variabl=
e in free-radius server.
>>>=20
>>> How do i do that ??? please help....................
>>=20
>> Guessing you're referring to stored procedures in SQL? Or are you misusing=
 SQL terminology to refer to something like a subroutine or function writen i=
n the policy language?
>=20
> ..or do you mean using an external program (C or perl etc) to be given valu=
es and return values?

Jees, we really need to move to a new listserv, this latency is getting ridic=
ulous. Posts on the educase lists are pretty much instantaneous, but there se=
em to get delayed randomly for 30 mins or more.

Does anyone else experience that?

-Arran

--===============0335358221421386373==--


From a.cudbardb@freeradius.org Tue Jan 15 13:24:59 2013
From: Arran Cudbard-Bell <a.cudbardb@freeradius.org>
To: freeradius-users@lists.freeradius.org
Subject: Re: how to call stored procedure with output varaibles in free-radius
Date: Tue, 15 Jan 2013 12:24:55 +0000
Message-ID: <887BA03F-4024-4053-8E55-73DBD513FF15@freeradius.org>
In-Reply-To: <8DB99D7B-120B-41E0-A4B1-BFD1FFFA5E04@freeradius.org>
MIME-Version: 1.0
Content-Type: multipart/mixed; boundary="===============5508647261455721879=="

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


On 15 Jan 2013, at 12:24, Arran Cudbard-Bell <a.cudbardb@freeradius.org> wrot=
e:

>=20
> On 15 Jan 2013, at 11:48, A.L.M.Buxey@lboro.ac.uk wrote:
>=20
>> Hi,
>>=20
>>>> How to call my own stored procedure ,which takes input and output variab=
le in free-radius server.
>>>>=20
>>>> How do i do that ??? please help....................
>>>=20
>>> Guessing you're referring to stored procedures in SQL? Or are you misusin=
g SQL terminology to refer to something like a subroutine or function writen =
in the policy language?
>>=20
>> ..or do you mean using an external program (C or perl etc) to be given val=
ues and return values?
>=20
> Jees, we really need to move to a new listserv, this latency is getting rid=
iculous. Posts on the educase lists are pretty much instantaneous, but there =
seem to get delayed randomly for 30 mins or more.
>=20
> Does anyone else experience that?
>=20
> -Arran

*there are posts here that


--===============5508647261455721879==--


From p.mayers@imperial.ac.uk Tue Jan 15 13:52:28 2013
From: Phil Mayers <p.mayers@imperial.ac.uk>
To: freeradius-users@lists.freeradius.org
Subject: Re: how to call stored procedure with output varaibles in free-radius
Date: Tue, 15 Jan 2013 12:52:17 +0000
Message-ID: <50F55101.8020805@imperial.ac.uk>
In-Reply-To: <8DB99D7B-120B-41E0-A4B1-BFD1FFFA5E04@freeradius.org>
MIME-Version: 1.0
Content-Type: multipart/mixed; boundary="===============6059536413665225861=="

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

On 15/01/13 12:24, Arran Cudbard-Bell wrote:
>
> On 15 Jan 2013, at 11:48, A.L.M.Buxey@lboro.ac.uk wrote:
>
>> Hi,
>>
>>>> How to call my own stored procedure ,which takes input and
>>>> output variable in free-radius server.
>>>>
>>>> How do i do that ??? please help....................
>>>
>>> Guessing you're referring to stored procedures in SQL? Or are you
>>> misusing SQL terminology to refer to something like a subroutine
>>> or function writen in the policy language?
>>
>> ..or do you mean using an external program (C or perl etc) to be
>> given values and return values?
>
> Jees, we really need to move to a new listserv, this latency is
> getting ridiculous. Posts on the educase lists are pretty much
> instantaneous, but there seem to get delayed randomly for 30 mins or
> more.
>
> Does anyone else experience that?

Received: headers suggest something funny is going on in xs4all-land. 
For example, your first reply to the OP (sorry for the re-wrapping - 
local Exchange 2010 installation mangling RFC 822 headers here I'm 
afraid, am attempting to restore readability manually ;o):

Received: from list5.xs4all.net (list5.xs4all.net [194.109.21.196])
  by smtp-vbr12.xs4all.nl (8.13.8/8.13.8) with ESMTP id r0FB4BUE062954
  ...
  for <p.mayers@imperial.ac.uk>;
  Tue, 15 Jan 2013 12:13:24 +0100 (CET)
  ...
Received: from list5.xs4all.net (localhost [127.0.0.1])
  by list5.xs4all.net (8.14.3/8.14.3/Debian-9.4)
  with ESMTP id r0FAkGj3032462
  for <p.mayers@imperial.ac.uk>;
  Tue, 15 Jan 2013 11:51:48 +0100

--===============6059536413665225861==--


From olivier@heliosnet.org Tue Jan 15 14:26:27 2013
From: Olivier Beytrison <olivier@heliosnet.org>
To: freeradius-users@lists.freeradius.org
Subject: Re: how to call stored procedure with output varaibles in free-radius
Date: Tue, 15 Jan 2013 14:26:23 +0100
Message-ID: <50F558FF.5010809@heliosnet.org>
In-Reply-To: <8DB99D7B-120B-41E0-A4B1-BFD1FFFA5E04@freeradius.org>
MIME-Version: 1.0
Content-Type: multipart/mixed; boundary="===============2461451246117537238=="

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

On 15.01.2013 13:24, Arran Cudbard-Bell wrote:
>=20
> Jees, we really need to move to a new listserv, this latency is getting rid=
iculous. Posts on the educase lists are pretty much instantaneous, but there =
seem to get delayed randomly for 30 mins or more.
>=20
> Does anyone else experience that?

Me, all the time, and yeah it's a pain.
Sometimes I reply to a mail then watch the online archives to see the
answers to my mail, before it arrives in my inbox ..

Olivier

--=20

 Olivier Beytrison
 Network & Security Engineer, HES-SO Fribourg
 Mail: olivier@heliosnet.org

--===============2461451246117537238==--