Unstable FreeRadius

[Dennis Skinner]

Bill Schoolfield wrote:
> 
> Wed May  3 08:02:52 2006 : Error: rlm_sql_mysql: MYSQL Error: Cannot get
> result
> Wed May  3 08:02:52 2006 : Error: rlm_sql_mysql: MYSQL Error:
> Wed May  3 08:02:52 2006 : Error: rlm_sql_mysql: MYSQL Error: No Fields
> Wed May  3 08:02:52 2006 : Error: rlm_sql_mysql: MYSQL error:
> Wed May  3 08:02:52 2006 : Info: rlm_sql_mysql: Starting connect to
> MySQL server for #0
> Wed May  3 08:02:52 2006 : Error: rlm_sql (sql): failed after re-connect

All of those look like MySQL problems.  Do you have mytop installed?
What does it look like (you can also look at "show process list", but
mytop is nicer)?  What happens when you restart MySQL when radius does
that (you may need to HUP radiusd, not sure)?

I found that accounting requests would get very sluggish on large MyISAM
tables causing "no DB handles" errors.  Archiving data and switching to
InnoDB completely alleviated those problems (note that it may take
several hours to change the engine on large tables).

Also, the current release is 1.1.1, you should probably use that.

-- 
Dennis Skinner
Systems Administrator
BlueFrog Internet
http://www.bluefrog.com