Re: Redundant Freeradius

2012-12-04 Thread fknet
Thanks Fajar, I'm not an real DBA, but I've worked with mysql for some years. I'll do some tests. Fabricio Em 03/12/2012 10:05, Fajar A. Nugraha escreveu: On Mon, Dec 3, 2012 at 6:52 PM, fknet ffkam...@conchalnet.com.br wrote: Thanks Fajar! I'm not an expertise, but I know how to work with

Re: Redundant Freeradius

2012-12-03 Thread Fajar A. Nugraha
On Mon, Dec 3, 2012 at 6:52 PM, fknet ffkam...@conchalnet.com.br wrote: Thanks Fajar! I'm not an expertise, but I know how to work with a database, I've done this for some years. My doubt is about the replication of radacct specifically. If you're familiar with master-master replication,

Re: Redundant Freeradius

2012-12-03 Thread fknet
Thanks Fajar! I'm not an expertise, but I know how to work with a database, I've done this for some years. My doubt is about the replication of radacct specifically. I'll try to do it using the robust-proxy-accounting. best regards FAbrício Em 01/12/2012 04:15, Fajar A. Nugraha escreveu:

Re: Redundant Freeradius

2012-11-30 Thread fknet
Hello, anyone can help me with this doubt??? Can I replicate the radacc table of mysql database without any problem ??? Or need I use proxy in freeradius? thanks Fabrício Em 28/11/2012 18:47, fknet escreveu: Hello people! Today I've just one FreeBSD server running FreeRadius +MySQL on my

Re: Redundant Freeradius

2012-11-30 Thread Fajar A. Nugraha
On Sat, Dec 1, 2012 at 8:37 AM, fknet ffkam...@conchalnet.com.br wrote: Hello, anyone can help me with this doubt??? Short answer: hire a competent DBA. Long answer: Your question was asked so many times already by others. Search the list archive for details. The short summary is there's no

Re: radrelay: cross-replication of accounting records between two redundant freeradius servers

2011-12-18 Thread Arch Mangle
Hi Alan On Sat, Dec 17, 2011 at 3:47 PM, Alan DeKok al...@deployingradius.comwrote: Arch Mangle wrote: I've got radrelay replicating accounting packets from a primary radius server to a secondary radius server. The secondary radius server is capable of handling radius accounting/auth

Re: radrelay: cross-replication of accounting records between two redundant freeradius servers

2011-12-17 Thread Alan DeKok
Arch Mangle wrote: I've got radrelay replicating accounting packets from a primary radius server to a secondary radius server. The secondary radius server is capable of handling radius accounting/auth requests if NASes cannot reach the primary or the primary fails. ... However, when I test

radrelay: cross-replication of accounting records between two redundant freeradius servers

2011-12-16 Thread Arch Mangle
Hi List I've got radrelay replicating accounting packets from a primary radius server to a secondary radius server. The secondary radius server is capable of handling radius accounting/auth requests if NASes cannot reach the primary or the primary fails. I want to replicate packets from the

redundant FreeRadius Servers

2011-09-20 Thread Simon Langen
Hello, I need two FreeRadius Servers which have the same data consisted. I'm testing on two Ubuntu 10.4 with freeradius 2.1.8. My Cisco# asks the first and if the first is not available it asks the second. Is there any Information on this topic? I use freeradius with mysql. is

Re: redundant FreeRadius Servers

2011-09-20 Thread Alan Buxey
Just ensure that they have the same config. If you want to use mysql then master/slave replication would be a way of achieving that alan - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Re: Redundant Freeradius

