Using Freeradius 0.8.1 and validating users using Sybase driver work fine
for us; but if for some reason we lost connection to the DB, or the DB
server is restarted we can't continue validating using the DB until radiusd
is restarted and new sockets are open again.
Is there any way to do a new connection to the DB (open new sockets) in
case that the DB is restarted? or check the "connection" before connect to
DB and open new sockets in case we need it?
This is the debug of the fail when freeradius "lost" connection to DB:
rlm_sql (sql): Reserving sql socket id: 3
SELECT 1,NAME,'User-Password',PASS,'==' FROM names WHERE USER = 'jon'
Client Library error:
severity(0) number(6) origin(3) layer(5)
ct_results(): network packet layer: internal net library error:
Net-Library operation terminated due to disconnect
rlm_sql_sybase(sql_select_query): Failure retrieving query results
Client Library error:
severity(0) number(5) origin(3) layer(5)
ct_cancel(): network packet layer: internal net library error:
Net-Library operation terminated due to disconnect
rlm_sql_sybase(sql_select_query): cleaning up.
rlm_sql_getvpdata: database query error
rlm_sql (sql): SQL query error; rejecting user
rlm_sql (sql): Released sql socket id: 3
modcall[authorize]: module "sql" returns fail
modcall: group authorize returns fail
There was no response configured: rejecting request 1
Server rejecting request 1.
Finished request 1
Some idea about how can I reconnect to the DB without restart "radiusd"?
Best regards,
Yurguen
===============================================================
Este mensaje y sus anexos son confidenciales y de uso exclusivo
de las personas a las que est� dirigido. En caso de que ud.
recibiera �ste correo por error no podr� modificar, copiar o
distribuir parte o la totalidad del mismo; asimismo le solicitamos
que notifique tal situaci�n al emisor y que
que tenga a bien eliminarlo de su sistema.
El emisor no acepta responsabilidades por errores
u omisiones en el contenido de �ste correo dado que
Internet no garantiza la seguridad y exactitud de las
comunicaciones.
Las opiniones vertidas en este correo son exclusivas
de su autor y no representan la opini�n del Banco Galicia.
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
