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@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