Hi...
i'm getting some many errors like this...
Mon Aug 20 11:27:26 2012 : Error: [sql] Couldn't update SQL accounting STOP
record - Lock wait timeout exceeded; try restarting transaction
Mon Aug 20 11:27:26 2012 : Error: rlm_sql_mysql: Cannot store result
Mon Aug 20 11:27:26 2012 : Error:
Hi,
i'm getting some many errors like this...
Mon Aug 20 11:27:26 2012 : Error: [sql] Couldn't update SQL accounting
STOP record - Lock wait timeout exceeded; try restarting transaction
Mon Aug 20 11:27:26 2012 : Error: rlm_sql_mysql: Cannot store result
Mon Aug 20 11:27:26
On 20 Aug 2012, at 16:33, Tony Peña emperor...@gmail.com wrote:
Hi...
i'm getting some many errors like this...
Mon Aug 20 11:27:26 2012 : Error: [sql] Couldn't update SQL accounting STOP
record - Lock wait timeout exceeded; try restarting transaction
Mon Aug 20 11:27:26 2012 :
On 20 Aug 2012, at 16:40, alan buxey a.l.m.bu...@lboro.ac.uk wrote:
Hi,
i'm getting some many errors like this...
Mon Aug 20 11:27:26 2012 : Error: [sql] Couldn't update SQL accounting
STOP record - Lock wait timeout exceeded; try restarting transaction
Mon Aug 20 11:27:26 2012 :
Hi,
It's NDB (he's running cluster).
ah yes. i skimmed over that bit - its obvious then. move to postgresSQL ;-)
alan
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
On 20 Aug 2012, at 16:59, alan buxey a.l.m.bu...@lboro.ac.uk wrote:
Hi,
It's NDB (he's running cluster).
ah yes. i skimmed over that bit - its obvious then. move to postgresSQL ;-)
and hack in his own fully redundant clustering system? ;)
-Arran
-
List info/subscribe/unsubscribe? See
hi
yes I have 64 to start initial each radius-server and
yes have NDB engine into cluster.. .just missing the use for buffered_sql
for live session.. that i have to read to implement,
for example now.. not happening.. just when occurs start to doing that
issues..
thanxs for the tips
2012/8/20
Hi,
and hack in his own fully redundant clustering system? ;)
its postgresql - unlike MySQL it doesnt NEED replication or clustering mess ;-)
alan
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Stefan A. wrote:
is there an option to turn just SQL Errors and warnings on, to be written to
disk?
They should be logged by default.
My opinion is, that not FR is ignoring attributes, but SQL is simply not
delivering them ... from time to time, possibly by timeouts
I assume, that FR
Hi,
is there an option to turn just SQL Errors and warnings on, to be written to
disk?
We are running 300 to 1000 Auth Requests per second (plus about 2-3000 Acct)
In some rare cases, FR seems to ignore the reply attributes, which are
comming from the DB. In that cases, we give the user a clean
am a new user to linux.
I will try leaving the nas table empty. Thanks
--
View this message in context:
http://www.nabble.com/mysql-errors-when-running-freeradius-tp23977490p24095318.html
Sent from the FreeRadius - User mailing list archive at Nabble.com.
-
List info/subscribe/unsubscribe? See
JamesWhetherly wrote:
Please note i am not wasting time as suggested or doing it just for *fun*.
I understand.
I haven't deleted any thing from the sql.conf file, all i deleted was the
nas database like i said from mysql! The part about the nas table is still
there uncommented! I have only
Ok i have done what you guys have said, which is to not use sql for nas's.
I
deleted the table and changed the readclient line in sql.conf to 'no'. I
have checked radiusd.conf and it has the line $INCLUDE sites-enabled at
the
end of the file. I have also checked in sites-enabled in the
Hi,
have checked radiusd.conf and it has the line $INCLUDE sites-enabled at the
wrong.
$INCLUDE ${confdir}/sites-enabled/
and then make sure you have some files in there (usually
symlinks to the files in sites-available directory)
alan
-
List info/subscribe/unsubscribe? See
this message in context:
http://www.nabble.com/mysql-errors-when-running-freeradius-tp23977490p24071260.html
Sent from the FreeRadius - User mailing list archive at Nabble.com.
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
ok added that new line to radiusd.conf, seems to go through the first
stages
of the authorize section, when it comes to the sql part it errors again.
Post the debug of the server startup as well.
Radiusd -X Debug:
Listening on authentication address * port 1812
Listening on accounting
= *
port = 0
}
Listening on authentication address * port 1812
Listening on accounting address * port 1813
Listening on proxy address * port 1814
Ready to process requests.
--
View this message in context:
http://www.nabble.com/mysql-errors-when-running-freeradius-tp23977490p24071452.html
Sent
JamesWhetherly wrote:
linux-6pfg:/home/james # radiusd -X
...
Module: Linked to module rlm_sql
Module: Instantiating sql
Ok, it's there...
sql {
...
authorize_check_query =
authorize_group_check_query =
authorize_group_reply_query =
accounting_onoff_query
...
including configuration file /etc/raddb/sql.conf
including configuration file /etc/raddb/sql/mysql/counter.conf
...
You have done something to sql.conf. It didn't include dialup.conf.
Ivan Kalik
Kalik Informatika ISP
-
List info/subscribe/unsubscribe? See
${nas_table} not found
Errors reading /etc/raddb/radiusd.conf
--
View this message in context:
http://www.nabble.com/mysql-errors-when-running-freeradius-tp23977490p24073492.html
Sent from the FreeRadius - User mailing list archive at Nabble.com.
-
List info/subscribe/unsubscribe? See http
JamesWhetherly wrote:
I thought that the dialup.conf was linked to the 'nas' table . . . .
No.
I've re-added it and it just brings up errors to do with the nas table
again, which i deleted and told not to look at with readclients.
Could you *please* stop breaking the configuration?
, type, secret FROM ${nas_table} not found
Errors reading /etc/raddb/radiusd.conf
--
View this message in context:
http://www.nabble.com/mysql-errors-when-running-freeradius-tp23977490p24073492.html
Sent from the FreeRadius - User mailing list archive at Nabble.com.
-
List info/subscribe
I thought that the dialup.conf was linked to the 'nas' table . . . .
I've re-added it and it just brings up errors to do with the nas table
again, which i deleted and told not to look at with readclients.
Don't delete things from sql.conf. Put back:
# Table to keep radius client info
-Requests from the NAS, but only writes
# accounting packets to disk if the home server is down.
#
# Post-Proxy-Type Fail {
# detail
# }
}
Thank you.
--
View this message in context:
http://www.nabble.com/mysql-errors-when-running-freeradius
I created a table using the schema called nas.sql, and populated it with
local host. When i then run radius (please note that i am in fact running
it: radiusd -X) i can't get it to authenticate.
So, post the debug.
I had a look to see if sql was in the authenticate section of the virtual
JamesWhetherly wrote:
I created a table using the schema called nas.sql, and populated it with
local host. When i then run radius (please note that i am in fact running
it: radiusd -X) i can't get it to authenticate.
For us to be able to help you, you *must* post the output of radiusd
-X
seconds.
Cleaning up request 1 ID 114 with timestamp +7469
Ready to process requests.
--
View this message in context:
http://www.nabble.com/mysql-errors-when-running-freeradius-tp23977490p24057283.html
Sent from the FreeRadius - User mailing list archive at Nabble.com.
-
List info/subscribe
Ready to process requests.
rad_recv: Access-Request packet from host 127.0.0.1 port 46876, id=114,
length=59
User-Name = sqltest
User-Password = testpwd
NAS-IP-Address = 127.0.0.2
NAS-Port = 1812
No authenticate method (Auth-Type) configuration found for the
I have been following the mysql guide on the freeradius wiki for handling of
users. I've had a few problems along the way and i can get radius accepting
test packs not using mysql. I am using openSUSE 11.1.
When i now try to launch radius it is coming up with mysql errors, and i
can't figure
Hi,
The debug code can be found below.
FreeRADIUS has a very verbose (and very good imho!) debug log. it pretty
much screams out what the problem is!
rlm_sql (sql): Connected new DB handle, #4
rlm_sql (sql): Processing generate_sql_clients
rlm_sql (sql) in generate_sql_clients: query is
seconds.
Sending delayed reject for request 0
Sending Access-Reject of id 210 to 127.0.0.1 port 45849
Waking up in 4.9 seconds.
Cleaning up request 0 ID 210 with timestamp +8
Ready to process requests.
Thanks for the help!
--
View this message in context:
http://www.nabble.com/mysql-errors-when
Hi,
I have used the schema that was located in side raddb/sql/mysql/schema.sql.
So the database looks like this:
the NAS table is here
raddb/sql/mysql/nas.sql
if you load that up you'll have a lovely new table to play with.
Only one of those tables looks like it is to do with NAS's, which
look in sql/mysql/nas.sql
JamesWhetherly wrote:
Hi Alan,
Thanks for the reply. I am pretty new to unix, and started playing around
with it about 6 weeks ago!
I am trying to use radtest at the moment and haven't added any clients as i
am awaiting the arrival of my new base station. So i
JamesWhetherly wrote:
I am trying to use radtest at the moment and haven't added any clients as i
am awaiting the arrival of my new base station. So i haven't added any new
clients.
You have configured raddb/sql.conf to set readclients = yes. This
is NOT enabled in the default
We have a Cisco VOIP network and we use FreeRadius
with MySQL on Redhat to collect our RADIUS records.
For some reason we are getting these errors. Please
assist. I really appreciate everyone's input on what
is the cause of these problems.
==
Sat Sep 25 16:47:49 2004 :
35 matches
Mail list logo