failed query & postgresql driver

freeradius at list.coretech.ro freeradius at list.coretech.ro
Fri Nov 17 20:43:49 CET 2006


hello,

I am trying to use the redundant feature of freeradius and I do not 
understand why the sql module (postgresql driver) returns ok when a 
query fails.

from radiusd -X
rlm_sql (sql): Reserving sql socket id: 61
rlm_sql_postgresql: Status: PGRES_FATAL_ERROR
rlm_sql_postgresql: Error column "aaa" does not exist
rlm_sql_postgresql: Postgresql Fatal Error: [42703] Accured!!
rlm_sql_postgresql: Postgresql Fatal Error: [UNDEFINED COLUMN] Occured!!
radius_xlat:  ''
rlm_sql (sql): Released sql socket id: 61
  modcall[accounting]: module "sql" returns ok for request 1
modcall:  group  returns ok for request 1
modcall: group accounting returns ok for request 1

in file sql_postgresql.c function sql_check_error I see that for non 
"SQL_DOWN" errors it returns 0 (OK) is this ok ?
also in the compile stage I get:

In file included from sql_postgresql.c:56:
sql_postgresql.h:21: warning: missing braces around initializer
sql_postgresql.h:21: warning: (near initialization for `errorcodes[0]')
sql_postgresql.c: In function `sql_query':
sql_postgresql.c:300: warning: enumeration value `PGRES_EMPTY_QUERY' not 
handled in switch
sql_postgresql.c:300: warning: enumeration value `PGRES_COPY_OUT' not 
handled in switch
sql_postgresql.c:300: warning: enumeration value `PGRES_COPY_IN' not 
handled in switch
sql_postgresql.c:319: warning: control reaches end of non-void function
sql_postgresql.c: At top level:
sql_postgresql.c:68: warning: 'sql_num_fields' declared `static' but 
never defined
sql_postgresql.c:75: warning: 'status_is_ok' defined but not used


my gcc is: gcc (GCC) 3.4.4 20050721 (Red Hat 3.4.4-2)
is it to old ? the rest of freeradius compiles ok


thanks,
razvan radu




More information about the Freeradius-Users mailing list