>^^ It's not ippool.sql - we're talking about the RADIPPOOL table - No I
>haven't changed this - go and check it by
>yourself:/freeradius-1.1.7/freeradius-1.1.7/doc/examples/postgresql
>And besides that I'm not using "ippool.sql" but instead of I'm using
>"postgresqlippool.conf" because I'm using PostgreSQL as DB Server.
You are correct. Schema in 1.1.7 is broken and will not work as
documented. I have attached postgre ippool.sql schema from 2.0.4. That
will correct the input errors. It's also indexed so it should work
faster.
>Didn't you read what I wrote? ; ) It won't work , because there are
>fields which can't be NULL ... for example "pool_key" and so on
>>
..
>proper shema won't work.
This one should.
>>
>>> ^^ 2. What is expiry_time good for if there is already an
>>> lease-duration = 3600 configured in the postgresqlippool.conf? And why
>>> do I get forced to use unix timestamp instead of using a simple time in
>>> secounds when it'll be expired?
>>>
>>
>> Seconds from when? You do need a timestamp for lease start then.
>>
>^^ ah, ok that makes sence ; ) but untill now I'm only able to tell the
>DB a fix Timestamp like 2008-12-31 11:15:00 but how do I change that the
>server is picking up the actual time everytime somebody gets an IP.
>Might there be a special variable for our case?
start-update query should do that.
Ivan Kalik
Kalik Informatika ISP
--
-- Table structure for table 'radippool'
--
CREATE TABLE radippool (
id BIGSERIAL PRIMARY KEY,
pool_name varchar(64) NOT NULL,
FramedIPAddress INET NOT NULL,
NASIPAddress VARCHAR(16) NOT NULL default '',
pool_key VARCHAR(64) NOT NULL default 0,
CalledStationId VARCHAR(64),
CallingStationId text NOT NULL default ''::text,
expiry_time TIMESTAMP(0) without time zone NOT NULL default
'now'::timestamp(0),
username text DEFAULT ''::text
);
CREATE INDEX radippool_poolname_expire ON radippool USING btree (pool_name,
expiry_time);
CREATE INDEX radippool_framedipaddress ON radippool USING btree
(framedipaddress);
CREATE INDEX radippool_nasip_poolkey_ipaddress ON radippool USING btree
(nasipaddress, pool_key, framedipaddress);
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
