Freeradius won't authorize off redundant sql

Alan DeKok aland at ox.org
Tue Apr 4 22:55:18 CEST 2006


"Cris Boisvert" <cris at usai.net> wrote:
> Freeradius running using redunant sql scenario.
> If first sql is not available it falls to secondary..
> When FR Start is links correctly to both databases. 
> When the primary stops.. It won't respond at all.
> Below is the radiusd -X output.
...
> rlm_sql_mysql: query:  SELECT id,UserName,Attribute,Value,op FROM radcheck
> WHERE Username = 'test at usai.net' ORDER BY id

  See: http://dev.mysql.com/doc/refman/5.0/en/mysql-options.html

  It has a "read timeout", but it doesn't work on Linux.

  The problem is that the MySQL client is waiting forever for the
primary to comne back.  Until they implement the read timeout on
Linux, there's little that can be done on the FreeRADIUS side to fix
it.

  Alan DeKok.



More information about the Freeradius-Users mailing list