tnt@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@rv.uar.net, tech@mail.rv.ua Regards, Igor Levchuk