Having multiple authentication query in sql.conf
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
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
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-t1353... Sent from the FreeRadius - User forum at Nabble.com.
participants (3)
-
Peter Nixon -
vignesh -
vignesh_b