You very helpfully deleted all the interesting information from the
debug log (please always post the full log). But you can do this
yourself. Take a look at sql initialization section and see what it's
saying about initializing the sql driver, in this case it should be
rlm_sql_mysql, that shou
): Ignoring unconnected handle 1..
rlm_sql (sql): Ignoring unconnected handle 0..
rlm_sql (sql): There are no DB handles to use! skipped 5, tried to connect 0
++[sql] returns fail
Using Post-Auth-Type Reject
+- entering group REJECT {...}
[attr_filter.access_reject] expand: %{User-Name} -> us
Alisson wrote:
> somebody fixed this problem?
>
> the message "Discarding conflicting packet from client"
Fix your database so that it isn't too slow.
Alan DeKok.
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
t;>> -
>>> 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,
I still have the problems,
I changed some variables, but the problem continues
2009/10/9 Marinko Tarlac
> 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.
> accounting {
>if (Acct-Status-Type == Start) {
>update reply {
> Tmp-String-0 =
> "%{exec:/etc/freeradius/SCRIPT/userlogin.py %{User-Name}}"
> }
> }
> if (Acct-Status-Type
009 : Info: rlm_sql (sql): There are no DB handles
to use! skipped 0, tried to connect 0
The only modification that I have made to conf is:
with Freeradius 1.7
radius:/etc/freeradius# cat ../freeradius.orig/acct_users
DEFAULT Acct-Status-Type == "Start"
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/MySQLTune
Alisson wrote:
> but this problem is on radius or db?
What part of "fix your database" is hard to understand?
Alan DeKok.
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
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
> 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. May
> but this problem is on radius or db?
Database, network between radius and sql or incorrect data in sql.conf.
Ivan Kalik
Kalik Informatika ISP
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
> but this problem is on radius or db?
>
> 2009/10/9 Alan DeKok
>
>> 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 wa
> 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? Ha
ttp://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 th
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
but this problem is on radius or db?
2009/10/9 Alan DeKok
> 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
: errors There are no DB handles to use and Discarding conflicting
packet from client
somebody have this same problem?
2009/10/9 Roberto Greiner
http://forums.mysql.com/
Alisson wrote:
ok.. but what I need to do on my DB?
Repair? Create another DB? alter some variable
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://ww
s.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
>>
#x27;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 s
t 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..
>
> Th
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
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 peopl
Dear Alan,
I want to check some thing.
When i got the error ( There are no DB handles to use ) in my log file,
will the request be discarded and the router must resend it again or the
RADIUS will buffer the request and wait till a DB
connection is free to use and then process the
Hi Folks, I have freebsd 4.10-RELEASE
with mysql 4.1.1-alpha and freeradius 1.1.0
Radius give me this error:
There are no DB handles to use!
what this error means ?
radiusd -X
ql: group_membership_query = "SELECT GroupName FROM
usergroup WHERE UserName='%{SQL-User-N
Hi Folks, I have freebsd 4.10-RELEASE
with mysql 4.1.1-alpha and freeradius 1.1.0
Radius give me this error:
There are no DB handles to use!
what this error means ?
radiusd -X
ql: group_membership_query = "SELECT GroupName FROM
usergroup WHERE UserName='%{SQL-User-N
Hello,
Got the frequent message in radius.log:
Thu Oct 7 18:19:09 2004 : Info: rlm_sql (sql): There are no DB handles to use!
skipped 0, tried to connect 0
Does it mean that there are not enough connections permitted to the database?
Has the parameter num_sql_socks anything to do with that?
It
DB handle, #3
rlm_sql (sql): starting 4
rlm_sql (sql): Attempting to connect rlm_sql_mysql #4
rlm_sql: Starting connect to MySQL server for #4
rlm_sql (sql): Connected new DB handle, #4
when receiv the the auther
rlm_sql (sql): There are no DB handles to use! skipped 0, tried to connect 0
29 matches
Mail list logo