Re: Upgrading FreeRadius / MSSQL
Thanks Alan One small further question if I may. FR (using freetds) is currently set against a single mssql server. We are currently setting a second SQL server to allow failover in the case of a server failure. I assume we can run two freetds modules to allow freeradius to failover OK ? I shall be building a test server here the next few days. Should I take the latest .tar from the website or download from git ? Thanks again Richard Palmer | Director | Merula Limited Company Registered in England and Wales No. 3243995 5 Avro Court, Huntingdon, Cambridgeshire, PE29 6XS Phone 01480 222940 | Support 0845 330 0666 Support Email support@merula.net
--- Original message --- Subject: Re: Upgrading FreeRadius / MSSQL From: <A.L.M.Buxey@lboro.ac.uk> To: FreeRadius users mailing list <freeradius-users@lists.freeradius.org> Date: Monday, 29/02/2016 10:22 AM
Hi,
Taking a look at http://wiki.freeradius.org/modules/Rlm_sql I can see that there are 3 possible drivers mentioned for use with mssql - We are currently using freetds - however the site mentions:
I'd say stick with the FreeTDS method if you are happy with it and your config is currently using it - the ODBC one adds extra elements/dependencies into the mix - and you may have extra work to do (not just the local FR configuration).
alan - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Hi,
One small further question if I may. FR (using freetds) is currently set against a single mssql server. We are currently setting a second SQL server to allow failover in the case of a server failure. I assume we can run two freetds modules to allow freeradius to failover OK ?
I would assume that if the module doesnt allow multiple servers to be defined, then you can have 2 instances and use the usual failover mechanism
I shall be building a test server here the next few days. Should I take the latest .tar from the website or download from git ?
the latest 3.0.x from GIT will have all recent bugfixes/tweaks.... theres also the 3.1.x track which some would suggest that you use. alan
On Feb 29, 2016, at 8:18 AM, Richard J Palmer <richard@merula.net> wrote:
One small further question if I may. FR (using freetds) is currently set against a single mssql server. We are currently setting a second SQL server to allow failover in the case of a server failure. I assume we can run two freetds modules to allow freeradius to failover OK ?
Yes. Configure two SQL modules, one for server A, and the other for server B. Then, put them into a "redundant" block. See "man unlang".
I shall be building a test server here the next few days. Should I take the latest .tar from the website or download from git ?
3.0.11 is fine. Alan DeKok.
participants (3)
-
A.L.M.Buxey＠lboro.ac.uk -
Alan DeKok -
Richard J Palmer