freeradius and MS SQL -- anyone got it working?

[Arne Götje (=?utf-8?q?=E9=AB=98=E7=9B=9B=E8=8F=AF?=)]

On Friday 30 September 2005 21:28, Duane Cox wrote:
> There are a few qwerks with getting FreeRadius to work with MSSQL.

thought so... :)

> First thing, the FreeTDS files have been removed (more like
> abandonded) from FreeRadius.
> If you really want to call FreeTDS direclty, you will have to
> download the files from the "attic".
> But more than that you will also have to update the files as they do
> not currently compile properly, they are a bit old.
> I would suggest to go with unixodbc or iodbc, even though using
> FreeTDS is IMHO the best way, it's not supported.

oh... ok, then I'll go with unixodbc.

> 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.
>
> 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".
>
> These things should help you out.  If you need any further
> assistance, ie. configure/make commands and file contents ask again.

Thanks. :)

Could you give me an example how the /etc/odbc.ini has to look like?

Cheers
Arne
-- 
Arne Götje (高盛華) <arne at linux.org.tw>
PGP/GnuPG key: 1024D/685D1E8C
Fingerprint: 2056 F6B7 DEA8 B478 311F  1C34 6E9F D06E 685D 1E8C
Key available at wwwkeys.pgp.net.   Encrypted e-mail preferred.

-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 189 bytes
Desc: not available
URL: <http://lists.freeradius.org/pipermail/freeradius-users/attachments/20051001/576732c6/attachment.pgp>