radippool table for Oracle

[Guilherme Franco]

Mr. Peter,

Thanks, yes, that's correct.

But what I need is this behaviour even if the user disconnects and
even if I run out of IPs in the pool. Basically, John logs in for the
first time and randomly catches ip 1.1.1.130. When John logs out and
comes back next week, he should be able to get 1.1.1.130 again, so
that IP can't be reused.

Is there any form to do that?

Sorry, maybe I've described the problem in a wrong way earlier.

Thank you very much for the answers, I hope to contribute later to
freeradius posting my oracle schema.


On 9/12/06, Peter Nixon <listuser at peternixon.net> wrote:
> On Tue 12 Sep 2006 22:44, Guilherme Franco wrote:
> > Thanks Mr. Nixon,
> >
> > I thought that someone might have already created such a schema.
> >
> > But that's not a problem.
> >
> > I'll be playing with the errors and as I get a working schema I'll post
> > back.
> >
> > Just another doubt: Is there any way to create a pool of addresses and
> > when someone receives one ip  from this pool, this ip stays assigned
> > to that user forever (lease forever, just like a static IP)? I need
> > this so that I assign an IP only based in the group (which has some
> > pools assigned to it), no need to manually create Frammed-Ip-Address =
> > x.x.x.x for that user.
>
> That is basically what the default sqlippool config does unless you run out of
> IPs in the pool, in which case it will start to hand reusing IPs that are
> currently not connected.
>
> --
>
> 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
>
>
>