Hi everyone, I have set up a FreeRadius2 v2.1.8 installation a while back and configured it according to our needs. It is running smoothly, currently doing Auth and Acc on one box with a MySQL database and a detail file being used. We now want to set up a second box which basically shall do the exact same thing as the first does as a failover and also give us two identical accounting tables in the databases. Can you guys point me in the right direction for this - google just doesn't seem to like me on this one. Thanks so much Marius
Marius Pesé wrote:
Hi everyone,
I have set up a FreeRadius2 v2.1.8 installation a while back and configured it according to our needs. It is running smoothly, currently doing Auth and Acc on one box with a MySQL database and a detail file being used. We now want to set up a second box which basically shall do the exact same thing as the first does as a failover and also give us two identical accounting tables in the databases.
You're trying to configure: = RADIUS + MySQL NAS -> / \ = RADIUS + MySQL Don't. Instead, configure = RADIUS = = MySQL NAS -> / \ - / \ = RADIUS =/ \= MySQL i.e. Configure MySQL failover for the two RADIUS servers. This turns the problem into a MySQL problem, rather than a RADIUS one. It also gives you two points of failover, rather than one. Alan DeKok.
-----Original Message----- From: freeradius-users-bounces+marius=mindspring.co.za@lists.freeradius.org [mailto:freeradius-users-bounces+marius=mindspring.co.za@lists.freeradius.org] On Behalf Of Alan DeKok Sent: Tuesday, June 22, 2010 10:19 AM To: FreeRadius users mailing list Subject: Re: Redundant Accounting Marius Pesé wrote:
Hi everyone,
I have set up a FreeRadius2 v2.1.8 installation a while back and configured it according to our needs. It is running smoothly, currently doing Auth and Acc on one box with a MySQL database and a detail file being used. We now want to set up a second box which basically shall do the exact same thing as the first does as a failover and also give us two identical accounting tables in the databases.
You're trying to configure: = RADIUS + MySQL NAS -> / \ = RADIUS + MySQL Don't. Instead, configure = RADIUS = = MySQL NAS -> / \ - / \ = RADIUS =/ \= MySQL i.e. Configure MySQL failover for the two RADIUS servers. This turns the problem into a MySQL problem, rather than a RADIUS one. It also gives you two points of failover, rather than one. Alan DeKok. Hi Alan, Thanks for your reply. You are right about the scenario I am trying to achieve: RADIUS1 + MySQL NAS --< | RADIUS2 + MySQL (Trying to point out the synchronized databases on both servers) I read the MySQL white paper on the solution you are proposing, but since we are a fairly small company we are actually hoping to find a solution using only two servers as in the first scenario you depictured. Do you think there is another reason besides scalability not to run mySQL and Radius on the same box? Is mySQL clustering the way to get redundant accounting either way or is there something in FreeRadius one can use for our smaller setup? Thanks again Marius - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Marius Pesé wrote:
Thanks for your reply. You are right about the scenario I am trying to achieve:
RADIUS1 + MySQL NAS --< | RADIUS2 + MySQL
(Trying to point out the synchronized databases on both servers)
That's a database replication issue.
I read the MySQL white paper on the solution you are proposing, but since we are a fairly small company we are actually hoping to find a solution using only two servers as in the first scenario you depictured. Do you think there is another reason besides scalability not to run mySQL and Radius on the same box?
Look at MySQL master-master replication.
Is mySQL clustering the way to get redundant accounting either way or is there something in FreeRadius one can use for our smaller setup?
You can use MySQL clustering. The code is GPL, so there's no cost other than time. Alan DeKok.
-----Original Message----- From: freeradius-users-bounces+marius=mindspring.co.za@lists.freeradius.org [mailto:freeradius-users-bounces+marius=mindspring.co.za@lists.freeradius.org] On Behalf Of Alan DeKok Sent: Tuesday, June 22, 2010 11:22 AM To: FreeRadius users mailing list Subject: Re: Redundant Accounting Marius Pesé wrote:
Thanks for your reply. You are right about the scenario I am trying to achieve:
RADIUS1 + MySQL NAS --< | RADIUS2 + MySQL
(Trying to point out the synchronized databases on both servers)
That's a database replication issue.
I read the MySQL white paper on the solution you are proposing, but since we are a fairly small company we are actually hoping to find a solution using only two servers as in the first scenario you depictured. Do you think there is another reason besides scalability not to run mySQL and Radius on the same box?
Look at MySQL master-master replication.
Is mySQL clustering the way to get redundant accounting either way or is there something in FreeRadius one can use for our smaller setup?
You can use MySQL clustering. The code is GPL, so there's no cost other than time. Alan DeKok. Hi Alan, So you would advise not to use any built-in Radius functionality? I thought I could achieve this with using one of the copy-acct-to-home-server modules or something like that... Regards Marius - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Marius Pesé wrote:
So you would advise not to use any built-in Radius functionality?
What did my message say?
I thought I could achieve this with using one of the copy-acct-to-home-server modules or something like that...
You drew a picture showing how you wanted MySQL to MySQL communication. This is a MySQL issue, and has nothing to do with RADIUS. Alan DeKok.
-----Original Message----- From: freeradius-users-bounces+marius=mindspring.co.za@lists.freeradius.org [mailto:freeradius-users-bounces+marius=mindspring.co.za@lists.freeradius.org] On Behalf Of Alan DeKok Sent: Tuesday, June 22, 2010 12:40 PM To: FreeRadius users mailing list Subject: Re: Redundant Accounting Marius Pesé wrote:
So you would advise not to use any built-in Radius functionality?
What did my message say? Just double-checking.
I thought I could achieve this with using one of the copy-acct-to-home-server modules or something like that...
You drew a picture showing how you wanted MySQL to MySQL communication. This is a MySQL issue, and has nothing to do with RADIUS. Alan DeKok. Thanks for your advice, now I can concentrate my research on mySQL. Regards Marius - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
participants (2)
-
Alan DeKok -
Marius Pesé