Freeradius 2.0 + postgresql 8.3

[Igor Levchuk]

tnt at kalik.net пишет:
>> rlm_sql (sql): sql_set_user escaped user --> 'testo'
>>       expand: UPDATE radippool  SET nasipaddress = '', pool_key = 0,
>> callingstationid = '',  expiry_time = 'now'::timestamp(0) - '1
>> second'::interval # WHERE nasipaddress = '%{NAS-IP-Address}' # AND
>> pool_key = '%{Calling-Station-Id}' -> UPDATE radippool  SET nasipaddress
>> = '', pool_key = 0, callingstationid = '',  expiry_time =
>> 'now'::timestamp(0) - '1 second'::interval # WHERE nasipaddress =
>> '194.44.252.230' # AND pool_key = ''
>> rlm_sql_postgresql: Status: PGRES_FATAL_ERROR
>> rlm_sql_postgresql: Error operator does not exist: timestamp without
>> time zone #
>> rlm_sql_postgresql: Postgresql Fatal Error: [42883: UNDEFINED FUNCTION]
>> Occurred!!
>>
>>
>> #radtest testo test localhost 1 xxxxx
>>
>> Can you help me fix it ?
>>     
>
> Hm, now() is type "timestamp with time zone". It looks like plain
> "timestamp" doesn't mean that any more. It means "timestamp without
> time zone" in current version. Try changing timestamp(0) to timestamp
> with time zone(0) in the dialup.conf query.
>
> Ivan Kalik
> Kalik Informatika ISP
>
> -
> List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
>   
Mmmm... Sorry :)
Im using old version of radippool table.
Fixed.
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
);


-- 
ISP UARNet[Rivne]
000, +38(0362) 26-44-74, +38(0362) 26-97-82
E-mail: igor at rv.uar.net, tech at mail.rv.ua
Regards, Igor Levchuk