Having multiple authentication query in sql.conf

[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
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 189 bytes
Desc: not available
URL: <http://lists.freeradius.org/pipermail/freeradius-users/attachments/20060328/0c9382d5/attachment.pgp>