freeradius and MS SQL -- anyone got it working?
Alan DeKok
aland at ox.org
Fri Sep 30 17:14:57 CEST 2005
"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.
More information about the Freeradius-Users
mailing list