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