radippool table for Oracle

[Peter Nixon]

That should not be a problem to do. You just need to modify the queries a bit.

Cheers

Peter

On Tue 12 Sep 2006 23:56, Guilherme Franco wrote:
> 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
>
> -
> List info/subscribe/unsubscribe? See
> http://www.freeradius.org/list/users.html

-- 

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/20060913/fcf6f10e/attachment.pgp>