Re: freeradius 2.0.5 problem

2008-07-07 Thread Arran Cudbard-Bell
[EMAIL PROTECTED] wrote: Hi, 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: DB still too slow - what and how did you attempt to optimise the DB? what queries are you doing on a live DB -

Re: freeradius 2.0.5 problem

2008-07-06 Thread Egi
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

Re: freeradius 2.0.5 problem

2008-07-06 Thread 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

Re: freeradius 2.0.5 problem

2008-07-06 Thread Egi
It looks like everything is ok there: [EMAIL PROTECTED] ~]# mysqlcheck -u root -p radius --auto-repair Enter password: radius.nas OK radius.radacct OK radius.radcheckOK

Re: freeradius 2.0.5 problem

2008-07-06 Thread A . L . M . Buxey
Hi, 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: DB still too slow - what and how did you attempt to optimise the DB? what queries are you doing on a live DB - are you doing live SQL logging,

freeradius 2.0.5 problem

2008-07-03 Thread Egi
Hello! I have a problem with my freeradius server. The schema is the following... 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: Thu Jul 3 17:39:33 2008 : Error: Discarding duplicate request from

Re: freeradius 2.0.5 problem

2008-07-03 Thread A . L . M . Buxey
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