Re: freeradius 2.0.5 problem

[Egi <ekonomi@albaniaonline.net>]

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