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 - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html