Freeradius 2.0 + postgresql 8.3

Igor Levchuk igor at rv.uar.net
Tue Jan 20 16:34:51 CET 2009


Hello,
I have an error:
freeradius -X
.......
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 ?


-- 
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




More information about the Freeradius-Users mailing list