[email protected] пишет:
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: [email protected], [email protected]
Regards, Igor Levchuk
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
