mysql issue

andy andy at shady.org
Thu May 25 16:41:37 CEST 2006


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    andy at shady.org
> -----------------------------------------------
> 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
> 

-- 
andy    andy at shady.org
-----------------------------------------------
Never argue with an idiot. They drag you down 
to their level, then beat you with experience.
----------------------------------------------- 



More information about the Freeradius-Users mailing list