On the subject of backup servers. If you want to run TWO MySQL servers and
have FreeRadius fall over between them, you'll need to do something like
this: duplicate your sql.conf and edit the second copy to reflect connecting
to your backup server ; then name the files something like sql1.conf and
sql2.conf ; in radiusd.conf change and duplicate the include line for
sql.conf to include sql1.conf and sql2.conf instead ; in the 'authorize'
section of radiusd.conf change the 'sql' entry to a 'group' one, like this:
group {
sql1 {
fail = 1
notfound = return
noop = 2
ok = return
updated = 3
reject = return
userlock = 4
invalid = 5
handled = 6
}
sql2 {
fail = 1
notfound = return
noop = 2
ok = return
updated = 3
reject = return
userlock = 4
invalid = 5
handled = 6
}
}
Note that if FreeRadius fails over to the second MySQL server and tries to
update the accounting table (radacct), nasty things might possibly happen to
your replication setup and database integrity as the first MySQL server
won't have got the updates...
On Wed, Mar 18, 2009 at 11:52 AM, Evan Brown <[email protected]> wrote:
>
> Yes I can't do that, well as its for a client I beleve it will take a
> lot of convincing. Hence the current mess
>
> On 3/18/09, Kent Perrier <[email protected]> wrote:
> > I'd normalize your name space so you have only one ebrown, and then
> > replicate the LDAP servers between each other so that you have
> redundancy.
> >
> > Of course, if you can't do that, then best of luck to you! ;) I don't
> know
> > anything about Freeradius.
> >
> > Kent
> >
> > >
> >
>
> --
> Sent from my mobile device
>
> >
>
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"NLUG" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/nlug-talk?hl=en
-~----------~----~----~----~------~----~------~--~---