mysql issue

[Chris Carver]

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    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
>>
>>     
>
>