"Duane Cox" <duanec@mail.illicom.net> wrote:
First thing, the FreeTDS files have been removed (more like abandonded) from FreeRadius.
It was "abandoned" at the specific request of the FreeTDS project members, who told us the FreeTDS API used by the module was not stable, and shouldn't be used by anyone.
Second, in order to get MSSQL to work with the current version of FreeRadius 1.0.5, you will need to install either unixodbc or iodbc. I chose unixodbc; and in doing so it requires FreeTDS. So install both FreeTDS and unixODBC.
Oh, so it *does* work with the unixODBC module, like I said. Why then the comments about the freetds module?
Third. You will need to include mssql.conf and call rlm_sql_unixodbc. The mssql.conf has to many tricks to it. First the default driver is invalid and the "server" is really the DSN and must match that name found in /etc/odbc.ini. Also /etc/odbc.ini must be readable by the freeradius daemon. Also, there is an extra statement in the mssql.conf that is totaly not used and can be deleted; it's "authenticate_query".
Please submit patches to the files & docs. We'll be glad to fix any issues with the project. Alan DeKok.