RE: delayed update on sql logging
-Original Message- From: freeradius-users-bounces+kamil=extendbroadband@lists.freeradius.org [mailto:freeradius-users-bounces+kamil=extendbroadband@lists.freeradius. org] On Behalf Of Ivan Kalik Sent: Wednesday, September 30, 2009 1:07 PM To: FreeRadius users mailing list Subject: Re: delayed update on sql logging I am checking simultaneous-use information, logged users etc on sql server. The problem is, if a user logges in, nearly after a minute later i can see the logged on user on mysql tables. But i can see the same user with radlast command in the same second the user logs in. So it seems like there is a delay between updating the data on sql. And with this, user can log in mutliple times with same username even i set sim-use to 1. Is there any parameter for that??? Or what else can cause that problem. Are you using buffered-sql accounting? How can we use buffered-sql accounting with 1.1.7 ? 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.115/2403 - Release Date: 09/29/09 17:56:00 - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Hi guys,
I am trying to write user disconnections or every login to the sql. Can someone help me how can I do this? Thanks, K. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
RE: Hi guys,
Yes I am getting accounting packets. -Original Message- From: freeradius-users-bounces+kamil=extendbroadband@lists.freeradius.org [mailto:freeradius-users-bounces+kamil=extendbroadband@lists.freeradius. org] On Behalf Of Ivan Kalik Sent: Monday, September 28, 2009 12:17 PM To: FreeRadius users mailing list Subject: Re: Hi guys, I am trying to write user disconnections or every login to the sql. Are you getting accounting packets from NAS? 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 - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
RE: your mail
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@lists.freeradius.org [mailto:freeradius-users-bounces+kamil=extendbroadband@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 - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
RE: your mail
Yes at startup all connections accepts and connects. My radius is working .users can authenticate. -Original Message- From: freeradius-users-bounces+kamil=extendbroadband@lists.freeradius.org [mailto:freeradius-users-bounces+kamil=extendbroadband@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 - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
RE: your mail
I tried 10 sql socks... ill let you know results -Original Message- From: freeradius-users-bounces+kamil=extendbroadband@lists.freeradius.org [mailto:freeradius-users-bounces+kamil=extendbroadband@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 - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
