Freeradius keeps a configurable number of open connections, called
sockets in the config, which it uses to query the DB at all times. I
believe it keeps these open persistently. In sql.conf...
# number of sql connections to make to server
num_sql_socks = 5
Chris Carver
Network Engineer
andy wrote:
On another note still related to MySQL, is there a way to enforce mysql and freeradius to make persistant connections
to the database store?
On Wed, May 24, 2006 at 11:10:16AM +0100, andy wrote:
Hi list,
Fairly new to freeradius, just about to deploy a solution involving RedBack with data storage on the backend using
MySQL.
I am using NDBD MySQL clustering on the backend and I see the following error
from FreeRadius:
rlm_sql_mysql: MYSQL check_error: 2006, returning SQL_DOWN
This seems to relate to a timeout issue but googling doesnt provide any answers for that specific error code. (too like
the date 2006 I expect).
I have fairly tweaked the mysql backend to be fairly resilant in a heavy load situation, and none of the other
applications running against this cluster seem to have issues.
I was wondering if anyone could enlighten me as to how to fix this error, or what threshholds would be recomended for
running in this environment? It seems that when this error occurs, for the next few auth attempts, certain attributes
are not passed back to the redback. This specifically being IP-Interface.
any clues on this issue would be greatly appreciated.
thanks
--
andy [EMAIL PROTECTED]
-----------------------------------------------
Never argue with an idiot. They drag you down
to their level, then beat you with experience.
-----------------------------------------------
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html