Hi Gilbert,

I am not sure but i think also this is a bug im mysql driver! 
Same problems here! But i have a little solution i hope this 
is working on your situation.
We have two location and every location have a own radius server and own mysql 
db.
We also use mysql replication. So there is a master en slave situation.

On location one we have master db and radius. 
On radiusd.conf we have 
authorize  
         redundant {
        sql1 #(masterdb on localdb)
        sql2 #(slave db on location 2)
}


accounting {
sql1 #(location 1 master)


On location 2:
radiusd.conf we have:
authorize  
         redundant {
        sql2 #(slave db localdb)
        sql1 #(masterdb db on location 2)
}

accounting {
sql1 #(location 1 master)

So radius server on more than one location check to login in the local db 
(accounting). 
So the users can login every time local.   
On the client NAS we use chillipot so there we can configure a first radius and 
second. 
So first is local same subnet and when down he go to the second radius i can 
connection to location 2.

So i think this is save (for me) !? 
I testit and i can reboot one of the radius servers and every users can login 
in the down time.

The best solution is when redundant is fast working. But i have spent so much 
time in it.
This is for my a working solution. 
Sorry for my english!

Michel

> Nobody can help me or can say this is a bug?
> max_request_time make no different..
> 
> Gilbert
> 
> > what happens... 
> > 
> > The connection to the second mysql database it takes three minutes!
> > 
> > It look likes a bug i search on google and see same problems but no
> > solutions! 
> > 
> > I set max_request_time to 5 seconds, so it's faster for testing:
> > 
> > Gilbert
> > 
> > > Gilbert Otingen <[EMAIL PROTECTED]> wrote:
> > > >   redundant {
> > > >                 sql1
> > > >                 sql2
> > > >         }
> > > > 
> > > > And i can see the successful connect in the log  and everything works as
> > > > expected... but until i shutdown the first database. 
> > > 
> > >   Then... what happens?
> > > 
> > > > Any ideas on what the problem is?
> > > 
> > >   Without a description of the problem, I have no idea.
> > > 
> > >   Alan DeKok.
> > > 
> > > - 
> > > List info/subscribe/unsubscribe? See 
> > > http://www.freeradius.org/list/users.html
> > 
> > 
> > 
> > - 
> > List info/subscribe/unsubscribe? See 
> > http://www.freeradius.org/list/users.html
> 
> 
> - 
> List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Met vriendelijke groet,

M. v Dop
www.westwireless.nl

- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Reply via email to