segmentation fault freeradius 2.1.7 using rlm_sql

2011-07-27 Thread Amir Tal
are quite large, I didn't attach complete dump or radius -X , let me know what other info is needed. Regards, Amir Tal. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

RE: segmentation fault freeradius 2.1.7 using rlm_sql

2011-07-28 Thread Amir Tal
, 2011 4:33 PM To: FreeRadius users mailing list Subject: Re: segmentation fault freeradius 2.1.7 using rlm_sql Amir Tal wrote: For some unknown reason radiusd keeps getting segmentation faults, every few days and even after several hours of work. Upgrade. Alan DeKok. - List info/subscribe

RE: segmentation fault freeradius 2.1.7 using rlm_sql

2011-08-02 Thread Amir Tal
fault freeradius 2.1.7 using rlm_sql Amir Tal wrote: For some unknown reason radiusd keeps getting segmentation faults, every few days and even after several hours of work. Upgrade. Alan DeKok. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html - List info

RE: segmentation fault freeradius 2.1.7 using rlm_sql

2011-08-02 Thread Amir Tal
02, 2011 11:02 AM To: FreeRadius users mailing list Subject: Re: segmentation fault freeradius 2.1.7 using rlm_sql On Tue, Aug 2, 2011 at 2:27 PM, Amir Tal a...@ccc.co.il wrote: Upgraded freeradius to 2.1.11 (built from source) This time it brought the whole machine down: Notice how I DIDN'T

sql returns fail for some stop requests

2012-07-11 Thread Amir Tal
. The Cloud has no limit ! [cid:image001.jpg@01CD5F84.25487600]http://www.ccc.co.il/ Amir Tal Systems Automation Expert Cloud Services Direct: 972-(0)3-9201471 Fax: 972-(0)-3-9201442 www.ccc.co.ilhttp://www.ccc.co.il/ [cid:image002.png@01CD5F84.25487600] http://www.facebook.com/triplec.il

RE: sql returns fail for some stop requests

2012-07-15 Thread Amir Tal
raised from the default 5 to 25, this is a rare error, but it still exists, might be related. Amir. From: Amir Tal Sent: Wednesday, July 11, 2012 4:48 PM To: 'freeradius-users@lists.freeradius.org' Subject: sql returns fail for some stop requests Freeradius ver 2.1.12, configured to use ldap

RE: sql returns fail for some stop requests

2012-07-19 Thread Amir Tal
I have increased the value of MAX_QUERY_LEN in freeradius-server-2.1.12/src/modules/rlm_sql/conf.h (#define MAX_QUERY_LEN 8192) There are still duplicated connections/sessions , example sqltrace: INSERT INTO radacct (acctsessionid,acctuniqueid, username, realm,

RE: sql returns fail for some stop requests

2012-07-22 Thread Amir Tal
Adding unique key to the database results in the following being returned from rlm_sql, What happen to accounting data when a duplicate entry is encountered? In addition, currently there is no scheduled clearing of the data in radacct table, wont this increase in occurrence? -- [sql] expand:

RE: sql returns fail for some stop requests

2012-07-24 Thread Amir Tal
After additional debugging the fault seems to be with a rouge backup process running on DB host, causing it to be slow to un-responsive for 10-20 minutes. (all unclosed sessions are within this time frame) This is easy to fix, but I'm looking for a way to make a fail-safe solution. There can

Re: sql returns fail for some stop requests

2012-08-08 Thread Amir Tal
After moving MYSQL to a clustered environment, and moving all backup and not related tasks to slave hosts, It seems the issue is resolved, radius has been running for several days without any errors and/or sessions not being stopped. Thanks for all your help and suggestions, Amir. - List