SQLIPPOOL problem

Guilherme Franco guilhermefranco at gmail.com
Sat Oct 28 14:24:21 CEST 2006


Thanks Peter, that will do.

But I came into another problem, regarding this.

I've created entries in radreply such as "user at domain.com
Framed-IP-Address = 1.1.1.2".

When the user authenticates, freeradius finds the data from radreply,
but sqlippool still assigns a random IP.

What can it be, please?


Thank you very much.


On 10/28/06, Peter Nixon <listuser at peternixon.net> wrote:
> On Fri 27 Oct 2006 01:50, Guilherme Franco wrote:
> > Hi,
> >
> > This is very important, please.
> >
> > In ippool module I can use two or more pools just by setting
> >
> > ippool POOL1{...}
> > ippool POOL2{...}
> >
> > In SQLIPPOOL, I know that I can create as many pools as I wan't but I
> > need to treat that pools differently, say, POOL1 assigns static IPs
> > and POOL2 dynamic ones, or POOL1 is in databaseX and POOL2 in
> > databaseY.
> >
> > So I did this sqlippool.conf:
> >
> > sqlippool POOL1{...}
> > sqlippool POOL2{...}
> >
> > And then in radiusd.conf
> >
> > post-auth{
> > POOL1
> > POOL2
> > }
> >
> > But the user that have Pool-Name := POOL2 in radcheck receives the IP
> > (because POOL2 exists in the database), but it's not treated by the
> > POOL2 instance created in sqlippool.conf (radiusd -X shows that both
> > module POOL1 and POOL2 are instantiated), it's being treated by the
> > POOL1 instance.
> >
> > So, how can I tell that for users that belong to POOL2 use the POOL2
> > module, instead of POOL1 and vice-versa?
>
> With sqlippool the name of the module has no relation to the Pool-Name
> attribute. The easiest way to do what you want is simply make the 2nd module
> use a different database table and don't put the same Pool-Name is both
> tables..
>
> Cheers
>
> --
>
> Peter Nixon
> http://www.peternixon.net/
> PGP Key: http://www.peternixon.net/public.asc
> -
> List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
>


-- 
Guilherme de Oliveira Franco
Damovo - Brasil



More information about the Freeradius-Users mailing list