Hi Everyone I've been trying to setup MySQL fail over with freeradius I've followed http://wiki.freeradius.org/SQL_HOWTO#Additional_Snippets But I get weird results. If I stop the first sql server service, freeradius starts to use the second sql server, as expected. But if I stop the entire first server (ie poweroff) freeradius still continues to try and use sql1, hanging... I have tryed this with real servers and with virtual servers, both react the same, if you take down the first sql service it will start to use the second, but if you power off or suspecd the first sql server, radius hangs trying to get to the server. I have tryed freeradius 2.1.0., 2.1.1 and 2.1.3, on redhat enterprise 4 compiled from source. Restarting freeradius it will notice the first sql server is down and use the second sql server. Can anyone confirm this behaviour? Any ideas how to get it working correctly? Secondly, I have been looking into sqlippool and MySQL fail over. We would really like to be able to use a read/write master and read only slave, but it looks to me that the sqlippool needs to be writeable to mark the IP address as used and avoid duplicate IP allocation. Can someone confirm this? Thanks Peter
Peter Ellens wrote:
If I stop the first sql server service, freeradius starts to use the second sql server, as expected.
But if I stop the entire first server (ie poweroff) freeradius still continues to try and use sql1, hanging...
FreeRADIUS is at the mercy of the MySQL client libraries. It asks them to connect, and if they never return... there's little that the server can do.
Any ideas how to get it working correctly?
I presume that there's some magic MySQL client setting, saying "don't screw up this badly", but I don't know what it is.
We would really like to be able to use a read/write master and read only slave, but it looks to me that the sqlippool needs to be writeable to mark the IP address as used and avoid duplicate IP allocation.
Yes. Alan DeKok.
Hi Alan Would it be possible to implement time outs on the calls to the mysql libraries? Thanks -----Original Message----- From: freeradius-users-bounces+peter=bccnz.com@lists.freeradius.org [mailto:freeradius-users-bounces+peter=bccnz.com@lists.freeradius.org] On Behalf Of Alan DeKok Sent: Thursday, 11 December 2008 8:32 a.m. To: FreeRadius users mailing list Subject: Re: mysql fail over Peter Ellens wrote:
If I stop the first sql server service, freeradius starts to use the second sql server, as expected.
But if I stop the entire first server (ie poweroff) freeradius still continues to try and use sql1, hanging...
FreeRADIUS is at the mercy of the MySQL client libraries. It asks them to connect, and if they never return... there's little that the server can do.
Any ideas how to get it working correctly?
I presume that there's some magic MySQL client setting, saying "don't screw up this badly", but I don't know what it is.
We would really like to be able to use a read/write master and read only slave, but it looks to me that the sqlippool needs to be writeable to mark the IP address as used and avoid duplicate IP allocation.
Yes. Alan DeKok. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Peter Ellens wrote:
Would it be possible to implement time outs on the calls to the mysql libraries?
The MySQL reference API suggests that this is possible: http://dev.mysql.com/doc/refman/5.1/en/mysql-options.html Alan DeKok.
participants (2)
-
Alan DeKok -
Peter Ellens