errors There are no DB handles to use and Discarding conflicting packet from client
Hi, I have a dedicated server with freeradius 2.05 i'm getting 2 errors Error: Discarding conflicting packet from client net port 25000 - ID: 100 due to recent request 7343. There are no DB handles to use! skipped 0, tried to connect 0 I'm searching on the forums and a lot of people has this problem.. I change sql_num_socks = 30 I increase the max_connections=5000000 I increase everything that what was possible but the problem still happens I see on the forums in alot of web sites and nobody has the solution somebody can help? -- View this message in context: http://www.nabble.com/errors-There-are-no-DB-handles-to-use-and-Discarding-c... Sent from the FreeRadius - User mailing list archive at Nabble.com.
Alisson wrote:
Hi, I have a dedicated server with freeradius 2.05
i'm getting 2 errors
Error: Discarding conflicting packet from client net port 25000 - ID: 100 due to recent request 7343.
There are no DB handles to use! skipped 0, tried to connect 0
Your database is broken. Fix it.
I'm searching on the forums and a lot of people has this problem..
They all have broken databases.
I change sql_num_socks = 30 I increase the max_connections=5000000 I increase everything that what was possible
but the problem still happens
I see on the forums in alot of web sites and nobody has the solution
Really? This question has been asked and answered probably hundreds of times on this list. The answer is always the same: Fix the database. The database is either down, or it is not responding to queries. No amount of forum-shopping or poking at FreeRADIUS will fix the DB. Alan DeKok.
ok.. but what I need to do on my DB? Repair? Create another DB? alter some variable? 2009/10/9 Alan DeKok <aland@deployingradius.com>
Alisson wrote:
Hi, I have a dedicated server with freeradius 2.05
i'm getting 2 errors
Error: Discarding conflicting packet from client net port 25000 - ID: 100 due to recent request 7343.
There are no DB handles to use! skipped 0, tried to connect 0
Your database is broken. Fix it.
I'm searching on the forums and a lot of people has this problem..
They all have broken databases.
I change sql_num_socks = 30 I increase the max_connections=5000000 I increase everything that what was possible
but the problem still happens
I see on the forums in alot of web sites and nobody has the solution
Really? This question has been asked and answered probably hundreds of times on this list. The answer is always the same:
Fix the database.
The database is either down, or it is not responding to queries. No amount of forum-shopping or poking at FreeRADIUS will fix the DB.
Alan DeKok. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
-- Att. Alisson F. Gonçalves Sistemas de Informação - UFGD
http://forums.mysql.com/ Alisson wrote:
ok.. but what I need to do on my DB?
Repair? Create another DB? alter some variable?
2009/10/9 Alan DeKok <aland@deployingradius.com <mailto:aland@deployingradius.com>>
Alisson wrote: > Hi, I have a dedicated server with freeradius 2.05 > > i'm getting 2 errors > > Error: Discarding conflicting packet from client net port 25000 - ID: 100 > due to recent request 7343. > > There are no DB handles to use! skipped 0, tried to connect 0
Your database is broken. Fix it.
> I'm searching on the forums and a lot of people has this problem..
They all have broken databases.
> I change sql_num_socks = 30 > I increase the max_connections=5000000 > I increase everything that what was possible > > but the problem still happens > > I see on the forums in alot of web sites and nobody has the solution
Really? This question has been asked and answered probably hundreds of times on this list. The answer is always the same:
Fix the database.
The database is either down, or it is not responding to queries. No amount of forum-shopping or poking at FreeRADIUS will fix the DB.
Alan DeKok. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
-- Att. Alisson F. Gonçalves Sistemas de Informação - UFGD ------------------------------------------------------------------------
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
-- ----------------------------------------------------- Marcos Roberto Greiner Os otimistas acham que estamos no melhor dos mundos Os pessimistas tem medo de que isto seja verdade James Branch Cabell -----------------------------------------------------
somebody have this same problem? 2009/10/9 Roberto Greiner <mrgreiner@gmail.com> > http://forums.mysql.com/ > > Alisson wrote: > >> ok.. but what I need to do on my DB? >> >> Repair? Create another DB? alter some variable? >> >> 2009/10/9 Alan DeKok <aland@deployingradius.com <mailto: >> aland@deployingradius.com>> >> >> >> Alisson wrote: >> > Hi, I have a dedicated server with freeradius 2.05 >> > >> > i'm getting 2 errors >> > >> > Error: Discarding conflicting packet from client net port 25000 >> - ID: 100 >> > due to recent request 7343. >> > >> > There are no DB handles to use! skipped 0, tried to connect 0 >> >> Your database is broken. Fix it. >> >> > I'm searching on the forums and a lot of people has this problem.. >> >> They all have broken databases. >> >> > I change sql_num_socks = 30 >> > I increase the max_connections=5000000 >> > I increase everything that what was possible >> > >> > but the problem still happens >> > >> > I see on the forums in alot of web sites and nobody has the solution >> >> Really? This question has been asked and answered probably hundreds >> of times on this list. The answer is always the same: >> >> Fix the database. >> >> The database is either down, or it is not responding to queries. No >> amount of forum-shopping or poking at FreeRADIUS will fix the DB. >> >> Alan DeKok. >> - >> List info/subscribe/unsubscribe? See >> http://www.freeradius.org/list/users.html >> >> >> >> >> -- >> Att. >> Alisson F. Gonçalves >> Sistemas de Informação - UFGD >> ------------------------------------------------------------------------ >> >> - >> List info/subscribe/unsubscribe? See >> http://www.freeradius.org/list/users.html >> > > > -- > ----------------------------------------------------- > Marcos Roberto Greiner > > Os otimistas acham que estamos no melhor dos mundos > Os pessimistas tem medo de que isto seja verdade > James Branch Cabell > ----------------------------------------------------- > > > - > List info/subscribe/unsubscribe? See > http://www.freeradius.org/list/users.html > -- Att. Alisson F. Gonçalves Sistemas de Informação - UFGD
Did you set up the database? If not, check out /usr/local/etc/raddb/sql/mysql/admin.sql (assuming you are intending to use mysql.) Good luck, -craig ----- Original Message ----- From: Alisson To: FreeRadius users mailing list Sent: Friday, October 09, 2009 2:53 PM Subject: Re: errors There are no DB handles to use and Discarding conflicting packet from client somebody have this same problem? 2009/10/9 Roberto Greiner <mrgreiner@gmail.com> http://forums.mysql.com/ Alisson wrote: ok.. but what I need to do on my DB? Repair? Create another DB? alter some variable? 2009/10/9 Alan DeKok <aland@deployingradius.com <mailto:aland@deployingradius.com>> Alisson wrote: > Hi, I have a dedicated server with freeradius 2.05 > > i'm getting 2 errors > > Error: Discarding conflicting packet from client net port 25000 - ID: 100 > due to recent request 7343. > > There are no DB handles to use! skipped 0, tried to connect 0 Your database is broken. Fix it. > I'm searching on the forums and a lot of people has this problem.. They all have broken databases. > I change sql_num_socks = 30 > I increase the max_connections=5000000 > I increase everything that what was possible > > but the problem still happens > > I see on the forums in alot of web sites and nobody has the solution Really? This question has been asked and answered probably hundreds of times on this list. The answer is always the same: Fix the database. The database is either down, or it is not responding to queries. No amount of forum-shopping or poking at FreeRADIUS will fix the DB. Alan DeKok. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html -- Att. Alisson F. Gonçalves Sistemas de Informação - UFGD ------------------------------------------------------------------------ - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html -- ----------------------------------------------------- Marcos Roberto Greiner Os otimistas acham que estamos no melhor dos mundos Os pessimistas tem medo de que isto seja verdade James Branch Cabell ----------------------------------------------------- - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html -- Att. Alisson F. Gonçalves Sistemas de Informação - UFGD ------------------------------------------------------------------------------ - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html __________ Information from ESET Smart Security, version of virus signature database 4494 (20091009) __________ The message was checked by ESET Smart Security. http://www.eset.com __________ Information from ESET Smart Security, version of virus signature database 4494 (20091009) __________ The message was checked by ESET Smart Security. http://www.eset.com
Also check out http://wiki.freeradius.org/SQL_HOWTO ----- Original Message ----- From: Alisson To: FreeRadius users mailing list Sent: Friday, October 09, 2009 2:53 PM Subject: Re: errors There are no DB handles to use and Discarding conflicting packet from client somebody have this same problem? 2009/10/9 Roberto Greiner <mrgreiner@gmail.com> http://forums.mysql.com/ Alisson wrote: ok.. but what I need to do on my DB? Repair? Create another DB? alter some variable? 2009/10/9 Alan DeKok <aland@deployingradius.com <mailto:aland@deployingradius.com>> Alisson wrote: > Hi, I have a dedicated server with freeradius 2.05 > > i'm getting 2 errors > > Error: Discarding conflicting packet from client net port 25000 - ID: 100 > due to recent request 7343. > > There are no DB handles to use! skipped 0, tried to connect 0 Your database is broken. Fix it. > I'm searching on the forums and a lot of people has this problem.. They all have broken databases. > I change sql_num_socks = 30 > I increase the max_connections=5000000 > I increase everything that what was possible > > but the problem still happens > > I see on the forums in alot of web sites and nobody has the solution Really? This question has been asked and answered probably hundreds of times on this list. The answer is always the same: Fix the database. The database is either down, or it is not responding to queries. No amount of forum-shopping or poking at FreeRADIUS will fix the DB. Alan DeKok. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html -- Att. Alisson F. Gonçalves Sistemas de Informação - UFGD ------------------------------------------------------------------------ - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html -- ----------------------------------------------------- Marcos Roberto Greiner Os otimistas acham que estamos no melhor dos mundos Os pessimistas tem medo de que isto seja verdade James Branch Cabell ----------------------------------------------------- - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html -- Att. Alisson F. Gonçalves Sistemas de Informação - UFGD ------------------------------------------------------------------------------ - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html __________ Information from ESET Smart Security, version of virus signature database 4494 (20091009) __________ The message was checked by ESET Smart Security. http://www.eset.com __________ Information from ESET Smart Security, version of virus signature database 4494 (20091009) __________ The message was checked by ESET Smart Security. http://www.eset.com
the radius DB is working with user root the Users are authenticanting, and everything is working but i have this 2 errors and I tried do fix altering some variables from mysql and radius, but still appearing the message 2009/10/9 Craig Campbell <craig@ccraft.ca> > Also check out http://wiki.freeradius.org/SQL_HOWTO > > ----- Original Message ----- > *From:* Alisson <alissonfer@gmail.com> > *To:* FreeRadius users mailing list<freeradius-users@lists.freeradius.org> > *Sent:* Friday, October 09, 2009 2:53 PM > *Subject:* Re: errors There are no DB handles to use and Discarding > conflicting packet from client > > somebody have this same problem? > > 2009/10/9 Roberto Greiner <mrgreiner@gmail.com> > >> http://forums.mysql.com/ >> >> Alisson wrote: >> >>> ok.. but what I need to do on my DB? >>> >>> Repair? Create another DB? alter some variable? >>> >>> 2009/10/9 Alan DeKok <aland@deployingradius.com <mailto: >>> aland@deployingradius.com>> >>> >>> >>> Alisson wrote: >>> > Hi, I have a dedicated server with freeradius 2.05 >>> > >>> > i'm getting 2 errors >>> > >>> > Error: Discarding conflicting packet from client net port 25000 >>> - ID: 100 >>> > due to recent request 7343. >>> > >>> > There are no DB handles to use! skipped 0, tried to connect 0 >>> >>> Your database is broken. Fix it. >>> >>> > I'm searching on the forums and a lot of people has this problem.. >>> >>> They all have broken databases. >>> >>> > I change sql_num_socks = 30 >>> > I increase the max_connections=5000000 >>> > I increase everything that what was possible >>> > >>> > but the problem still happens >>> > >>> > I see on the forums in alot of web sites and nobody has the solution >>> >>> Really? This question has been asked and answered probably hundreds >>> of times on this list. The answer is always the same: >>> >>> Fix the database. >>> >>> The database is either down, or it is not responding to queries. No >>> amount of forum-shopping or poking at FreeRADIUS will fix the DB. >>> >>> Alan DeKok. >>> - >>> List info/subscribe/unsubscribe? See >>> http://www.freeradius.org/list/users.html >>> >>> >>> >>> >>> -- >>> Att. >>> Alisson F. Gonçalves >>> Sistemas de Informação - UFGD >>> ------------------------------------------------------------------------ >>> >>> - >>> List info/subscribe/unsubscribe? See >>> http://www.freeradius.org/list/users.html >>> >> >> >> -- >> ----------------------------------------------------- >> Marcos Roberto Greiner >> >> Os otimistas acham que estamos no melhor dos mundos >> Os pessimistas tem medo de que isto seja verdade >> James Branch Cabell >> ----------------------------------------------------- >> >> >> - >> List info/subscribe/unsubscribe? See >> http://www.freeradius.org/list/users.html >> > > > > -- > Att. > Alisson F. Gonçalves > Sistemas de Informação - UFGD > > ------------------------------ > > - > List info/subscribe/unsubscribe? See > http://www.freeradius.org/list/users.html > > > __________ Information from ESET Smart Security, version of virus signature > database 4494 (20091009) __________ > > The message was checked by ESET Smart Security. > > http://www.eset.com > > > > __________ Information from ESET Smart Security, version of virus signature > database 4494 (20091009) __________ > > The message was checked by ESET Smart Security. > > http://www.eset.com > > - > List info/subscribe/unsubscribe? See > http://www.freeradius.org/list/users.html > -- Att. Alisson F. Gonçalves Sistemas de Informação - UFGD
the radius DB is working with user root
the Users are authenticanting, and everything is working
but
i have this 2 errors
and I tried do fix altering some variables from mysql and radius,
but still appearing the message
Do debug (radiusd -X) and see what causes the error. Maybe some queries are failing. Ivan Kalik Kalik Informatika ISP
Hi, Answering your questions 1) Is your database server/process running? R: Yes 2) Is database IP/port/user/password correct in sql.conf? R:Yes 3) Is correct type of database selected? R:Yes Radchecks=Innodb and the another tables are MyIsam 4) Is your database configured to recieve queries from radius server (ie. not localhost) if they are not on the same machine? R: Yes, the users are authenticanting. They are on the same machine. 5)Have you created radius database? R: Yes, users are authenticant with the radius db 6) Does user configured in radius have permissions to run queries on radius database? R; yes, i'm using root 7) Is there a firewall stopping traffic? R: I dont use 8) Do you see radius handles connected to the database server when you start radius server? R: Yes, I have 10 handles thank you 2009/10/9 Ivan Kalik <tnt@kalik.net>
the radius DB is working with user root
the Users are authenticanting, and everything is working
but
i have this 2 errors
and I tried do fix altering some variables from mysql and radius,
but still appearing the message
Do debug (radiusd -X) and see what causes the error. Maybe some queries are failing.
Ivan Kalik Kalik Informatika ISP
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
-- Att. Alisson F. Gonçalves Sistemas de Informação - UFGD
but this problem is on radius or db? 2009/10/9 Alan DeKok <aland@deployingradius.com>
Alisson wrote:
ok.. but what I need to do on my DB?
Repair? Create another DB? alter some variable?
Ask the people who wrote and support the DB.
Asking DB questions on a RADIUS list isn't the best way to solve the problem.
Alan DeKok. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
-- Att. Alisson F. Gonçalves Sistemas de Informação - UFGD
but this problem is on radius or db?
2009/10/9 Alan DeKok <aland@deployingradius.com>
Alisson wrote:
ok.. but what I need to do on my DB?
Repair? Create another DB? alter some variable?
Ask the people who wrote and support the DB.
Asking DB questions on a RADIUS list isn't the best way to solve the problem.
Alan DeKok. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
-- Att. Alisson F. Gonçalves Sistemas de Informação - UFGD - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
ok.. but what I need to do on my DB?
Is your database server/process running? Is database IP/port/user/password correct in sql.conf? Is correct type of database selected? Is your database configured to recieve queries from radius server (ie. not localhost) if they are not on the same machine? Have you created radius database? Does user configured in radius have permissions to run queries on radius database? Is there a firewall stopping traffic? Do you see radius handles connected to the database server when you start radius server? Should I go on? Ivan Kalik Kalik Informatika ISP
This is not database list but here what you can do: - install sysbench and do some tests with your current settings - tunning-primer.sh (http://www.day32.com/MySQL/tuning-primer.sh), - mytop, - mysqlreport (http://hackmysql.com/mysqlreport) and - mysqltuner.pl (http://wiki.mysqltuner.com/MySQLTuner) Tools I mentioned above will help you to track down the bottleneck you have with your database. Of course, you have a task to find a problem and tell us about it :) Best regards Ivan Kalik wrote:
ok.. but what I need to do on my DB?
Is your database server/process running? Is database IP/port/user/password correct in sql.conf? Is correct type of database selected? Is your database configured to recieve queries from radius server (ie. not localhost) if they are not on the same machine? Have you created radius database? Does user configured in radius have permissions to run queries on radius database? Is there a firewall stopping traffic? Do you see radius handles connected to the database server when you start radius server?
Should I go on?
Ivan Kalik Kalik Informatika ISP
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Hi, I still have the problems, I changed some variables, but the problem continues 2009/10/9 Marinko Tarlac <mangia81@gmail.com>
This is not database list but here what you can do: - install sysbench and do some tests with your current settings - tunning-primer.sh (http://www.day32.com/MySQL/tuning-primer.sh), - mytop, - mysqlreport (http://hackmysql.com/mysqlreport) and - mysqltuner.pl (http://wiki.mysqltuner.com/MySQLTuner)
Tools I mentioned above will help you to track down the bottleneck you have with your database.
Of course, you have a task to find a problem and tell us about it :)
Best regards
Ivan Kalik wrote:
ok.. but what I need to do on my DB?
Is your database server/process running? Is database IP/port/user/password correct in sql.conf? Is correct type of database selected? Is your database configured to recieve queries from radius server (ie. not localhost) if they are not on the same machine? Have you created radius database? Does user configured in radius have permissions to run queries on radius database? Is there a firewall stopping traffic? Do you see radius handles connected to the database server when you start radius server?
Should I go on?
Ivan Kalik Kalik Informatika ISP
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
-- Att. Alisson F. Gonçalves Sistemas de Informação - UFGD
somebody fixed this problem? the message "Discarding conflicting packet from client" Alisson wrote:
Hi,
I still have the problems,
I changed some variables, but the problem continues
2009/10/9 Marinko Tarlac <mangia81@gmail.com>
This is not database list but here what you can do: - install sysbench and do some tests with your current settings - tunning-primer.sh (http://www.day32.com/MySQL/tuning-primer.sh), - mytop, - mysqlreport (http://hackmysql.com/mysqlreport) and - mysqltuner.pl (http://wiki.mysqltuner.com/MySQLTuner)
Tools I mentioned above will help you to track down the bottleneck you have with your database.
Of course, you have a task to find a problem and tell us about it :)
Best regards
Ivan Kalik wrote:
ok.. but what I need to do on my DB?
Is your database server/process running? Is database IP/port/user/password correct in sql.conf? Is correct type of database selected? Is your database configured to recieve queries from radius server (ie. not localhost) if they are not on the same machine? Have you created radius database? Does user configured in radius have permissions to run queries on radius database? Is there a firewall stopping traffic? Do you see radius handles connected to the database server when you start radius server?
Should I go on?
Ivan Kalik Kalik Informatika ISP
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
-- Att. Alisson F. Gonçalves Sistemas de Informação - UFGD
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
-- View this message in context: http://www.nabble.com/errors-There-are-no-DB-handles-to-use-and-Discarding-c... Sent from the FreeRadius - User mailing list archive at Nabble.com.
participants (6)
-
Alan DeKok -
Alisson -
Craig Campbell -
Ivan Kalik -
Marinko Tarlac -
Roberto Greiner