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