2010-11-11 Thread Rhommel Lamas
Hi, i left the redundant for a while and today i am trying again, and it fails I have this on the radiusd.conf detail { fail = 1 } redundant redundant_sql { sql1 sql2 handled } redundant redundant_sqlip {

Re: Redundant Freeradius

2010-10-27 Thread Rhommel Lamas
1.- What happens when i have my clients on the Mysql Database and it appears duplicated? 2.- When i make a radiusd -X and one of my mysql is down it cant start keeps giving me errors but if i start both it starts ok On Oct 26, 2010, at 8:27 PM, Alan DeKok wrote: Rhommel Lamas wrote:

Re: Redundant Freeradius

2010-10-27 Thread Phil Mayers
On 10/27/2010 09:47 AM, Rhommel Lamas wrote: 1.- What happens when i have my clients on the Mysql Database and it appears duplicated? You KNOW what happens; it doesn't work. Don't have duplicate clients. 2.- When i make a radiusd -X and one of my mysql is down it cant start keeps giving

Re: Redundant Freeradius

2010-10-27 Thread Rhommel Lamas
Just resolved the Clients it only check for clients on the local Database. Working out the problem at start with one of the databases, but The radius Works perfect if one of the databases fails after it starts On Oct 27, 2010, at 11:42 AM, Phil Mayers wrote: On 10/27/2010 09:47 AM, Rhommel

Re: Redundant Freeradius

2010-10-27 Thread Rhommel Lamas
Is there any chance that freeradius start without both databases online? On Oct 27, 2010, at 11:42 AM, Phil Mayers wrote: On 10/27/2010 09:47 AM, Rhommel Lamas wrote: 1.- What happens when i have my clients on the Mysql Database and it appears duplicated? You KNOW what happens; it doesn't

Re: Redundant Freeradius

2010-10-27 Thread Alan DeKok
Rhommel Lamas wrote: Is there any chance that freeradius start without both databases online? Why? Alan DeKok. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Re: Redundant Freeradius

2010-10-27 Thread Rhommel Lamas
Because it doesn't start i think it should at least start right? On Oct 27, 2010, at 2:01 PM, Alan DeKok wrote: Rhommel Lamas wrote: Is there any chance that freeradius start without both databases online? Why? Alan DeKok. - List info/subscribe/unsubscribe? See

Re: Redundant Freeradius

2010-10-27 Thread Alan DeKok
Rhommel Lamas wrote: Because it doesn't start i think it should at least start right? And do... what? What exactly do you plan on doing with a RADIUS server that can't write accounting to SQL, or read authentication from SQL? Alan DeKok. - List info/subscribe/unsubscribe? See

Re: Redundant Freeradius

2010-10-27 Thread Rhommel Lamas
For example i have 2 Databases server, and 1 radius server, i need to configure it for failover. I already configured both Sql instances, and both sqlippool instances. When i start radius i see two scenarios: 1.- If both Databases are up and running Radius Works. 2.- If one of my mysql is down

Re: Redundant Freeradius

2010-10-27 Thread Alan DeKok
Rhommel Lamas wrote: For example i have 2 Databases server, and 1 radius server, i need to configure it for failover. I already configured both Sql instances, and both sqlippool instances. OK. When i start radius i see two scenarios: 1.- If both Databases are up and running Radius

Re: Redundant Freeradius

2010-10-27 Thread Rhommel Lamas
ok i was getting crazy around here thought it was something about my configuration :) Good To know that Sql instances should have a variable that you can setup in case you are using a failover and it adjust some parameters like 1.- readclients: Actually i had to set the variable readclients to

Redundant Freeradius

2010-10-26 Thread Rhommel Lamas
I am having problemas deploying a redundant freeradius with mysql Here my sql.conf # -*- text -*- ## ## sql.conf -- SQL modules ## ## $Id$ ## # # Configuration for the SQL module # # The database schemas and queries

Redundant Freeradius

2010-10-26 Thread Rhommel Lamas
I am having problemas deploying a redundant freeradius with mysql Here my sql.conf # -*- text -*- ## ## sql.conf -- SQL modules ## ## $Id$ ## # # Configuration for the SQL module # # The database schemas and queries

Re: Redundant Freeradius

2010-10-26 Thread Alan DeKok
Rhommel Lamas wrote: I am having problemas deploying a redundant freeradius with mysql Here my sql.conf Which is not needed. The result after a radiusd -X is /etc/raddb/sql.conf[116]: Instantiation failed for module sql2 /etc/raddb/radiusd.conf[771]: Failed to find module sql2. /etc

Re: Redundant Freeradius

2010-10-26 Thread Rhommel Lamas
]: Failed to parse group subsection. /etc/raddb/sites-enabled/default[1]: Errors parsing authorize section. On Oct 26, 2010, at 4:12 PM, Alan DeKok wrote: Rhommel Lamas wrote: I am having problemas deploying a redundant freeradius with mysql Here my sql.conf Which is not needed

Redundant Freeradius

2010-10-26 Thread Rhommel Lamas
I am having problemas deploying a redundant freeradius with mysql Here my sql.conf # -*- text -*- ## ## sql.conf -- SQL modules ## ## $Id$ ## # # Configuration for the SQL module # # The database schemas and queries

Re: Redundant Freeradius

2010-10-26 Thread Alan DeKok
Rhommel Lamas wrote: FreeRADIUS Version 2.1.7, for host x86_64-redhat-linux-gnu, built on Mar 31 2010 at 00:14:28 ... And you now need to *READ* the debug output. The answer to the problem is in there. Alan DeKok. - List info/subscribe/unsubscribe? See

Re: Redundant Freeradius

2010-10-26 Thread Rhommel Lamas
I see that the problema is that i have the clients loaded in both Databases but how can i do to avoid it seeing duplicates? On Oct 26, 2010, at 8:27 PM, Alan DeKok wrote: Rhommel Lamas wrote: FreeRADIUS Version 2.1.7, for host x86_64-redhat-linux-gnu, built on Mar 31 2010 at 00:14:28 ...