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 info/s
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 alwa
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: %
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,
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 us
an \m
rpm -qa | grep radius :
freeradius2-python-2.1.12-7
freeradius2-ldap-2.1.12-7
freeradius2-2.1.12-7
freeradius2-krb5-2.1.12-7
freeradius2-mysql-2.1.12-7
freeradius2-utils-2.1.12-7
freeradius2-postgresql-2.1.12-7
freeradius2-perl-2.1.12-7
freeradius2-unixODBC-2.1.12-7
additional logs and/
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 wrote:
> Upgraded freeradius to 2.1.11 (built from source)
>
> This time it brought the whole machine down:
Notice how I DIDN&
-bounces+amir=ccc.co...@lists.freeradius.org] On Behalf
Of Alan DeKok
Sent: Wednesday, July 27, 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, ev
, 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/sub
/var/log/radius/sqltrace.sql -> /var/log/radius/sqltrace.sql
rlm_sql (sql): Trying to (re)connect unconnected handle 12..
rlm_sql (sql): Attempting to connect rlm_sql_mysql #12
since configuration files 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
10 matches
Mail list logo
