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. Thanks. On 9/12/06, Peter Nixon <listuser@peternixon.net> wrote:

On Tue 12 Sep 2006 21:45, Guilherme Franco wrote:

...

Hello,

Is there anyone that managed to create a working "radippool" table for Oracle?

I'm using the last CVS version of freeradius and there's a schema_sqlippool_pgsql.sql but it's only for PostGreSQL:

CREATE TABLE radippool ( id serial NOT NULL, pool_name text NOT NULL, ip_address inet, nas_ip_address text NOT NULL, nas_port integer NOT NULL, calling_station_id text DEFAULT ''::text NOT NULL, expiry_time timestamp(0) without time zone NOT NULL, username text DEFAULT ''::text );

CREATE INDEX radippool_poolname_ipaadr ON radippool USING btree (pool_name, ip_address); CREATE INDEX radippool_poolname_expire ON radippool USING btree (pool_name, expiry_time); CREATE INDEX radippool_nasipaddr_port ON radippool USING btree (nas_ip_address, nas_port); CREATE INDEX radippool_nasipaddr_calling ON radippool USING btree (nas_ip_address, calling_station_id);

-- NOTE: don't forget to vaccum a DB regulary

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

What can I change to make it Oracle compatible?

Try to create the table and then fix the bits that give a syntax error. Your DBA should be able to help you with this.

Then do the same thing for the queries.

Once you have a working schema and queries send them to the list so that we can add them to cvs.

There was a report to the list that it works with MySQL after a bit of playing so it should be easy to make it work with Oracle (Which is much closer to Postgresql than MySQL is)

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

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

Hi Please update to the latest sqlippool.conf in cvs as I have just committed a lot of cleanups to it. 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