SQL and ippool

[Maxim Sirenko]

Hi!

I think, SQL server with some stored procedures should think of it.
But I doubt that it's possible to bind username to pool.
If I'm right NAS already has to know the name of pool from which it requests 
the IP for client and SQL server simply returns to radius free ip from this 
pool.


It's possible to bind NAS ip address to some pool
or to bind username to certain ip address.

My answer is not the last instance but I think it's somewhere near the 
truth.

Best regards,
Maxim.

----- Original Message ----- 
From: "Xiaochen Jing" <xjing at datavalet.com>
To: "'FreeRadius users mailing list'" 
<freeradius-users at lists.freeradius.org>
Sent: Thursday, September 18, 2008 6:36 PM
Subject: SQL and ippool


>
>
> Hello all,
>
>
>
> The scenario will be: when Freeradius receives a user request, it forwards
> it to SQL server (local or remote) for authenticating the 
> username/password.
> If the username/password is valid, then Freeradius will use a certain 
> ippool
> to assign IP address to the user, based on username.
>
>
>
> Can this be accomplished? I am wondering, when SQL sends a reply back to
> Freeradius, how can Freeradius knows what ippool it should use to assign 
> IP
> based on user name?
>
>
>
> Can anyone shed some light on it?
>
>
>
> Thanks in advance
>
>
>
>
>
>


--------------------------------------------------------------------------------


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