Unstable FreeRadius

[Bill Schoolfield]

Last week I reported an issue I had with FreeRadius 1.0.5 on Red Hat 
Enterprise Linux ES release 3. It had to do with dropped MySQL connections.

We continue experience severe problems with FreeRadius. The server will 
run for upwards to 8 hours, sometimes more, before getting into some 
unknown state where it stops responding to requests. At this time 
FreeRadius consumes all the system's cpu cycles and won't stop without a 
kill -9.

We are also running radrelay which relays to another port on the same 
server. The mysql database (version 4.0.26) is local to the server where 
FreeRadius resides.

Please if you have any ideas or suggestions please pass them along. 
Otherwise we may be forced to fall back on another approach. I can 
happily send more detail if needed but there's potentially a lot and I 
didn't want to overwhelm the list...

Thanks in advance for your ideas. From the log, here is the basic pattern:

Many of these...

Wed May  3 08:02:25 2006 : Info: rlm_sql (sql): There are no DB handles 
to use! skipped 0, tried to connect 0

then...

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

or:

Wed May  3 17:50:05 2006 : Info: rlm_sql_mysql: Starting connect to 
MySQL server for #4
Wed May  3 17:50:05 2006 : Error: rlm_sql_mysql: Couldn't connect socket 
to MySQL server radius at localhost:radius
Wed May  3 17:50:05 2006 : Error: rlm_sql_mysql: Mysql error ''
Wed May  3 17:50:05 2006 : Error: rlm_sql (sql): Failed to connect DB 
handle #4
Wed May  3 17:50:05 2006 : Error: rlm_sql (sql): reconnect failed, 
database down?
Wed May  3 17:50:05 2006 : Error: rlm_sql (sql): Couldn't insert SQL 
accounting STOP record - rlm_sql_mysql: no connection to db

or:

Sat May  6 12:40:04 2006 : Error: rlm_sql (sql): failed after re-connect
Sat May  6 12:40:04 2006 : Error: rlm_sql (sql): Couldn't update SQL 
accounting STOP record - Lost connection to MySQL server during query

or:
Sun May  7 18:20:41 2006 : Error: rlm_sql_mysql: MYSQL Error: Cannot get 
result
Sun May  7 18:20:42 2006 : Error: rlm_sql_mysql: MYSQL Error:
Sun May  7 18:20:42 2006 : Error: rlm_sql_mysql: MYSQL Error: No Fields
Sun May  7 18:20:42 2006 : Error: rlm_sql_mysql: MYSQL error:
Sun May  7 18:20:42 2006 : Info: rlm_sql_mysql: Starting connect to 
MySQL server for #8
Sun May  7 18:20:42 2006 : Error: rlm_sql (sql): failed after re-connect