Hi All I am after a little advice if I may as we upgrade our FreeRadius Servers here. For long and complicated reasons the backed database is on a MSSQL Server rather than mysql etc. We are currently using the very old 2.1.x server (which works BUT I know is rather old in the tooth) but moving to the latest 3.1 release. However I have a quick question before I start the process. 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: rlm_sql_freetds - FreeTDS (mssql) rlm_sql_sybase - Sybase (mssql) rlm_sql_unixodbc - unixODBC (mssql) As possibly suitable - is there a current 'preference' ? If it makes any difference I am hoping to set up failover between two mssql servers - one as primary the other for IF the primary server fails Thanks in advance Richard Palmer
On 26-02-16 23:19, Richard J Palmer wrote:
rlm_sql_freetds - FreeTDS (mssql) rlm_sql_sybase - Sybase (mssql) rlm_sql_unixodbc - unixODBC (mssql)
rlm_sql_sybase no longer exists, so that makes the choice a little easier. As for the other two options: odbc is a kind of abstractions layer, which is great if you need a bunch of applications talking to the same mssql-server, but I doubt its preference in your case. rlm_sql_freetds is probably your best choice. -- Herwin Weststrate
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
participants (3)
-
A.L.M.Buxey＠lboro.ac.uk -
Herwin Weststrate -
Richard J Palmer