how to call stored procedure with output varaibles in free-radius
Hi All, How to call my own stored procedure ,which takes input and output variable in free-radius server. How do i do that ??? please help.................... 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/> ============================================================================================================================ 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="http://www.techmahindra.com/Disclaimer.html">http://www.techmahindra.com/Disclaimer.html</a> externally and <a href="http://tim.techmahindra.com/tim/disclaimer.html">http://tim.techmahindra.com/tim/disclaimer.html</a> internally within Tech Mahindra. ============================================================================================================================
On 15 Jan 2013, at 06:22, "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.
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? -Arran
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? alan
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? -Arran
On 15 Jan 2013, at 12:24, Arran Cudbard-Bell <a.cudbardb@freeradius.org> 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?
-Arran
*there are posts here that
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
On 15.01.2013 13:24, Arran Cudbard-Bell wrote:
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?
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 -- Olivier Beytrison Network & Security Engineer, HES-SO Fribourg Mail: olivier@heliosnet.org
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. -- Fajar
participants (6)
-
A.L.M.Buxey＠lboro.ac.uk -
Arran Cudbard-Bell -
Fajar A. Nugraha -
Lakshmi Narayana Baliah -
Olivier Beytrison -
Phil Mayers