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