Freeradius 2.0 + postgresql 8.3

[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