freeradius 2.0.5 problem

[Marinko Tarlac]

Hi

Did you try to open database and see all tables and data inside them? 
Maybe one of the tables is damaged so you'll need to check it first (and 
repair if it is necessary) .

Egi wrote:
> Hello,
>
> I tried to optimize tables, and also followed the sql tunning guide by 
> setting the database to innodb but I still get only these error:
>
> Sun Jul  6 17:32:28 2008 : Error: Dropping conflicting packet from 
> client mikrotik1:43365 - ID: 45 due to unfinished request 22668
> Sun Jul  6 17:32:28 2008 : Error: Dropping conflicting packet from 
> client mikrotik2:54058 - ID: 250 due to unfinished request 22681
>
> Thank You!
>
>
> A.L.M.Buxey at lboro.ac.uk wrote:
>> Hi,
>>
>>  
>>> Mikrotik Router > freeradius server > Mysql Server
>>>
>>> From time to time (Maybe once in 4-5 days) i get this error repeated 
>>> for many many times:
>>>     
>>
>> your MySQL is too slow to respond to the requests - check your SQL 
>> queries and see how you can optimise them.
>> I've been able to go from queries that look up many
>> thousands of lines to just a single index query.
>> change your MySQL engine to InnoDB - or
>> even better, move to postgresql instead. these
>> event happen when a table gets eventually too
>> large for the basic MySQL settings to cope. think
>> about deleting old records etc.  i
>>
>> alan
>> -
>> List info/subscribe/unsubscribe? See 
>> http://www.freeradius.org/list/users.html
>>
>>
>>   
>
> -
> List info/subscribe/unsubscribe? See 
> http://www.freeradius.org/list/users.html
>