Re: Freeradius won't authorize off redundant sql

"Cris Boisvert" <cris@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@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.