problem with postgres and 2.0.4

A.L.M.Buxey at lboro.ac.uk A.L.M.Buxey at lboro.ac.uk
Mon May 5 16:14:16 CEST 2008


hi,

anyone else noted this - i'll file a bug if theres
another noted problem. we are using the database to hold NAS entries.

just upgraded to 2.0.4 and radiusd wont start. log shows this:

Mon May  5 14:55:55 2008 : Info: rlm_sql (xbase): Driver rlm_sql_postgresql (module rlm_sql_postgresql) loaded and linked
Mon May  5 14:55:55 2008 : Info: rlm_sql (xbase): Attempting to connect to radius at localhost:/xbase
Mon May  5 14:55:55 2008 : Error: sql_postgresql: calling unimplemented function


further debugging with radiusd -X shows the following (we have 10 SQL threads open - default)

rlm_sql (xbase): Attempting to connect rlm_sql_postgresql #9
rlm_sql (xbase): Connected new DB handle, #9
rlm_sql (xbase): Processing generate_sql_clients
rlm_sql (xbase) in generate_sql_clients: query is SELECT id, nasname, shortname, type, secret FROM xbaseschema.naslist
rlm_sql (xbase): Reserving sql socket id: 9
rlm_sql_postgresql: Status: PGRES_TUPLES_OK
rlm_sql_postgresql: query affected rows = 39 , fields = 5
rlm_sql (xbase): Read entry nasname=127.0.0.1,shortname=localhost,secret=topsecretstuff
sql_postgresql: calling unimplemented function

this is postgres 8.1.11   - no change to schema between previous versions - all looks
fine and a quick rollback to 2.0.3 and the daemon is fine. 2.0.4 postgres issue?

alan



More information about the Freeradius-Users mailing list