freeradius and MS SQL -- anyone got it working?

[Alan DeKok]

"Duane Cox" <duanec at 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.