It looks like everything is ok there: [root@radsql ~]# mysqlcheck -u root -p radius --auto-repair Enter password: radius.nas OK radius.radacct OK radius.radcheck OK radius.radgroupcheck OK radius.radgroupreply OK radius.radippool OK radius.radpostauth OK radius.radreply OK radius.radusergroup OK But i still get the error... Thank you! Marinko Tarlac wrote:
HiDid 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 22681Thank You! A.L.M.Buxey@lboro.ac.uk wrote:Hi,Mikrotik Router > freeradius server > Mysql ServerFrom 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-List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html