Re: Having multiple authentication query in sql.conf

2006-03-29 Thread vignesh_b

thanks peter
but can is there any way where i can specify radius to use authetication
query a for calls from user a, and query b for users b. 
--
View this message in context: 
http://www.nabble.com/Having-multiple-authentication-query-in-sql.conf-t1353830.html#a3647212
Sent from the FreeRadius - User forum at Nabble.com.

- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html


Re: Having multiple authentication query in sql.conf

2006-03-28 Thread Peter Nixon
On Tue 28 Mar 2006 09:13, vignesh wrote:
 Hello all
 Can I have multiple authentication queries in sql.conf file. There are
 different ways by which we want to autheticate the users. I will let you
 know what I exactly want. I want to authenticate users based on the CLID
 and the remote ip address. The problem is that the remote address has to
 be searched from a set of ips. I will give you a example Suppose that we
 have a user 9204 and if the call for this particular user comes from a
 set of ips like 222.223.33.24 or 33.44.334.44( which will be present in
 some database tables) etc only then user will be authenticated.

This is very easy to do with a database stored procedure. Change your query to 
call a single sql function, then put all the different queries you need 
inside that function.

Cheers

-- 

Peter Nixon
http://www.peternixon.net/
PGP Key: http://www.peternixon.net/public.asc


pgpPKwZaASLqh.pgp
Description: PGP signature
- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Having multiple authentication query in sql.conf

2006-03-27 Thread vignesh
Hello all
Can I have multiple authentication queries in sql.conf file. There are
different ways by which we want to autheticate the users. I will let you
know what I exactly want. I want to authenticate users based on the CLID
and the remote ip address. The problem is that the remote address has to
be searched from a set of ips. I will give you a example Suppose that we
have a user 9204 and if the call for this particular user comes from a
set of ips like 222.223.33.24 or 33.44.334.44( which will be present in
some database tables) etc only then user will be authenticated. 

Vignesh

- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html