freeradius 2.0.5 problem
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 client private-network port 35005 - ID: 223 due to unfinished request 5713664 Thu Jul 3 17:39:35 2008 : Error: Discarding duplicate request from client private-network port 35005 - ID: 223 due to unfinished request 5713664 Thu Jul 3 17:39:57 2008 : Error: Discarding duplicate request from client private-network port 45713 - ID: 65 due to unfinished request 5714017 Thu Jul 3 17:39:57 2008 : Error: Discarding duplicate request from client private-network port 35070 - ID: 126 due to unfinished request 5714018 Thu Jul 3 17:39:59 2008 : Error: Discarding duplicate request from client private-network port 45713 - ID: 65 due to unfinished request 5714017 Thu Jul 3 17:39:59 2008 : Error: Discarding duplicate request from client private-network port 35070 - ID: 126 due to unfinished request 5714018 also followed by some less errors like this one: Thu Jul 3 17:41:45 2008 : Error: WARNING: Unresponsive child (id 1377945920) for request 5715136, in module exec component post-auth And then many other errors like: hu Jul 3 17:43:16 2008 : Error: Received conflicting packet from client private-network port 35977 - ID: 249 due to unfinished request 5718311. Giving up on old request. Thu Jul 3 17:43:16 2008 : Error: Received conflicting packet from client private-network port 35976 - ID: 248 due to unfinished request 5718310. Giving up on old request. Thu Jul 3 17:43:16 2008 : Error: Received conflicting packet from client private-network port 35978 - ID: 250 due to unfinished request 5718312. Giving up on old request. Thu Jul 3 17:43:16 2008 : Error: Received conflicting packet from client private-network port 46742 - ID: 247 due to unfinished request 5718313. Giving up on old request. Thu Jul 3 17:43:16 2008 : Error: Received conflicting packet from client private-network port 46729 - ID: 235 due to unfinished request 5718317. Giving up on old request. also mixed with some other: Thu Jul 3 17:42:58 2008 : Error: WARNING: Unresponsive child (id 1346476352) for request 5716367, in module exec component post-auth And after that freeradius becomes unresponsive, i get "Radius timeout" on microtik and so the clients aren't authenticating. I have around 1200 clients in total, usually there are 700-800 users online. Thank You!
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
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
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@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
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:
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@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
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
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, for example? if so, DONT. it ties the thread of the FreeRADIUS server up so its cannot do other work - use the relay SQL functionality so that a 2nd listen thread does that work insteda alan
A.L.M.Buxey@lboro.ac.uk 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 - are you doing live SQL logging, for example? if so, DONT. it ties the thread of the FreeRADIUS server up so its cannot do other work - use the relay SQL functionality so that a 2nd listen thread does that work insteda
alan - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Though remember to create two instances of the SQL module so that you don't tie up all the SQL connection handles doing logging in the other virtual-server instance. -- Arran Cudbard-Bell (A.Cudbard-Bell@sussex.ac.uk), Authentication, Authorisation and Accounting Officer, Infrastructure Services (IT Services), E1-1-08, Engineering 1, University Of Sussex, Brighton, BN1 9QT DDI+FAX: +44 1273 873900 | INT: 3900
participants (4)
-
A.L.M.Buxey＠lboro.ac.uk -
Arran Cudbard-Bell -
Egi -
Marinko Tarlac