Re: Send Access-Reject when user does not match any group?

2013-01-15 Thread Bogdan Enache
Hi, I tried something else today. I created in SQL a group named disabled, with no check items, only a Reply-Message. A put a user in that group. I put a rule in the users file (commenting everything else out): DEFAULT Group == disabled, Auth-Type := Reject Reply-Message := Your

Re: how to call stored procedure with output varaibles in free-radius

2013-01-15 Thread Arran Cudbard-Bell
On 15 Jan 2013, at 06:22, Lakshmi Narayana Baliah lb0074...@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

how to call stored procedure in free-radius server

2013-01-15 Thread Lakshmi Narayana Baliah
Hi Arran, Thanks for your reply have created stored procedure(myS1Request) in oracle database 11g as shown below, procedure takes input and output parameters. The below procedure should be called in the SQL module in Free-radius for Authentication and Authorization purpose. PROCEDURE

Re: how to call stored procedure with output varaibles in free-radius

2013-01-15 Thread A . L . M . Buxey
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

Re: how to call stored procedure in free-radius server

2013-01-15 Thread Arran Cudbard-Bell
On 15 Jan 2013, at 11:30, Lakshmi Narayana Baliah lb0074...@techmahindra.com wrote: Hi Arran, Thanks for your reply have created stored procedure(myS1Request) in oracle database 11g as shown below, procedure takes input and output parameters. The below procedure should be called in

Re: how to call stored procedure with output varaibles in free-radius

2013-01-15 Thread Fajar A. Nugraha
On Tue, Jan 15, 2013 at 1:22 PM, Lakshmi Narayana Baliah lb0074...@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

Re: how to call stored procedure in free-radius server

2013-01-15 Thread Phil Mayers
On 15/01/13 11:30, Lakshmi Narayana Baliah wrote: Hi Arran, Thanks for your reply have created stored procedure(myS1Request) in oracle database 11g as shown below, procedure takes input and output parameters. The below procedure should be called in the SQL module in Free-radius for

Re: how to call stored procedure with output varaibles in free-radius

2013-01-15 Thread Arran Cudbard-Bell
On 15 Jan 2013, at 11:48, a.l.m.bu...@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

Re: Send Access-Reject when user does not match any group?

2013-01-15 Thread Bogdan Enache
Hi list, I have managed to solve the last problem by replacing Group with SQL-Group, like so: DEFAULT SQL-Group == disabled, Auth-Type := Reject Reply-Message := Your account is disabled., Fall-Through := No Now users which are in the disabled group get Access-Reject, which is

Re: how to call stored procedure with output varaibles in free-radius

2013-01-15 Thread Arran Cudbard-Bell
On 15 Jan 2013, at 12:24, Arran Cudbard-Bell a.cudba...@freeradius.org wrote: On 15 Jan 2013, at 11:48, a.l.m.bu...@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

Re: how to call stored procedure with output varaibles in free-radius

2013-01-15 Thread Phil Mayers
On 15/01/13 12:24, Arran Cudbard-Bell wrote: On 15 Jan 2013, at 11:48, a.l.m.bu...@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

how to test a user in db from free-radius server

2013-01-15 Thread Lakshmi Narayana Baliah
Hi All, I have configured freeradius server + oracle database 11g. I send user1 in the Access-Request from radclient to the free-radius server. I need to check whether user1 is exists in user_test table, which is in oracle database 11g. The table contains username - 'user1' and

Re: how to call stored procedure with output varaibles in free-radius

2013-01-15 Thread Olivier Beytrison
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,

Re: how to test a user in db from free-radius server

2013-01-15 Thread Fajar A. Nugraha
On Tue, Jan 15, 2013 at 7:37 PM, Lakshmi Narayana Baliah lb0074...@techmahindra.com wrote: Hi All, I have configured freeradius server + oracle database 11g. I send user1 in the Access-Request from radclient to the free-radius server. I need to check whether user1 is exists in user_test

Re: Use of %{Framed-IP-Address} in dialup.conf

2013-01-15 Thread Örn Arnarson
Hi Alan, There is a Framed-IP-Address: xxx.xx.xx.xxx in the packet. That should then presumably mean that I should be able to access this variable in said config file? Regards, Örn On Mon, Jan 14, 2013 at 2:07 AM, Alan DeKok al...@deployingradius.comwrote: Örn Arnarson wrote: I'm logging

RE: Slow Ldap Authorization

2013-01-15 Thread Tyler Brady
On 01/15/2013 07:45 AM, Phil Mayers wrote: Sorry, I've just realised another thing you can try - disable referral chasing. This is an option on the ldap module - try this: ldap { ... chase_referrals = no } This solved my problem. Thank you! - List info/subscribe/unsubscribe? See

Re: Use of %{Framed-IP-Address} in dialup.conf

2013-01-15 Thread Alan DeKok
Örn Arnarson wrote: Hi Alan, There is a Framed-IP-Address: xxx.xx.xx.xxx in the packet. That should then presumably mean that I should be able to access this variable in said config file? Yes. Run the server in debugging mode to see. Odds are the Framed-IP-Address is in the

Re: Use of %{Framed-IP-Address} in dialup.conf

2013-01-15 Thread Arran Cudbard-Bell
On 15 Jan 2013, at 21:02, Alan DeKok al...@deployingradius.com wrote: Örn Arnarson wrote: Hi Alan, There is a Framed-IP-Address: xxx.xx.xx.xxx in the packet. Outbound packet right (reply)? Because you're dealing with an Access-Request, which is why you're modifying the Post-Auth query?