n Sep 28 05:01:23 2009 : Error: Dropping conflicting packet from client private-network-2:45456 - ID: 102 due to unfinished request 73062 Mon Sep 28 05:01:24 2009 : Error: Dropping conflicting packet from client private-network-2:46646 - ID: 6 due to unfinished request 73055 Mon Sep 28 05:01:24 2009 : Error: WARNING: Unresponsive child (id 2811198352) for request 73046 (in component accounting module rlm_sql) Mon Sep 28 05:01:24 2009 : Error: Dropping conflicting packet from client private-network-2:58451 - ID: 70 due to unfinished request 73070 Mon Sep 28 05:01:25 2009 : Info: rlm_sql (sql): There are no DB handles to use! skipped 0, tried to connect 0 Mon Sep 28 05:01:25 2009 : Info: rlm_sql (sql): There are no DB handles to use! skipped 0, tried to connect 0 Mon Sep 28 05:01:25 2009 : Error: Dropping conflicting packet from client private-network-2:57058 - ID: 8 due to unfinished request 73066 Mon Sep 28 05:01:26 2009 : Error: Dropping conflicting packet from client private-network-2:2059 - ID: 39 due to unfinished request 73067 Mon Sep 28 05:01:26 2009 : Error: WARNING: Unresponsive child (id 2863647632) for request 73047 (in component accounting module rlm_sql) Mon Sep 28 05:01:26 2009 : Error: Dropping conflicting packet from client private-network-2:58451 - ID: 70 due to unfinished request 73070 Mon Sep 28 05:01:27 2009 : Error: WARNING: Unresponsive child (id 2779728784) for request 73048 (in component accounting module rlm_sql) Mon Sep 28 05:01:27 2009 : Info: rlm_sql (sql): There are no DB handles to use! skipped 0, tried to connect 0 Mon Sep 28 05:01:27 2009 : Error: Dropping conflicting packet from client private-network-2:1667 - ID: 193 due to unfinished request 73072 Mon Sep 28 05:01:28 2009 : Info: rlm_sql (sql): There are no DB handles to use! skipped 0, tried to connect 0 Mon Sep 28 05:01:28 2009 : Info: rlm_sql (sql): There are no DB handles to use! skipped 0, tried to connect 0 Mon Sep 28 05:01:28 2009 : Error: Discarding duplicate request from client private-network-2:34244 - ID: 112 due to unfinished request 73074 Mon Sep 28 05:01:28 2009 : Error: Dropping conflicting packet from client private-network-2:34244 - ID: 112 due to unfinished request 73074 Mon Sep 28 05:01:29 2009 : Error: Dropping conflicting packet from client private-network-2:1667 - ID: 193 due to unfinished request 73072 Mon Sep 28 05:01:29 2009 : Info: rlm_sql (sql): There are no DB handles to use! skipped 0, tried to connect 0 Mon Sep 28 05:01:30 2009 : Error: Dropping conflicting packet from client private-network-2:60655 - ID: 71 due to unfinished request 73075 Mon Sep 28 05:01:31 2009 : Error: Dropping conflicting packet from client private-network-2:33747 - ID: 7 due to unfinished request 73058 Mon Sep 28 05:01:31 2009 : Info: rlm_sql (sql): There are no DB handles to use! skipped 0, tried to connect 0 Mon Sep 28 05:01:32 2009 : Error: Dropping conflicting packet from client private-network-2:60655 - ID: 71 due to unfinished request 73075 Mon Sep 28 05:01:33 2009 : Info: rlm_sql (sql): There are no DB handles to use! skipped 0, tried to connect 0 Mon Sep 28 05:01:33 2009 : Error: Dropping conflicting packet from client private-network-2:45456 - ID: 102 due to unfinished request 73062 Mon Sep 28 05:01:35 2009 : Error: Dropping conflicting packet from client private-network-2:3494 - ID: 92 due to unfinished request 73071 Mon Sep 28 05:01:35 2009 : Error: WARNING: Unresponsive child (id 3084983184) for request 73055 (in component accounting module rlm_sql) Mon Sep 28 05:01:35 2009 : Error: WARNING: Unresponsive child (id 2979036048) for request 73054 (in component accounting module rlm_sql) Mon Sep 28 05:01:35 2009 : Error: WARNING: Unresponsive child (id 2832178064) for request 73053 (in component accounting module rlm_sql) Mon Sep 28 05:01:35 2009 : Info: rlm_sql (sql): There are no DB handles to use! skipped 0, tried to connect 0 Mon Sep 28 05:01:35 2009 : Error: Dropping conflicting packet from client private-network-2:57058 - ID: 8 due to unfinished request 73066 Mon Sep 28 05:01:36 2009 : Error: Dropping conflicting packet from client private-network-2:2059 - ID: 39 due to unfinished request 73067 Mon Sep 28 05:01:37 2009 : Error: Dropping conflicting packet from client private-network-2:36362 - ID: 9 due to unfinished request 73073 Mon Sep 28 05:01:37 2009 : Error: WARNING: Unresponsive child (id 2790218640) for request 73056 (in component accounting module rlm_sql) Mon Sep 28 05:01:37 2009 : Info: rlm_sql (sql): There are no DB handles to use! skipped 0, tried to connect 0 Mon Sep 28 05:01:39 2009 : Info: rlm_sql (sql): There are no DB handles to use! skipped 0, tried to connect 0 Mon Sep 28 05:01:39 2009 : Error: Dropping conflicting packet from client private-network-2:32873 - ID: 159 due to unfinished request 73080 Mon Sep 28 05:01:40 2009 : Error: Dropping conflicting packet from client private-network-2:56532 - ID: 120 due to unfinished request 73076 Mon Sep 28 05:01:41 2009 : Info: rlm_sql (sql): There are no DB handles to use! skipped 0, tried to connect 0 Mon Sep 28 05:01:41 2009 : Error: WARNING: Unresponsive child (id 3062954896) for request 73058 (in component accounting module rlm_sql) Mon Sep 28 05:01:41 2009 : Info: rlm_sql (sql): There are no DB handles to use! skipped 0, tried to connect 0 Mon Sep 28 05:01:41 2009 : Error: Dropping conflicting packet from client private-network-2:3211 - ID: 75 due to unfinished request 73081 Mon Sep 28 05:01:41 2009 : Error: Dropping conflicting packet from client private-network-2:32873 - ID: 159 due to unfinished request 73080 Mon Sep 28 05:01:42 2009 : Info: rlm_sql (sql): There are no DB handles to use! skipped 0, tried to connect 0 Mon Sep 28 05:01:43 2009 : Error: Dropping conflicting packet from client private-network-2:3211 - ID: 75 due to unfinished request 73081 Mon Sep 28 05:01:43 2009 : Error: WARNING: Unresponsive child (id 3052465040) for request 73059 (in component accounting module rlm_sql) Mon Sep 28 05:01:43 2009 : Info: rlm_sql (sql): There are no DB handles to use! skipped 0, tried to connect 0 Why I am having this error messages? Here is my radiusd.conf Thanks. Kamil
Hi, as your free support channel I would suggest that you read the errors that you are having
n Sep 28 05:01:23 2009 : Error: Dropping conflicting packet from client private-network-2:45456 - ID: 102 due to unfinished request 73062 ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
a new packet repeating what a current packet is already asking/setting has been received. the current packet is still being dealt with
Mon Sep 28 05:01:24 2009 : Error: WARNING: Unresponsive child (id 2811198352) for request 73046 (in component accounting module rlm_sql)
rlm_sql taking ages to reply/sort things out
Mon Sep 28 05:01:25 2009 : Info: rlm_sql (sql): There are no DB handles to use! skipped 0, tried to connect 0
ta da. thats why SQL is having issues - either the DB is dead or the settings are wrong...or there are no free handles! how many handles have you set the MySQL to have? what are you using the MySQL for and what is the query time or insert time for the entries you are having problems with?
Why I am having this error messages? Here is my radiusd.conf
busy RADIUS daemon. slow or useless database backend infrastructure/configuration. FreeRADIUS can handle several hundred AAA per second without issues..but you put something in its way that is slow - LDAP lookup, DB query or insert then it doesnt have the resources to handle incoming AAA requests and you see this error message alan
09/28/2009 03:09 PM, Alan Buxey:
FreeRADIUS can handle several hundred AAA per second without issues..but you put something in its way that is slow - LDAP lookup,
<kidding troll> LDAP lookup is always fast ;-) Slowness is only for relational stuff </> -- Architecte Informatique chez Blueline/Gulfsat: Administration Systeme, Recherche & Developpement +261 34 29 155 34
Hello At my sql.conf : # number of sql connections to make to server num_sql_socks = 20 my db is windows based, queries are pretty fast. Is there specific configuration that I can check? Thanks -----Original Message----- From: freeradius-users-bounces+kamil=extendbroadband.com@lists.freeradius.org [mailto:freeradius-users-bounces+kamil=extendbroadband.com@lists.freeradius. org] On Behalf Of Alan Buxey Sent: Monday, September 28, 2009 3:10 PM To: FreeRadius users mailing list Subject: Re: your mail Hi, as your free support channel I would suggest that you read the errors that you are having
n Sep 28 05:01:23 2009 : Error: Dropping conflicting packet from client private-network-2:45456 - ID: 102 due to unfinished request 73062 ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
a new packet repeating what a current packet is already asking/setting has been received. the current packet is still being dealt with
Mon Sep 28 05:01:24 2009 : Error: WARNING: Unresponsive child (id 2811198352) for request 73046 (in component accounting module rlm_sql)
rlm_sql taking ages to reply/sort things out
Mon Sep 28 05:01:25 2009 : Info: rlm_sql (sql): There are no DB handles to use! skipped 0, tried to connect 0
ta da. thats why SQL is having issues - either the DB is dead or the settings are wrong...or there are no free handles! how many handles have you set the MySQL to have? what are you using the MySQL for and what is the query time or insert time for the entries you are having problems with?
Why I am having this error messages? Here is my radiusd.conf
busy RADIUS daemon. slow or useless database backend infrastructure/configuration. FreeRADIUS can handle several hundred AAA per second without issues..but you put something in its way that is slow - LDAP lookup, DB query or insert then it doesnt have the resources to handle incoming AAA requests and you see this error message alan - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html No virus found in this incoming message. Checked by AVG - www.avg.com Version: 8.5.409 / Virus Database: 270.13.113/2399 - Release Date: 09/27/09 17:52:00
Hi,
Hello At my sql.conf : # number of sql connections to make to server num_sql_socks = 20
my db is windows based, queries are pretty fast.
Is there specific configuration that I can check?
I recall a long time back having a problem when mysql was given that many sockets from FreeRADIUS - set that value to something lower eg 10 you can use several SQL tools to check what the concurrent socket count usage etc is - but i would suggest this action alan
At my sql.conf : # number of sql connections to make to server num_sql_socks = 20
my db is windows based, queries are pretty fast.
Is there specific configuration that I can check?
Do a debug of server startup. Can you connect to the database at all? If not, check connection settings in sql.conf. If they are OK: - have you built MySQL so it can accept queries from non-local source (Windows default is only accept localhost queries)? - is there a firewall blocking packets? Ivan Kalik Kalik Informatika ISP
Yes at startup all connections accepts and connects. My radius is working .users can authenticate. -----Original Message----- From: freeradius-users-bounces+kamil=extendbroadband.com@lists.freeradius.org [mailto:freeradius-users-bounces+kamil=extendbroadband.com@lists.freeradius. org] On Behalf Of Ivan Kalik Sent: Monday, September 28, 2009 3:44 PM To: FreeRadius users mailing list Subject: RE: your mail
At my sql.conf : # number of sql connections to make to server num_sql_socks = 20
my db is windows based, queries are pretty fast.
Is there specific configuration that I can check?
Do a debug of server startup. Can you connect to the database at all? If not, check connection settings in sql.conf. If they are OK: - have you built MySQL so it can accept queries from non-local source (Windows default is only accept localhost queries)? - is there a firewall blocking packets? Ivan Kalik Kalik Informatika ISP - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html No virus found in this incoming message. Checked by AVG - www.avg.com Version: 8.5.409 / Virus Database: 270.13.113/2399 - Release Date: 09/27/09 17:52:00
I tried 10 sql socks... ill let you know results -----Original Message----- From: freeradius-users-bounces+kamil=extendbroadband.com@lists.freeradius.org [mailto:freeradius-users-bounces+kamil=extendbroadband.com@lists.freeradius. org] On Behalf Of Ivan Kalik Sent: Monday, September 28, 2009 3:44 PM To: FreeRadius users mailing list Subject: RE: your mail
At my sql.conf : # number of sql connections to make to server num_sql_socks = 20
my db is windows based, queries are pretty fast.
Is there specific configuration that I can check?
Do a debug of server startup. Can you connect to the database at all? If not, check connection settings in sql.conf. If they are OK: - have you built MySQL so it can accept queries from non-local source (Windows default is only accept localhost queries)? - is there a firewall blocking packets? Ivan Kalik Kalik Informatika ISP - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html No virus found in this incoming message. Checked by AVG - www.avg.com Version: 8.5.409 / Virus Database: 270.13.113/2399 - Release Date: 09/27/09 17:52:00
participants (4)
-
Alan Buxey -
Ivan Kalik -
Kamil Semavi -
Rakotomandimby Mihamina